-
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
-
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
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
Nagesh
-
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
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?
Nagesh
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|