ORA-65024 Running DBMS_LOGMNR_D.BUILD(OPTIONS=> DBMS_LOGMNR_D.STORE_IN_REDO_LOGS)
(Doc ID 2523394.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation 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 |