tns Questions

8

Is it possible to use a fully qualified TNS entry using sqlldr bundled with Oracle 10/11? For example, in SQLPlus: sqlplus user/password@(description=(address=(host=localhost)(protocol=tcp)(port...
Reconstructionist asked 13/9, 2011 at 22:54

8

Solved

I'm trying to connect to an oracle database with SQL Developer. I've installed the .Net oracle drivers and placed the tnsnames.ora file at C:\Oracle\product\11.1.0\client_1\Network\Admin I'm usi...
Strobe asked 8/1, 2009 at 16:57

15

Solved

I am getting the following errors while from the lsnrctl status command: C:\Users\pna105>lsnrctl stat LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 08-OCT-2014 17:53 :55 C...
Gunter asked 7/10, 2014 at 13:16

22

I am a SQL Server user . I am on a project that is using oracle (which I rarely use) I need to create an ODBC connection so I can access the some data via MS Access I have a application on my mac...
Dovekie asked 15/10, 2008 at 19:23

3

Solved

I have a Spring Boot app that works smoothly when it connects to an Oracle instance in the classic way: jdbc:oracle:thin:@<server name>:<port num>/<service name> However, when ...
Tryout asked 2/1, 2017 at 9:57

4

I am new to NativeScript and am currently going through the installation steps described here (http://docs.nativescript.org/angular/tutorial/ng-chapter-1) and I just completed executing the PowerSh...
Imperfective asked 5/5, 2016 at 0:13

4

I am using Oracle database. I've written a small JDBC connection program in Java but I am facing an issue with the listener. import java.sql.Connection; import java.sql.DriverManager; import java....
Ploch asked 16/6, 2015 at 7:14

8

Solved

I've got an ASP.NET application that can connect to Oracle when it's started by Visual Studio Development Server, but when I deploy it to my local IIS, it does not connect, showing the "ORA-12154: ...
Kele asked 24/8, 2011 at 13:30

11

Solved

Sometimes I get Oracle connection problems because I can't figure out which tnsnames.ora file my database client is using. What's the best way to figure this out? ++happy for various platform solu...
Extrasensory asked 13/8, 2008 at 23:49

1

Solved

Having the opposite problem as this person. TNSPING OK but sqlplus gives ORA-12154? I'm trying to install Oracle on a VM in VMWare Workstation. I've tried to install Oracle 11g and 12c on: Windo...
Kimberlite asked 17/9, 2015 at 18:51

3

Solved

The scenario : an Oracle 11g database containing some sensitive user data that could result legal liabilities if disclosed to the wrong party. The desired effect : only a certain user, connecting ...
Orthohydrogen asked 13/2, 2013 at 12:32

3

Solved

Borderline ServerFault question, but figured I'd try here first since I've had luck with Oracle questions in the past. I'm trying to connect to an oracle database from PHP, and I'm getting the fol...
Fortuitous asked 25/1, 2010 at 18:36

2

Solved

I was looking at a very slow SQL query (originating from a Java app using Hibernate deployed in JBoss 5.1). This particular query returned about 10K records but still took 40s or more. I ended up ...
Anklet asked 8/10, 2010 at 20:4
1

© 2022 - 2024 — McMap. All rights reserved.