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;