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.
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 |
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. |
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. |
11 |
If the Oracle E-Business database is configured with Oracle NDE (Network Data Encryption), include the encryption type of RC4_256 in sqlnet.ora of the database server. |
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 |
a |
Open the stat.conf file located in <STAT_HOME>/conf and add the parameter <env>.env.CONTEXT_NAME:<sid_hostname>. |
b |
(Optionally) If you experience issues with compiling RDF Report File, you may need to patch the reports.sh file located in $ORACLE_HOME/bin directory: |
• |
c |
(Optionally) If you experience issues with compiling Form File, you may need to patch the frmcmp_batch.sh file located in $ORACLE_HOME/bin directory: |
• |
NOTE: For R12.2, make sure to change these values on both Run and Patch Editions. |
d |
15 |
Review Appendix F of the System Administrator Guide if you have a firewall between your Stat Oracle Agents and your Stat Central Agent. |
1 |
Verify that your Stat® production database is version 5.7.x, 5.8.x, or 6.0.x. |
5 |
Install the Stat Windows® Client. |
7 |
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.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center