ORA-07453: requested resource manager plan schema does not contain OTHER_GROUPS

文档解释

ORA-07453: requested resource manager plan schema does not contain OTHER_GROUPS

Cause: User tried to load a resource manager plan schema that does not contain the OTHER_GROUPS group.

Action: Use a resource manager plan schema that contains the OTHER_GROUPS group.

ORA-07453:请求的资源管理计划架构不包含OTHER_GROUPS

(1)官方解释

ORA-07453: requested resource manager plan schema does not contain OTHER_GROUPS

Cause: The requested resource manager plan did not contain the OTHER_GROUPS resource consumer group

Action: Retry the operation with a plan schema that contains the OTHER_GROUPS resource consumer group

(2)常见案例

当ORACLE想使用pdbshell连接使用从现有的一个资源管理计划后可能出现的错误:

ORA-07453: requested resource manager plan schema does not contain OTHER_GROUPS

(3)正常处理方法及步骤

原因:

由于在资源管理计划方案中缺少OTHER_GROUPS资源消费者组,因此出现此错误。

正常处理方法及步骤

1、使用SQL管理者,创建OTHER_GROUPS资源消费者组;

2、设置OTHER_GROUPS资源消费者组属性,将其设置为最小优先级(级别0)

SQL>alter system set resource_manager_plan=’DBA/default_plan’ SCOPE=BOTH;

3、将OTHER_GROUPS资源消费者组添加到资源管理计划方案中;

4、重新尝试使用pdbshell连接到指定的数据库。

你可能感兴趣的