Installing this Maintenance Level Release

Oracle Linux 9 Server Support

The OFS AAI 8.1.2.10.x release supports Oracle Linux 9 Server in addition to the continued support on Oracle Linux 8 and Oracle Linux 7.

Note:

The Oracle Linux 9 Server Configuration section applies to upgrade installation of OFS AAI and the New Installation of OFS AAI 8.1.2.0.0 with Oracle Linux 9 Server section applies to new installation of OFS AAI.

New Installation of OFS AAI 8.1.2.0.0 with Oracle Linux 9 Server: To install the OFS AAI 8.1.2.0.0 base installer with Oracle Linux 9 Server, follow the instructions in the My Oracle Support Doc ID 3067623.1 and then upgrade to OFS AAI 8.1.2.5.0.

Installing this Maintenance Level Release

To install this Maintenance Level Release, follow these steps:

Note:

If you want to install OFS IAA and OIP in the same environment, please contact OFSAA Support via My Oracle Support.

Login to My Oracle Support and search for 39540301 under the Patches & Updates tab.
Download the latest Erwin data model 39540328 patch.
Download the OFSAA 8.1.2.11.0 IAA 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/OEL.
Stop all the OFSAAI Services. For more information, see the Start/Stop Infrastructure Services section in Oracle Insurance IFRS 17 Pack Installation Guide Release 8.1.2.0.0.
Login to the OFSAA Server as a non-root user and navigate to the $FIC_HOME folder.
Assign WRITE permission to the file/folders such as common scripts, EXEWebService, ficapp, and ficweb, and find them in the $FIC_HOME folder by executing the command:
chmod -R 775 *
If you have to 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.11.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.
Give EXECUTE permission to the utility by using the command:
chmod 751 unzip_<os>
Extract the contents of the 8.1.2.11.0 ML archive file by using either of the following commands:
unzip <name of the file to be unzipped>
10. Update the params.conf file present in the OFS_IIA_PACK folder. Add the webserver type and the version in the parameters; WEBSERVER_TYPE and WEBSERVER_VERSION.
Update the configuration file params.conf file present in the OFS_IIA_PACK/appsLibConfig/conf folder before triggering the installation. The update instructions are present in this file itself.
In case of customized Data Model Upload, then update the params.conf file present in the OFS_IIA_PACK/appsLibConfig/conf folder accordingly.
Give EXECUTE permission to the ML Patch Installer Script. Navigate to the OFS_ AAI directoryand execute the command:
chmod 755 OFSAAIUpdate.sh
Execute the following command:
./OFSAAIUpdate.sh
Verify if the ML is applied successfully by checking the log files generated in OFS_IIA_ PACK/OFS_IIA/logs directories. You must also verify the Data Model logs, the path can be found in the silent.props file of the release v8.1.2.0.0 file. You can ignore ORA-00001 and ORA-02292 in the log file. In case of any other errors, contact My Oracle Support.
After successful installation of the ML, perform the following steps:
- Clear the Application Cache. Navigate to the following path depending on the configured Web Application Server and delete the files.
  1. Tomcat: <Tomcat installation folder>/work/Catalina/localhost/<Application name>/org/apache/jsp
  2. Weblogic: <Weblogic installation location>/domains/<Domain name>/servers/<Server name>/tmp/_WL_user/<Application name>
  3. Websphere: <Websphere installation directory>/AppServer/profiles/<Profile name>/temp/<Node name>/server1/<Application name>/<.war file name>
Delete the existing EAR/WAR file available in the folder $FIC_HOME/ficweb.
Generate the application EAR/WAR file and redeploy the application onto your configured Web Application Server. For more information on generating and deploying the EAR/ WAR file, see Create and Deploy the EAR or WAR Files in OFS AAI Release 8.1.2.0.0 Installation and Configuration Guide.
In the FICHOME/ficweb/webroot/WEB-INF path, modify the sun-jaxws.xml by commenting out <endpoint implementation="com.ofs.fsapps.subledger.jaxws.service.SubLedgerPublishServiceImpl" name="SubLedgerWebServiceImpl" url-pattern="/subLedgerWS"/>.
Restart all the OFSAAI Services. For more information, refer to the Start/Stop Infrastructure Services section in OFS AAI Release 8.1.2.0.0 Installation and Configuration Guide.
Optionally, in case of a performance issue, enable partioning by navigating to <Installer Path>/OFS_IIA_PACK/OFS_IIA/bin/scripts/atomic/create then execute the PARTITION_SCRIPT.sql file by using @PARTITION_SCRIPT.sql in the Atomic Schema.
If you are facing any issue related to the primary keys unique index of theFCT_INS_ACST_REP_LINE_DEP table being invalid after rerunning a reports job and also when the FCT_INS_ACST_REP_LINE_DEP table is partitioned by using the PARTITION_SCRIPT.sql (mentioned in the above step), then perform the steps mentioned in the document Partitioned_Table_Index_Issue.docx on the MOS page to overcome the issue.

For enabling partitioning, you require the license for Oracle Database Partioning.