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

Hybrid View

  1. #1
    Join Date
    Sep 2001

    Oracle Client Connecting to Database without tnsnames.ora file


    I ve installed oracle client in one of my desktop . i made entries in the tnsnames,.ora file for the connect string and the connection was thro and working perfectly. now i deleted the tnsnames.ora file from the machine and still iam able to connect to the database from the client machine with the same connect string but iam not able to connect using any othe connect string value.

    how does a client connect to the server without referring to the tnsnames.ora file. is there any other file which it could refer to .pls clarify me on this.

    thanks in advance

  2. #2
    Join Date
    Nov 2001
    Planet Earth
    maybe u r using names server
    The man called Zorro

  3. #3
    Join Date
    Mar 2002
    Manchester, England
    you havent a tnsnames file in you current working dir have you?

    you'll find that it'll use that before it goes to the 'correct' file in %ORACLE_HOME%/network/admin (windows....im not sure about unix) so even if you delete the original it use the local file just to screw with your head.

  4. #4
    Join Date
    Mar 2002
    Mesa, Arizona
    Here's one approach.

    Do you have a sqlnet.ora file anywhere on your client?

    If so, look for the parameter NAMES.DIRECTORY_PATH

    It may look something like this: NAMES.DIRECTORY_PATH=(tnsnames, ldap)

    It specifies what to use for name (connection info) resolution and in what order to use it.

    It might be helpful to run netca and netmgr and see what Oracle think's it's got - that is, if you don't want to do a manual configuration of name resolution.

    Sucks, don't it. This could be made a ton easier.
    "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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.