ORA-02855: Number of requests is less than the number of slaves ORACLE 报错 故障修复 远程处理

文档解释

ORA-02855: Number of requests is less than the number of slaves

Cause: The value given for “db_slave_buffers” in your INIT.ORA file is less than the number specified for the number of slaves, “db_slaves.”

Action: Specify a number that is greater than that given for “db_slaves” Alternatively, specify 0. The kernel will supply the appropriate number.

ORA-2855：表示当前多个slave工作服务器请求的任务数量不及系统指定的任务数量。

官方解释

ORA-02855: number of requests is less than the number of slaves

Cause: The number of slaves that the user requested is greater than the number of requests.

Action: Either increase the number of requests or reduce the number of slaves.

常见案例

当ORA-02855错误发生时，可能是由于开发人员设置分布式工作服务器的数量超过了请求的数量。

正常处理方法及步骤

1、调整系统设置，减少slave工作服务器的数量使其与请求的任务数量一致。

2、如果可以，增加请求的任务数量以满足系统设置的需求。