EM 12c: Analyzing a Patch Plan in Enterprise Manager 12c Cloud Control Fails with Error: SQL Patching tool failed to run on the following database targets (Doc ID 2094349.1)

Last updated on JULY 24, 2017

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.7.0 to 12.1.0.8.0 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Analyzing a Patch Plan (for instance, patch 21359755) for a target 12.1.0.2 database in Enterprise Manager (EM) 12c Cloud Control fails with the following console error:

Connecting to database...OK
Note: Datapatch will only apply or rollback SQL fixes for PDBs
that are in an open state, no patches will be applied to closed PDBs.
Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
(Doc ID 1585822.1)
DBD::Oracle::db selectrow_array failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout

(DBD ERROR: error possibly near indicator at char 7 in 'SELECT dbms_sqlpatch.verify_queryable_inventory FROM dual') [for Statement "SELECT dbms_sqlpatch.verify_queryable_inventory FROM dual"] at /soft/oracle/product/12.1.0.2/sqlpatch/sqlpatch.pm line 2547.
PREREQ_STATUS: FAILED
PREREQ_MESG: SQL Patching tool failed to run on the following database targets - orcl.us.oracle.com

 

 

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