Showing posts with label Oracle. Show all posts
Showing posts with label Oracle. Show all posts

Wednesday, January 7, 2009

Oracle OraClient Network Configuration

After Oracle OraClient has been installed, network connection can be added, edited manually from Network Configuration File. This file locates in X:\oracle\product\10.2.0\client_1\network\admin\tnsnames.ora. Its syntax looks like

ServiceName =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = HostName)(PORT = HostPort))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ServiceName)
    )
  )