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
Thanks,
Ramesh
EXP error 04068 error in oracle 9i hel needed
hi ,
Thanks for the reply,When i run the catnoque.sql ..i got some errors.
drop type sys.aq$_recipients
*
ERROR at line 1:
ORA-02303: cannot drop or replace a type with type or table dependents
Type dropped.
Type dropped.
drop type sys.aq$_agent
*
ERROR at line 1:
ORA-02303: cannot drop or replace a type with type or table dependents
Type dropped.
drop SEQUENCE system.aq$_qidseq
*
ERROR at line 1:
ORA-02289: sequence does not exist
****************************
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
Regards,
Ramesh