Create the Oracle GoldenGate Administrator account - Intergraph Smart 3D - Administration & Configuration - Hexagon PPM

Intergraph Smart 3D Global Workshare (Oracle)

Language
English
Product
Intergraph Smart 3D
Subproduct
Global Workshare
Search by Category
Administration & Configuration
Smart 3D Version
13

The GoldenGate environment is managed by an administrative database user account. To manage the GoldenGate environment, you must create a GoldenGate administrator user GGADMIN with the appropriate privileges. Do not use the SYS or SYSTEM user as the GoldenGate administrator.

The GoldenGate administrator account is an Oracle account used to configure the Global Workshare inside Smart 3D. This account is essential to operate the GoldenGate software during the life of the Global Workshare Configuration.

  • The GoldenGate administrative user can have any valid name. In the case of a multiple Global Workshare configuration, we recommend that each site has its own GoldenGate administrative user with his or her own tablespace.

  • A script for creating this account is delivered in SharedContent.

You must perform the following procedure at the Host and all Satellite location servers.

  1. Open SQL *Plus, and connect to the Oracle instance as an administrative user who can create users, grant privileges, create tablespaces, and alter users (as sysdba).

  2. At the SQL prompt, type the following statement, and press ENTER:

    @"[Product Folder]\ProjectMgmt\Tools\OracleScriptsToInitDB\GWC\S3D_GoldenGate_Admin.sql";

    • The S3D_GoldenGate_Admin.sql script creates the GoldenGate Administrator account with the user name GGADMIN and the password MANAGER. You can edit the script to customize the user name and password, but the user name and password must be the same on all participating servers.

    • To guarantee that the GoldenGate administrator username and password remains the same across all servers, we recommend using the same script on all participating servers.

    • You can use any valid name and password combination for the GoldenGate administrative user account. The combination must match across all instances of the Global Workshare configuration.

  3. Review the output of the script, and resolve any reported errors.

When you run S3D_GoldenGate_Admin.sql on a server for the first time, the following error may display. This error is expected as the user does not exist in the database:

ORA-01918: user 'GGADMIN' does not exist