Results 1 to 2 of 2

Thread: access to the tnsname

  1. #1
    Join Date
    Jun 2006
    Posts
    16

    access to the tnsname

    I have a computer that do a connexion to a remote oracle database.
    Where can i specify to it the emplacement of the tnsname on the server ?

  2. #2
    Join Date
    Jun 2006
    Posts
    4
    If you have sqlplus installed on your pc- it will look in the ORACLE_HOME/network/admin for a tnsnames.ora file. This file on your pc must have the information for the remote database that you want to connect to.
    In addition the environment variable TNS_ADMIN can point to another location.

    -clp

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •