connect strings for sqlnet

on October 10, 2008 at 1:56 pm
Posted In: Oracle odds and ends (Cat)

INSTANCE_NAME = HOSTA
SERVICE_NAME=SVCA

SID=SIDA

CONNECT system@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=1.2.3.4)(PORT=1521))
(connect_data=(sid=hosta)))

 

CONNECT system@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=1.2.3.4)(PORT=1521))
(connect_data=(service_name=svca)))

CONNECT system@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=1.2.3.4)(PORT=1521))
(connect_data=(sid=sida)))

CONNECT system@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=1.2.3.4)(PORT=1521))
(connect_data=(sid=sida)(service_name=svca)))