GGSCI (localhost.localdomain as c##goldengate@ora12c/CDB$ROOT) 59> dblogin userid c##goldengate, password goldengate
Successfully logged into database CDB$ROOT.
GGSCI (localhost.localdomain as c##goldengate@ora12c/CDB$ROOT) 60> register extract ext database container (ora12cpdb1)
2019-08-19 09:45:00 ERROR OGG-08221 Cannot register or unregister EXTRACT EXT because of the following SQL error: OCI Error ORA (status = 1031-ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 319
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 104
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 135
ORA-06512: at line 1
).
尝试单独赋予权限也不行:
grant execute on SYS.DBMS_XSTREAM_GG_INTERNAL to c##goldengate;
grant execute on SYS.DBMS_XSTREAM_GG to c##goldengate;
grant execute on SYS.DBMS_XSTREAM_GG to c##goldengate;
网上说这是一个bug,需要打补丁.
Successfully logged into database CDB$ROOT.
GGSCI (localhost.localdomain as c##goldengate@ora12c/CDB$ROOT) 60> register extract ext database container (ora12cpdb1)
2019-08-19 09:45:00 ERROR OGG-08221 Cannot register or unregister EXTRACT EXT because of the following SQL error: OCI Error ORA (status = 1031-ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 319
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 104
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 135
ORA-06512: at line 1
).
尝试单独赋予权限也不行:
grant execute on SYS.DBMS_XSTREAM_GG_INTERNAL to c##goldengate;
grant execute on SYS.DBMS_XSTREAM_GG to c##goldengate;
grant execute on SYS.DBMS_XSTREAM_GG to c##goldengate;
网上说这是一个bug,需要打补丁.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/77311/viewspace-3126834/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
单节点的es添加另外一个节点组成主从集群
下一篇：
es备份迁移到另外的机器
请登录后发表评论
登录
全部评论
