| "ORA-12154: TNS : Culd not resolve the connect identifier specified" [message #164997] |
Mon, 27 March 2006 23:53  |
jyotirmaymitra
Messages: 2
Registered: March 2006
|
Junior Member |
|
|
Subject: ORA-12154: TNS : Culd not resolve the connect identifier specified
RDBMS Version: Oracle 10g R2 (10.2.0.1.0)
Operating System and Version: Windows XP Professional ver 2000 service pack 2
Error Number (if applicable): ORA-12154: TNS : Culd not resolve the connect identifier specified
Product (i.e. SQL*Loader, Import, etc.): SQL *Plus
Product Version: SQL *Plus 10.2.0.1.0
Hi,
I have installed Oracle 10g R2 (Ver 10.2.0.1.0) on my workstation (Windows XP Professional ver 2000 service pack 2). From my workstation I could very well connect to the Oracle DB (using Sql *Plus, Enterprise Manager Console, DB Console link). Problem is when I have installed Oracle Client (10g ver 10.2.0.1.0) in my colleague’s workstation and was trying to connect to the server through oracle client. We are getting
"ORA-12154: TNS : Could not resolve the connect identifier specified" problem.
Strange enough from the same Oracle client (10g ver 10.2.0.1.0) we could very well connect to another Oracle server (Oracle 8i ver 8.1.7) situated on a different location.
The Oracle server (10G R2) as well as the client (10g ver 10.2.0.1.0) I have downloaded from OTN site.
I am also attaching the Tnsnames.ora and SQLNet.Ora file along with LISTENER.ora file from both Server and Client for your reference.
If you can give us a solution to resolve it then it would be great.
Regds.
----------------------Server side .Ora files-----------------------
Tnsnames.ora
DEMO =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.5.43)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = demo.com)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
-------
sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES = (NTS)
---
listener.ora
LISTENER=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=10.11.5.43)(PORT=1521))
)
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=demo.com)
(ORACLE_HOME=E:\oracle\product\10.2.0\db_1)
(SID_NAME=demo)
)
)
-----------------Clinet side .Ora files--------------
Tnsnames.ora
DEMO =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.5.43)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = demo.com)
)
)
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
