2.2 Installing this Release

Ensure that you install all the Oracle Enterprise Performance Management application packs on a single infodom.

To install this release patch, follow these steps:

1. Log in to My Oracle Support and search for 34861418 under the Patches & Updates tab.
2. Download the OFS Profitability Management 8.1.2.2.0 ML Release archive file and copy it to your OFSAA server in Binary mode.

   Note:

   There are different archive files for different operating systems such as Solaris, and RHEL or OEL.
3. Stop all the OFS AAI services. For more information, see Stop the OFSAA Infrastructure services section in the OFS AAI Installation and Configuration Guide available at OHC Documentaion Library.
4. Log in to the OFSAA server as a non-root user and navigate to the $FIC_HOME directory.
5. Assign WRITE permission to the files or directories such as commonscripts, EXEWebService, ficapp, ficweb, and ficdb using the command:

   chmod -R 775 *

6. If you have the Unzip utility, skip to the next step or download the Unzip utility (OS-specific) and copy it in Binary mode to the directory that is included in your PATH variable, typically $HOME path or directory in which you have copied the 8.1.2.2.0 ML.
   • Uncompress the unzip installer file using the command:
     uncompress unzip_<os>.Z

     Note:

     If you notice an error message "uncompress: not found [No such file or directory]" when the package is not installed, contact your UNIX administrator.
   • Assign EXECUTE permission to the utility using the command:

     chmod 751 unzip_<os>

     For example, chmod 751 unzip_linux

7. Extract the contents of the 8.1.2.2.0 ML archive file using one of the following commands:

   unzip_<os> -a <name of the file to be unzipped>

   Or

   unzip –a <name of the file to be unzipped>

   Note:

   The -a option is mandatory to extract the archive file. An example for the Linux operating system, unzip_linux -a p34861418_81220_linux.zip
8. Navigate to the /OFS_PAM_PACK/appsLibConfig/conf directory and configure the parameter UPLOAD_MODEL to 1 in the params.conf file.

   Note:

   Model Upload Process: Input values required are 0 or 1.

   • 1 indicates Trigger Model Upload.
   • 0 indicates Skip Model upload process.

   If the value is 1, then choose a type of Model Upload from the following:

   • 0 indicates Released Data Model.
   • 1 indicates the Customized Data Model.

   If the value of the Model upload type is 1, then provide the inputs for the Data Model name and the path of the Data Model.

9. Navigate to the OFS_PAM_PACK directory to assign EXECUTE permission to the ML patch installer script using the command:

   chmod 755 OFSAAIUpdate.sh

10. Complete the patch upgrade using the command:

    ./OFSAAIUpdate.sh

11. Verify if the ML patch is applied successfully by checking the log file generated in the OFS_PAM_PACK/logs and OFS_PAM_PACK/OFS_PFT/logs directory. You can ignore error codes ORA-00001 and ORA-02292 in the log file. For any other errors, contact My Oracle Support.

    Note:

    For an upgrade on Hive Infodom, you may encounter an exception "PL/SQL: ORA-00942: table or view does not exist". You can ignore this error.
12. After successful installation of the ML, follow these steps:
    • Run the following command to execute the .profile file:

      . $HOME/.profile

    • Clear the application cache. Navigate to the following path depending on the configured web application server and delete the files.
      • Tomcat:

        <Tomcat installation folder>/work/Catalina/localhost/<Application name>/org/apache/jsp

      • WebLogic:

        <WebLogic installation location>/domains/<Domain name>/servers/<Server name>/tmp/_WL_user/<Application name>

      • WebSphere:

        <WebSphere installation directory>/AppServer/profiles/<Profile name>/temp/<Node name>/server1/<Application name>/<.war file name>

13. Delete the existing EAR or WAR file available in the $FIC_HOME/ficweb directory.
14. Generate the application EAR or WAR file and redeploy the application onto your configured web application server. For more information on creating and deploying the EAR or WAR file, see Create and deploy EAR/WAR files section in the OFS AAI Installation and Configuration Guide available at OHC Documentaion Library.

Restart all the OFSAAI services. For more information, see Start the OFSAA Infrastructure services section in the OFS AAI Installation and Configuration Guide available at OHC Documentaion Library.