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

Last updated on APRIL 17, 2023

Applies to:

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

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