How to apply Jul-2024 RU patches on Oracle 19C

 Dear All,

How to apply Jul-2024 RU patches on Oracle 19C :

 

1.    We need to check existing opatch patch version & last applied RU patches  and database versions.

 

2.    Download the latest RU patch from metal ink/ support.oracle.com

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

>> downloaded latest Jul 2024 RU patch  (36582781 )

>> downloaded latest Opath utility .( 6880688)

 

How to install the utility: Opatch utility install/ upgrade

-----------------------------------------------------------

 

To install this patch, Please extract the file "zipped file" using unzip or winzip,

depending upon the platform. You should extract the zip file directly under the

ORACLE_HOME. Please follow the following steps for extracting the zip file of OPatch.

 

(1)  Please take a backup of ORACLE_HOME/OPatch into a dedicated backup

location.

(2) Please make sure no directory ORACLE_HOME/OPatch exist.

(3) Please unzip the OPatch downloaded zip into ORACLE_HOME directory.

 

To check the version of the opatch utility installed in the above step,

go to the OPatch directory and run "opatch version".

 

Present : opatch version is : 12.2.0.1.17

After upgrade :  opatch version >> 12.2.0.1.43

 

3.    Copy the download patch to oracle database server.

By using Winscp I have copied the patches to my database server.

4.    Interim Patch Conflict Detection and Resolution.

 unzip p36582781_190000_Linux-x86-64.zip

 cd 36582781

export PATH=$ORACLE_HOME/OPatch:$PATH

opatch prereq CheckConflictAgainstOHWithDetail -ph ./

Check the invalids before patch apply

SQL> select count(*) from dba_objects where status='INVALID';

  COUNT(*)

----------

         0

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 PDB                            READ WRITE NO

SQL> alter session set container=pdb;

Session altered.

SQL> select count(*) from dba_objects where status='INVALID';

  COUNT(*)

----------

         0

Take database home and orainventory backups .. ****

5.     Shutdown the database instance and listener services ..

lsnrctl stop LISTENER

 

6.     Apply JUL 2024 RU patch using opatch utility

./opatch apply

 

7.    Start database and listener

8.    Run datapatch verbose

 

9.    Release the instance .

 

Check the database open or not and send communication mail to team…

Thanks,

Srinivas