Create the Smart 3D GoldenGate user alias for standalone configurations - 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

Perform the following procedure at the Host and all Satellite locations that are configured as standalone Oracle databases.

  1. Click Start > All Programs > Accessories > Notepad.

  2. Type the following text:

    DROP USER s3dgguser CASCADE;

    CREATE USER s3dgguser IDENTIFIED BY password

    DEFAULT TABLESPACE users quota unlimited on users;

    GRANT connect, resource, FLASHBACK ANY TABLE, SELECT ANY TABLE,

    INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE,

    CREATE TABLE, SELECT ANY TRANSACTION, SELECT ANY SEQUENCE,

    SELECT ANY DICTIONARY, LOCK ANY TABLE, DROP ANY TABLE, EXECUTE ANY

    PROCEDURE, SYSDBA TO s3dgguser;

    GRANT EXECUTE ON SYS.DBMS_FLASHBACK TO s3dgguser;

    EXEC dbms_goldengate_auth.grant_admin_privilege('s3dgguser');

  3. Save the script with the name S3D_GoldenGate_alias_user.sql. You can provide any valid user name and password combination on each server. Make sure that each username and password combination is unique.

  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_alias_user.sql";

  6. Review the output of the script, and resolve any reported errors. The first time you run S3D_GoldenGate_alias_user.sql on a server, the following error might display. This error is expected and resolves itself:

    ORA-01918: user s3dgguser does not exist

  7. Click Start > All Programs > Accessories > Command Prompt (Run as Administrator), and then navigate to the GoldenGate home folder.

  8. Type the following command to open the GoldenGate command interface.

    ggsci.exe

  9. Type the following commands:

    ADD CREDENTIALSTORE

    ALTER CREDENTIALSTORE ADD USER s3dgguser ALIAS s3dgoldengate

    • If the credential store already exists, you are prompted with a warning. This is not a problem.

    • You must replace the s3dgguser with the user you created in step 2. The ALIAS required to work with Smart 3D Workshare is s3dgoldengate.

  10. After entering the second command in step 9, you are prompted for the password of the s3dgguser. This information is encrypted and stored within the GoldenGate installation and is only accessible by the GoldenGate process. By default, the process creates the cwallet.sso file in .\dircrd\ in the GoldenGate installation folder. When this file is created, only the current user has access to the credentials created through GoldenGate. Full Control permissions on this file must be granted to the user who interacts with the GoldenGate processes.