EXP-00008: ORACLE error 29516 encountered

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

Run CATEXP as INTERNAL and try again.

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

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

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

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

Quote:

---

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.

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

Is the lib64 directory under $ORACLE_HOME/lib?

If not, this could be the problem.

Hi Julian,

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

Quote:

---

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.