“Error 12154” on Oracle database

Asked By 10 points N/A Posted on -
qa-featured

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.

SHARE
Best Answer by cathy emrald
Answered By 0 points N/A #95190

“Error 12154” on Oracle database

qa-featured

 

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.

Best Answer
Best Answer
Answered By 5 points N/A #95192

“Error 12154” on Oracle database

qa-featured

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.

Related Questions