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.
“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.
“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.