Improve company productivity with a Business Account.Sign Up

x
?
Solved

ORA-29516 during JAVA installtion

Posted on 2001-08-28
9
Medium Priority
?
1,330 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
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This article will show a step by step guide on how to mask column values in Oracle 12c using DBMS_REDACT full redaction option. This option is available on licensed Oracle Enterprise edition as part of Oracle's Advanced Security.
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.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

606 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