当前位置:网站首页>Ora-16525 DG broker not available
Ora-16525 DG broker not available
2022-07-22 17:02:00 【cqszpx】
database :Oracle 11.2.0.4
System :CentOS 7.9
Problem description :dgmgrl perform show configuration command , The following appears ora-16525 abnormal , As shown below :
DGMGRL> show configuration;
Error:
ORA-16525: the Data Guard broker is notyet available
Configuration details cannot be determinedby DGMGRL
Check the alarm log :
[[email protected] trace]$ catdrcorcl150.log (drcorcl150.log stay $
ORACLE_BASE/rdbms/orcl150/orcl150/trace Under the table of contents )
....
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)
The primary and standby databases here dg_broker_start Are all 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
Try to dg_broker_start Set to "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
Conclusion : Transfer the primary and standby databases dg_broker_start It is amended as follows true,showconfiguration Normal display .
The following is the log information :
[[email protected] 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
边栏推荐
- Hiam fine-grained unified authorization management helps enterprises achieve refined management and control of system permissions
- AT1225 かかし
- ES6 arrow function
- When the win10 system is turned on, the response is slower than usual. How to solve it by turning around and waiting for 1 minute?
- 1143. 最长公共子序列
- On the continuous chain use of promise then
- npm私服发包及使用
- [vs] trying to load a program with incorrect format
- Random forest learning notes
- Understand recursion and iteration
猜你喜欢
How much do you know about hande digital platform system and trial?
【Redis】分布式场景下Redis高可用部署方案
STM32 tutorial on using various sensors
[MySQL] SQL tuning practice teaching
Simple tutorial of STM32 control motor
[vs] trying to load a program with incorrect format
TensorFlow 各优化器在鸢尾花分类任务中的应用
GD32F470之串口空闲中断+DMA篇
Codeforce d2. RGB substring (hard version) sliding window
HZERO企业级数字PaaS平台 (二)| 企业级权限体系
随机推荐
5.SSH远程服务
Visual system design example (Halcon WinForm) -8. matching search
HIAM细粒度统一授权管理助力企业实现系统权限精细化管控
ES6 let and Const
【专题分享】汉得企业级PaaS平台HZERO之开源专题
还有人不会这些数据分析小案例吗?一招教你招聘数据可视化~
【MySQL】sql调优实战教学
Use ffmpeg to push and pull streams
ig,ax = plt.subplots()
微信支付项目实战、创建订单到支付退款代码详解
ES6 template string
[redis] redis high availability deployment scheme in distributed scenarios
【网页性能优化】-—— 关于图片懒加载
ARC110E Shorten ABC
教程更新20220719
opencv支持H264视频编码
The function and application of tostring() and rewriting
Mecol Studio - harmonyos second assignment
Complex network modeling (network robustness)
线程系列协程原理