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

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.

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

1. Open a text editor, such as Notepad.

2. Type the following text:

   DROP USER GGADMIN CASCADE;

   CREATE USER GGADMIN

   IDENTIFIED BY password

   DEFAULT TABLESPACE USERS

   QUOTA UNLIMITED ON USERS;

   GRANT CONNECT, RESOURCE, DBA TO GGADMIN;

   The username (GGADMIN) and password can be customized, but must be the same on all participating servers.

3. Save the script with the name S3D_GoldenGate_admin.sql.

   

   • To guarantee that the GoldenGate administrator username and password remains the same across all servers, it is recommended to reuse 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.

4. 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).

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

   @"<file location>\S3D_GoldenGate_admin.sql";

6. 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