Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    14

    Unanswered: Exports fail after 9.2.0.4 patchset

    Hi there,

    I had to apply patchset 9.2.0.4 to our Oracle 9.2.0.1.0 Enterprise Edition in order to solve a bug related to cursors management.

    The problem is that now I can't EXPort anymore. It fails with:

    Export done in US7ASCII character set and AL16UTF16 NCHAR character set
    server uses WE8ISO8859P1 character set (possible charset conversion)
    . exporting pre-schema procedural objects and actions
    . exporting foreign function library names for user SCA
    . exporting PUBLIC type synonyms
    . exporting private type synonyms
    . exporting object type definitions for user SCA
    EXP-00008: ORACLE error 942 encountered
    ORA-00942: table or view does not exist
    EXP-00024: Export views not installed, please notify your DBA
    EXP-00000: Export terminated unsuccessfully


    I searched at Google and found that I had to run catexp.sql. On a test machine, that didn't worked, giving even more errors. So, I ran catpatch.sql. More errors. Now, exports fail with:

    EXP-00056: ORACLE error 604 encountered
    ORA-00604: error occurred at recursive SQL level 1
    ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC_EVENTS
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at line 2
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at line 2


    Does anyone have similar problems? How can I solve this mess? Thanks in advance,

    Arménio Pinto

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    I think I ran catexp.sql or something along those lines.

    Did you run it as SYSDBA?

    When you export, does that user have the EXP_FULL_DATABASE role?

    Did you try running catalog.sql?
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Sep 2004
    Posts
    1

    me too...

    damn,
    i've the same problem, and to try to have the exp working i run the catexp.sql and now seem that all is messed up...

    the strange things is that i've all the data avalaible (i can connect on db and do select to retrieve info...) but also the connection give some strange error..

    if i try to connect via sqlplus i receive this strange errors:
    Enter user-name: java/xxxx@xxxxx
    ERROR:
    ORA-04045: errors during recompilation/revalidation of SYS.DBMS_OUTPUT
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at "LBACSYS.LBAC_EVENTS", line 440
    ORA-06512: at line 2
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at "LBACSYS.LBAC_EVENTS", line 440
    ORA-06512: at line 2


    ERROR:
    ORA-04045: errors during recompilation/revalidation of
    SYS.DBMS_APPLICATION_INFO
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at "LBACSYS.LBAC_EVENTS", line 440
    ORA-06512: at line 2
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at "LBACSYS.LBAC_EVENTS", line 440
    ORA-06512: at line 2


    Error accessing package DBMS_APPLICATION_INFO

    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.4.0 - Production

    SQL>


    ----------------------
    the strange is that i can do select to retrieve datas...




    if i try to run the exp this is the error that i receive:
    User to be exported: (RETURN to quit) > java

    User to be exported: (RETURN to quit) >

    . exporting pre-schema procedural objects and actions
    EXP-00008: ORACLE error 4045 encountered
    ORA-04045: errors during recompilation/revalidation of SYS.DBMS_REFRESH_EXP_SITES
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at "LBACSYS.LBAC_EVENTS", line 440
    ORA-06512: at line 2
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at "LBACSYS.LBAC_EVENTS", line 440
    ORA-06512: at line 2
    EXP-00083: The previous problem occurred when calling SYS.DBMS_REFRESH_EXP_SITES.schema_info_exp
    EXP-00008: ORACLE error 4045 encountered
    ORA-04045: errors during recompilation/revalidation of SYS.DBMS_REFRESH_EXP_LWM
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at "LBACSYS.LBAC_EVENTS", line 440
    ORA-06512: at line 2
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at "LBACSYS.LBAC_EVENTS", line 440
    ORA-06512: at line 2
    EXP-00083: The previous problem occurred when calling SYS.DBMS_REFRESH_EXP_LWM.schema_info_exp
    EXP-00008: ORACLE error 4045 encountered
    ORA-04045: errors during recompilation/revalidation of SYS.DBMS_REPCAT_RGT_EXP
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at "LBACSYS.LBAC_EVENTS", line 440
    ORA-06512: at line 2
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at "LBACSYS.LBAC_EVENTS", line 440
    ORA-06512: at line 2
    EXP-00083: The previous problem occurred when calling SYS.DBMS_REPCAT_RGT_EXP.schema_info_exp
    EXP-00008: ORACLE error 4045 encountered
    ORA-04045: errors during recompilation/revalidation of SYS.DBMS_TRANSFORM_EXIMP
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at "LBACSYS.LBAC_EVENTS", line 440
    ORA-06512: at line 2
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at "LBACSYS.LBAC_EVENTS", line 440
    ORA-06512: at line 2
    EXP-00083: The previous problem occurred when calling SYS.DBMS_TRANSFORM_EXIMP.schema_info_exp
    EXP-00008: ORACLE error 4045 encountered
    ORA-04045: errors during recompilation/revalidation of SYS.LT_EXPORT_PKG
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at "LBACSYS.LBAC_EVENTS", line 440
    ORA-06512: at line 2
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at "LBACSYS.LBAC_EVENTS", line 440
    ORA-06512: at line 2
    EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_PKG.schema_info_exp
    EXP-00008: ORACLE error 4045 encountered
    ORA-04045: errors during recompilation/revalidation of SYS.DBMS_AW_EXP
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at "LBACSYS.LBAC_EVENTS", line 440
    ORA-06512: at line 2
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at "LBACSYS.LBAC_EVENTS", line 440
    ORA-06512: at line 2
    EXP-00083: The previous problem occurred when calling SYS.DBMS_AW_EXP.schema_info_exp
    EXP-00008: ORACLE error 4045 encountered
    ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC_UTL
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at "LBACSYS.LBAC_EVENTS", line 440
    ORA-06512: at line 2
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at "LBACSYS.LBAC_EVENTS", line 440
    ORA-06512: at line 2
    EXP-00083: The previous problem occurred when calling LBACSYS.LBAC_UTL.schema_info_exp
    EXP-00008: ORACLE error 4045 encountered
    ORA-04045: errors during recompilation/revalidation of SYS.DBMS_RULE_EXP_RULES
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at "LBACSYS.LBAC_EVENTS", line 440
    ORA-06512: at line 2
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at "LBACSYS.LBAC_EVENTS", line 440
    ORA-06512: at line 2
    EXP-00083: The previous problem occurred when calling SYS.DBMS_RULE_EXP_RULES.schema_info_exp
    EXP-00008: ORACLE error 4045 encountered
    ORA-04045: errors during recompilation/revalidation of SYS.DBMS_LOGREP_EXP
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at "LBACSYS.LBAC_EVENTS", line 440
    ORA-06512: at line 2
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at "LBACSYS.LBAC_EVENTS", line 440
    ORA-06512: at line 2
    EXP-00083: The previous problem occurred when calling SYS.DBMS_LOGREP_EXP.schema_info_exp
    . exporting foreign function library names for user JAVA
    . exporting PUBLIC type synonyms
    EXP-00008: ORACLE error 4045 encountered
    ORA-04045: errors during recompilation/revalidation of SYS.DBMS_JAVA
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at "LBACSYS.LBAC_EVENTS", line 440
    ORA-06512: at line 2
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at "LBACSYS.LBAC_EVENTS", line 440
    ORA-06512: at line 2
    EXP-00000: Export terminated unsuccessfully


    -----------------------------


    have anyone a hint about what i can try to do ?

  4. #4
    Join Date
    Nov 2002
    Posts
    833
    are you exporting from the a remote client instead on the server itself?
    the charsets missmatch lets me assume this
    then upgrade yours exp/imp utility on the client

Posting Permissions

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