0 Get the patch # that you want to download. - For this document, I am using the following: Patch# is 33859214 For this document, I am using the following: - Patch# is 33859214 Patch# is 33859214 For this document, I am using the following: - Patch# is 33859214 Patch# is 33859214 Patch# is 33859214

1 Download Patch from Oracle Support. https://support.oracle.com/ for the platform your database is hosted on. In this case, my database is hosted on 64-Bit Linux. Zip File Name: p33859214_19150000_Linux-x86-64.zip

9 Ensure ORACLE_HOME environment is set echo $ORACLE_HOME $echo $ORACLE_HOME /u01/app/oracle/product/19.3.0/dbh_12 $

10 Check the current Patcheset. opatch lsinventory $opatch lsinv |grep applied Patch  29585399     : applied on Thu Apr 18 02:21:33 CDT 2019 Patch  29517242     : applied on Thu Apr 18 02:21:17 CDT 2019

$opatch lsinv |grep desc ARU platform description:: Linux x86-64 Patch description:  “OCW RELEASE UPDATE 19.3.0.0.0 (29585399)” Patch description:  “Database Release Update : 19.3.0.0.190416 (29517242)” $opatch lspatches -oh /u01/app/oracle/product/19.3.0/dbh_12 29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)

29517242;Database Release Update : 19.3.0.0.190416 (29517242) OPatch succeeded. $ 11 Unzip the patch cd $cd /u99/software/Patches/

unzip p33859214_19150000_Linux-x86-64.zip 12 Verify the Patch Directory is created. In this case, a directory called 33859214 is created. 13 Determine whether any currently installed interim patches conflict with this patch From readme.txt

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/33803476/33806152 % $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/33803476/33815596 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u99/software/Patches/33859214/33803476/33806152 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u99/software/Patches/33859214/33803476/33815596 14 from readme.txt

For Oracle home, as home user: Create file /tmp/patch_list_dbhome.txt with the following content: % cat /tmp/patch_list_dbhome.txt <UNZIPPED_PATCH_LOCATION>/33803476/33806152 <UNZIPPED_PATCH_LOCATION>/33803476/33815596 Run OPatch command to check if enough free space is available in the Oracle home: % $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_dbhome.txt The command output reports pass and fail messages as per the system space availability:

- If OPatch reports Prereq “checkSystemSpace” failed. , then cleanup the system space as the required amount of space is not available. If OPatch reports Prereq “checkSystemSpace” failed. , then cleanup the system space as the required amount of space is not available. - If OPatch reports Prereq “checkSystemSpace” passed. , then no action is needed. Proceed with patch installation. If OPatch reports Prereq “checkSystemSpace” passed. , then no action is needed. Proceed with patch installation. If OPatch reports Prereq “checkSystemSpace” failed. , then cleanup the system space as the required amount of space is not available. If OPatch reports Prereq “checkSystemSpace” passed. , then no action is needed. Proceed with patch installation. vi /tmp/patch_list_dbhome.txt /u99/software/Patches/33859214/33803476/33806152 /u99/software/Patches/33859214/33803476/33815596

:wq! cat /tmp/patch_list_dbhome.txt $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_dbhome.txt 15 SET LINESIZE 500 SET PAGESIZE 1000

SET SERVEROUT ON SET LONG 2000000 COLUMN action_time FORMAT A12 COLUMN action FORMAT A10 COLUMN comments FORMAT A30 COLUMN description FORMAT A60

COLUMN namespace FORMAT A20 COLUMN status FORMAT A10 SELECT TO_CHAR(action_time, ‘YYYY-MM-DD’) AS action_time,action,status, description,patch_id FROM sys.dba_registry_sqlpatch ORDER by action_time; col comp_id for a10 col version for a11

col status for a10 col comp_name for a37 select comp_id,comp_name,version,status from dba_registry; 16 COLUMN object_name FORMAT A30 SELECT owner,

object_type, object_name, status FROM dba_objects WHERE status = ‘INVALID’ ORDER BY owner, object_type, object_name;

