Consolidate all Oracle databases - 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

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, select the replicated model to consolidate.

  2. Click Tools > Consolidate Model from Workshare Command to open the Consolidate Models from Workshare Dialog.

  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. 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 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. See Regenerate the reports database.

  • After a 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.

  • If needed, you can move all the objects from the permission groups at the workshare location to a one or multiple mapped permission groups at the host location. See Move objects between permission groups in a consolidated model.