Home › Oracle tnsnames.ora

Oracle tnsnames.ora 

Dr. Xi
Joined:
04/09/2007
Posts:
710

August 15, 2007 18:39:02    Last update: August 15, 2007 18:39:02
The tnsnames.ora file maps net service names to connect descriptors. Here's a sample: 

ORA10 =
  (DESCRIPTION = (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = somehost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME=ORA10)
    )
  )


When a client connects with a net service name, tnsnames.ora is searched in the following order:
  1. $HOME/.tnsnames.ora (or current working directory on Windows)
  2. $TNS_ADMIN/tnsnames.ora
  3. /etc/tnsnames.ora
  4. $ORACLE_HOME/network/admin/tnsnames.ora
Share |
| Comment  | Tags
 
Easy email testing with http://www.ximailstop.com

Related Notes