OGG FAQ

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;

 
上一篇:DedeCms完美的FLASH幻灯代码


下一篇:es基本查询相关的