TNS issues
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: TNS issues

  1. #1
    Join Date
    Apr 2007
    Location
    USA
    Posts
    110

    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.

  2. #2
    Join Date
    Apr 2006
    Posts
    377
    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.

  3. #3
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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.

  4. #4
    Join Date
    Apr 2007
    Location
    USA
    Posts
    110
    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
  •  


Click Here to Expand Forum to Full Width