This discussion is archived
2 Replies Latest reply: Jan 25, 2013 11:49 AM by EdStevens RSS

ora-12154:TNS

987231 Newbie
Currently Being Moderated
hi all,please I have a problem I install PLsql but when I wanna used I coudn'nt because when i wanna connect my databse it show me this message that ora-12154:tns
please help me
  • 1. Re: ora-12154:TNS
    sb92075 Guru
    Currently Being Moderated
    984228 wrote:
    hi all,please I have a problem I install PLsql but when I wanna used I coudn'nt because when i wanna connect my databse it show me this message that ora-12154:tns
    please help me
    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.wordpress.com/2011/02/26/ora-12154tns-03505/
  • 2. Re: ora-12154:TNS
    EdStevens Guru
    Currently Being Moderated
    984228 wrote:
    hi all,please I have a problem I install PLsql
    PLSQL is a programming language in the Oracle database. You don't install PL/SQL. I will assume you installed the Oracle database product, created a database, and area now attempting to connect to the database using the command line utility 'sqlplus'.
    but when I wanna used I coudn'nt because when i wanna connect my databse it show me this message that ora-12154:tns
    please help me
    What operating system is the database on?
    What operating system are you running sqlplus on?
    Are those two systems the same?

    Please go to a command line prompt and recreate the error. Copy the entire session - both the full command and the full response - and paste into your next posting.

    Also, as sb said, read [url http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/] ora-12154 TNS:could not resolve the connect identifier specified

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points