重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: kfs 在线oracle到kingbase的主服务时报错之ORA-04060: insufficient privilege [打印本页]

作者: 郑全 时间: 前天 18:00
标题: kfs 在线oracle到kingbase的主服务时报错之ORA-04060: insufficient privilege
问题：
   在O 2 K 环境中，在线主服务时，报权限不够的错误：
   [flysync@node2 ~]$ repswitch -conf switch_conf online oracle40
2026-07-29 11:17:36 |             | [ - main] INFO  util.ConnectMBean conn start
2026-07-29 11:17:36 |             | [ - main] INFO  util.ConnectMBean Connected to replicator process
2026-07-29 11:17:36 |             | [ - main] INFO  util.ConnectMBean Connected to ReplicationServiceManagerMBean
2026-07-29 11:17:36 |             | [ - main] INFO  util.ConnectMBean conn start
2026-07-29 11:17:36 |             | [ - main] INFO  util.ConnectMBean Connected to replicator process
2026-07-29 11:17:36 |             | [ - main] INFO  util.ConnectMBean Connected to ReplicationServiceManagerMBean
2026-07-29 11:17:36 |             | [ - main] INFO  util.ConnectMBean Connected to OpenReplicatorManagerMBean: ora11
2026-07-29 11:17:36 |             | [ - main] INFO  util.ConnectMBean Connected to OpenReplicatorManagerMBean: kes91
Processing online command...
2026-07-29 11:17:36 |             | [ - main] INFO  util.ConnectMBean Connected to OpenReplicatorManagerMBean: ora11
2026-07-29 11:17:36 |             | [ - main] INFO  database.AbstractDatabase Loading database driver: oracle.jdbc.driver.OracleDriver
Set extractor start specific event ID:ora:1268527
put node oracle40 to online status error, Online operation failed (Unable to set logging: ORA-04060: insufficient privileges to execute DBMS_STREAMS.SET_TAG
ORA-06512: at "SYS.DBMS_STREAMS", line 16
ORA-06512: at line 1
)

原因：
   主要是oracle 数据库中flysync用户，缺少角色EXECUTE_CATALOG_ROLE 导致。

解决办法：
   直接授权这个角色或者DBA即可
   grant EXECUTE_CATALOG_ROLE to flysync;

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)