| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Help : ORA-29516
I did find that Note and followed the steps, but I still have the problem=
=2E I
was told by Oracle Support that you can't delete the Java code on 8.1.6.
Oracle Support is looking into the problem, but I still wonder if any one=
else
ran into the same problem.
TIA Yigal
Tom Tyson <tomtysonjr_at_yahoo.com> wrote:
> Yigal
> =
> You should check out MetaLink, found this on the first hit:
> =
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D
> 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
> --------------------
> =
> 1. First, run catexp as sys. Then retry the export. Often times this =
will
> fix the problem and then export will run without error.
> =
> 2. If running catexp as sys does not fix the errors, the problem may b=
e
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:
> =
> 3. It appears that the errors relate to a bad or incomplete installati=
on
of
> JAVAVM, which stands for java virtual machine. This is installed u=
sing
> initjvm.sql. If using this, then verify with our Unix group whethe=
r or
> not the installation of it was successful. =
> =
> The ORA-29516 means that something failed in the JAVAVM when export tri=
ed
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 w=
hen
> Java has not been loaded, in which case the error here might result. T=
o
> verify what is currently in your database please run the following quer=
ies:
> =
> select owner,synonym_name,table_owner,table_name from all_synonyms w=
here =
=
> table_owner =3D 'DLC535' or owner =3D '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 follow=
ing =
> instructions:
> =
> Remove it by deinstalling it as SYS
> - run rmjvm.sql located in your ORACLE_HOME/javavm/install directory=
=2E
> =
> The export should then run successfully.
> =
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D
> Tom Tyson
> =
> =
> --- Yigal Ran <ydran_at_usa.net> wrote:
> > I am receiving ORA-29516 during an Oracle export, did any one encount=
er
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=3D=
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 List=
s
> > --------------------------------------------------------------------
> > 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!?
> Get Yahoo! Mail - Free email you can access from anywhere!
> http://mail.yahoo.com/
> -- =
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- =
> Author: Tom Tyson
> INET: tomtysonjr_at_yahoo.com
> =
> 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).
From: orastaff_at_mindspring.com (OraStaff) Date: Sat, 14 Oct 2000 12:35:04 -0400 (EDT) Subject: * Columbia MD- Oracle PL/SQL and Reports Skills Needed- Learn Java!
Don't miss this opportunity with this company in Columbia, Maryland that
needs a candidate who has Oracle PL/SQL and Reporting experience for a
full time staff position.
This is an Oracle ERP environment and the selected candidate will
work/learn Java too!
No Relocation assistance is provided.
This position offers:
NO sub contracting positions available.
PLEASE do not send your resume if you are not in the United States.
For immediate consideration, please email your resume as an attachment to:
Email: orastaff_at_mindspring.com
Phone: 1-800-549-8502. (Please do not call if you need sponsorship)
Please Use Job Code: Columbia/Dev/B. Wise./Doug
*We pay referral fees.
So please contact us if you know of anyone who would be qualified/interested
Received on Sat Oct 14 2000 - 10:41:19 CDT
 |
 |