My Oracle Support Banner

DBMS_LOGMNR_D failed with ORA-20042: PDB <PDB NAME> not found, PDB name in lower case. (Doc ID 2770334.1)

Last updated on MAY 02, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 19.5.0.0.0 and later
Information in this document applies to any platform.

Symptoms

After applying patch 28698087 and setting below parameters in EBS database , below errors reported when PDB name was in lower case

_pdb_name_case_sensitive=TRUE
.sec_case_sensitive_logon=TRUE

SQL> BEGIN DBMS_LOGMNR_D.BUILD(OPTIONS=> DBMS_LOGMNR_D.STORE_IN_REDO_LOGS);END;
2 /
BEGIN DBMS_LOGMNR_D.BUILD(OPTIONS=> DBMS_LOGMNR_D.STORE_IN_REDO_LOGS);END;
*
ERROR at line 1:
ORA-20042: PDB EBSDBA not found.
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 8132
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 5190
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 5381
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 7983
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 8146
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 8302
ORA-06512: at "SYS.DBMS_LOGMNR_D", line 61
ORA-06512: at line 1

Changes

 Patch 28698087 was applied and PDB name was in lower case.

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
Changes
Cause
Solution
References


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