DBAsupport.com Forums - Powered by vBulletin
Page 1 of 3 123 LastLast
Results 1 to 10 of 26

Thread: EXP-00008: ORACLE error 29516 encountered

  1. #1
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323
    Hi Oracle Guru's

    I am encountering with the following error, when I try to do full export. My Oracle version is 8.1.6.0.0 on Sun OS 5.7

    EXP-00008: ORACLE error 29516 encountered
    ORA-29516: Aurora assertion failure: Assertion failure at eox.c:187
    Uncaught exception Root of all Java exceptions:
    EXP-00000: Export terminated unsuccessfully.

    To resolve this problem, I have done the following :
    1. loaded initjvm.sql
    2. increased SGA
    3. increased rollback segments
    4. lastly i tried with de-install the java using rmjvm.sql

    but still the problem is same.

    Can any one help in this.

    Thanks in advance
    Nagesh
    Nagesh

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Run CATEXP as INTERNAL and try again.

    Did you increase also DB_BLOCK_BUFFERS? What is DB_BLOCK_BUFFERS set to?


  3. #3
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323
    Hi Julian,

    Yes, I ran catexp from internal, and tried, still the error is same. My DB_BLOCK_BUFFERS are 65536.

    Thanks in advance.
    Nagesh
    Nagesh

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Then it is probably not a resource issue, except if you RBSs are small. But you said that you made them bigger.

    It could be that the Java Virtual Machine installation is incomplete.

    Does

    SELECT COUNT(*)
    FROM all_objects
    WHERE object_type LIKE 'JAVA%';

    return something like 8000?

    Check that the synonym DBMS_JAVA and DBMS_JAVA package exist and valid. If the synonym exists without a package run $ORACLE_HOME/javavm/install/initdbj.sql





  5. #5
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323
    Hi Julian,

    Here are the some details for your reference,

    SVRMGR> select object_name,status,object_type
    2> from all_objects
    3> where object_name = 'DBMS_JAVA';
    OBJECT_NAME STATUS OBJECT_TYPE
    ------------------------------ ------- ------------------
    DBMS_JAVA VALID PACKAGE
    DBMS_JAVA VALID PACKAGE BODY
    DBMS_JAVA VALID SYNONYM
    3 rows selected.

    SVRMGR> select count(*) from all_objects
    2> where object_type like 'JAVA%';
    COUNT(*)
    ----------
    8867

    SVRMGR> select tablespace_name,bytes/(1024*1024) "MB"
    2> from dba_data_files
    3> where tablespace_name in('SYSTEM','RBS');

    TABLESPACE_NAME MB
    ------------------------------ ----------
    SYSTEM 225
    RBS 1024

    Then :- started Export

    . about to export HKZONE_IMP's tables via Conventional Path ...
    . . exporting table CARRIER_PLAN 0 rows exported
    . about to export AURORA$ORB$UNAUTHENTICATED's tables via Conventional Path ...
    . exporting referential integrity constraints
    . exporting synonyms
    EXP-00008: ORACLE error 29516 encountered
    ORA-29516: Aurora assertion failure: Assertion failure at eox.c:187
    Uncaught exception Root of all Java exceptions:
    EXP-00000: Export terminated unsuccessfully

    Julian, here i would like to tell you one of my observations during the initplsj.sql run is, that :

    SVRMGR> connect internal
    Connected.
    SVRMGR> select name from v$database;
    NAME
    ---------
    ORACLE
    1 row selected.
    SVRMGR> @initplsj
    Server Output ON
    ORA-29516: Aurora assertion failure: Assertion failure at eox.c:187
    Uncaught exception Root of all Java exceptions:
    ORA-29516: Aurora assertion failure: Assertion failure at eox.c:187
    Uncaught exception Root of all Java exceptions:
    SVRMGR>

    Is the export error due to the above?

    I hope I had given clear picture now.

    Thanks & Regards
    Nagesh
    Nagesh

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    SVRMGR> @initplsj
    Server Output ON
    ORA-29516: Aurora assertion failure: Assertion failure at eox.c:187
    Uncaught exception Root of all Java exceptions:
    ORA-29516: Aurora assertion failure: Assertion failure at eox.c:187
    Uncaught exception Root of all Java exceptions:
    SVRMGR>

    Is the export error due to the above?

    I hope I had given clear picture now.

    Thanks & Regards
    Nagesh
    Yes, the exp error is due to the failure of INITPLSJ.

    Now, make sure the lib64 directory is in your LD_LIBRARY_PATH
    and check that your CLASSPATH is set correctly.



  7. #7
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323
    Hi Julian,

    Here is my environment varibles. Please let me know which of these variables creating problem.

    ORACLE_BASE=/usr/oracle
    export ORACLE_BASE
    ORACLE_HOME=$ORACLE_BASE/product/8.1.6
    export ORACLE_HOME
    LD_LIBRARY_PATH=$ORACLE_HOME/lib
    export LD_LIBRARY_PATH
    #CLASSPATH=$ORACLE_BASE/oracle/jre
    CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/product/jlib
    export CLASSPATH

    ORACLE_SID=zoneprod
    export ORACLE_SID
    PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/local/bin:/etc:/usr/ccs/bin:/usr/openwi
    n/bin:/usr/dt/bin:/usr/ucb
    export PATH

    Thanks & Regards
    Nagesh
    Nagesh

  8. #8
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Is the lib64 directory under $ORACLE_HOME/lib?

    If not, this could be the problem.



  9. #9
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323
    Hi Julian,

    Yes lib64 is there. But not under $ORACLE_HOME/lib, it is under $ORACLE_HOME. Is it Okay?



    Nagesh

  10. #10
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by gnagesh
    Hi Julian,

    Yes lib64 is there. But not under $ORACLE_HOME/lib, it is under $ORACLE_HOME. Is it Okay?

    No. lib64 should be under $ORACLE_HOME/lib. I think that might be the problem.


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