Home » SQL & PL/SQL » Client Tools » ORA-12154: TNS:could not resolve the connect identifier specified (Red Hat Enterprise Linux Server release 5.9)
ORA-12154: TNS:could not resolve the connect identifier specified [message #667773] Mon, 15 January 2018 01:58 Go to next message
Lazarus
Messages: 1
Registered: January 2018
Junior Member
Am trying to connect to my Oracle DB from SQLPlus but getting ORA-12154.

When i tnsping the DB it is responding with the same path where my sqlnet.ora.listener.ora and tnsnames.ora are located.

Kindly advise
Re: ORA-12154: TNS:could not resolve the connect identifier specified [message #667778 is a reply to message #667773] Mon, 15 January 2018 04:13 Go to previous messageGo to next message
Michel Cadot
Messages: 65946
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Don't tell, show us what you do and get.
Copy and paste your DOS session, no screen shot.

Before, Please read How to use [code] tags and make your code easier to read.

Re: ORA-12154: TNS:could not resolve the connect identifier specified [message #667779 is a reply to message #667778] Mon, 15 January 2018 07:09 Go to previous message
BlackSwan
Messages: 26274
Registered: January 2009
Location: SoCal
Senior Member

ora-12154 ALWAYS only occurs on SQL Client & no SQL*Net packets ever leave client system
ora-12154 NEVER involves the listener, the database itself or anything on the DB Server.
ora-12154 occurs when client requests a connection to some DB server system using some connection string.
TNS-03505 is thrown by tnsping & is same error as ora-12154 thrown by sqlplus or others.
The lookup operation fails because the name provided can NOT be resolved to any remote DB.
The analogous operation would be when you wanted to call somebody, but could not find their name in any phonebook.
The most frequent cause for the ora-12154 error is when the connection alias can not be found in tnsnames.ora.
The lookup operation of the alias can be impacted by the contents of the sqlnet.ora file; specifically DOMAIN entry.
TROUBLESHOOTING GUIDE: ora-12154 & TNS-12154 TNS:could not resolve service name [ID 114085.1]
http://edstevensdba.com/oracle-tns/ora-12154tns-03505/
Previous Topic: failure in testing a connection in 12c database
Next Topic: Howe toad or sql developer connect to oracle
Goto Forum:
  


Current Time: Tue Nov 13 11:54:38 CST 2018