ora-12154 could not resolve... with oracle instant client

oracle oracle-sqldeveloper tnsnames ora-12154
chrismarx picture chrismarx · Aug 16, 2011 · Viewed 7.2k times · Source

Here are the details:

  1. I installed the oracle instant client 11.2.0.2.0 from the OTN download page on a windows 7 64 bit vm (vmware).
  2. I am trying to to connect to a remote oracle database, and I can successfully connect with one program using TNS, but not with SQL*Plus and other applications.
  3. Trying to connect with SQL*Plus, using schema@servicename, password, etc, gives the above error.
  4. To connect via SQL Developer, normally I would use the basic connection info and not rely on tnsnames, but trying a normal connection gives me: io error: unknown host specified. SQL Developer can successfully connect and query database if i use the TNS protocol.
  5. Trying from other programs gives me the same error I got with SQL*Plus. Same when trying with the service name from tnsnames.

This is obviously quite frustrating for it to work one way and not the other. I followed all the normal instructions for using the instant client, the directory with instantclient has been addded to the PATH, a TNS_ADMIN entry has also been created, with the directory to the tnsnames.ora file

Answer

chrismarx picture chrismarx · Aug 17, 2011

Well, on a whim, I went to changing everything in my setup to match an windows 2003 server that i had setup with instant client before. The main changes were putting the instant client in a folder at the root of the drive (not program files/oracle/etc), but c:/oracle, i know ive seen other posts saying that oracle was particular about characters in the directory path, maybe spaces are a no-no too?

I also add a bunch more environmental variables, anythign that was on the other machine, ORACLE_HOME (to root of instance), SQL_PATH (same), and added the root of the directory to the PATH system variable, not just the folder with the instantclient files. Anyways, I'm happy its working, anyone one of these changes could have been it though-

Related questions

Use tnsnames.ora in Oracle SQL Developer

I am evaluating Oracle SQL Developer. My tnsnames.ora is populated, and a tnsping to a connection defined in tnsnames.ora works fine. Still, SQL Developer does not display any connections. Oracle SQL Developer Soars mentions, that if you have …

Read More
Oracle TNS names not showing when adding new connection to SQL Developer

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 using the following format in tnsnames.ora: dev = (DESCRIPTION = (…

Read More
How to set tnsnames.ora location for SQL Developer in Windows 10

This question (Use tnsnames.ora in Oracle SQL Developer) looks like it should have the answer. But my copy of SQL Developer does not have Advanced under Database (it does have Advanced Parameters, but that's not helping). I've looked all …

Read More