Chat now with support
Chat with Support

Stat 6.0 - Upgrade Notes

Upgrading Stat Upgrade the Stat Central Agent Upgrade the Stat Oracle Agent (Oracle E- Business Suite only) Additional changes Appendix: Upgrade Checklist

Upgrade the Stat database

After you have created a copy of your Stat® 5.8.x production database (test database), you are ready to begin the test upgrade.

For Oracle®, the scripts can be run using SQL*Plus or Toad™ for Oracle.
For SQL Server®, execute the appropriate upgrade scripts using Toad for SQL Server or SQL Query Analyzer. Do not use other third-party tools.

Please note the following:

Oracle® 10g, 11g, and 12c are supported in Stat® 6.0.0. The upgrade scripts for Stat 6.0.0 running on Oracle® are located in <target directory>\Scripts\Oracle\Upgrade.

IMPORTANT: To upgrade to Stat 6.0.0, you must be on Stat 5.8.x.
1
For PeopleSoft users only, make sure that UORA580ps854-855.sql script was previously run.
2
Locate the script UORAv580-600.sql.
3
Recompile any invalid PL/SQL modules in the database by running the script utlrp.sql located in <ORACLE_HOME>/rdbms/admin directory.

SQL Server® 2005, 2008, 2012, and 2014 are supported in Stat® 6.0.0. The upgrade scripts for Stat 6.0.0 running on SQL Server are located in <target directory>\Scripts\MSSQLServer\Upgrade.

IMPORTANT: To upgrade to Stat 6.0.0, you must be on Stat 5.8.x.
1
For PeopleSoft® users only, make sure that UMSS580ps854-855.sql script was previously run.
2
Locate the script UMSSv580-600.sql.

Upgrade a staging database (PeopleSoft only)

If running on Oracle®, execute StageORA855.sql, if not previously run.
If running on SQL Server®, execute StageMSS855.sql, if not previously run.
If running on DB2® execute StageDB2-OS390-855.sql (for mainframe), or StageDB2-UNIX-855.sql (for AIX®/UNIX®), if not previously run.

PeopleSoft on Oracle

1
Locate the StageORA855.sql script.
[OWNER/PWD@DATABASENAME] Replace with the correct values for the PeopleSoft® schema owner/password and staging database.
[SPOOLPT] Replace with the directory for the session log.
[PTAPP] Replace with the tablespace for the staging table
[PSINDEX] Replace with the tablespace for the staging table indexes

PeopleSoft on SQL Server

1
Locate the StageMSS855.sql script.
2
Find and replace the variable [DATABASENAME] with the name of the database.
4
Log in as sa or a login that is a member of the sysadmin fixed server role or the database owner.
Related Documents