Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-12154: TNS:could not resolve the connect identifier specified

M1k3GDec 8 2010 — edited Dec 9 2010
I had a problem with the configuration of the Local Net Service name in a previous posting. This was resolved, and everything seemed ok. When I tested, connection was succesful. Now, when I try to import my database, I get an error message saying that TNS could not resolve the connect identifier. The global database name when I configured the db was danaos. The SID was ORCL. This has worked well in the past. Can't understand why its an issue now. I can't change these, as the database of a client is already configured like this, and his client application (which I copied onto my laptop) needs these values to run. Its strange that the listener seems to be ok, the LNS tests ok, and then on import, I get this message. Any ideas?
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrator>cd\

C:\>cd import_db\dmp

C:\Import_DB\dmp>imp system/????99@ORCL full=y file=test.dmp buffer=1000000

Import: Release 11.2.0.1.0 - Production on Wed Dec 8 22:35:28 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.


IMP-00058: ORACLE error 12154 encountered
ORA-12154: TNS:could not resolve the connect identifier specified
IMP-00000: Import terminated unsuccessfully

C:\Import_DB\dmp>
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 5 2011
Added on Dec 8 2010
2 comments
4,707 views