Skip to main content
FlashGrid.io

Out of Place ( OOP ) Patching using opatchauto

  • Updated
  • Products: FlashGrid Cluster on Azure
  • Products: FlashGrid Server on AWS
  • Products: FlashGrid Cluster on AWS
  • Products: FlashGrid Server on Azure

This document explains additional steps that need to be performed in FlashGrid cluster/server environments following out of place (OOP) Patching.

Note The steps in this article can be applied to Database nodes only.

Grid Infrastructure Post Patch

Restart FlashGrid ASM Service

# systemctl restart flashgrid_asm.service

Modify User Profiles

Ensure that the Oracle Grid Infrastructure Home Path is updated in the following files:

  • /home/fg/.bashrc
  • /home/grid/.bashrc
  • /root/.bashrc

For example, if there is the original home path in one of these files:

export ORACLE_HOME=/u01/app/19.3.0/grid
export PATH=/u01/app/19.3.0/grid/bin:$PATH

Change it to the clone home path:

export ORACLE_HOME=/u01/app/19.3.0/grid_oop
export PATH=/u01/app/19.3.0/grid_oop/bin:$PATH

Modify /etc/oratab (only for Single-Instance Databases)

Note Follow the steps in this section only if you use Single-Instance Databases.

There are two types of entries in /etc/oratab:

  • managed by Oracle Restart - they have the # line added by Agent comment: 
    +ASM:/u01/app/19.3.0/grid:N             # line added by Agent
orcl:/u01/app/oracle/product/12.2.0/dbhome_1:N          # line added by Agent
  • non-managed by Oracle Restart - those are without the comment 
    asm:/u01/app/19.3.0/grid:N
exampledb:/u01/app/oracle/product/12.2.0/dbhome_1:N

    When you have any non-managed by Oracle Restart entries, update them accordingly to point them to the clone home path:

    asm:/u01/app/19.3.0/grid_oop:N
exampledb:/u01/app/oracle/product/12.2.0/dbhome_oop:N

Database Post Patch

Note This section should be skipped when out of place Patching is applied only to Grid Infrastructure. Otherwise, follow the steps below.

Modify User Profiles

Ensure that the Database Home Path is updated in: /home/oracle/.bashrc

For example, if there is the original home path:

Change it to the clone home path:

export ORACLE_HOME=/u01/app/oracle/product/19.3.0/dbhome_oop
export PATH=/u01/app/oracle/product/19.3.0/dbhome_oop/bin:$PATH

Modify /etc/flashgrid_debug_env

Ensure that PATH_DB_HOME points to the clone home path in: /etc/flashgrid_debug_env

For example, if there is the original home path:

PATH_DB_HOME=/u01/app/oracle/product/19.3.0/dbhome_1

Change it to the clone home path:

PATH_DB_HOME=/u01/app/oracle/product/19.3.0/dbhome_oop

Modify /etc/oratab (only for Single-Instance Databases)

The steps are the same as in Modify /etc/oratab (only for Single-Instance Databases)