Queryable Patch inventory - Issue/Solutions for ORA-20008 Timed out, Job Load_opatch_inventory_% (Doc ID 1638882.1)

Last updated on JUNE 02, 2017

Applies to:

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

Symptoms

 During execution of datapatch or DBMS_QOPATCH in PDB/RAC environment following errors seen

./datapatch -verbose

DBD::Oracle::st execute failed: ORA-20008: Timed out, Job Load_opatch_inventory_1
execution time is more than 120Secs
ORA-06512: at "SYS.DBMS_QOPATCH", line 1011
ORA-06512: at line 4 (DBD ERROR: OCIStmtExecute) [for Statement "DECLARE
x XMLType;
BEGIN
x := dbms_qopatch.get_pending_activity;
? := x.getStringVal();
END;" with ParamValues: :p1=undef] at
/u01/app/oracle/product/12.1.0/dbhome_1/sqlpatch/sqlpatch.pm line 824.

Even tried using force and got an error in PDB Environment :

./datapatch -apply 17027533 -force
SQL Patching tool version 12.1.0.1.0 on Fri Jan 10 16:01:42 2014
Copyright (c) 2013, Oracle.  All rights reserved.

Connecting to database...OK
Determining current state...done
For the following PDBs: CDB$ROOT
Nothing to roll back
The following patches will be applied: 17027533
For the following PDBs: PDB$SEED
Nothing to roll back
.......

.......

For the following PDBs: LSTCLONE
Nothing to roll back
The following patches will be applied: 17027533
For the following PDBs: LRGMGRTSTPDB
Nothing to roll back
The following patches will be applied: 17027533
Adding patches to installation queue...DBD::Oracle::st execute failed:
ORA-20008: Timed out, Job Load_opatch_inventory_1 execution time is more than
120Secs
ORA-06512: at "SYS.DBMS_QOPATCH", line 1428
ORA-06512: at "SYS.DBMS_QOPATCH", line 309 (DBD ERROR: error possibly near
<*> indicator at char 7 in 'SELECT
<*>dbms_qopatch.get_opatch_files('17027533').GetStringVal() FROM dual') [for
Statement "SELECT dbms_qopatch.get_opatch_files('17027533').GetStringVal()
FROM dual"] at /u01/app/oracle/product/12.1.0/dbhome_1/sqlpatch/sqlpatch.pm
line 251.

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms