Patchset Setup

8 Patchset Setup

This topic describes about the Patchset setup using Oracle Banking Microservices Architecture Installer.

Prerequisites

Check for existing setup or the environment is available.
Updated Patch Set Installation script with respective to the current release upgrade is available in the respective VM’s. If not copy the required scripts from SVN.

8.1 Foundation Setup Upgrade

Installer Path

You can download the installer from Oracle Software Delivery Cloud (OSDC). The following table provides the download path of the installer.

Table 8-1 Installer Path

Application	Archive Name	OSDC Path
OBMA patch Installer	obma_patch.zip	INSTALLER/
OBCR patch Installer	obcr_patch.zip	INSTALLER/

Parent topic: Patchset Setup

8.1.1 Download Installer

The patch installer is available in OSDC zip of each product.

To download the installer:

Launch putty and login to the VM (where the installation is planned) with OS user.

Create a directory obma_patch_installer in /scratch.

mkdir -p /scratch/obma_patch_installer

chmod 755 /scratch/obma_patch_installer

Navigate to the new directory obma_patch_installer.
cd /scratch/obma_patch_installer
Download the patch installer zip file from the OSDC zip to obma_patch_installer directory.
Unzip installer zip file by executing the below command.
```
unzip <product zip file>
```

Before you proceed, please refer section Kafka Databags Update for Kafka SSL and Kafka scram passwords update.

Parent topic: Foundation Setup Upgrade

8.1.2 Update Properties File

To update properties file:

Navigate to the path /scratch/obma_patch_installer/chef-repo/.
Open the respective OBMA properties file and update the obma_patch_properties.rb with below details.
Update the local user and its group.

Figure 8-1 Update Local User and Group

Description of "Figure 8-1 Update Local User and Group"
Verify the version of java, update if required, and ensure the same version is available in the software's directory.

Figure 8-2 Verify Java Version

Description of "Figure 8-2 Verify Java Version"
Verify the configuration service details, update if required.

Figure 8-3 Verify Configuration Details

Description of "Figure 8-3 Verify Configuration Details"
Verify the Java home and certificate names.

Figure 8-4 Verify Java Home and Certificate Names

Description of "Figure 8-4 Verify Java Home and Certificate Names"
Verify the Kafka details as below.

Figure 8-5 Verify Kafka Details

Description of "Figure 8-5 Verify Kafka Details"
Verify the plato router details, update if required.

Figure 8-6 Verify Plato Router

Description of "Figure 8-6 Verify Plato Router"
Update database details under “#Database details for weblogic datasource configuration”.

Figure 8-7 Update Database Details

Description of "Figure 8-7 Update Database Details"

Parent topic: Foundation Setup Upgrade

8.1.3 Update Roles File

To update roles file:

Navigate to the path /scratch/obma_patch_installer/chef-repo/roles.
Update the obma_patch_install.rb with below details.
If you are upgrading from one version to another, then the version to be undeployed needs to be added in the below section app_undeployment.

Figure 8-8 App Undeployment

Description of "Figure 8-8 App Undeployment"
In the app_deployment section, update the new version to be deployed.

Figure 8-9 App Deployment

Description of "Figure 8-9 App Deployment"
Navigate to the bottom of the file and verify the recipes to be executed. All the listed recipes will be executed in sequential order as shown below.
For execution, please switch to root user from OS user and then run the below commands.
```
cd /scratch/obma_patch_installer/chef-repo
```
```
sh obma_patch_installer.sh
```
1. ```
run_list ['recipe[obma_patchset::undeployapp]','recipe[obma_patchset::stopman]','recipe[obma_patchset::updatesetuseroverrides_patch]','recipe[obma_patchset::startman]','recipe[obma_patchset::deployapp]']
```
  Once successfully run, please make sure all services are up. Upon verification, please make update the runlist to as below and re-run the obma_patch_installer.sh command.
2. ```
run_list ['recipe[obma_patchset::deployapigateway_router]']
```
  This step would bring up the plato-apigateway-router at the port specified. To confirm the same please visit the router logs at the location /scratch/work_area/logs.

Parent topic: Foundation Setup Upgrade

8.2 Oracle Banking Collections and Recovery Patch Installation

To upgrade the OBCR product using patch installer, first perform steps mentioned in section Download Installer.

Parent topic: Patchset Setup

8.2.1 Update Properties File

To update properties file:

Navigate to the path /scratch/obma_patch_installer/chef-repo/.
Open the respective product properties file and update the obcr_patch_properties.rb with below details.
Update the local user and its group.

Figure 8-10 Update Local User and Group

Description of "Figure 8-10 Update Local User and Group"
Verify Java home and certificate names.

Figure 8-11 Verify Java Home

Description of "Figure 8-11 Verify Java Home"

Parent topic: Oracle Banking Collections and Recovery Patch Installation

8.2.2 Update Roles File

To update roles file:

Navigate to the path /scratch/obma_patch_installer/chef-repo/roles and update obcr_patch_install.rb file with below details.
If you are upgrading from one version to another, then the version to be undeployed needs to be added in the below section app_undeployment.

Figure 8-12 App Undeployment

Description of "Figure 8-12 App Undeployment"
In the app_deployment section, update the new version to be deployed.

Figure 8-13 App Deployment

Description of "Figure 8-13 App Deployment"

Navigate to the bottom of the file and verify the recipes to be executed. All the listed recipes will be executed in sequential order as shown below.

run_list ['recipe[obma_patchset::undeployapp]','recipe[obma_patchset::stopman]','recipe[obma_patchset::updatesetuseroverrides_patch]','recipe[obma_patchset::startman]','recipe[obma_patchset::deployapp]']

For execution, please switch to root user from OS user and then run the below commands.

cd /scratch/obma_patch_installer/chef-repo
sh obcr_patch_installer.sh

run_list ['recipe[obma_patchset::undeployapp]','recipe[obma_patchset::stopman]','recipe[obma_patchset::addjdbcconnections_plato]','recipe[obma_patchset::updatesetuseroverrides_patch]','recipe[obma_patchset::startman]','recipe[obma_patchset::deployapp]']

Once everything is deployed, run the initial setup scripts from the below mentioned paths at Oracle Software Delivery Cloud to create the required maintenances. The descriptions for each of these have been provided in the Initial setup section of this document.

If a new role/user needs to be created, then run the below two scripts in Section-A followed by scripts from Section-B.

If no new role/user needs to be created, then only run scripts from Section-B.

Post Section-A & B please run Section-C & D if and only if you need to fill a certain maintenance for correspondence. Please read the descriptions for these scripts from Initial setup section of this document before executing.

Especially, for section-D the script only needs to be executed if the values for these properties are not already present in the database.

Section-A

OBCR_INITIAL_SETUP/obcr_role_creation.sql
To be compiled in SMS schema for OBCR specific admin role creation.
OBCR_INITIAL_SETUP/sms_initial_setup.sql
To be compiled in SMS schema.

Section-B

OBCR_INITIAL_SETUP/obma_role_seed.sql
To be compiled in SMS schema.
OBCR_INITIAL_SETUP/obcr_role.sql
To be compiled in SMS schema.

Section-C

OBCR_INITIAL_SETUP/ plato_properties_script.sql
To be compiled in PLATO schema.
OBCR_INITIAL_SETUP/ platofeed_script.sql
To be compiled in PLATOFEED schema.

Section-D

OBCR_INITIAL_SETUP/ dms_properties_script.sql
To be compiled in PLATO schema.

Parent topic: Oracle Banking Collections and Recovery Patch Installation