Stat 6.2 - Install Notes

NORAv620-3.sql

Execute the scripts

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

For PeopleSoft® users only, execute the NORAv620ps8x.sql archive table create script, located in the <installation package>\Scripts\Oracle\Install directory. Modify the bracketed variables in a similar manner to the prior mandatory scripts.

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

Modify the bracketed variables in a similar manner to the prior mandatory scripts.

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, <installation package>\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>/rdbms/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. Also, for users who plan to compare form library files that have attached libraries, there are special configuration steps that must be performed. For more information, see Object compare support for form library files.

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.