Oracle数据库 加入小组
【故障处理】 ORA-16665 Time Out Waiting For The Result From A Member
【问题描述】
有朋友遇到DG Broker报错，截图如下：
【分析】
可能是由于DGBroker超时导致的，相关参数有OperationTimeout。
该参数配置属性指定代理应等待运行状况检查、获取可监控属性和设置属性操作以完成的最长时间。
可以尝试调大该参数的值
DGMGRL> EDIT CONFIGURATION SET PROPERTY OperationTimeout=120;
8.1.12 OperationTimeout
The OperationTimeout configuration property specifies the maximum amount of time the broker should wait for health check, get monitorable property, and set property operations to complete.
| Category | Description |
|---|---|
|
Datatype |
Integer |
|
Valid values |
>= 30 and <= 3600 |
|
Broker default |
30 seconds |
|
Imported? |
No |
|
Parameter class |
Not applicable |
|
Role |
Primary and standby |
|
Standby type |
Not applicable |
|
Corresponds to |
Not applicable |
|
Scope |
Broker configuration. This property will be consumed by broker on all databases in the configuration. |
|
Cloud Control name |
Not applicable |
【参考文档】
http://ke.sandata.com.cn/page/531
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/dgbkr/oracle-data-guard-broker-properties.html#GUID-C256CDA1-B9D0-432A-95D5-2123DCFCCDCA
