DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: URGENT ! Exp ORACLE error 4068 encountered in oracle 9i

  1. #1
    Join Date
    Jan 2003
    Posts
    141

    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

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    run 'catnoqueue.sql' then try.

    HTH
    Amar
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Jan 2003
    Posts
    141

    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

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  5. #5
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  6. #6
    Join Date
    Jan 2003
    Posts
    141
    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

  7. #7
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  8. #8
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    This also can be bug no. 1273218

    im just checking it...
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  9. #9
    Join Date
    Jan 2003
    Posts
    141
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width