ORA-29399: user string does not have privilege to switch to consumer group string

文档解释

ORA-29399: user string does not have privilege to switch to consumer group string

Cause: An attempt was made to set the initial consumer group of the specified user but the user does not have the privilege to switch to that group.

Action: Grant the privilege to switch to the consumer group to the user and then set the initial group.

ORA-29399错误指出用户没有切换到消费者组权限。

官方解释

ORA-29399,一般是由于对于已经在RAC环境上存在的消费者组,没有授予用户从另一个消费者组切换的权限。

常见的情况:

1. 在多实例环境中,某个实例登录时需要切换到特定的消费者组,如果用户没有被授予该消费者组的登录权限,就会出现ORA-29399错误。

2. 如果某个用户没有对已经存在的消费者组授予权限,也会出现ORA-29399错误。

一般处理方法及步骤

1. 使用SYSTEM或SYS用户切换到错误用户所属的消费者组,然后执行以下指令:

GRANT CONNECT TO [username] IDENTIFIED BY [user password];

GRANT RESOURCE TO [username];

2. 将用户添加到相应的消费者组的用户组中:

ALTER CONSUMER GROUP [consumer_group] ADD USER [username];

3. 如果要求用户必须以特定的消费者组登录,还需要设置登录default consumer group:

ALTER USER [username] DEFAULT CONSUMER GROUP [consumer_group];

你可能感兴趣的