Duplicate Model for Workshare across Untrusted Networks - Intergraph Smart 3D - Administration

Intergraph Smart 3D Project Management

PPMProductFamily
3D Design and Visualization
PPMProduct
Intergraph Smart 3D
PPMCategory
Administration
Version_S3D
12.x(2018)

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 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. For more information, see Execute PreBackup scripts.

  8. Using the administrative client computer at the Host location, create the required database backups.

  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.

  11. Using the local administrator account, connect to the Host and Satellite servers, and execute the PostRestore scripts. For more information, see Execute PostRestore scripts.

  12. Finish the Global Workshare by performing additional configuration actions (Regenerate the Reports database at all satellites, Setup the DuSS server, and Monitor replication).

See Also

Duplicate Model for Workshare
Duplicate the Model for Global Workshare Configuration
Monitoring Replication