首先在主上查看报如下错误: DGMGRL> show configuration; Configuration - queue_zs_dg Protection Mode: MaxPerformance Databases: queuedb - Primary database queuedb02 - Physical standby database Error: ORA-16664: unable to receive the result from a database Fast-Start Failover: DISABLED Configuration ...
16664with ORA-12514. 解决办法 edit data <standby set property StaticConnect'<Static Address>'; 例如: edit database hrz set property StaticConnectIdentifier'(DESCRIPTION(ADDRESS=(PROTOCOL=tcp)(HOST=sd3)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=hrz_DGMGRL.sd3)(INSTANCE_NAME=hrz)(SERVER=...
Error: ORA-16664: unable to receive the result from a member 6.检查PRODDG02的状态 DGMGRL> show...
在主库上使用DGMGRL检查配置时遇到DGM-17016和ORA-16664 报错 更改 新配置的broker DGMGRL> CREATE CONFIGURATION DG_CONFIG AS PRIMARY DATABASE IS PRIMARY CONNECT IDENTIFIER IS PRIMARY; Configuration "dg_config" created with primary database "primary" DGMGRL> ADD DATABASE STANDBY AS CONNECT IDENTIFIER IS ...
Warning: ORA-16792: configurable property value is inconsistent with member setting 现象: DGMGRL> show configuration Configuration - lhr122 Protection Mode: MaxPerformance Members: lhr122 - Primary database lhr122dg - Physical standby database
动图 动图 动图 917 1323 ñ16664 3月18日 21:30 来自快乐大本营超话 û收藏 转发 评论 ñ赞 评论 o p 同时转发到我的微博 同时评论给 快乐大本营 按热度 按时间 正在加载,请稍候...1510关注 1071粉丝 31055微博 微关系 她的关注(1324) 粉丝红包 李大锤同学 钟文泽 微博红包 她的...
Fast-Start Failover: DISABLED Configuration Status: WARNING (status updated 5 seconds ago) DGMGRL> show database lhr122dg InconsistentProperties INCONSISTENT PROPERTIES INSTANCE_NAME PROPERTY_NAME MEMORY_VALUE SPFILE_VALUE BROKER_VALUE lhr122dg ArchiveLagTarget 0 0 ...
· oracle 19c dgbroker 报错ORA-16664 with ORA-12514如何解决 · OGG-03542 Failed to connect to the database · 低版本客户端连接19C RAC数据库报ORA-28040协议错误 · Oracle 低版本客户端连接19C报错ORA-28040 · ASM数据库启动报ORA-01078,ORA-01565,ORA-17503,ORA-01017 阅读排行: · 为...
最近在弄11g的dg时,遇到如下问题,记录下。 首先在主上查看报如下错误: DGMGRL> show configuration; Configuration - queue_zs_dg Protection Mode: MaxPerformance Databases: queuedb - Primary database queuedb02 - Physical standby database Error: ORA-16664: unable to receive the result from a database ...
Warning: ORA-16792: configurable property value is inconsistent with member setting Fast-Start Failover: DISABLED Configuration Status: WARNING (status updated 5 seconds ago) DGMGRL> show database lhr122dg InconsistentProperties INCONSISTENT PROPERTIES ...