17 Database Downtime Begins here 18 Find all listeners running from the ORACLE_HOME you are patching Ensure that all listeners running from this database home should be down. To find what listeners are associated with this ORACLE_HOME, run the following: - ps -ef |grep lsnr |awk  ‘{print $8 $9}’ |grep -v grep ps -ef |grep lsnr |awk  ‘{print $8 $9}’ |grep -v grep

ps -ef |grep lsnr |awk  ‘{print $8 $9}’ |grep -v grep 19 Shutdown Listener that is associated with this ORACLE_HOME you are patching. - lsnrctl stop LISTENER lsnrctl stop LISTENER lsnrctl stop LISTENER 20

Find all DATABASES running from the ORACLE_HOME you are patching: - echo $ORACLE_HOME echo $ORACLE_HOME - ls -1 $ORACLE_HOME/dbs/init* $ORACLE_HOME/dbs/spfile* ls -1 $ORACLE_HOME/dbs/init* $ORACLE_HOME/dbs/spfile* echo $ORACLE_HOME ls -1 $ORACLE_HOME/dbs/init* $ORACLE_HOME/dbs/spfile* 21 Stop all instances running from the ORACLE_HOME you are patching:

- . oraenv → DBPA . oraenv → DBPA - sqlplus / as sysdba sqlplus / as sysdba - shutdown immediate; shutdown immediate; . oraenv → DBPA sqlplus / as sysdba shutdown immediate; 22 Verify listener and instances associated with ORACLE_HOME you are patching are completely down.

- ps -ef |grep lsnr |grep LISTENER |grep -v grep ps -ef |grep lsnr |grep LISTENER |grep -v grep - ps -ef |grep pmon |grep DBPA |grep -v grep ps -ef |grep pmon |grep DBPA |grep -v grep ps -ef |grep lsnr |grep LISTENER |grep -v grep ps -ef |grep pmon |grep DBPA |grep -v grep 23 Take Backup of ORACLE_HOME and Database (Rollback plan ) cd $ORACLE_HOME

tar -cvf oracle_home_17 May_2022.tar $ORACLE_HOME Connect with rman take full backup 24 Change directory to Patch’s Staging Directory - cd /u01/app/oracle/product/19.3.0/dbh_12/PATCHES/33859214/33803476/33806152 cd /u01/app/oracle/product/19.3.0/dbh_12/PATCHES/33859214/33803476/33806152

cd /u01/app/oracle/product/19.3.0/dbh_12/PATCHES/33859214/33803476/33806152 /u01/app/oracle/product/19.3.0/dbh_12/PATCHES/33859214/33803476/33806152 25 At this point, patch can be installed. - opatch apply opatch apply opatch apply

$pwd /u01/app/oracle/product/19.3.0/dbh_12/PATCHES/33859214/33803476/33815596 $opatch apply 26 Verify patches are applied - opatch lsinventory opatch lsinventory

opatch lsinventory Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production Version 19.15.0.0.0 $opatch lsinv |grep applied Patch  33815596     : applied on Wed May 18 00:20:15 CDT 2022 Patch  33806152     : applied on Wed May 18 00:01:01 CDT 2022

$opatch lsinv |grep desc ARU platform description:: Linux x86-64 Patch description:  “OCW RELEASE UPDATE 19.15.0.0.0 (33815596)” Patch description:  “Database Release Update : 19.15.0.0.220419 (33806152)” $opatch lspatches -oh /u01/app/oracle/product/19.3.0/dbh_12 33815596;OCW RELEASE UPDATE 19.15.0.0.0 (33815596)

33806152;Database Release Update : 19.15.0.0.220419 (33806152) OPatch succeeded. 27 Once the opatch is completed its patching: - startup LISTENER startup LISTENER - Startup INSTANCE(S). Startup INSTANCE(S). startup LISTENER

Startup INSTANCE(S). - lsnrct start lsnrct start lsnrct start - . oraenv →DBPA . oraenv →DBPA - sqlplus / as sysdba startup sqlplus / as sysdba - startup startup . oraenv →DBPA sqlplus / as sysdba

