Apply patches in 12.2 in downtime mode

Check Patches:
SELECT DISTINCT RPAD(a.bug_number,
11)|| RPAD(e.patch_name,
11)|| RPAD(TRUNC(c.end_date),
12)|| RPAD(b.applied_flag, 4)  BUG_APPLIED
FROM
apps.ad_bugs a,
apps.ad_patch_run_bugs b,
apps.ad_patch_runs c,
apps.ad_patch_drivers d ,
apps.ad_applied_patches e
WHERE
a.bug_id = b.bug_id AND
b.patch_run_id = c.patch_run_id AND
c.patch_driver_id = d.patch_driver_id AND
d.applied_patch_id = e.applied_patch_id AND
a.bug_number in  ('23199810','22748721')
ORDER BY 1 DESC;

select ADOP_SESSION_ID, BUG_NUMBER, STATUS, APPLIED_FILE_SYSTEM_BASE, PATCH_FILE_SYSTEM_BASE, ADPATCH_OPTIONS, NODE_NAME, END_DATE, CLONE_STATUS
from ad_adop_session_patches
order by end_date desc;

Precheck: Spool in file

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

select object_type,count(*) from dba_objects where status='INVALID' group by object_type;



Apply patches in 12.2 in downtime mode::::::::::::::

Bring down services: and start with below:

adop phase=apply patches=22748721 apply_mode=downtime

In case of many patch with merge option:

adop phase=apply patches=23199810,23199810_PTB:u23199810.drv,23199810_DK:u23199810.drv,23199810_NL:u23199810.drv,23199810_F:u23199810.drv,23199810_D:u23199810.drv,23199810_HU:u23199810.drv,23199810_I:u23199810.drv,23199810_PL:u23199810.drv,23199810_PT:u23199810.drv,23199810_RU:u23199810.drv,23199810_ZHS:u23199810.drv,23199810_E:u23199810.drv,23199810_ZHT:u23199810.drv merge=yes apply_mode=downtime