5M执行rman target sys/Sap12345@MWEASDB auxiliary sys/Sap12345@MWEASDBDG的时候提示
1、在主库执行tnsping 
2、在备库执行ping
都是自己ping自己通,找备库不通。
-------------------------------------------------
1、主库的tns设置
MWEASDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.4 )(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MWEASDB)
)
)
LISTENER_MWEASDB =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.4 )(PORT = 1521))
MWEASDBDG =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.36.166)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = MWEASDBDG)
)
)
2、主库的监听设置
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.4)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
----------------------------------------
3、备库的tns设置
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/19.3.0/db_home1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
MWEASDBDG =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.36.166)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MWEASDBDG)
)
)
LISTENER_MWEASDB =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.36.166)(PORT = 1521))
MWEASDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.4)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = MWEASDB)
)
)
5、备库的监听设置
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.36.166)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
ADR_BASE_LISTENER = /u01/app/oracle
墨值悬赏



评论
