My Oracle Support Banner

datapatch fails for dbms_sqlpatch.patch_initialize with error: 'ORA-00955','ORA-06512: at "SYS.DBMS_SQLPATCH"' (Doc ID 2589536.1)

Last updated on SEPTEMBER 17, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

 12.2 datapatch fails with error:

logfile: &full_logfile (no errors)

 

And apply log shows the following errors in the beginning and there are no other errors.

SQL> BEGIN
2 dbms_sqlpatch.patch_initialize(p_patch_id => 28822638,
3 p_patch_uid => 22660595,
4 p_flags => '&flags',
5 p_description => '&description',
6 p_action => 'APPLY',
7 p_logfile => '&full_logfile',
8 p_bundle_series => '&bundle_series');
9 END;
10 /
old 4: p_flags => '&flags',
new 4: p_flags => 'NB',
old 5: p_description => '&description',
new 5: p_description => 'DATABASE OCT 2018 RELEASE UPDATE REVISION 12.2.0.1.190115',
old 7: p_logfile => '&full_logfile',
new 7: p_logfile => '$ORACLE_BASE/cfgtoollogs/sqlpatch/patch_num/patch_uid/patch_num_apply_<DB>_PDB_<PDB>_<timestamp>.log',,
old 8: p_bundle_series => '&bundle_series');
new 8: p_bundle_series => '12.2.0.1.190115DBOCT2018RUR');
BEGIN
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
ORA-06512: at "SYS.DBMS_SQLPATCH", line 598
ORA-06512: at "SYS.DBMS_SQLPATCH", line 451
ORA-06512: at line 2

 

registry$sqlpatch shows status 'END' and null values for FLAGS,DESCRIPTION,BUNDLE_SERIES,BUNDLE_ID,BUNDLE_DATA :

select * from registry$sqlpatch where PATCH_ID='<patchnum>;

PATCH_ID  ACTION  ACTION_TIME     DESCRIPTION   LOGFILE                                                                                           STATUS   VERSION    PATCH_UID  FLAGS  BUNDLE_SERIES  BUNDLE_ID  INSTALL_ID  PATCH_DIRECTORY BUNDLE_DATA PATCH_DESCRIPTOR POST_LOGFILE

28822638  APPLY     <timestamp>                             <patch_num_apply_<DB>_PDB_<PDB>_<timestamp>.log' location    END       12.2.0.1     22660595

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.