Skip to Main Content
  • Questions

  • ORA-29547 Java system class not available: oracle/aurora/rdbms/Compiler

Breadcrumb

Question and Answer

Tom Kyte

Thanks for the question, Omar.

Asked: October 26, 2000 - 3:59 am UTC

Last updated: September 21, 2004 - 11:12 am UTC

Version: 8.1.5

Viewed 10K+ times! This question is

You Asked

Hi Tom,
I tried to use your code

CREATE or replace JAVA SOURCE
NAMED "MyTimestamp"
AS
import java.lang.String;
import java.sql.Timestamp;
public class MyTimestamp
{
public static String getTimestamp()
{
return (new
Timestamp(System.currentTimeMill is())). toString();
}
};
/

but the following error occured
ORA-29547 Java system class not available:
oracle/aurora/rdbms/Compiler

I know that it is because java system not loaded yet but I would
like to know which script will do so and the its location.
I am using Oracle8i 8.1.5 on True64 Unix

thanks in advance

and Tom said...


Perform the manual installation of JServer by running the following:

$ORACLE_HOME/javavm/install/initjvm.sql

Initjvm.sql must be run by the SYS user using svmrgrl


Rating

  (7 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

A reader, April 02, 2002 - 1:21 pm UTC


Error ORA-29541

Subhro, September 05, 2002 - 5:33 am UTC

Tom,
When I run initjvm.sql, I get this error repeatedly.
ORA-29541: class SYS.oracle/aurora/rdbms/security/PolicyTableManager could not be resolved

What could be the reason...
Thanks

Tom Kyte
September 05, 2002 - 7:48 am UTC

don't know - you haven't given me much information. (oh like, did you run it as sys, what version are you using, did you have a bad java install that you need to remove first with rmjvm, etc)

Please contact support and open a TAR.

I did as u said

Subhro, September 05, 2002 - 8:33 am UTC

Well, Tom,
The Oracle Version is 8.1.7. I did run the script as Sys and thru svrmgrl. This time, I did run rmjvm.sql and then ran the initjvm again. But still the same problem arrives.

I have set
java_pool_size = 70000000.

I guess I will have to raise a TAR.

Thanks anyway for the help...



Tianhua Wu, September 05, 2002 - 9:28 am UTC

for 8.1.6 and 8.1.7, you also need to run several more scripts besides initjvm.sql, check metalink for detail.

Didn't work...

Rahul, January 21, 2003 - 6:59 am UTC

Hi Tom

I am getting the same problem
ORA-29547: Java system class not available: oracle/aurora/rdbms/Compiler

and tried the solution which you gave to Omar, but it didn't workout to me. I have run the script INITJVM.SQL manually script by script and got the problem when I ran INIT_SECURITY.SQL, it gave me same problem
ORA-29540: class oracle/aurora/rdbms/security/PolicyTableManager does not exist

Now tell me what should I do ?
I am unable to complete the initjvm.sql to install the JVM in oracle.

Please response.

Thanks.

Tom Kyte
January 21, 2003 - 10:02 am UTC

use rmjvm to get it backed out of there and try again.

contact support if the problem persists. given I don't know your version, os, etc -- i cannot really help (don't put it here, use support -- this is what they are really good at -- install, configuration, help "my database is down")

Ora-29547

Mahomed, June 23, 2004 - 12:50 pm UTC

Hi Tom,
I have had ORA-29547 when using java class Timestamp.
I have run $ORACLE_HOME/javavm/install/initjvm.sql and got the following error :

ORA-04043 object java/lang/Clonable does not exist
followed by Ora - 600

I have run initjvm.sql as user SYS from svrmgrl and I have tried running rmjvm.sql first, but no joy!.

My platform is Oracle v 8.1.7.4 on Tru64 Unix.

Any help would be appreciated.

Thanks.

Tom Kyte
June 23, 2004 - 1:23 pm UTC

please contact support for that, I've not seen that myself.

could not find $ORACLE_HOME/javavm/install/initjvm.sql

Mohamed Mustafa Z, September 21, 2004 - 10:37 am UTC

I have installed XSU and XDK.I have oracle client Release 1 (9.0.1.1.1) for Windows Platforms. I am trying to use load java.
And hit this error:
Error while creating resource META-INF/MANIFEST.MF
ORA-29547: Java system class not available: oracle/aurora/rdbms/Compiler

trying to solve it by running what is in this question but i dont could not find $ORACLE_HOME/javavm/install/initjvm.sql

Tom Kyte
September 21, 2004 - 11:12 am UTC



on your server, do you have a javavm\install directory under your %ORACLE_HOME% directory or not

you say windows but are using unix terminology

more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library