Re: DBMS_LOGMNR_LOGREP_DICT error during full export

When faced with system objects that are strangely missing or invalid, I usually run catproc.sql.
In fact, I have found it necessary in every case where a 9.2.0.5<http://9.2.0.5> database on Win2k has had the April 2005 CPU applied.

All patches have had to be backed out of the database, run catproc.sql, apply the CPU.

catproc.sql is not a panacea, but it does often fix internal inconsistencies in the database.

Jared

On 6/6/05, Lou Avrami <avramil_at_concentric.net> wrote:
>
> Hi all,
>
> I help administer a 9.2.0.5 <http://9.2.0.5> database which is exported
> each night. The ful=
> l
> export process always receives the error below, related to
> SYS.DBMS_LOGMNR_LOGREP_DICT.system_info_exp.
>
> Oracle Support suggest rerunning $ORACLE_HOME/rdbms/admin/dbmslmd.sql.
> Tha=
> t
> didn't seem to help.
>
> this database was upgraded from 8i to 9i. I'm told that is when the
> proble=
> m
> first occurred.
>
> Has anyone else encountered this problem? Can anyone suggest a solution? =
> =20
> It's not a critical issue - the export seems to finish ok otherwise, we
> don't manifest this error at any other point. I'm handing this database
> of=
> f
> to another group soon, so I'd like to clean this up, if possible.
>
> Thanks,
> Lou Avrami
>
> ....
> ....
> . exporting PUBLIC type synonyms
> . exporting private type synonyms
> . exporting object type definitions
> . exporting system procedural objects and actions
> EXP-00008: ORACLE error 942 encountered
> ORA-00942: table or view does not exist
> ORA-06512: at "SYS.DBMS_LOGMNR_LOGREP_DICT", line 994
> ORA-06512: at line 1
> EXP-00083: The previous problem occurred when calling =
> =20
> SYS.DBMS_LOGMNR_LOGREP_DICT.system_info_exp
> . exporting pre-schema procedural objects and actions
> . exporting cluster definitions
> . about to export SYSTEM's tables via Direct Path ...
> . . exporting table AQ$_INTERNET_AGENTS 0 rows exported
> . . exporting table AQ$_INTERNET_AGENT_PRIVS 0 rows exported
> Table DEF$_AQCALL will be exported in conventional path.
> ...
> ...
>
>
> =20
>
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l