My Oracle Support Banner

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 later
Oracle 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

connect to PDB

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.