TNSPing????
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: TNSPing????

  1. #1
    Join Date
    Mar 2003
    Posts
    29

    TNSPing????

    Normally when doing a tnsping in 9i the app will tell you which tnsnames.ora file it is using.

    However om my machine it says it cant resolve the service name and the file it specifies as using is the SQLNET.ora file
    ????????

    is there some setting I missed?

    Any ideas or comments?

    thanks

    jacques

  2. #2
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    It's using sqlnet.ora as the parameter file

    Does your sqlnet.ora file have an entry like this?

    NAMES.DIRECTORY_PATH=

    Did you get an TNS-03535 error also?
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  3. #3
    Join Date
    Mar 2003
    Posts
    29

    Re

    That is exactly what it does!

    any ideas?

    thanks

    j

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    get rid of the sqlnet.ora file if you arent using a names server - dont really need it there

  5. #5
    Join Date
    Mar 2003
    Posts
    29
    thanks davey23uk

    that did the trick - still not sure why it tried doing that before but its solved now.

    Thanks again for all the help

  6. #6
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    If you're only configuration is via a tnsnames file, you can delete the sqlnet.ora file and it'll look for the tnsnames.ora file by default.

    The sqlnet.ora file is handy if you have names (defunct) or an ldap server (Oracle Internet Directory aka OID). Here's why.

    NAMES.DIRECTORY_PATH= LDAPSERVER1,BACKUPLDAPSERVER,TNSNAMES (surrounded by less/greater than symbols)

    That way if LDAPSERVER is down, BACKUPLDAPSERVER will be used for connection information, and if that's unavailable it'll cascade to your tnsnames.ora file in $ORACLE_HOME/network/admin. Perty nifty, huh. Personally, I like the idea of centrally managed connection information store.

    Sounds like you have a simple client side configuration, so, party on.

    PS. Davey, US thanks you for Paul Oakenfold, best thing from UK since the Beatles...
    Last edited by KenEwald; 09-03-2003 at 12:08 PM.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    what about the spice girls? surely you must love them

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