[重庆思庄每日技术分享]-ORA-16525 dg broker不可用

数据库：Oracle 11.2.0.4

系统：CentOS 7.9

问题描述：dgmgrl执行show configuration命令，出现以下ora-16525异常，如下所示：

DGMGRL> show configuration;

Error:

ORA-16525: the Data Guard broker is notyet available

Configuration details cannot be determinedby DGMGRL

查看告警日志：

[oracle@oel trace]$ catdrcorcl150.log (drcorcl150.log 在$ORACLE_BASE/rdbms/orcl150/orcl150/trace目录下)

....

05/27/2022 17:40:54

Data Guard Broker shutting down

RSM0 successfully terminated

05/27/2022 17:40:57

>> Data Guard Broker Has Been ShutDown <<

Fore Deregistering service ORCL150_DGBwith listener(s)

此处主备库的dg_broker_start均为false

SQL> show parameter dg_broker

NAME TYPE VALUE

----------------------------------------------- ------------------------------

dg_broker_config_file1 string /u01/app/oracle/product/11.2.0

/db_1/dbs/dr1ORCL150.dat

dg_broker_config_file2 string /u01/app/oracle/product/11.2.0

/db_1/dbs/dr2ORCL150.dat

dg_broker_start boolean FALSE

尝试将dg_broker_start设置为"true".

SQL> alter system setdg_broker_start=true;

System altered.

DGMGRL> show configuration;

Configuration - dg_conf

Protection Mode: MaxPerformance

Databases:

orcl150 - Primary database

orcl151 - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS

结论：将主备库dg_broker_start修改为true，showconfiguration正常显示.

以下为日志信息：

[oracle@oel trace]$ cat drcorcl150.log

......

05/27/2022 17:40:54

Data Guard Broker shutting down

RSM0 successfully terminated

05/27/2022 17:40:57

>> Data Guard Broker Has Been ShutDown <<

Fore Deregistering service ORCL150_DGBwith listener(s)

05/28/2022 13:29:47

Creating Data Guard Broker Monitor Process(DMON)

05/28/2022 13:29:50

>> Starting Data Guard Brokerbootstrap <<

Broker Configuration File Locations:

dg_broker_config_file1 ="/u01/app/oracle/product/11.2.0/db_1/dbs/dr1ORCL150.dat"

dg_broker_config_file2 = "/u01/app/oracle/product/11.2.0/db_1/dbs/dr2ORCL150.dat"

05/28/2022 13:29:54

DMON Registering service ORCL150_DGB withlistener(s)

Broker Configuration: "dg_conf"

Protection Mode: Maximum Performance

Fast-Start Failover (FSFO): Disabled, flags=0x0, version=0

Primary Database: orcl150 (0x01010000)

Standby Database: orcl151, Enabled Physical Standby (0x02010000)

05/28/2022 13:29:58

Site orcl151 returned ORA-16525.

Version Check Results:

Database orcl151 returned ORA-16525

Creating process RSM0