Installing this Release

Log in to My Oracle Support and search for 37374258 under the Patches & Updates Tab.

Download the OFS PCD 8.1.2.5.0 OFS PCD 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 AIX, Solaris, and RHEL or OEL.

Stop all the OFS AAI Services.

For more information, see the Stopping Infrastructure Services section in the OFS AAI Installation and Configuration Guide.

Log in to the OFSAA Server as a non-root user and navigate to the $FIC_HOME directory.

Assign WRITE permission to the files or directories such as commonscripts, EXEWebService, ficapp, ficweb, and ficdb using the command:

chmod -R 775 *

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 v8.1.2.5.0 ML.

Uncompress the unzip installer file using the command:

unzip –a OFS_PM_8.1.2.5.0_<OS>.zip

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_aix

Extract the contents of the v8.1.2.5.0 ML archive file using one of the following commands: unzip_<os> -a OFS_PM_8.1.2.5.0

or

unzip –a OFS_PM_8.1.2.5.00_<OS>

Note:

The above “-a” option is mandatory to extract the archive file. An example of the AIX Operating System, unzip -a p37374258_81250_AIX64.zip

Update the parameters in the params.conf file present in the OFS_PM_PACK/appsLibConfig/conf directory for the following parameters:

UPLOAD_MODEL=0

Navigate to the OFS_PM_PACK directory to assign EXECUTE permission to the ML Patch Installer Script using the command:

chmod 755 OFSAAIUpdate.sh

Complete the patch upgrade using the command:

./OFSAAIUpdate.sh

Verify if the ML patch is applied successfully by checking the log file generated in the OFS_PM_PACK/OFS_PCD/logs directory. You can ignore error codes ORA-00001 and ORA-02292 in the log file. You can also ignore the errors “Object already exists” and “Table already has a referential constraint with the same name”.

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.

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>

Delete the existing EAR or WAR file available in the $FIC_HOME/ficweb directory.

Generate the application EAR or WAR file and redeploy the application on your configured Web Application Server. For more information, see OFS AAI Installation and Configuration Guide.

Restart all the OFSAAI Services. For more information, see the Starting Infrastructure Services section in the OFS AAI Installation and Configuration Guide.