Verify databases are enabled for GoldenGate replication - Intergraph Smart 3D - Administration & Configuration - Hexagon PPM

Intergraph Smart 3D Global Workshare (Oracle)

Language
English
Product
Intergraph Smart 3D
Subproduct
Global Workshare
Search by Category
Administration & Configuration
Smart 3D Version
13

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.

  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, follow the steps below to 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;