Tnsnames.ora Issue
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Tnsnames.ora Issue

  1. #1
    Join Date
    Jan 2001
    Posts
    515

    Tnsnames.ora Issue

    I have moved a database to a new server. I then modified by tnsnames.ora on my machine to point to the new server. It works fine through TOAD but I cannot connect through the SQLPlus client on my machine.

    When I do a tnsping to the databse from Windows cmd line it returns the tnsnames.ora entry for the old server. So it seems that my machine is using a network tnsnames file.

    How do I find it?

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    whats the output of the environment variable TNS_ADMIN (and make sure you updated the right one)

  3. #3
    Join Date
    Jan 2001
    Posts
    515

    What is the command

    I am a unix person. How do I see the value? in unix I would do echo $TNS_ADMIN. What is the windows command?

  4. #4
    Join Date
    Jan 2001
    Posts
    515

    no TNS_ADMIN

    I do not see any TNS_ADMIN set. My SQLPlus is using a tnsnames.ora file somewhere I cannot find.

    I turned on tracing but it just keeps showing me the wrong tnsnames entry but it does not tell me what file it is reading. How do I determine that?

    Any help would be appreciated.

  5. #5
    Join Date
    Jan 2001
    Posts
    515

    Here is the log

    ***********************************************************************
    I cahnged the host name and user name but this should give you an idea

    Fatal NI connect error 12505, connecting to:
    (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=wronghost)(PORT=1521))(CONNECT_DATA=(SID=MYDEV)(SERVER=DED ICATED)(CID=(PROGRAM=C:\ORACLE\ora92\bin\sqlplusw.exe)(HOST=myhost)(USER=myid))))

    VERSION INFORMATION:
    TNS for 32-bit Windows: Version 9.2.0.7.0 - Production
    Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 9.2.0.7.0 - Production
    Time: 14-DEC-2006 15:28:49
    Tracing not turned on.
    Tns error struct:
    ns main err code: 12564
    TNS-12564: TNS:connection refused
    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

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