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