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
Last updated on JULY 24, 2017
Applies to:Enterprise Manager for Oracle Database - Version 184.108.40.206.0 to 220.127.116.11.0 [Release 12.1]
Information in this document applies to any platform.
Analyzing a Patch Plan (for instance, patch 21359755) for a target 18.104.22.168 database in Enterprise Manager (EM) 12c Cloud Control fails with the following console error:
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/22.214.171.124/sqlpatch/sqlpatch.pm line 2547.
PREREQ_MESG: SQL Patching tool failed to run on the following database targets - orcl.us.oracle.com
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