Oracle Database Administration: The Essential Refe

tnsnames.ora

The following file will allow Oracle client machines to access three databases on the network: DB1 is accessed using TCP/IP, DB2 is accessed using SPX/IPX, and DB3 is accessed using the named pipes protocol:

DB1.world = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
        (ADDRESS = 
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (HOST = Production1)
          (PORT = 1526)
        )
    )
    (CONNECT_DATA = (SID = DB1)
    )
  )
DB2.world = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
        (ADDRESS = 
          (COMMUNITY = spx.world)
          (PROTOCOL = SPX)
          (SERVICE = Server_lsnr)
        )
    )
    (CONNECT_DATA = (SID = DB2)
    )
  )
DB3.world = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
        (ADDRESS = 
          (COMMUNITY = nmp.world)
          (PROTOCOL = NMP)
          (SERVER = FinanceServer1)
          (PIPE = ORAPIPE)
        )
    )
    (CONNECT_DATA = (SID = DB3)
    )
  )