Wednesday, March 2, 2011

Multiple listeners with fail over and load balancing?


Listener.ora

LISTENER1 =
(ADDRESS_LIST =
 (ADDRESS= (PROTOCOL= TCP)(Host= mypc1)(Port= 1526))
)
LISTENER2 =
(ADDRESS_LIST =
 (ADDRESS= (PROTOCOL= TCP)(Host= mypc1)(Port= 1536))
)
SID_LIST_LISTENER1=
(
SID_LIST = (SID_DESC = (GLOBAL_DBNAME= oradb1) (ORACLE_HOME= /u01/816) (SID_NAME = oradb1) )
)

SID_LIST_LISTENER2=
(
SID_LIST = (SID_DESC = (GLOBAL_DBNAME= oradb1) (ORACLE_HOME= /u01/816) (SID_NAME = oradb2) )
)


TNS Entry :-

oradb1 =
(
   DESCRIPTION = (FAILOVER=on) (LOAD_BALANCE=on)
   (ADDRESS = (PROTOCOL = TCP)(HOST = mypc1)(PORT =1526))
   (ADDRESS = (PROTOCOL = TCP)(HOST = mypc1)(PORT =1536))
   (CONNECT_DATA = (SERVICE_NAME = oradb1))
)

No comments:

Post a Comment