Set up a Hub and Spoke configuration for Oracle databases - Intergraph Smart 3D - Administration & Configuration

Intergraph Smart 3D Global Workshare (Oracle)

Language
English
Product
Intergraph Smart 3D
Subproduct
Global Workshare
Search by Category
Administration & Configuration
Smart 3D Version
12.1 (2019)

WDYWTD_ConfigureReplcation

The following topics pertain only to configuring a Hub and Spoke Global Workshare Configuration for Oracle databases between one Host and one or more Satellites.

GoldenGate is used as the driving software for the replication of data from the Host to all Satellite locations. It connects and captures database changes at the Host location, stages the changes into local files, propagates the changes to the remote servers, and then applies the changes at the Satellite database locations. Model database changes at Satellite locations are similarly propagated back to the Host location.

  • You cannot use Global Workshare if you are running Oracle on Linux. You must run Oracle on a Windows-based computer to set up Global Workshare.

  • Do not delete the Oracle Archive Log files, unless you are certain they can be safely removed. Deleting these files while GoldenGate still requires them causes the Extract processes to hang. This hang event can be complicated to resolve and sometimes the only solution is to consolidate and reconfigure the Global Workshare.

  • Oracle GoldenGate should be monitored daily to confirm that the changes are being propagated and that all processes are enabled and healthy. Immediately contact Smart 3D Support for an investigation if problems are noticed, as these issues compound with time. See Monitor replication.

  • Configuring Global Workshare within an integrated environment is a detailed and complicated process. Contact PPM Smart Community for assistance.

What do you want to do?