Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem in database Patching!

HesipesiNov 8 2019 — edited Nov 13 2019

Hi,

I'm trying to patch a database which hasn't been patched for a while and I'm getting the following error? patch from JAN 2019 to JUL 2019

Does any one have an idead about how to fix it.

I'm new to database patching.

----

Copyright (c) 2014, Oracle. All rights reserved.

Connecting to database...OK

Determining current state...done

Current state of SQL patches:

Patch 26925311 ():

Not installed in binary or the SQL registry

Patch 27001733 (Database PSU 12.1.0.2.180116, Oracle JavaVM Component (JAN2018)):

Not installed in binary or the SQL registry

Patch 28729169 ():

Not installed in binary or the SQL registry

Patch 28790654 ():

Not installed in binary or the SQL registry

Patch 29774383 (Database PSU 12.1.0.2.190716, Oracle JavaVM Compon):

Installed in the binary registry only

Adding patches to installation queue and performing prereq checks...

Installation queue:

The following patches will be rolled back:

26925311 ()

28729169 ()

28790654 ()

The following patches will be applied:

29774383 (Database PSU 12.1.0.2.190716, Oracle JavaVM Compon)

catcon: ALL catcon-related output will be written to /tmp/sqlpatch_catcon__catcon_10683.lst

catcon: See /tmp/sqlpatch_catcon_*.log files for output generated by scripts

catcon: See /tmp/sqlpatch_catcon__*.lst files for spool files, if any

Installing patches...

Patch installation complete. Total patches installed: 4

Validating logfiles...

Patch 26925311 rollback: WITH ERRORS

logfile: /opt/oracle/cfgtoollogs/sqlpatch/26925311/21850549/26925311_rollback_2019Nov08_10_44_26.log (errors)

Error at line 16: ORA-20001: set\_patch\_metadata not called

Error at line 17: ORA-06512: at "SYS.DBMS\_SQLPATCH", line 613

Error at line 18: ORA-06512: at line 2

Patch 28729169 rollback: WITH ERRORS

logfile: /opt/oracle/cfgtoollogs/sqlpatch/28729169/22626239/28729169_rollback_2019Nov08_10_38_00.log (errors)

Error at line 16: ORA-20001: set\_patch\_metadata not called

Error at line 17: ORA-06512: at "SYS.DBMS\_SQLPATCH", line 613

Error at line 18: ORA-06512: at line 2

Patch 28790654 rollback: WITH ERRORS

logfile: /opt/oracle/cfgtoollogs/sqlpatch/28790654/22620251/28790654_rollback_2019Nov08_10_37_59.log (errors)

Error at line 16: ORA-20001: set\_patch\_metadata not called

Error at line 17: ORA-06512: at "SYS.DBMS\_SQLPATCH", line 613

Error at line 18: ORA-06512: at line 2

Patch 29774383 apply: WITH ERRORS

logfile: /opt/oracle/cfgtoollogs/sqlpatch/29774383/22961858/29774383_apply_2019Nov08_11_08_54.log (errors)

Error at line 16: ORA-20001: set\_patch\_metadata not called

Error at line 17: ORA-06512: at "SYS.DBMS\_SQLPATCH", line 613

Error at line 18: ORA-06512: at line 2

Please refer to MOS Note 1609718.1 for information on how to resolve the above errors.

----

Here is the result of :

select * from dba_registry_sqlpatch

err.jpg

Please let me know if you need more info!

Thanks!

/Hesi

Comments
Post Details
Added on Nov 8 2019
4 comments
2,499 views