My Oracle Support Banner

Fleet Maintenance: UPDATE_DB/UPDATE_RACDB Fails In Apply PSU Step with Error "ORA-20008: Timed out" While Executing Datapatch (Doc ID 2646749.1)

Last updated on MARCH 09, 2020

Applies to:

Enterprise Manager for Oracle Database - Version 13.3.1.0.0 and later
Information in this document applies to any platform.

Symptoms

In Enterprise Manager Cloud Control, Fleet Maintenance UPDATE_DB,UPDATE_RACDB fails in Apply PSU Step with Error "ORA-20008: Timed out" While Executing Datapatch

Command Snippet:
emcli db_software_maintenance -performOperation -name=Fleet -purpose=UPDATE_DB/UPDATE_RACDB -target_type=oracle_database/rac_database -target_list=ABC -normal_credential=ORACLE:SYSMAN -privilege_credential=ROOT:SYSMAN

Job Step Log:: Job Steps Log for Job :Apply PSU/Patches on the database
-----------------------------------------------------------------------------------
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/12.2.0.1/db_1.190416/sqlpatch/sqlpatch.pm line 2088,
<LOGFILE> line 8.

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.