Verify Databases are enabled for GoldenGate Replication - Intergraph Smart 3D - Administration

Intergraph Smart 3D Project Management

PPMProductFamily
3D Design and Visualization
PPMProduct
Intergraph Smart 3D
PPMCategory
Administration
Version_S3D
10.1(2014R1)

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

  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 value returned is FALSE, you must enable GoldenGate replication on the database server. It is also required to update the undo retention to 86400.

  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> ALTER SYSTEM SET UNDO_RETENTION=86400 scope=spfile;

    SQL> SHUTDOWN IMMEDIATE;

    SQL> STARTUP;

    SQL> EXIT;