Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2011

    Question Unanswered: Error while connect database by usnig EXP.exe utility

    (Oracle 10g)
    I want to take backup by using exp utility .

    I am Able to connect database by using sql developer client tool.
    but when I try to connect same database by using
    exp/imp utility in the Server it giving following error.

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

    I have tried to connect by SqlPlus also but there is the same error.

    I have checked the entry in tnsnames and listener allready.

    Please help

  2. #2
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 4
    Do you have more than one Oracle software installed on the computer? If so, EXP is using a "wrong" TNSNAMES.ORA which does not contain alias to a database you'd like to export. TNS_ADMIN environment variable might solve the problem.

  3. #3
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    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]
    ora-12154/tns-03505 | Ed Stevens, DBA
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts