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,需要打补丁.