- startup startup startup 28 Verify listener and instances are started. - ps -ef |grep lsnr |grep LISTENER |grep -v grep ps -ef |grep lsnr |grep LISTENER |grep -v grep - ps -ef |grep pmon |grep DBPA|grep -v grep ps -ef |grep pmon |grep DBPA|grep -v grep ps -ef |grep lsnr |grep LISTENER |grep -v grep

ps -ef |grep pmon |grep DBPA|grep -v grep 29 Execute post patch steps and run datapatch command $cd $ORACLE_HOME/OPatch $./datapatch -verbose 31

Check opatch lsinventory and list of patches applied in ORACLE_HOME $opatch lsinv |grep applied Patch  33815596     : applied on Wed May 18 00:20:15 CDT 2022 Patch  33806152     : applied on Wed May 18 00:01:01 CDT 2022 $opatch lsinv |grep desc ARU platform description:: Linux x86-64

Patch description:  “OCW RELEASE UPDATE 19.15.0.0.0 (33815596)” Patch description:  “Database Release Update : 19.15.0.0.220419 (33806152)” $opatch lspatches -oh /u01/app/oracle/product/19.3.0/dbh_12 33815596;OCW RELEASE UPDATE 19.15.0.0.0 (33815596) 33806152;Database Release Update : 19.15.0.0.220419 (33806152) 32

Recompile invalid Objects select count(*) from all_objects where status = ‘INVALID’ group by owner; SQL> @?/rdbms/admin/utlrp.sql SQL> select count(*) from all_objects where status = ‘INVALID’ group by owner; 2. WinSCP to Server:$ORACLE_HOME/Patches_Staging_Area

3. Extract Patch to get the ReadMe.txt 30. After applying RU patch,Check the DBA_REGISTRY_SQLPATCH SET LINESIZE 500 SET PAGESIZE 1000

SET SERVEROUT ON SET LONG 2000000 COLUMN action_time FORMAT A12 COLUMN action FORMAT A10 COLUMN patch_type FORMAT A10 COLUMN description FORMAT A32

COLUMN status FORMAT A10 COLUMN version FORMAT A10 spool check_patches_19c.txt select CON_ID, TO_CHAR(action_time, ‘YYYY-MM-DD’) AS action_time, PATCH_ID,

PATCH_TYPE, ACTION, DESCRIPTION, SOURCE_VERSION, TARGET_VERSION from CDB_REGISTRY_SQLPATCH

order by CON_ID, action_time, patch_id; spool off 4. From the ReadMe.txt file, ensure if the patch is: - Online Patchable → Ensure that all the services in the Oracle home are up (OR) Online Patchable → Ensure that all the services in the Oracle home are up (OR) - Offline Patchable → Ensure that all the services in the Oracle home are down Offline Patchable → Ensure that all the services in the Oracle home are down Online Patchable → Ensure that all the services in the Oracle home are up (OR)

Offline Patchable → Ensure that all the services in the Oracle home are down 5. Set ORACLE_SID . oreanv → DBPA 6. Export PATH to OPatch location

export PATH=$ORACLE_HOME/OPatch:$ORACLE_HOME/bin:$PATH 7. From the Read.me file, opatch version should be the latest version. To find the current opatch version, check the Patch 6880880 . From Readme.txt opatch version 8.

Upgrade Opatch Tool from 12.2.0.1.17 to 12.2.0.1.30 $pwd /u99/software/Patches $cp p6880880_210000_Linux-x86-64.zip /u01/app/oracle/product/19.3.0/dbh_12 cd /u01/app/oracle/product/19.3.0/dbh_12 mv OPatch/ OPatch_BKP

$cd /u01/app/oracle/product/19.3.0/dbh_12 $mv OPatch/ OPatch_BKP $ls -ltrh  p6880880_210000_Linux-x86-64.zip -rwxr-xr-x. 1 oracle oinstall 119M May 17 21:53 p6880880_210000_Linux-x86-64.zip $pwd /u01/app/oracle/product/19.3.0/dbh_12

$unzip  p6880880_210000_Linux-x86-64.zip opatch version No Description Screenshot / Command / Others Hope it Helps.