ORA-12154: TNS:could not resolve the connect identifier specified
Dear All,
I facing a very strange problem.
My database is *10.2.0.4.0* on Windows 2003 Server. My listener is running on the port *1527*. This is a back-end database of SAP Portal.
Everything is running fine except I am not able to connect to the database using connect identofier and I am recieving the above error message.
If set the environment and connect with below, it is working fine:
sqlplus system/<PASSWORD>
But iif try the below, I am receiving the above error:
sqlplus system/<PASSWORD>@<SID>
tnsping is working absolutely fine. And if I give password wrong it is throwing the error: ORA-01017: invalid username/password; logon denied .
Below are the snap of the relevant files:
listener.ora
-----
ADMIN_RESTRICTIONS_LISTENER_<SID> = on
LISTENER_<SID> =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = <SID>.WORLD)
)
(ADDRESS=
(PROTOCOL = IPC)
(KEY = <SID>)
)
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = <SERVER>)
(PORT = 1527)
)
)
STARTUP_WAIT_TIME_LISTENER_<SID> = 0
CONNECT_TIMEOUT_LISTENER_<SID> = 10
TRACE_LEVEL_LISTENER_<SID> = OFF
SID_LIST_LISTENER_<SID> =
(SID_LIST =
(SID_DESC =
(SID_NAME = <SID>)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
)
)
-----
sqlnet.ora
-----
AUTOMATIC_IPC = ON
TRACE_LEVEL_CLIENT = OFF
NAMES.DEFAULT_DOMAIN = WORLD
SQLNET.EXPIRE_TIME = 10
SQLNET.AUTHENTICATION_SERVICES = (NTS)
DEFAULT_SDU_SIZE=32768
-----
tnsnames.ora
-----
<SID>.WORLD=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = <SERVER>)
(PORT = 1527)
)
)
(CONNECT_DATA =
(SID = <SID>)
(GLOBAL_NAME = <SID>.WORLD)
)
)
-----
I am must be doing some very basic mistake but I am stuck. Please advice.