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 220.127.116.11.0 to 18.104.22.168.0 [Release 12.1]
Information in this document applies to any platform.
Analyzing a Patch Plan (for instance, patch 21359755) for a target 22.214.171.124 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/126.96.36.199/sqlpatch/sqlpatch.pm line 2547.
PREREQ_MESG: SQL Patching tool failed to run on the following database targets - orcl.us.oracle.com
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