Chat now with support
Chat with Support

Stat 6.0 - Install Notes

Installing Stat
Prepare for installation Unpack the 6.0.0 installer Install the Stat database Create a staging database (PeopleSoft Only) Install the Stat Client Configure the Stat database Update the System Maintenance table Install the Stat Central Agent Install the Stat Oracle Agent (Oracle E- Business Suite only) Configure the SYSTEM user account Update the PS Object Mover Instructions (PeopleSoft Only) Implement Stat


Locate the script NORAv600-3.sql.
Replace [DATABASENAME] with the name of database.
Replace [SPOOLPT] with the directory for the Session Log.

Execute the scripts

The Stat® database scripts are run via Oracle® SQL*Plus or Toad™ for Oracle.

For SQL*Plus, at the prompt, type: @ <drive:\> <path information>\ <filename>, and press Enter.

For PeopleSoft® users only, execute the NORAv600ps8x.sql archive table create script. Modify the bracketed variables in a similar manner to the prior mandatory scripts.

For Oracle® E-Business Suite users only, execute the NORAv600oa.sql script, located in the <target directory>\Scripts\Oracle\Install directory.

Oracle patch compare support: Stat database (Oracle E- Business Suite Only)

If you are running Oracle® E-Business Suite and plan to use the object compare feature for developer objects (form, form libraries and reports) in patches, the Oracle JVM must be installed with your Stat® Repository. Refer to the Oracle Metalink document appropriate for the Oracle release of your Stat Repository:

After installing the Oracle JVM, you need to install the stat_db.jar file, located in the directory, <target directory>\scripts\Oracle. To do this, execute the following command, adding the appropriate connection parameters:

NOTE: For Oracle 12c , execute the loadjava command this way:

$>loadjava –force –resolve –user [username]/[password]@[database] stat_db.jar

After loading the Java® classes, you need to recompile invalid PL/SQL modules in the database by running the script, utlrp.sql located in the <ORACLE_HOME>/rdms/admin directory.

NOTE: Each Stat Client that will use the object compare feature for developer objects must be properly configured. For more information, see Oracle developer object compare support: Stat Client.

Running Stat with multiple Oracle versions

If you have more than one version of Oracle® installed on the same machine, Stat® connects by default to the client that is defined by ORACLE_HOME.

However, you may select an alternative Oracle client by creating a batch file, for example:

This configures Stat to connect to the non-default Oracle client and allows other applications to connect to the version that is defined by ORACLE_HOME, even if that version is not supported by Stat, such as Oracle 8.

Related Documents