暂无图片
分享
吴明
2020-04-08
dataguard配置dg_broker遇到的问题

在主库上通过dgmgrl去切换到备库的时候报错:DGMGRL> connect sys/3EEcAjsGcWdr@orcl
Connected.
DGMGRL> switchover to stdorcl
Performing switchover NOW, please wait…
Operation requires a connection to instance “stdorcl” on database “stdorcl”
Connecting to instance “stdorcl”…
Unable to connect to database
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Failed.
Warning: You are no longer connected to ORACLE.

    connect to instance "stdorcl" of database "stdorcl"

备库的参数:
StaticConnectIdentifier = ‘(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=std)(PORT=13899))(CONNECT_DATA=(SERVICE_NAME=stdorcl)(INSTANCE_NAME=stdorcl)(SERVER=DEDICATED)))’
但是,主库是可以通过tnsping通stdorcl的
[oracle@pri admin]$ tnsping stdorcl

TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 08-APR-2020 18:47:25

Copyright © 1997, 2013, Oracle. All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = std)(PORT = 13899)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = stdorcl)))
OK (0 msec)

备库的监听状态如下:
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=std)(PORT=13899)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC13899)))
Services Summary…
Service “stdorcl” has 1 instance(s).
Instance “stdorcl”, status UNKNOWN, has 1 handler(s) for this service…
Service “stdorcl_DGMGRL” has 1 instance(s).
Instance “stdorcl”, status UNKNOWN, has 1 handler(s) for this service…
The command completed successfully

备库重启监听多次,还是有这个问题。抓狂啊。。。
请问各位,这个问题大概的原因是什么?

收藏
分享
4条回答
默认
最新
杨卓

dg_broker连接串配置的问题,建议service_name使用DGMGRL的,编辑修改下
DGMGRL>
edit database tt11204 set property
StaticConnectIdentifier=’(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.20.88)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=tt11204_DGMGRL)(INSTANCE_NAME=tt11204)(SERVER=DEDICATED)))’;

暂无图片 评论
暂无图片 有用 0
吴明

已经改过参数
DGMGRL> edit database ‘stdorcl’ set property StaticConnectIdentifier=’(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=std)(PORT=13899))(CONNECT_DATA=(SERVICE_NAME=stdorcl_DGMGRL)(INSTANCE_NAME=stdorcl)(SERVER=DEDICATED)))’;
Property “staticconnectidentifier” updated
但是还是无法切换,报错信息跟之前的一样

暂无图片 评论
暂无图片 有用 0
吴明

问题已解决。。。备库的local_listener参数不对,修改之后,可以正常切换主备了

暂无图片 评论
暂无图片 有用 0
吴明
问题已关闭: 问题已经得到解决
暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