文档解释
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];