Add a satellite to an existing Oracle Global Workshare - Intergraph Smart 3D - Administration & Configuration - Hexagon

Intergraph Smart 3D Project Management

Language
English
Product
Intergraph Smart 3D
Subproduct
Project Management
Search by Category
Administration & Configuration
Smart 3D Version
13.1

This procedure steps you through adding a new Satellite to an existing Oracle Global Workshare Configuration (GWC).

  • The new Satellite must be properly configured for GoldenGate replication before proceeding. This includes installing the GoldenGate software, creating the GoldenGate administrator account, creating the GoldenGate service account, and configuring the network connectivity between the administrative workstation and the two servers.

  • For information on setting up a new Oracle GWC, see Set up an Oracle Global Workshare.

  1. Connect to the Host server, and open Project Management.

  2. Create a new location for the new Satellite.

  3. Duplicate the model for a Global Workshare Configuration for the new Satellite location.

  4. In the Duplicate Model for Workshare Dialog, select the new Satellite location, and click Add >>>. When prompted, type the GoldenGate administrator account password.

    A new set of scripts is created and placed in the AddSatellite_<Location>_<Model> folder.

  5. Navigate to the local temp folder, and open AddSatellite_<Location>_<Model>. To locate the local temp folder, click Start > Run, and type %temp% in the Run dialog.

  6. Copy the scripts into their corresponding servers. See Copy generated scripts into GoldenGate folders.

  7. Execute the PreBackup scripts on the Host server and the newly added Satellite server.

  8. Create a backup file of the model.

  9. Transfer a copy the backup files and a copy of the SharedContent folder to the new Satellite server and restore the database to the Satellite location using the correct workshare location. See Restore a site database

  10. Execute the PostRestore scripts on the Host server and the newly added Satellite server.

  11. Regenerate the Reports databases at the newly added Satellite server.

  12. After the scripts finish executing, monitor the replication to ensure that all GoldenGate processes are running.

  • Users do not have to stop working on existing satellites when a new Satellite is added to an existing Oracle GWC.

  • To track any unusual errors that might occur, it is recommended that you output the setup Golden Gate batch files to a .log file. For example, to create an output log file when you execute a batch file named PostRestore.bat located in a subfolder of the C:\temp folder, type the following in the Run dialog: C:\temp\ReplicationPlant1\PostRestore.bat > C:\temp\ReplicationPlant1\PostRestore.log.

  • You must run the PreBackup.bat or PreBackup<ServiceName>.bat file before you make the backup files on the host. The PostRestore.bat or PostRestore<ServiceName>.bat file must be run after you restore the backup files on the Satellites.