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

Install the Stat database

This section contains instructions for the scripts that need to be run against the Development (optional), and Production databases. The scripts are located under a scripts directory on the Stat® CD. Each script, which is supplied with the Stat Installation CD, must be edited to replace certain variables prior to its execution. Because they perform actions such as granting access to the Stat User ID and creating database objects, the path information supplied in the scripts is critical.

Read all instructions included within the scripts before proceeding with script execution.

NOTE: The Stat user password is set in the first new install script. This password can be modified after the installation is completed. At least one administrative user needs to be logged into the Stat application at the time. For more information, see the section Changing the Database Password, in the book, Stat 6.0.0: System Administration, Chapter 3, Stat Security.

Stat on Oracle

Oracle® install scripts are located in <target directory>\Scripts\Oracle\Install. Run the first three scripts to create the Stat® database regardless of your change management module. See the comments in each script for a complete description of its purpose.
3
CAUTION: Each script should be run one-time only.

NORAv600-1.sql

1
Locate the script NORAv600-1.sql.
Replace [DATABASENAME] with the name of the database.
Replace [SYSTEMPWD] with the password of the Oracle® user SYSTEM.
Replace [SPOOLPT] with the directory for the Session Log.
Replace [MOUNTPT] with the directory path for the datafile. If possible, spread MOUNTPT over multiple disks.
NOTE: We recommend the use of locally managed tablespaces and, if running Oracle 11g or 12c, Automatic Segment Space Management as included in the script.

NORAv600-2.sql

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