-
TNS issues
hi all,
I just upgraded my database from 9.8 to 10.4. Now I have some TNS issues
if sitting directing on my server and do a
sqlplus user/passwd@InstanceName I get the TNS error
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
however my sqlplus connection is fine without the @InstanceName (if my SID is OK)
However all my 3rd party/client tools are connecting fine. TOAD, DBVISUALIZER, client SQLPLUS and users are using the database OK. So I don't think anything has changed in TNS settings?.
As a result I cannot initiate an RMAN backup from this server/instance
Recovery Manager: Release 10.2.0.4.0 - Production on Thu Feb 26 13:26:40 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: XXXXXXX (DBID=368783836355)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04004: error from recovery catalog database: ORA-12154: TNS:could not resolve the connect identifier specified
thanks
Looking for the greatest evil in the world? Look in the mirror.
-
Did you keep the old 9.2.0.8 home on this node? Verify that you are resolving out to the correct tnsnames.ora file. What does it show when you try tnsping instancename ? Do you have the TNS_ADMIN environment variable set? Also may want to verify the contents of the tnsnames.ora file.
Last edited by ebrian; 02-26-2009 at 07:00 PM.
-
Have you made a copy of your ${ORACLE_HOME}/network/admin/tnsnames.ora file from your Ora9i to your Ora10g Oracle home?
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
You both provided great pointers. I had not yet moved the TNS from the old home.
Thanks a bundle. Much appreciated.
Looking for the greatest evil in the world? Look in the mirror.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|