Verify databases are enabled for GoldenGate Replication - Intergraph Smart 3D - Administration & Configuration

Perform the following procedure at the Host and all of the Satellite location servers that participate in the Workshare.

This procedure is only applicable for Oracle versions 12.1.0.2 and later.

1. Open SQL *PLUS, and connect as a user with SYSDBA privileges.

2. At the SQL prompt, type show parameter goldengate, and press ENTER.

   

If the enable_goldengate_replication parameter value is FALSE, you must enable GoldenGate replication on the database server.

1. Open SQL *Plus on the database server.

2. 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;