2.2 Installing This Release

To install this release patch, follow these steps:

  1. Log in to My Oracle Support and search for 37569313 under the Patches & Updates tab.
  2. Download the OFS Performance Analytics Pack 8.1.2.5.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, RHEL, or OEL.
  3. Stop all the OFS AAI services. For more information, see the Stopping Infrastructure Services section in the OFS AAI Installation and Configuration Guide. section.
  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.5.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.5.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 -a p 37569313_81250_linux.zip
  8. Navigate to the /OFS_PFT_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
  9. Navigate to the OFS_PFT_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_PFT_PACK/logs and OFS_PFT_PACK/OFS_PFT/logs directory. You can ignore error codes ORA-00001 and ORA-02292 in the log file. For any other errors, contact 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, see OFS AAI Installation and Configuration Guide.
  15. In the Command prompt, navigate to the $FIC_HOME/FTPWebService directory of the WEB tier and type ./ant.sh. This triggers the creation of the EAR (<contextname>.ear) or WAR (<contextname>.war) file. The EAR or WAR file is created in the $FIC_HOME/FTPWebService directory of the WEB tier.
  16. After the EAR or WAR file is created, a confirmation message stating that the build was successful is displayed.
  17. Stop the webserver.
  18. Take a backup of the EAR (<contextname>.ear) or WAR (<contextname>.war) file.
  19. Deploy the EAR (<contextname>.war) WAR (<contextname>.ear) file in the web server.
  20. Clear the webserver cache.
  21. Restart all the OFSAAI services. For more information, see the Starting Infrastructure Services section in the OFS AAI Installation and Configuration Guide.