If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

URGENT ! Exp ORACLE error 4068 encountered in oracle 9i

hi,
When taking full export dump i got the following error.Can anyone tell me how to solve the problem.

. exporting posttables actions
EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: has errors
ORA-04063: package body "SYS.DBMS_AQADM_SYS" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_AQ_IMPORT_INTERNAL", line 85
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1120
ORA-06512: at "SYS.DBMS_SQL", line 316
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 86
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 137
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully

Then i tried to export now i got the error in package (SYS.DBMS_SYS_SQL)
The first time export i got the following error:

. exporting posttables actions
EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: has errors
ORA-04063: package body "SYS.DBMS_AQADM_SYS" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_AQ_IMPORT_INTERNAL", line 85
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1120
ORA-06512: at "SYS.DBMS_SQL", line 316
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 86
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 137
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully
****************************
After running the catnoque.sql and now i tried to take an exp dmp it showed the following error.

. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: has errors
ORA-04063: package body "SYS.DBMS_AQ_IMPORT_INTERNAL" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1120
ORA-06512: at "SYS.DBMS_SQL", line 316
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 86
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 137
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully

Still the problem exists. After deleting from the sys.expact$ table now it is giving more no. of error like,

ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_AQ_SYS_EXP_INTERNAL" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_AQ_EXP_QUEUES", line 49
ORA-06512: at line 1
EXP-00085: The previous problem occurred when calling SYS.DBMS_AQ_EXP_QUEUES
ate_exp for object 31360
EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_AQ_SYS_EXP_INTERNAL" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_AQ_EXP_QUEUES", line 49
ORA-06512: at line 1
EXP-00085: The previous problem occurred when calling SYS.DBMS_AQ_EXP_QUEUES
ate_exp for object 31379
EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_AQ_SYS_EXP_INTERNAL" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_AQ_EXP_QUEUES", line 49
ORA-06512: at line 1
EXP-00085: The previous problem occurred when calling SYS.DBMS_AQ_EXP_QUEUES
ate_exp for object 31377
EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_AQ_SYS_EXP_INTERNAL" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_AQ_EXP_QUEUES", line 49
ORA-06512: at line 1
EXP-00085: The previous problem occurred when calling SYS.DBMS_AQ_EXP_QUEUES
ate_exp for object 31380