Hello Everyone,
I am trying to configure Oracle Goldengate 12.3 MA running on RHLE 7.4 to replicate between to Oracle 11.2.0.4 databases. I am taking advantage of the Web Interface for the initial trial configuration. I have GG running and I am able to connect to the Service Manager and the Admin Server without any issues. However, my next step is to create the first extract using the Admin Server. The AS connects to the database without any issues, but once I try to create the first extract service, it generates this following information for the Parameter File:
extract EXT1
useridalias GGADMIN_ORADEV1 domain OracleGoldenGate
exttrail /u003/ae
TABLE GABE.table1;
After I click on Create and Run, I get the following error:
EXTRACT (Integrated) added.
Cannot register or unregister EXTRACT EXT1 because of the following SQL error: OCI Error ORA (status = 1031-ORA-01031: insufficient privileges ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 94 ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 93 ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 124 ORA-06512: at line 1 ).
Deleted EXTRACT EXT1.