Login  Register

Is patch applied

Posted by big on Nov 08, 2022; 8:18pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Is-patch-applied-tp11216.html

Hi,
On R12.2.9 DB 18C on AIX
I ran:
time adop phase=apply patches=30628681 hotpatch=yes abandon=yes
In log I have:
view adop_20221108_155909.log
[STATEMENT] [END   2022/11/08 17:23:17] adzdoptl.pl run
[STATEMENT] adop phase=apply - Completed Successfully
But when query database:

SQL> select APPLIED_PATCH_ID ,PATCH_NAME ,CREATION_DATE from ad_applied_patches where PATCH_NAME in ('330628681')order by CREATION_DATE desc;

no rows selected

SQL> select ad_patch.is_patch_applied('R12',-1, 330628681 ) from dual;

AD_PATCH.IS_PATCH_APPLIED('R12',-1,330628681)
--------------------------------------------------------------------------------
NOT_APPLIED

Is patche 30628681 really applied or not?

When I run adop -status, I see apply phase is acative.

Thanks and regards.