SQL> SELECT applied_patch_id, patch_name, patch_type,LAST_UPDATE_DATE from applsys.ad_applied_patches where PATCH_NAME=’1809065289′;
APPLIED_PATCH_ID PATCH_NAME PATCH_TYPE LAST_UPDATE_DATE
————————— ——————- ——————— —————————
370789 1809065289 ONE-OFF 24-JAN-21
370790 1809065289 ONE-OFF 24-JAN-21
SQL> select PATCH_DRIVER_ID,APPLIED_PATCH_ID,ORIG_PATCH_NAME from ad_patch_drivers where APPLIED_PATCH_ID=’370790′;
PATCH_DRIVER_ID APPLIED_PATCH_ID ORIG_PATCH_NAME
————— ——————- —————————-
343160 30790 1809065289
SQL> SELECT ab.bug_number, acp.patch_abstract
FROM ad_comprising_patches acp, ad_bugs ab
WHERE acp.bug_id = ab.bug_id AND acp.patch_driver_id = ‘343160’;
BUG_NUMBER PATCH_ABSTRACT
——————– ———————————————————————————————————————————–
30735865 R12.TXK.C.DELTA.12
31904550 This patch delivers the fix to ensure fs_clone duration is not impacted due to symbolic links of large size in APPL_TOP or COMMON_TOP.
23705992 TNSNAMES.ORA GENERATED WITH SCAN NAME INSTEAD OF SCAN IPS FOR CUSTOM RACE DB CLONE
18525466 REVERT CHANGES MADE TO VALIDATE MANAGED SERVER PORTS OF ALL NODES
