How to Apply OCT-2024 RU patches on Oracle 19C Non-RAC Database

 Dear All,

In this post i am going to share How to Apply OCT-2024 RU patches on Oracle 19C Non-RAC Database step by step process.

Oracle Database 19c Proactive Patch Information (Doc ID 2521164.1)

>> downloaded latest OCT 2024 RU patch  (36912597)

>> downloaded latest Opatch utility .( 6880688)

 High level steps

Ø  Check the existing patches.

Ø  Download the patches from support.oracle.com

Ø  Copy to the database server and unzip.

Ø  Upgrade opatch utility to as per  recommended level ( readme file )

Ø  Unzip the main RU patch and do the patch analysis.

$cd 36912597 

$/u01/app/oracle/product/19.0.0/db_home/OPatch/opatch
prereq CheckConflictAgainstOHWithDetail -ph ./ 

> Take downtime to apply the RU
patches. ( DEV >> TEST >> UAT >> PROD ) 

>Demo
instance approvals not required .. 

>>>  Take database full backup and other
important configuration files backups.

 Ex :: Rman / cold / hot 

Ø  Take Invalid count ( complete invalid objects ).

Ø  Ø   Stop the db listener and database.9PM IST 10PM IST )

Ø  Ø  Apply the patch using opatch command.

Ø  Ø  Start the database and db listener. 

Ø  ØTake invalid count and compare before patch and after patch, if any issues compile invalids. 

ؠؠ Still more invalids contact oracle support.

No invalids .. 

Ø  Run the datapatch verbose (* its should run post RU / CPU / major patches )  

Ø  Release the instance for business.  

   

 

>>> Click on the patch and download .. select the OS as per your environment , here im using Linux X86-64 bit ..for 19C database.

Click on download then 

Click on Zip file .. 1.7G

Once its downloaded upload to database server and proceed further steps as per the readme file .

Oracle® Database Patch 36912597 - Database Release Update 19.25.0.0.241015

Download latest Opatch utility 

Patch 6880880

After copy the both patches to database server .. fist upgrade the opatch utility version then start apply the OCT-2024 CPU

 

unzip p36912597_<version>_<platform>.zip

cd 36912597

opatch prereq CheckConflictAgainstOHWithDetail -ph ./

 

unzip -d <PATCH_TOP_DIR> p36912597_<version>_<platform>.zip

cd <PATCH_TOP_DIR> 36912597

opatch apply

 

Multitenant (CDB/PDB) Oracle Database

Sqlplus / as sysdba

Startup

alter pluggable database all open;

cd $ORACLE_HOME/OPatch

./datapatch -sanity_checks

./datapatch -verbose

 

 

Note :

1. Any (pluggable) database that has invalid objects after the execution of datapatch should have catcon.pl run to revalidate those objects. For example:

2. export PATH=$PATH:$ORACLE_HOME/bin

3. cd $ORACLE_HOME/rdbms/admin

$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -e -b utlrp -d

Document 2521164.1

High level steps

Ø  Check the existing patches.

Ø  Download the patches from support.oracle.com

Ø  Copy the patch zip file to the database server and unzip.

Ø  Upgrade opatch utility to as per  recommended level ( readme file )

Ø  Unzip the main RU patch and do the patch analysis.

$cd 36912597

/u01/app/oracle/product/19.0.0/db_home/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./

Ø  Take downtime to apply the RU
patches. ( DEV >> TEST >> UAT >> PROD )
Demo instance approvals not required .. 
Ø  Take database full backup and other
important configuration files backups.
ex: types of backups in oracle database .. Rman / cold/ hot 
Ø  Take Invalid count ( complete invalid objects ).

Ø  Stop the db listener and database.(9PM IST to 10PM IST )



Ø  Apply the patch using opatch command.





Ø  Start the database and db listener.




Take invalid count and compare before patch and after patch, if any issues compile invalids.

Ø  Still more invalids contact oracle support.  No invalids     
>>Ø  Run the datapatch verbose (* its should run post RU / CPU / major patches )

Ø  Release the instance for business.  
If any invalids compile it using below command.

$ORACLE_HOME/rdbms/admin utlrp.sql
If any errors after apply the patch you can rollback the patch using below command.

opatch rollback -id 36912597

Thanks,
Srini