Chat now with support
Chat with Support

Stat 6.2 - Upgrade Notes

Upgrade the Stat Oracle Agent (Oracle E- Business Suite only)

The following upgrade must be performed on each Oracle® E-Business Suite server that will be managed by Stat®. You must re-install each Stat Oracle Agent defined on each server before you can upgrade them from 5.8.x to 6.2.0. To save time, however, it is recommended that you first create a backup of the stat.conf file for each agent. This way, after installing a Stat Oracle Agent from the 6.2 installation cd, you can reuse your 6.1.0 configurations by copying configuration data from the archived stat.conf file to the new stat.conf file you just installed.

To use the Oracle E-Business Suite functionality supported by Stat, install and run the Stat Oracle Agent after you have installed and run the Stat Central Agent.

3
Backup or archive the stat.conf file for each Stat Oracle Agent you want to upgrade.
5
Locate the stat installation directory: <stat installation cd>/stat_agent_ora_apps.
6
Copy the stat_ora.zip from the Stat installation CD to the Oracle E-Business Suite server.
7
Unzip stat_ora.zip in the home directory of the new user created for the Stat Oracle Agent files, or the new directory if the existing user is being used. This directory is referred to below as STAT_HOME.
8
Set <STAT_HOME> and PATH in the profile of each Oracle E-Business Suite user (e.g. applmgr) on the server.
9
Set STAT_JAVA_HOME to the JVM that should be used by the Stat Oracle Agent.
Example: $>STAT_JAVA_HOME=/opt/java/18
TIP: You can also use the Java version supplied in your E-Business environment. The version used by Stat should be equal to or greater than the one in the E-Business environment.
a
Open statctl.sh.
12
For each Stat Oracle Agent that you are upgrading, open the stat.conf file that you backed up/archived in step 2, copy the configuration settings you want to re-use, and paste them in the corresponding 6.2.0 stat.conf file located in <STAT_HOME>/conf.
13
In each 6.2.0 stat.conf file, specify the new Stat 6.2.0 configuration settings as needed.
See Additional changes for information on new Stat 6.2.0 configuration parameters.
a
Open the stat.conf file located in <STAT_HOME>/conf and add the parameter <env>.env.CONTEXT_NAME:<sid_hostname>.
The following parameters are no longer required in the stat.conf file for 12.x and are automatically read from the Context File. If they are present in stat.conf, they will override the values read from the Context File.
Open the reports.sh file located in $ORACLE_HOME/bin/ and locate the following:
c
Open the frmcmp_batch.sh file located in $ORACLE_HOME/bin/ and locate the following:
NOTE: For R12.2, make sure to change these values on both Run and Patch Editions.
d
Remove xmlparserv2.jar from the <STAT_HOME>/lib/oracle directory.
15
Review Appendix F of the System Administrator Guide if you have a firewall between your Stat Oracle Agents and your Stat Central Agent.

Additional Changes

The table below describes the new user class rights defined in Stat 6.2.0. You may need to assign certain rights to implement some 6.2.0 enhancements.

6.1.0

Maintenance - General

OraApp Configuration – Start/Sop

Enables the user to start/stop/configure Oracle Application Environment Servers

6.1.0

PS Migration Mgmt

CSR Distributed Environments - Edit

Enables the user to activate/inactivate Distributed Environments on CSR Migration Path

6.1.0

Tools

Configuration Guide

Enables the user to open the Configuration Guide window and configure maintenance tables

6.2.0

Maintenance – Service Domain

Migration Steps - Edit

Enables the user to edit existing Pre and Post Migration Steps from within Migration Steps Maintenance.

6.2.0

Maintenance – Service Domain

Migration Steps - Add

Enables the user to add new Pre and Post Migration Steps from within Migration Steps Maintenance.

6.2.0

PeopleSoft Migration Management

PS Migration Step Command -Edit

Enables the user to modify PeopleSoft migration step custom command.

6.2.0

Migration Management

GenApp Migration Step Command –Edit

Enables the user to modify Generic Application migration step custom command.

6.2.0

Migration Management

Initiate planned migrations

Initiate planned migrations

6.2.0

Oracle Application Migration Management

OraApp Migration Step Command -Edit

Enables the user to modify CSR migration step custom command.

6.2.0

Tools

Archive Sets - Ready to Migrate

Enables the user to access the Archive Sets - Ready to Migrate Window.

6.2.0

Tools

Customer Search Utility

Enables the user to access the Customer Search Utility.

6.2.0

Tools

Migration Console

Enables the user to access the Migration Console.

6.2.0

Tools

Oracle Applications Console

Enables the user to access the Oracle Application Console.

6.2.0

Tools

Support Console

