Manual Oracle User Installation Scripts
Running The Scripts
- The User Installation scripts are in the Plug-ins\SoO\OracleScripts sub-folder of the Spotlight installation folder.
- The Predictive Diagnostics scripts are in the Plug-ins\Ppcm\OracleScripts sub-folder of the Spotlight installation folder.
Run the scripts from a SQL*Plus session.
Running User Scripts
In the scripts Install_post11gr2.sql and Upgrade_post11gr2.sql you will be prompted for the following information.
- connect_string - Target database entry in the local computer's tnsname.ora file.
- repository_owner - Spotlight user name to be created.
- repository_password - Spotlight user password.
- default_tablespace - Default tablespace name for the Spotlight user and objects.
- temp_tablespace - Default TEMP tablespace name for the Spotlight.
Note: The scripts will grant the following optional privileges to the new user:
- Select any table
- Alter system
If you do not require or do not allow these privileges, remove them from the script or revoke them later.
Note: For Oracle versions prior to 11g Release 2 there are the equivalent files install_pre11gr2.sql and upgrade_pre11gr2.sql. You will be additionally prompted to provide a DBA account username and password to create the Spotlight user.
- dba_name - DBA Userid. SYS should be used, as other DBA users may not have access to required X$ views.
- dba_password - Password for the specified DBA account.
Running Predictive Diagnostics Scripts
For Predictive Diagnostics, the variables requested by the Ppcm_install_post11gr2.sql script are:
- connect_string - Target database entry in the local computer's tnsname.ora file.
- repository_owner - Spotlight user where Predictive Diagnostics will be installed.
- repository_password - The password for the Spotlight user.
When upgrading an existing Spotlight user to take advantage of existing Predictive Diagnostics schema objects, run Ppcm_synonym.sql. The script will create connections to both Predictive Diagnostics and Spotlight users, the first to give select/execute privileges on objects, and the second to create synonyms. Variables requested by the Ppcm_synonym.sql script are:
- connect_string - Target database entry in the local computer's tnsname.ora file.
- repository_owner - Spotlight user where Predictive Diagnostics will be installed.
- repository_password - The password for the Spotlight user.
- ppcm_schema - The existing Predictive Diagnostics schema that is the target schema for created synonyms.
- ppcm_password - The password for the Predictive Diagnostics user.
Note: For Oracle versions prior to 11g Release 2 there is the equivalent file Ppcm_install_pre11gr2.sql. The script will ask you to connect as a DBA first, and then to provide a list of current Spotlight users. One of these entries should be used for the schema installation. The script will run a check to ensure that the Spotlight user is a valid one. It will also check that the Oracle version is equal to or later than Oracle 9.2. For an upgrade it will check the appropriate objects exist.
- dba_name - DBA Userid. This can be any DBA account (not just SYS) as no rights/privileges or objects are created. This is used purely as a check to review current users with Spotlight objects and Predictive Diagnostics objects, and to perform validation.
- dba_password - DBA Password.
