Q1:oracle_关于参数.ENABLE_GOLDENGATE_REPLICATION
A:
So, in order to use OGG, on Oracle 11.2.0.4, or Oracle 12.1.0.2+, you will need to issue the following command through SQL*Plus.
ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION = TRUE SCOPE=BOTH;
This only needs to be done once, and in a RAC environment, will take effect on all instances. It can be done without bouncing the database instance, and you’ll want to use SCOPE=BOTH or update the init.ora file to ensure that when the database is bounced, the setting remains in effect.
Q2:
WARNING OGG-01194 EXTRACT task LOAD2 abended : There is no trail to reposition to when doing direct load task
a: The cause was that the GoldenGate user did not have the privileges needed to insert rows into the target database.
It was solved by grant the insert any privilege: grant insert any table to ggs_owner;