Upgrading Stat
Introduction
Overview of the upgrade process
Unpack the 6.3.0 upgrade
Upgrade the Stat database
Upgrade existing PeopleSoft Archive Sets
Install the Stat Client
Create a new record for the database
Update PeopleSoft Object Mover instructions
Upgrade the Stat Central Agent
Upgrading the Stat Central Agent
Configuring the Stat Central Agent
Upgrade the Stat Oracle Agent (Oracle E- Business Suite only)
Additional Changes
Appendix: Upgrade Checklist
Before starting the Stat Central Agent
Resolving port and firewall conflicts
Stopping the Stat Central Agent
Configuring the Stat Central Agent as a Windows service
Installing DB2 support for the Stat Central Agent
Configuring the Stat Central Agent character map
Setting up support for AES256 ciphers for SFTP
Configuring the Web Client to use HTTPS
Modifying connection pool idle time
Installing multiple servers on the same host
Testing database and server connections
Update PeopleSoft Object Mover instructions
For PeopleSoft® users, log into Stat® 6.3.0 using the special Stat SYSTEM account to update the PeopleSoft Object Mover instructions. The Stat object that archives PeopleSoft objects requires a set of instructions in order to operate. To do this, select Maintenance | General | Update PS Object Mover Instructions. For more information, see the Stat System Administration Guide, Chapter 2, Administrative Utilities.
Upgrade the Stat Central Agent
Upgrading the Stat Central Agent
The upgrade to Stat® 6.3.0 completely replaces the existing directory tree installed at the location defined by <STAT_HOME>.
|
IMPORTANT: Do not copy files from earlier installations to the new 6.3.0 installation. |
For Stat 6.3.0, you need to have Java Development Kit installed, and optionally a system variable called JAVA_HOME that points to the JDK installation root directory (e.g., C:\Program Files\Java\jdk1.8.0_191).
If you are running Windows® or Solaris and have an older version of Java installed, go to http://www.oracle.com/technetwork/java/javase/downloads/index.html and upgrade to the appropriate version. The previous service wrapper has been replaced with a delivered server.bat. You will need to re-apply custom modifications.
|
IMPORTANT: There should be no Stat Central Agent running against your previous test database during the upgrade process. |
|
1 |
Create a new <STAT_HOME> folder for the Stat 6.3.0 agent and optionally create an environment variable for <STAT_HOME>. |
Instead of creating a system variable for <JAVA_HOME> and <STAT_HOME>, enter these values directly in <STAT_HOME>/app/bin/standalone.conf (for Unix) or <STAT_HOME>\app\bin\standalone.conf.bat (for Windows).
|
• |
For Windows, uncomment and change these 2 lines in <STAT_HOME>\app\bin\standalone.conf.bat. |
|
• |
For Unix, uncomment and change these 2 lines in <STAT_HOME>\app\bin\standalone.conf. |
|
2 |
Backup your previous <STAT_HOME> if you are planning on using the same name. |
|
NOTE: The new folder must be empty. |
For example, if you installed the Stat Central Agent in C:\Stat, move that directory to C:\stat_old, and create a new directory for C:\Stat (<STAT_HOME> will still point to the correct location).
We suggest making a backup of C:\Stat rather than deleting it so it is possible to refer to old log files or your original configuration files. For example:
|
• |
|
• |
|
4 |
Click Install Stat Central Agent. |
|
5 |
Open the standalone folder, locate the file stat_standalone.zip and unzip it to the desired location on the host computer where you want to install the Stat Central Agent. |
An example for Windows might be c:\stat; on Unix®, this might be /usr/local. The location you choose for the installation is referred to as <STAT_HOME>. Use Winzip® to unpack the file on Windows or use the unzip utility on Unix.
|
IMPORTANT: Do not unzip the file stat_standalone.zip to a directory that contains an exclamation point character (!).
If copying the installation files to a Unix system, be sure the file transfer settings are set to binary and not ascii. Use the -a modifier to unzip the file. |
The <STAT_HOME> directory should contain the following subdirectories:
|
• |
|
• |
|
• |
|
• |
|
• |
Because this is a new installation, you need to re-apply any configuration changes you want to retain from your previous release of Stat. See Configuring the Stat Central Agent for more information.
Note that while some configuration changes can be made after you have completed installing the Stat Central Agent, other changes should be made before proceeding to the next step in the installation. See Before starting the Stat Central Agent.
|
NOTE: Service.bat is used to start the service by calling run.bat. See Configuring the Stat Central Agent as a Windows service for more information. Quest® Software recommends that you validate that the agent will start without the service before invoking the service operation. |
|
7 |
|
• |
Windows: <STAT_HOME>\app\bin\run.bat |
|
• |
Unix: <STAT_HOME>/app/bin/run.sh |
|
NOTE: If you have port conflicts during startup, the server displays one or more error messages. For instructions on resolving port conflicts, see Resolving Port and Firewall Conflicts. |
|
NOTE: If you receive a Connection Refused error when your Stat Windows Client is trying to access the Stat Central Agent, you may need to start your Stat Central Agent with a -b parameter to specify the hostname of the agent. In this case, edit your run.bat (run.sh for Unix) and add -b=<hostname>, where <hostname> is the hostname for the machine running the Stat Central Agent.
For example, in run.bat:
standalone.bat -b=ALVWindows
For example, in run.sh:
./standalone.sh -b=ALVLinux |
In the server console, you will see the line, Stat Configuration Assistant is ready.
|
9 |
Open your internet browser and go to http://<stat_server_host_machine>:8080/stat-config. |
|
IMPORTANT: If you are not running the agent from the local machine (i.e. Telnet session), you must add the IP address to <STAT_HOME>/config/stat-config.properties or you will not have access to the Configuration Assistant. See Authorize Access to the Configuration Page. |
|
10 |
In the Type/Vendor field, select the database platform you are using. Options include Oracle or SQL Server. |
|
11 |
Enter the appropriate information for the Stat database: Host Name, Port, DB/Service Name, Login ID, Password. |
|
12 |
This field flexes to TNS Entry for Oracle users.
|
13 |
Choose the logging setting for the UI Logging Level and for the Stat Central Agent application. The default is INFO. |
|
15 |
Click Save. |
Configuring the Stat Central Agent
|
NOTE: Before making any configuration changes, be aware of the following:
|