Solved

ORA-29516 during JAVA installtion

Posted on 2001-08-28
9
1,159 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
  • 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
 

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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

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.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

746 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now