暂无图片
搭建DG的时候监听和tns设置的问题
我来答
分享
Edward
2023-06-28
搭建DG的时候监听和tns设置的问题
暂无图片 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

我来答
添加附件
收藏
分享
问题补充
2条回答
默认
最新
Edward

修改监听为静态后,主库启动提示

备库提示


这种情况正常吗?

暂无图片 评论
暂无图片 有用 2
My1492

正常的

暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