URGENT ! Exp ORACLE error 4068 encountered in oracle 9i

Printable View

01-09-2003, 06:52 AM
castlerock

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
01-09-2003, 07:48 AM
adewri

run 'catnoqueue.sql' then try.

HTH
Amar
01-09-2003, 08:08 AM
castlerock

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
01-09-2003, 08:12 AM
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
01-09-2003, 08:14 AM
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
01-09-2003, 09:12 AM
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
01-09-2003, 09:27 AM
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.
01-09-2003, 09:28 AM
adewri

This also can be bug no. 1273218

im just checking it...
01-09-2003, 11:33 AM
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