适用范围

ORACLE 11g DG Broker 切换报ORA-12545

问题概述

在 ORACLE RAC 到单机 DG Broker 配置与切换 的切换过程中遇到 ORA-12545: Connect failed because target host or object does not exist 具体报错如下：

DGMGRL> switchover to rac11g;
Performing switchover NOW, please wait...
Operation requires a connection to instance "rac11g1" on database "rac11g"
Connecting to instance "rac11g1"...
Connected.
New primary database "rac11g" is opening...
Operation requires startup of instance "RAC11GDG" on database "rac11gdg"
Starting instance "RAC11GDG"...
Unable to connect to database
ORA-12545: Connect failed because target host or object does not exist

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

Please complete the following steps to finish switchover:
	start up instance "RAC11GDG" of database "rac11gdg"

问题原因

DG Broker 中的staticConnectidentifier 配置为hostname，主库无法解析此 hostname，导致无法连接。

处理过程

检查 rac11gdg 详细信息

DGMGRL> show database verbose  rac11gdg