Answer / johnpaul

After successfully creating the dictionary to a flat file,
when attempting to start the Logminer utility, it fails
with errors:

ERROR at line 1:
ORA-01294: error occurred while processing information in
dictionary file , possible corruption
ORA-06512: at "SYS.DBMS_LOGMNR", line 53
ORA-06512: at line 1


Cause
The ATTRIBUTE$_TABLE is not being created in the dictionary
file


If the dictionary file is opened, we can see the syntax to
insert into the ATTRIBUTE$_TABLE table:

INSERT_INTO ATTRIBUTE$_TABLE VALUES
(00000000000000000000000000000003,1,'KOTADKVN',1,00000000000
000000000000000000013,1,,2,,,,,,'',0,,,,,,,);

However, the syntax to create the table should be prior to
the insert statement and it is missing. It should contain
the following:

CREATE_TABLE ATTRIBUTE$_TABLE (TOID RAW(16), VERSION# NUMBER
(22), NAME VARCHAR2(30), ATTRIBUTE# NUMBER(22), ATTR_TOID
RAW(16), ATTR_VERSION# NUMBER(22), SYNOBJ# NUMBER(22),
PROPERTIES NUMBER(22), CHARSETID NUMBER(22), CHARSETFORM
NUMBER(22), LENGTH NUMBER(22), PRECISION# NUMBER(22), SCALE
NUMBER(22), EXTERNNAME VARCHAR2(4000), XFLAGS NUMBER(22),
SPARE1 NUMBER(22), SPARE2 NUMBER(22), SPARE3 NUMBER(22),
SPARE4 NUMBER(22), SPARE5 NUMBER(22), SETTER NUMBER(22),
GETTER NUMBER(22) );



Solution
1. Use the online catalog

Example:
SQL> EXECUTE DBMS_LOGMNR.START_LOGMNR(OPTIONS =>
DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);

Answer / guest

Cause: The dictionary file is corrupt.

Action: Get a new dictionary file.

Please add more information about this Error

RMAN-06204: Changed string objects to UNAVAILABLE status

1 Answers  

---

ORA-13009: the specified date string is invalid

1 Answers  

---

ORA-07512: sscggtl: $enq unexpected return for client termination lock

1 Answers  

---

ORA-00205: error in identifying controlfile, check alert log for more info

2 Answers   TechValley,

---

ORA-23366: integer value string is less than 1

1 Answers  

---

ORA-00332: archived log is too small - may be incompletely archived

1 Answers  

---

PLS-00659: constructor method must return SELF AS RESULT

1 Answers  

---

ORA-08412: error encountered in WMSGBSIZ, size for WMSGBLK is not big enough for warning message

1 Answers  

---

ORA-25303: Buffered operation allowed only on the owner instance

1 Answers  

---

TNS-00509: Buffer overflow

1 Answers  

---

RMAN-06056: could not access datafile number

1 Answers  

---

PLS-00629: PIPE statement cannot be used in non-pipelined functions

1 Answers  

---