配置RAC+DG的时候,发现在配置监听这里不太顺利,先将其记下。以下配置仅为监听部分的配置。
环境:
RAC(主库)双节点
备库为单实例
Rdbms版本:11R2
RAC节点1:
$ pwd
/pmsdb/oracle/11.1.0/network/admin
$ cat listener.ora
# listener.ora.i2prddb5 Network Configuration File: /pmsdb/oracle/11.1.0/network/admin/listener.ora.i2prddb5
# Generated by Oracle configuration tools.
SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(GLOBAL_DBNAME=PMSZKFDB)(ORACLE_HOME=/pmsdb/oracle/11.1.0)(SID_NAME=ZKFP1)))
LISTENER_PMSZFPD3 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = PMSZFPD3-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.139)(PORT = 1521)(IP = FIRST))
)
)
zkf_pri =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = PMSZFPD3)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ZKF_PRI)
)
)
$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /pmsdb/oracle/11.1.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_DB =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.141)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.142)(PORT = 1521))
)
zkf_pri =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.141)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ZKF_PRI)
)
)
zkf_stb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.233)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ZKF_STB)
)
)
zkfp2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.140)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ZKF_PRI)
)
)
LISTENER_SCAN =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.143)(PORT = 1521))
RAC节点2:
$ pwd
/pmsdb/oracle/11.1.0/network/admin
$ cat listener.ora
# listener.ora.i2prddb5 Network Configuration File: /pmsdb/oracle/11.1.0/network/admin/listener.ora.i2prddb5
# Generated by Oracle configuration tools.
SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(GLOBAL_DBNAME=PMSZKFDB)(ORACLE_HOME=/pmsdb/oracle/11.1.0)(SID_NAME=ZKFP2)))
LISTENER_PMSZFPD4 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = PMSZFPD4-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.140)(PORT = 1521)(IP = FIRST))
)
)
zkf_pri =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = PMSZFPD4)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ZKF_PRI)
)
)
$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /pmsdb/oracle/11.1.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_DB =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.141)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.142)(PORT = 1521))
)
zkfp2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.140)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ZKF_PRI)
)
)
zkf_stb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.233)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ZKF_STB)
)
)
zkf_pri =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.141)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ZKF_PRI)
)
)
LISTENER_SCAN =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.143)(PORT = 1521))
)
备库DG(单实例):
$ pwd
/pmsdb/oracle/ZKFT1/11.1.0/network/admin
$ cat listener.ora
# listener.ora Network Configuration File: /pmsdb/oracle/ZKFT1/11.1.0/network/admin/listener.ora
# Generated by Oracle configuration tools.
ZKF_STB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.233)(PORT = 1523))
)
SID_LIST_ZKF_STB =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ZKF_STB)
(ORACLE_HOME = /pmsdb/oracle/ZKFT1/11.1.0)
(SID_NAME = ZKFP1)
)
)
$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /pmsdb/oracle/ZKFT1/11.1.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ZKF_PRI =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.141)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ZKF_PRI)
)
)
ZKF_STB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.233)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ZKF_STB)
)
)
ZKFP2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.29.96.140)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ZKF_PRI)
)
)
TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = I2TRNDB2)(PORT = 1523))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TEST)
)
)