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
- Modify User Profiles
- Modify /etc/oratab (only for Single-Instance Databases)
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
- Modify /etc/flashgrid_debug_env
- Modify /etc/oratab (only for Single-Instance Databases)
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)