What Does Oracle Error message ORA-12154 Mean?
I am not familiar with Oracle and have been tasked to attempt to get an application running that uses Oracle. The application is POCA from the FDA. This application is old and the documentation (from 2010) refers to Oracle database 10g. I was only able to get 11g so I know there may be issues. I was able to install Oracle and am attempting to run the installation scripts for the application. At one point I get the following error message.
IMP-00058: ORACLE error 12154 encountered
ORA-12154: TNS:could not resolve the connect identifier specified
IMP-00000: Import terminated unsuccessfully
Any idea what this mean?
IMP-00058: ORACLE error 12154 encountered
ORA-12154: TNS:could not resolve the connect identifier specified
IMP-00000: Import terminated unsuccessfully
Any idea what this mean?
ASKER
Thanks for the info slightwv. I installed Oracle by going through the installation wizard from the Oracle 11g download. I did not manually create entries in the tnsnames.ora file. I don't even know what that is as I am not familiar with Oracle. I'm just trying to get a standalone app that uses Oracle to work if possible. We are a SQL Server shop so there are no other machines with Oracle installed.
I'll take a look at the online docs. Thanks.
I'll take a look at the online docs. Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
In case it helps you feel any better, getting the TNS configuration entries correct (in the tnsnames.ora file) is usually the most challenging part of setting up a new Oracle server. Until that is correct, nothing that uses Oracle will work.
The error message from Oracle's import utility indicates that you are trying to import data from a previous Oracle database into your new database. This will only work if your new database is installed correctly, configured (in the tnsnames.ora file and in the spfile for managing how Oracles uses memory) and started. Usually you also need to have the Oracle listener started also. This executable is separate from the database executable, but is required to accept connection requests from any client program (like Oracle's import utility). The configuration file for this is: listener.ora, which is also in the \network\admin (or /network/admin in Linux/UNIX) sub-directory of your Oracle_home directory on the server. The easiest way to configure both of these is with the netca utility.
Oracle may seem awkward to install and configure compared to SQL Server, but Oracle is not limited to running on just one O/S.
The error message from Oracle's import utility indicates that you are trying to import data from a previous Oracle database into your new database. This will only work if your new database is installed correctly, configured (in the tnsnames.ora file and in the spfile for managing how Oracles uses memory) and started. Usually you also need to have the Oracle listener started also. This executable is separate from the database executable, but is required to accept connection requests from any client program (like Oracle's import utility). The configuration file for this is: listener.ora, which is also in the \network\admin (or /network/admin in Linux/UNIX) sub-directory of your Oracle_home directory on the server. The easiest way to configure both of these is with the netca utility.
Oracle may seem awkward to install and configure compared to SQL Server, but Oracle is not limited to running on just one O/S.
ASKER
The information slightwv provided led me to where the problem was occuring.
http://docs.oracle.com/cd/E11882_01/server.112/e17766/net12150.htm#ORA-12154
When you installed Oracle did you create the necessary entries in the tnsnames.ora file?
It is probably best that you copy a known good one from another machine.
This file is in the $ORACLE_HOME/network/admin