Enables the user to access the Support Console.

6.2.0

Wizard

Archive Set Synchronization Wizard

Enables the user to access the Archive Set Synchronization Wizard.

6.2.0

Wizard

CSR Search Wizard

Enables the user to access the CSR Search Wizard.

6.2.0

Wizard

Object Compare Wizard

Enables the user to access the Object Compare Wizard.

6.2.0

Wizard

Object History Wizard

Enables the user to access the Object History Wizard.

6.2.0

Wizard

Object Impact Wizard

Enables the user to access the Object Impact Wizard.

6.2.0

Wizard

Report Wizard

Enables the user to access the Report Wizard.

Assign user class rights

The table below describes the new user class rights defined in Stat 6.2.0. You may need to assign certain rights to implement some 6.2.0 enhancements.

6.1.0

Maintenance - General

OraApp Configuration – Start/Sop

Enables the user to start/stop/configure Oracle Application Environment Servers

6.1.0

PS Migration Mgmt

CSR Distributed Environments - Edit

Enables the user to activate/inactivate Distributed Environments on CSR Migration Path

6.1.0

Tools

Configuration Guide

Enables the user to open the Configuration Guide window and configure maintenance tables

6.2.0

Maintenance – Service Domain

Migration Steps - Edit

Enables the user to edit existing Pre and Post Migration Steps from within Migration Steps Maintenance.

6.2.0

Maintenance – Service Domain

Migration Steps - Add

Enables the user to add new Pre and Post Migration Steps from within Migration Steps Maintenance.

6.2.0

PeopleSoft Migration Management

PS Migration Step Command -Edit

Enables the user to modify PeopleSoft migration step custom command.

6.2.0

Migration Management

GenApp Migration Step Command –Edit

Enables the user to modify Generic Application migration step custom command.

6.2.0

Migration Management

Initiate planned migrations

Initiate planned migrations

6.2.0

Oracle Application Migration Management

OraApp Migration Step Command -Edit

Enables the user to modify CSR migration step custom command.

6.2.0

Tools

Archive Sets - Ready to Migrate

Enables the user to access the Archive Sets - Ready to Migrate Window.

6.2.0

Tools

Customer Search Utility

Enables the user to access the Customer Search Utility.

6.2.0

Tools

Migration Console

Enables the user to access the Migration Console.

6.2.0

Tools

Oracle Applications Console

Enables the user to access the Oracle Application Console.

6.2.0

Tools

Support Console

Enables the user to access the Support Console.

6.2.0

Wizard

Archive Set Synchronization Wizard

Enables the user to access the Archive Set Synchronization Wizard.

6.2.0

Wizard

CSR Search Wizard

Enables the user to access the CSR Search Wizard.

6.2.0

Wizard

Object Compare Wizard

Enables the user to access the Object Compare Wizard.

6.2.0

Wizard

Object History Wizard

Enables the user to access the Object History Wizard.

6.2.0

Wizard

Object Impact Wizard

Enables the user to access the Object Impact Wizard.

6.2.0

Wizard

Report Wizard

Enables the user to access the Report Wizard.

Appendix: Upgrade Checklist

The following checklist, combined with the previous sections of this document, will guide you through the entire upgrade process. Make a copy of this checklist for each database you will be upgrading.

1
Verify that your Stat® production database is version 5.7.x, 5.8.x, or 6.0.x.
7
Update the PeopleSoft® Object Mover instructions (PeopleSoft users only).

We are on a quest to make your information technology work harder for you. That is why we build community-driven software solutions that help you spend less time on IT administration and more time on business innovation. We help you modernize your data center, get you to the cloud quicker and provide the expertise, security and accessibility you need to grow your data-driven business. Combined with Quest’s invitation to the global community to be a part of its innovation, and our firm commitment to ensuring customer satisfaction, we continue to deliver solutions that have a real impact on our customers today and leave a legacy we are proud of. We are challenging the status quo by transforming into a new software company. And as your partner, we work tirelessly to make sure your information technology is designed for you and by you. This is our mission, and we are in this together. Welcome to a new Quest. You are invited to Join the Innovation.

Our logo reflects our story: innovation, community and support. An important part of this story begins with the letter Q. It is a perfect circle, representing our commitment to technological precision and strength. The space in the Q itself symbolizes our need to add the missing piece you to the community, to the new Quest.

For sales or other inquiries, visit https://www.quest.com/contact.

Technical support is available to Quest customers with a valid maintenance contract and customers who have trial versions. You can access the Quest Support Portal at https://support.quest.com.

The Support Portal provides self-help tools you can use to solve problems quickly and independently, 24 hours a day, 365 days a year. The Support Portal enables you to:

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating