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 Stat System Administration Guide, Chapter 3, Stat Security. |
3 |
Execute the appropriate scripts for your development environment using SQL*Plus or Toad® for Oracle only (Do not use other third-party tools). |
1 |
• |
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 data file. 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.
|
1 |
Locate the script NORAv620-2.sql. |
• |
Replace [DATABASENAME] with the name of the database. |
• |
Replace [SPOOLPT] with the directory for the Session Log. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center