“Error 12154” on Oracle database

Asked By whopperman 10 points N/A Posted on - 02/12/2012

Hello,

I'm using an Oracle database.  When I try to carry export a database, I face an error message:

EXP-00056 ORACLE error 12154 encountered
ORA-12154: TNS could not resolve the connect identifier specified

My attempt to access the database is successful and also the TNS is perfect.  I need a solution. Thanks.

• Status: Open
• Question Views: 2600
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Oracle Database

Best Answer by cathy emrald

Go To Solution

Answered By ilan aaroan 0 points N/A #95190

“Error 12154” on Oracle database

 

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.

About ilan aaroan

Questions
1

Answers
19

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 02/12/2012
• Question Category: Oracle Database

Best Answer

Best Answer

Answered By cathy emrald 5 points N/A #95192

“Error 12154” on Oracle database

ORA-12154: TNS: could not resolve the connect identifier specified occurs when there is a corrupt or wrong settings on your tnsnames.ora file. It could be trace on local copy of your configuration file. It can also be related if the default database name in sqlnet.ora is incorrect. To fix this, check the string in the NAMES.DIRECTORY_PATH in $ORACLE_HOME/network/admins/sqlnet.ora file. Ensure that the tnanames.ora is present in $ORACLE_HOME/network/admin directory and you can access it. And also, ensure that the entry for string in the tnsnames.ora file is present. Check for any spelling error. Check for any characters in your database password.

About cathy emrald

Questions
3

Answers
415

Best Answers
148

• Vote Up 0 Vote Down

• Posted on - 08/20/2012
• Question Category: Oracle Database