Initialize the Oracle Database - Intergraph Smart 3D - Installation & Upgrade - Hexagon

After the Oracle server software is installed and configured (that is, you can connect from a client to the Oracle database), you must configure the database to run with Smart 3D software.

The Smart 3D Reference Data Installation (see Reference Data Setup) delivers the following sample script files to the <Product Folder>\3DRefData\Tools\OracleScriptsToInitDB folder.

1. OracleScriptsToInitDB\SP3DUser_ROLES.SQL

2. OracleScriptsToInitDB\SP3DProjectAdminstrator_ROLES.SQL

3. OracleScriptsToInitDB\SP3DUser.SQL

4. OracleScriptsToInitDB\SP3DProjectAdministrator.SQL

These script files create the necessary schemas, users, and roles that are used to run the software on Oracle. The delivered script files, however, are only samples and must be edited to fit your server configurations.

Existing scripts delivered in the OracleScriptsToInitDB folder create the SP3DUser\SP3DAdministrator user and roles with high level permissions on the Oracle server. However, if you want minimum mandatory privileges for these roles, use the scripts delivered in the OracleScriptsToInitDB\MinimumAccessPrivileges folder. For more information, see Initialize the Oracle Database with Minimum Access Privilege.

• An administrative user must run the scripts on the server. Before proceeding, place a copy of each of the sample script files on the server computer.

• The scripts must be run in the order listed because previous scripts create items that are used in subsequent scripts. Do not deviate from the following sequence of steps.

• Make a backup of the SP3DUser\SP3DAdministrator user and roles configuration if it already exists on the Oracle server.

Create the Roles Needed for Smart 3D Users and Administrators

1. Log on to the Oracle database server computer using the local administrative account.

2. Open SQL Plus.

   The SQL Plus dialog displays.

3. In the User Name field, type SYS as SYSDBA or SYSOPER.

4. In the Password field, type the password for the SYS account.

5. At the SQL prompt, type @<File Location>:\SP3DUser_ROLES.SQL, and press Enter.

   For example, if you placed a copy of the script file in the root folder on the C drive, type @C:\SP3DUSER_ROLES.SQL.

6. After the script finishes, type @<File Location>:\SP3DProjectAdministrator_ROLES.SQL, and press Enter.

7. After the second script finishes, close the SQL Plus window.

Create the Users Needed for Smart 3D

1. Log on to the Oracle database server computer using the local administrative account.

2. Navigate to the SP3DUser.SQL script file, and open it in Notepad.

3. If you are using OS authentication, edit the external user identified in the file as needed. Use the following syntax: DOMAIN NAME\USERNAME, and then select File > Save.

   User logins cannot contain spaces. Any typed alpha character must be capitalized.

4. If you are using OS authentication, edit the external user identified in the file as needed. Use the following syntax: DOMAIN NAME\USERNAME, and then select File > Save.

   Any typed alpha character must be capitalized.

   -OR-

   If you are using database user authentication, edit the external user identified in the file and replace the database user name. Also, replace IDENTIFIED EXTERNALLY with IDENTIFIED BY [the user password].

   Example replace:

   CREATE USER "DOMAIN\USERNAME" PROFILE DEFAULT IDENTIFIED EXTERNALLY

   with:

   CREATE USER S3dStandardUser PROFILE DEFAULT IDENTIFIED BY S3duserPassword

   User logins cannot contain spaces. The database user name and password are case sensitive.

5. Open SQL Plus.

   The Log On dialog appears.

6. In the User Name field, type SYS AS SYSDBA.

7. In the Password field, type the password for the SYS account.

8. At the SQL prompt, type @<File Location>:\SP3DUser.SQL, and press Enter.

   For example, if you placed a copy of the script file in the root folder on the C drive, type @C:\SP3DUser.SQL.

9. After the script finishes, close the SQL Plus window.

Create the Administrative User

1. Log on to the Oracle database server computer using the local administrative account.

2. Navigate to the SP3DProjectAdministrator.SQL script file, and open it in Notepad.

3. If using OS authentication, edit the external user identified in the file as needed. Use the following syntax: DOMAIN NAME\USERNAME, and then select File > Save.

   Any typed alpha character must be capitalized.

   -OR-

   If using database user authentication, edit the external user identified in the file and replace the database user name. Also replace IDENTIFIED EXTERNALLY with IDENTIFIED BY [the user password].

   Example replace:

   CREATE USER "DOMAIN\USERNAME" PROFILE DEFAULT IDENTIFIED EXTERNALLY

   with:

   CREATE USER S3dAdminUser PROFILE DEFAULT IDENTIFIED BY S3dAdminUserPassword

   The database user name and password are case sensitive.

4. Open SQL Plus.

   The Log On dialog appears.

5. In the User Name field, type SYS AS SYSDBA.

6. In the Password field, type the password for the SYS account.

7. At the SQL prompt, type @<File Location>:\SP3DProjectAdministrator.SQL and press Enter.

   For example, if you placed a copy of the script file in the root folder on the C drive, you type @C:\SP3DProjectAdministrator.SQL.

8. After the script finishes, select File > Exit.

Enable Disable_Directory_Link_Check

1. Open SQL Plus.

   The Log On dialog appears.

2. In the User Name field, type SYS AS SYSDBA.

3. In the Password field, type the password for the SYS account.

4. At the SQL prompt, type:

   SQL> ALTER SYSTEM SET "_disable_directory_link_check" = TRUE SCOPE=SPFILE;

   SQL> ALTER SYSTEM SET "_kolfuseslf" = TRUE SCOPE=SPFILE;

   SQL> SHUTDOWN IMMEDIATE

   SQL> STARTUP