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’;

香港美国云服务器首选后浪云，2H2G首月10元开通。
后浪云（www.IDC.Net）提供简单好用，价格厚道的香港/美国云服务器和独立服务器。IDC+ISP+ICP资质。ARIN和APNIC会员。成熟技术团队15年行业经验。