Duplicate the model for Workshare across untrusted networks - 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)

This is only required if you are using Oracle as your database.

The Duplicate Model for Workshare Command generates the scripts and batch files to setup the replication process between the Host and each of the Satellites defined for the command. The process to create the scripts requires the Smart 3D workstation to make an Oracle connection to all database servers involved in the GWC. If a database server is on a domain that is untrusted, the connection fails and the scripts are not generated without first modifying the AUTHENTICATION_SERVICES sqlnet variable.

Follow these steps to setup workshare across untrusted domains:

  1. At the Host workstation, register the database servers from untrusted domains into the local TNSNAMES.ORA file.

  2. At the Satellite database server (untrusted) - Edit the Oracle sqlnet.ora file, and set authentication services to NONE. By default, this file is located in the ORACLE_HOME\network\admin folder.

    SQLNET.AUTHENTICATION_SERVICES=(NONE)

  3. Connect to the Host administrative workstation with Project Management, and create corresponding locations for the servers in untrusted domains.

  4. Using the administrative client computer at the Host location, run the Duplicate Model for Workshare Command, and add Satellites as usual. No errors should occur.

  5. At the Satellite database server (untrusted) - Edit the Oracle sqlnet.ora file, and set authentication back to Windows NT native authentication.

    SQLNET.AUTHENTICATION_SERVICES=(NTS)

  6. Copy the generated scripts from the Temp folder to their corresponding GoldenGate installation folders.

  7. Using the local administrator account, connect to the Host and Satellite servers, and execute the PreBackup scripts.

  8. Using the administrative client computer at the Host location, create the required database backups. See Make a Smart 3D backup.

  9. Copy the backup files to the servers in the untrusted domains.

  10. Using the administrative client computer at the Satellite location, restore the database backups to the servers on the domain in which replication is being setup. See Restore duplicated databases at Satellite locations.

  11. Using the local administrator account, connect to the Host and Satellite servers, and execute the PostRestore scripts.

  12. Finish the Global Workshare by performing additional configuration actions (regenerate the Reports databases at all satellites, setup the DuSS server, and monitor replication).