13c EM: Fleet Datapatch Step Retries Max 5 times On Failure And Retry Takes 25 Minutes To Complete
(Doc ID 2649025.1)
Last updated on APRIL 04, 2020
Applies to:Enterprise Manager for Oracle Database - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
In Enterprise Manager (EM) Cloud Control, Fleet Datapatch step retries max 5 times on failure and retry takes 25 minutes to complete.
Apply PSU/Patches on the database step output:
Try number 5.
+ /u01/app/oracle/product/184.108.40.206/db_1.190416/sqlpatch/sqlpatch SQL Patching tool version 220.127.116.11.0 Production on Fri Jun 7 22:10:05 2019
Copyright (c) 2012, 2019, Oracle. All rights reserved.
Connecting to database...OK
Bootstrapping registry and package to current versions...done
Determining current state...
DBD::Oracle::db selectrow_array failed: ORA-20008: Timed out, Job
Load_opatch_inventory_1execution time is more than 120Secs
ORA-06512: at "SYS.DBMS_QOPATCH", line 2235
ORA-06512: at "SYS.DBMS_QOPATCH", line 864
ORA-06512: at "SYS.DBMS_QOPATCH", line 2100
ORA-06512: at "SYS.DBMS_SQLPATCH", line 1023 (DBD ERROR: error possibly near
<*> indicator at char 47 in 'SELECT dbms_lob.getlength(XMLSerialize(CONTENT <*>dbms_sqlpatch.opatch_registry_state INDENT)) FROM dual') [for Statement
"SELECT dbms_lob.getlength(XMLSerialize(CONTENT dbms_sqlpatch.opatch_registry_state INDENT)) FROM dual"]
at /u01/app/oracle/product/18.104.22.168/db_1.190416/sqlpatch/sqlpatch.pm line 2088, <LOGFILE> line 8.
Datapatch failed but before retry a wait time of 5 mins will happen Tried 5 times. Please rerun the patch sqls.
Datapatch execution failed with error code 256[ERROR] - Datapatch execution failed with error code 256
Deleted temporary destination directory
Process returned : 1.
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