I neeed major help, sys package missing while exp 1

[sillyVM]

EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_REPCAT_RGT_EXP" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_REPCAT_RGT_EXP"
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_REPCAT_RGT_EXP.schema_info_exp
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_REFRESH_EXP_LWM" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_REFRESH_EXP_LWM"
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_REFRESH_EXP_LWM.schema_info_exp
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_REPCAT_UTL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_REPCAT_UTL"
ORA-06512: at "SYS.DBMS_REPCAT_EXP", line 87
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_REPCAT_EXP.schema_info_exp
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_LOGREP_UTIL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGREP_UTIL"
ORA-06512: at "SYS.DBMS_LOGREP_EXP", line 2700
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_LOGREP_EXP.schema_info_exp

That's what's showing during my exp of one of the user. Some packages in sys is missing, any idea I can recreate them? Thanks, this is urgent. I am scrambling for ideas.

 

[SantaMufasa]

Is this a newly installed/upgraded Oracle instance?

Have you ensured that you have run the Oracle Data Dictionary scripts, including CATEXP.sql, which is typically the source of the missing components that the error message mentions? (The script list that you must ensure you have run includes: catalog.sql, catproc.sql, catblock.sql, catexp.sql, et cetera.) Re-running these scripts does no damage to your instance.

Also, you may have these components, but there are pieces that (for whatever reason) are "INVALID". Anything that is INVALID, you can re-compile to either validate or to identify the erroring components.

These suggestions are places to begin your troubleshooting.

Let us know your findings.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[sillyVM]

I dropped some package in system by mistake.
I ran CATEXP.sql,
and ran catalog.sql
and running catproc.sql right now
have not ran catblock.sql

What else do I have to run, the etc ones? Thanks for pointing to the right direction.

 

[sillyVM]

ORA-00932: inconsistent datatypes: expected BLOB, CLOB got CHAR

Now it says this, when I try to export.

 

[SantaMufasa]

Silly,

Click on this link, which explains both the problem and (in excellent detail) the solution.

Let us know if this solves it for you.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[sillyVM]

whew worked..
I didn't restart the database as they said.
Just ran catqm.sql and now i can export again.
Thanks Mufa!

(I was almost getting rdy to type my next resume, and you saved my life.)