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

Thread: TNSPing????

Threaded View

  1. #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

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