Consolidate all Oracle databases - Intergraph Smart 3D - Administration

Intergraph Smart 3D Project Management

3D Design and Visualization
Intergraph Smart 3D
2019 (10.0)

You must perform this procedure at the Host location using the administrative computer on which the replication process was first initiated.

  1. In the Project Management tree view, select the replicated model to consolidate.

  2. Click Tools > Consolidate Model from Workshare.

    You can also right-click a replicated model in the tree, and select Consolidate Model from Workshare on the shortcut menu.

  3. Type the GoldenGate administrator password, and click OK.

    A series of scripts are generated in a subfolder named "Consolidate<ModelName>" in the local temp folder.

  4. Copy the scripts in the folder to their corresponding servers. For more information, see Copy generated scripts into GoldenGate folders.

  5. Using the administrative account, connect to the Host server and all Satellite servers being removed.

  6. Run the following script from the command prompt:

    Consolidate_<Instance>.bat > Consolidate_<Instance>.log

  • You can click Start > Run and type %temp% in the Run dialog box to locate the local temp folder.

  • Although not a mandatory part of the consolidation of replicated databases workflow, it is recommended that you run the View Generator on the Model database. The View Generator is delivered to [Product Folder]\Administrator\Core\Tools\Administrator\Bin\ViewGenerator.exe.

  • The Reports database is excluded from the consolidation process. Consequently, you must regenerate the Reports database. For more information, see Regenerate the reports database.

  • After successful consolidation, the permission groups (and their objects) that were associated to the Satellite locations now belong to the Host location; the consolidated databases now behave as normal, non-replicated databases.