Oracle 9i Listener
listener.ora in $ORACLE_HOME/network/admin with the following contents:
SID_LIST_LISTENER_VRTS1 = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /sfrac/oracle/product/9.2.0) (PROGRAM = extproc) ) (SID_DESC = (ORACLE_HOME = /sfrac/oracle/product/9.2.0) (SID_NAME = VRTS1) ) ) SID_LIST_LISTENER_VRTS2 = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /sfrac/oracle/product/9.2.0) (PROGRAM = extproc) ) (SID_DESC = (ORACLE_HOME = /sfrac/oracle/product/9.2.0) (SID_NAME = VRTS2) ) ) LISTENER_VRTS2 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = erpcc8)(PORT = 1521)) ) ) ) LISTENER_VRTS1 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = erpcc2)(PORT = 1521)) ) ) )
create the file tnsnames.ora with the following contents:
LISTENER_VRTS1 = (ADDRESS = (PROTOCOL = TCP)(HOST = erpcc2)(PORT = 1521)) LISTENER_VRTS2 = (ADDRESS = (PROTOCOL = TCP)(HOST = erpcc8)(PORT = 1521)) VRTS2 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = erpcc8)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = VRTS) (INSTANCE_NAME = VRTS2) ) ) LISTENERS_VRTS = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = erpcc8)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = erpcc2)(PORT = 1521)) ) VRTS = (DESCRIPTION = (LOAD_BALANCE = YES) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = erpcc8)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = erpcc2)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = VRTS) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) ) ) VRTS1 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = erpcc2)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = VRTS) (INSTANCE_NAME = VRTS1) ) )
Reference
http://eval.veritas.com/mktginfo/products/White_Papers/High_Availability/IBM_Paper_on_SFRAC.pdf