EXP-00056 ORACLE error 12154 encountered

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • osman7king
    New Member
    • Sep 2010
    • 61

    EXP-00056 ORACLE error 12154 encountered

    I have tried to export a database, but i got the following message:
    EXP-00056 ORACLE error 12154 encountered
    ORA-12154: TNS could not resolve the connect identifier specified

    but i can access the database successfully and the TNS is correct.

    Thanks
  • rski
    Recognized Expert Contributor
    • Dec 2006
    • 700

    #2
    Show the command you use to export database.

    Comment

    • osman7king
      New Member
      • Sep 2010
      • 61

      #3
      dear rski..
      I have fixed the problem.
      there was a '@' charactre in the password of my database, and after I change the password and remove that character from it, the problem has been fixed and the export operation has been done successfully.

      THANKS.

      Comment

      • Andrewpaul
        New Member
        • Feb 2012
        • 1

        #4
        Dear osman7king,
        Oracle 12154 error means TNS could not resolve the connect identifier specified. A connection to a database or other service was requested using a connect identifier, and the connect identifier specified could not be resolved into a connect descriptor using one of the naming methods

        configured. You can try below instruction

        There was a '@' character in the password of your database, and after you change the password and remove that character from it, the problem has been fixed and the export operation has been done successfully.
        For more solution visit,
        Last edited by Andrewpaul; Feb 17 '12, 05:07 AM.

        Comment

        Working...