My Oracle Support Banner

ORA-65024 Running DBMS_LOGMNR_D.BUILD(OPTIONS=> DBMS_LOGMNR_D.STORE_IN_REDO_LOGS) (Doc ID 2523394.1)

Last updated on MARCH 28, 2019

Applies to:

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

Symptoms

SQL> ALTER SESSION SET CONTAINER=cdb$root;
EXECUTE DBMS_LOGMNR_D.BUILD(OPTIONS=> DBMS_LOGMNR_D.STORE_IN_REDO_LOGS);

Session altered.

SQL> BEGIN DBMS_LOGMNR_D.BUILD(OPTIONS=> DBMS_LOGMNR_D.STORE_IN_REDO_LOGS); END;

*
ERROR at line 1:
ORA-65024: Pluggable database is not open.
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 7750
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 4812
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 4999
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 7601
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 7764
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 7920
ORA-06512: at "SYS.DBMS_LOGMNR_D", line 12
ORA-06512: at line 1

Changes

 SQL> select inst_id, name, open_mode , restricted, open_time from gv$pdbs order by name;

  INST_ID NAME          OPEN_MODE  RESTRICTED  OPEN_TIME
---------- -------------  ----------     --------------- ---------------------------------------------------------------------------
        2   <PDB_NAME> READ ONLY   NO              21-MAR-19 04.56.33.410 PM -04:00
        1   <PDB_NAME> READ ONLY   NO              21-MAR-19 04.56.33.416 PM -04:00
        1   PDB$SEED      READ ONLY  NO              03-MAR-19 03.35.08.473 PM -05:00
        2   PDB$SEED      READ ONLY  NO              03-MAR-19 03.35.07.261 PM -05:00
        2   <PDB_NAME>  READ WRITE NO             08-MAR-19 10.20.57.380 AM -05:00
        1   <PDB_NAME>  READ WRITE NO             08-MAR-19 10.20.57.376 AM -05:00
        2   <PDB_NAME>  READ WRITE NO             03-MAR-19 03.35.08.810 PM -05:00
        1   <PDB_NAME>  READ WRITE NO             03-MAR-19 03.35.10.086 PM -05:00
        2  <PDB_NAME>   READ WRITE NO             03-MAR-19 03.35.08.792 PM -05:00
        1  <PDB_NAME>   READ WRITE NO             03-MAR-19 03.35.10.416 PM -05:00

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.