Executing the Oracle scripts builds the necessary database views, packages, and procedures. Before you can begin to execute the Oracle scripts, complete the following steps:

• Unzip the DS_ORA_Max411_Scripts.zip file to a specific location, such as C:\temp\scripts.
• Log in to Oracle SQL Plus as the CMMS schema owner. This is usually MAXIMO.

Executing the Scripts in a Batch Process

You can execute the Oracle scripts in a batch process by using the following steps:

• Execute the max411_scripts.sql script file:

  

• Executing the max411_scripts.sql script file in turn executes the following list of scripts in the order listed:

Executing the Scripts Individually

If necessary, the scripts can be executed individually. The only condition is that the dsutility.plsql script has been successfully compiled into the database, and that workorder2.plsql follows workorder1.plsql.

To execute a script individually, enter the following commands in Oracle SQL Plus:

                SQL> connect {schema_owner}/{schema_owner_password}@{oracle_tns};
                SQL> start {directory_path}\dsutility.plsql;

Where {directory_path} is the actual directory path to the dsutility.plsql file, such as C:\temp\scripts. Repeat the execution process for the remaining scripts.

User DB Connection Setup

If you wish to use the User DB Connection option to connect to the database with the credentials of the user that logged in to the DataSplice Remote Client rather than the user set up in the connection profile in the Administration Client, you can grant the DS_USER role to the desired set of CMMS users. For more information about the User DB Connection setting, please see the Connection Profiles Tab section of the DataSplice Administration Client User Manual.

After the dsusers.plsql script has successfully run, you can grant the DS_USER role to the desired set of CMMS users. This is completely optional, and is only necessary if you intend to use the User DB Connection option for the database connection profile in the DataSplice Administration Client. This option passes the credentials of the user that logs in to the DataSplice Remote Client to the database, rather than the credentials specified for the connection profile in the Administration Client.

Example:

                SQL> GRANT DS_USER to CMMS_USER1;

See the dsusers.plsql script for an example SQL query for generating a script file of GRANT statements using the SPOOL option.