Solved

ORA-29516 during JAVA installtion

Posted on 2001-08-28
9
1,226 Views
Last Modified: 2013-12-12
When I run initjvm.sql on Oracle 8.1.7 under windows2000

there is some errors like:

create or replace java system;
*
ORA-29516: Aurora assertion failure: Assertion failure at eox.c:217
Uncaught exception Root of all Java exceptions: X0

ORA-06550: line 6, column 21:
PLS-00201: identifier 'DBA_JAVA_POLICY' must be declared
ORA-06550: line 6, column 5:
PL/SQL: SQL Statement ignored
ORA-06550: line 6, column 12:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 11, column 5:
PL/SQL: SQL Statement ignored
0
Comment
Question by:albosily
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
9 Comments
 
LVL 2

Expert Comment

by:banicki
ID: 6433597
Looks like a common problem
From Metalink Note 114350.1
 Problem:
  ========
  On a 64-bit installation of Oracle Enterprise edition, running the
  "Hello World" demo or a DBMS_JAVA package generates an error.

  Example:
  --------
    SQL> select sys.dbms_java.longname('foo') from dual;
    ORA-29516: Aurora assertion failure: Assertion failure at eox.c:187
    Uncaught exception Root of all Java exceptions:


  Solution:
  =========
  1. Verify the correct installation per [NOTE:103855.1].
  2. Verify the classpath:
     $ORACLE_HOME/jlib:$ORACLE_HOME/lib:$ORACLE_HOME/javavm/lib:$ORACLE_HOME/jdb
     c/lib:$ORACLE_HOME/sqlj/lib:$ORACLE_HOME/classes:/u04/jre/1.1.8/lib:/usr/
     java/lib:.

  3. Verify that the java function was successfully created in VALID status
     and the call spec was also created successfully.  Refer to the Oracle8i
     Java Stored Procedures Developer's Guide, Release 2 (8.1.6): Developing
     Stored Procedures: An Overview (Chapter 1).

  4. If you still get the error, then it may be that the problem is a failure
     to access the shared library libcorejava.so.
     1) Test for the correct version of libcorejava.so:
           $ cd $ORACLE_HOME/lib
        $ mv libcorejava.so libcorejava.so.old
        $ ln -s $ORACLE_HOME/lib64/libcorejava.so $ORACLE_HOME/lib/libcorejava.so
     2) Then try:
        SQL> select sys.dbms_java.longname('foo') from dual;
     3) If this works then REINSTALL JSever (rmjvm.sql then initjvm.sql).
     4) Ensure that $ORACLE_HOME/lib64 is in the LD_LIBRARY_PATH.
   
  Explanation:
  ============
  The problem was that the LD_LIBRARY_PATH did not contain $ORACLE_HOME/lib64
  during the installation.  This is documented in the Oracle 8.1.6 64-bit
  release notes but not in the installation guide.  Without $ORACLE_HOME/lib64,
  JServer installs using the 32-bit libcorejava.so.

  Note:  Please do not move 64-bit libraries into lib.  Lib should
         contain only 32-bit libs.  Lib64 should contain only 64-bit
         libraries.  If this is your problem, then you MUST reinstall
         with the correct LD_LIBRARY_PATH.
Problem:
  ========
  On a 64-bit installation of Oracle Enterprise edition, running the
  "Hello World" demo or a DBMS_JAVA package generates an error.
  Example:
  --------
    SQL> select sys.dbms_java.longname('foo') from dual;
    ORA-29516: Aurora assertion failure: Assertion failure at eox.c:187
    Uncaught exception Root of all Java exceptions:

  Solution:
  =========
  1. Verify the correct installation per [NOTE:103855.1].
  2. Verify the classpath:
     $ORACLE_HOME/jlib:$ORACLE_HOME/lib:$ORACLE_HOME/javavm/lib:$ORACLE_HOME/jdb
     c/lib:$ORACLE_HOME/sqlj/lib:$ORACLE_HOME/classes:/u04/jre/1.1.8/lib:/usr/
     java/lib:.
  3. Verify that the java function was successfully created in VALID status
     and the call spec was also created successfully.  Refer to the Oracle8i
     Java Stored Procedures Developer's Guide, Release 2 (8.1.6): Developing
     Stored Procedures: An Overview (Chapter 1).
  4. If you still get the error, then it may be that the problem is a failure
     to access the shared library libcorejava.so.
     1) Test for the correct version of libcorejava.so:
        $ cd $ORACLE_HOME/lib
        $ mv libcorejava.so libcorejava.so.old
        $ ln -s $ORACLE_HOME/lib64/libcorejava.so $ORACLE_HOME/lib/libcorejava.so
     2) Then try:
        SQL> select sys.dbms_java.longname('foo') from dual;
     3) If this works then REINSTALL JSever (rmjvm.sql then initjvm.sql).
     4) Ensure that $ORACLE_HOME/lib64 is in the LD_LIBRARY_PATH.

  Explanation:
  ============
  The problem was that the LD_LIBRARY_PATH did not contain $ORACLE_HOME/lib64
  during the installation.  This is documented in the Oracle 8.1.6 64-bit
  release notes but not in the installation guide.  Without $ORACLE_HOME/lib64,
  JServer installs using the 32-bit libcorejava.so.
  Note:  Please do not move 64-bit libraries into lib.  Lib should
         contain only 32-bit libs.  Lib64 should contain only 64-bit
         libraries.  If this is your problem, then you MUST reinstall
         with the correct LD_LIBRARY_PATH.
