The ENABLE_GOLDENGATE_REPLICATION parameter of the Oracle instance must be enabled. You must also modify the UNDO_RETENTION value.
Perform the following procedure at the Host and all of the Satellite location servers that participate in the Workshare.
-
Open SQL *PLUS, and connect as a user with SYSDBA privileges.
-
At the SQL prompt, type show parameter goldengate, and press ENTER.
If the enable_goldengate_replication parameter value is FALSE, follow the steps below to enable GoldenGate replication on the database server.
-
Open SQL *Plus on the database server.
-
At the command prompt, type the following:
CMD> SQLPLUS /NOLOG
SQL> CONNECT SYS/[password] AS SYSDBA
SQL> ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION=TRUE SCOPE=SPFILE;
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP;
SQL> EXIT;