Datapatch/QOPatch query fails on PDB reporting ' KUP-04080: Directory Object OPATCH_LOG_DIR Not Found '
(Doc ID 3013879.1)
Last updated on SEPTEMBER 26, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.21.0.0.0 and laterOracle Database Cloud Exadata Service - Version N/A and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version All Versions and later
Information in this document applies to any platform.
Symptoms
Error while executing the query related to qopatch on a PDB in multi-tenant environment with no errors in alert.log or qopatch_log.log
SQL> alter session set container=<PDB_Name>;
Session altered.
SQL> show con_name
CON_NAME
------------------------------
<PDB Name>
SQL> select * from OPATCH_XML_INV;
ERROR:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04080: directory object OPATCH_LOG_DIR not found
or
Execution of datapatch reports below message in Datapatch log :
708:19:37 ----> START container <PDB_NAME>...
08:19:37 INFO: running dbms_sqlpatch.verify_queryable_inventory...
08:19:37 Warning: Verifiaction failed. Please check! <================
08:19:37 ----> END container <PDB_NAME>
08:19:37 < Open PDB$SEED container in read-only >
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 |