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) ) )