Manual Oracle Database Grid Patching

As the database home owner execute:

/u01/app/oracle/product/19.0.0/db_1/bin/srvctl stop home -o /u01/app/oracle/product/19.0.0/db_1 -s /tmp/stat_file

Run the pre root script (As Root User)

/u01/app/oragrid/product/19.0.0/grid/crs/install/roothas.sh -prepatch

Patch GI home.

As the GI home owner execute:

. oraenv
+ASM

## OCW Release Update
$ /u01/app/oragrid/product/19.0.0/grid/OPatch/opatch apply -oh /u01/app/oragrid/product/19.0.0/grid -local /tmp/Patch202308/35642822/35655527

## Database Release Update
$ /u01/app/oragrid/product/19.0.0/grid/OPatch/opatch apply -oh /u01/app/oragrid/product/19.0.0/grid -local /tmp/Patch202308/35642822/35643107

## ACFS Release Update
$ /u01/app/oragrid/product/19.0.0/grid/OPatch/opatch apply -oh /u01/app/oragrid/product/19.0.0/grid -local /tmp/Patch202308/35642822/35652062

## Tomcat Release Update
$ /u01/app/oragrid/product/19.0.0/grid/OPatch/opatch apply -oh /u01/app/oragrid/product/19.0.0/grid -local /tmp/Patch202308/35642822/35553096

Patch DB home (As the database home owner execute:)

. oraenv
<DB_SID>

## OCW Release Update

$ /tmp/Patch202308/35642822/35655527/custom/scripts/prepatch.sh -dbhome /u01/app/oracle/product/19.0.0/db_1


## OCW Release Update

$ /u01/app/oracle/product/19.0.0/db_1/OPatch/opatch apply -oh /u01/app/oracle/product/19.0.0/db_1 -local /tmp/Patch202308/35642822/35655527

## Database Release Update
$ /u01/app/oracle/product/19.0.0/db_1/OPatch/opatch apply -oh /u01/app/oracle/product/19.0.0/db_1 -local /tmp/Patch202308/35642822/35643107


## OCW Release Update
$ /tmp/Patch202308/35642822/35655527/custom/scripts/postpatch.sh -dbhome /u01/app/oracle/product/19.0.0/db_1

Run the post script.

As the root user execute:

# /u01/app/oragrid/product/19.0.0/grid/rdbms/install/rootadd_rdbms.sh

If this is a GI Home, as the root user execute:

# /u01/app/oragrid/product/19.0.0/grid/crs/install/rootcrs.sh -postpatch

If this is an Oracle Restart Home, as the root user execute:

# /u01/app/oragrid/product/19.0.0/grid/crs/install/roothas.sh -postpatch

Tagged , ,