URGENT ! Exp ORACLE error 4068 encountered in oracle 9i

[castlerock]

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

[adewri]

run 'catnoqueue.sql' then try.

HTH
Amar

[castlerock]

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

[adewri]

Try this

1. Login into Server Manager as INTERNAL or SYS

2. Enter the following SQL command:
DELETE FROM SYS.EXPACT$ WHERE FUNC_PACKAGE = 'DBMS_AQ_IMPORT_INTERNAL';

After the statement issue a 'commit' so the statement can take effect. Then do the export.

HTH
Amar

[adewri]

or try dropping the queue table

To drop the queue tables, from SQL*Plus issue the following command: execute dbms_aqadm.drop_queue_table('')

SELECT * FROM dba_queue_tables; will give you the list of all que table.

I'm assuming that you dont need those queue tables.

Amar

[castlerock]

Hi Amar,

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

[adewri]

just check if you have any synonym names system ??

select * from dba_synonyms where owner = 'PUBLIC';
an see if there is one named "system".

if its there drop it.

[adewri]

This also can be bug no. 1273218

im just checking it...

[castlerock]

hi Amar,
I have dropped and recreated the database and imported the latest dump taken at around 5.00 in the evening. Now the database is up and running.

Thanks for the the support at the right time.

Thanks & regards,
Ramesh