Perform the following procedure at the Host and all of the Satellite locations 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 value returned is FALSE, you must enable GoldenGate replication on the database server. It is also required to update the undo retention to 86400.
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> ALTER SYSTEM SET UNDO_RETENTION=86400 scope=spfile;
SQL> SHUTDOWN IMMEDIATE;