Home > java, oracle > Java and Oracle: ORA-29547: Java system class not available: oracle/aurora/rdbms/Compiler

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

I’m trying to create a Java procedure in Oracle 9.2.0.8 and I’m getting this error:

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

This is because JServer has not been loaded. To load it, run this script as SYS:

SYS@prod1> @?/javavm/install/initjvm

And now you can check that is loaded:

SYSTEM@prod1> select comp_id, status from dba_registry;
COMP_ID             STATUS
------------------- ------
CATALOG             VALID
CATPROC             VALID
OWM                 VALID
JAVAVM              VALID

Troubleshooting

If you get this error installing JServer:

[...]
DOC>#######################################################################
DOC>#######################################################################
DOC>  If the following	rmjvm.check_for_rmjvm()  statement results in
DOC>  ORA-00028 it means that the database has not been restarted
DOC>  since the rmjvm script was run.  If so, restart the database and
DOC>  retry this script.
DOC>#######################################################################
DOC>#######################################################################
DOC>*/
call rmjvm.check_for_rmjvm()
     *
ERROR at line 1:
ORA-00028: your session has been killed
ORA-06512: at "SYS.RMJVM", line 447

Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production</pre>

Just follow this steps:

  • Restart DB
  • Remove JVM (executing the rmjvm.sql script)
  • Restart DB
  • Install JVM again
Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: