Yigal
You should check out MetaLink, found this on the first hit:
Problem Description
When performing an export on version on Oracle database version 8i, the
following errors are returned after exporting the 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
Solution Description
- First, run catexp as sys. Then retry the export. Often times this will
fix the problem and then export will run without error.
- If running catexp as sys does not fix the errors, the problem may be one
of hitting a resource issue for the export, try increasing the
db_block_buffers and size of your rollback segments. Then try the export
if it is still fails, try the following:
- It appears that the errors relate to a bad or incomplete installation of
JAVAVM, which stands for java virtual machine. This is installed using
initjvm.sql. If using this, then verify with our Unix group whether or
not the installation of it was successful.
The ORA-29516 means that something failed in the JAVAVM when export tried to
call into it, probably to attempt to translate a synonym from short to long
form. It may be that there are cases where export decides to do this when
Java has not been loaded, in which case the error here might result. To
verify what is currently in your database please run the following queries:
select owner,synonym_name,table_owner,table_name from all_synonyms where
table_owner = 'DLC535' or owner = 'DLC535';
select count(*) from all_objects where object_type like 'JAVA%'
If the jvm was installed you should find about 8000 objects
If you do not intend on using this please deinstall it using the following
instructions:
Remove it by deinstalling it as SYS
- run rmjvm.sql located in your ORACLE_HOME/javavm/install directory.
The export should then run successfully.
Tom Tyson
- Yigal Ran <ydran_at_usa.net> wrote:
> I am receiving ORA-29516 during an Oracle export, did any one encounter that
> problem, and has a solution.
>
>
> 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
>
>
> TIA
>
> Yigal
>
>
>
> ____________________________________________________________________
> Get free email and a permanent address at http://www.amexmail.com/?A=1
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Yigal Ran
> INET: ydran_at_usa.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Do You Yahoo!?
Received on Fri Oct 13 2000 - 12:33:19 CDT