0
 
LVL 2

Expert Comment

by:banicki
ID: 6433644
Looks like this is a generic problem across platforms.
Here is another hit that is closer to your problem, same solution, less detail.
Once again, from metalink

RDBMS Version: 8.1.7.0
  Operating System and Version: AIX 4.3.3
  Error Number (if applicable): ORA-29516: Aurora assertion failure: Assertion failure at eox.c:217
  Product (i.e. SQL*Loader, Import, etc.): During Running initjvm.sql
  Product Version:

  Oracle JServer Instllation - initjvm.sql

  create or replace java system;
  *
  ORA-29516: Aurora assertion failure: Assertion failure at eox.c:217
  Uncaught exception Root of all Java exceptions: ^D

  Can any one provide support ?


  From: Oracle, Narayanan Jayapalan 29-Dec-00 07:15
  Subject: Re : Oracle JServer Instllation - initjvm.sql

  Hi,

  1. Check if LD_LIBRARY_PATH is properly set.
  This problem may arise if it failed to load $ORACLE_HOME/lib/libcorejava.so

  2. Try increasing your system tablespace and shared_pool_size and retry the operation.
0
 
LVL 3

Expert Comment

by:Wadhwa
ID: 6433709
Hi albosily,

It looks to me this is  a memory related problem

Check the following wheather your system metts the following requirment or not. If it is not set the following parameter in init parameter file and run the initjvm.sql again.

SYSTEM Requirements (These numbers are recommendations)
? SHARED_POOL_SIZE > = 65M
? JAVA_POOL_SIZE >= 50M
? 50M free in the SYSTEM tablespace
? 250M of rollback segment space


Hope this will solve your problem

Sam..
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:albosily
ID: 6435316
Thanks all

How I can set LD_LIBRARY_PATH in Windows 2000

My system meet the the requirements:
SHARED_POOL_SIZE = 122M
JAVA_POOL_SIZE > 50M
>50M free in the SYSTEM tablespace
>250M of rollback segment space


0
 
LVL 3

Expert Comment

by:Wadhwa
ID: 6437804
There is no LD_LIBRARY_PATH on windows 2000.
Check the classpath again as commented before.

The two main reason for this error is the CLASSPATH settings not properly configured and the other is memeory.

You memory is OK but i am doubtful about the classpath setting.
0
 
LVL 3

Expert Comment

by:Wadhwa
ID: 6437824
After all verifications have passed then run the rmjvm.sql
    ($ORACLE_HOME/javavm/install/) script to create a clean JVM environment.  
     

 Finally run the script initjvm.sql ($ORACLE_HOME/javavm/install/) to
    install the Jserver into Oracle8i.
    Spool the output from the script to a log file for later error checking.

0
 

Author Comment

by:albosily
ID: 6466516
I run the rmjvm.sql and then run initjvm.sql but the same problems
0
 
LVL 1

Expert Comment

by:Moondancer
ID: 7034741
Please update and finalize this old, open question.  Please:

1) Award points ... if you need Moderator assistance to split points, comment here with details please or advise us in Community Support with a zero point question and this question link.
2) Ask us to delete it if it has no value to you or others
3) Ask for a refund so that we can move it to our PAQ at zero points if it did not help you but may help others.

EXPERT INPUT WITH CLOSING RECOMMENDATIONS IS APPRECIATED IF ASKER DOES NOT RESPOND.

Thanks,
Moondancer - EE Moderator

P.S.  Please click your Member Profile, expand View Question History to navigate and update all your open and locked questions.
0
 
LVL 1

Accepted Solution

by:
Moondancer earned 0 total points
ID: 7057469
Zero response, thus finalized.
100 points refunded, item closed.
Moondancer - EE Moderator
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question