ORA-56704: EXPLICIT consumer group mapping priority must be set to 1 ORACLE 报错 故障修复 远程处理

文档解释

ORA-56704: EXPLICIT consumer group mapping priority must be set to 1

Cause: An attempt was made to set the EXPLICIT mapping priority to a value other than 1.

Action: Set the mapping priorities to unique integers within the documented range with the EXPLICT priority set to 1.

ORA-56704 is an Oracle database error that occurs when trying to assign explicit consumer group mapping priority to a PDB, which must be set to 1 or higher.

官方解释

This error is caused when attempting to assign a consumer group priority to a PDB that is either not specified or is lower than the minimum required value of 1. The consumer group mapping priority defines the order in which any database transactions are mapped to consumer groups in the PDB.

常见案例

To resolve this error, the user must specify a valid explicit consumer group mapping priority that is equal to or greater than 1 and assign it to the PDB. This can be done using the ALTER PLUGGABLE DATABASE command:

ALTER PLUGGABLE DATABASE pdbname SET DB_CONSUMER_GROUP_MAPPING=’consumer_group_mapping_solution’;

一般处理方法及步骤

ALTER PLUGGABLE DATABASE pdbname SET DB_CONSUMER_GROUP_MAPPING=’consumer_group_mapping_solution’;