ORA-12154: TNS:could not resolve the connect identifier specified

oracle oracle10g database-connection ora-12154
ErAB picture ErAB · Aug 31, 2011 · Viewed 41.4k times · Source

The issue started when i installed the server version with already existing client version of Oracle 10g.

Background : The Oracle client version 10g was installed (at c:/oracle) to connect to a database residing in other country. So we can just connect to it and have limited access to it.

Path => c:/oracle/ora_client/network/admin/listener.ora

So to work as admin I installed 10g server at the same location c:/oracle on windows. I can now work as server.

Path => c:/oracle/product/db_1/network/admin/listener.ora

But the issue arises when I try to connect with my application installed to setup connection as a client (to server residing in other country), it fails and throws an error ORA-12154.

So, do I have to uninstall my server version (just in case the confusion might have arrived due to the presence of two Oracle databases)?

How can I fix it? What has been the probable cause for it? Please advise!

Answer

steve picture steve · Aug 31, 2011

When you installed the server version it updated the environment variables to point to the server installation and not the client installation. The definition of TNS aliases is done in tnsnames.ora and no the listener.ora. So you would have to copy the already existing entries from c:/oracle/ora_client/network/admin/tnsnames.ora to c:/oracle/product/db_1/network/admin/tnsnames.ora. Be careful that you obey the tnsnames.ora format.

Related questions

How to find the privileges and roles granted to a user in Oracle?

I am using Linux, Oracle10g. I have created one user called test. and granted create session and select any dictionary permission to the same user. i also granted sysdba and sysoper roles to the same users. Now i want …

Read More
Checking oracle sid and database name

I want to check SID and current database name. I am using following query for checking oracle SID select instance from v$thread; but table or view does not exist error is coming. I am using following query for checking …

Read More
CASE .. WHEN expression in Oracle SQL

I have the table with 1 column and has following data Status a1 i t a2 a3 I want to display the following result in my select query Status| STATUSTEXT a1 | Active i | Inactive t | Terminated a2 | Active a3 | Active One …

Read More