|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
Java and Oracle
The Oracle JServer Option is a Java Virtual Machine that can be embedded into the Oracle Server. If it is installed, it allows to write Java stored procedures.
ORA-29547: Java system class not available: oracle/aurora/rdbms/Compiler
This error indicates that JServer has not been loaded. This can be made up leeway through executing the script initjvm.sql in SQL*PLUS:
dba_registry shows if the Java VM is installed:
SQL> select comp_id from dba_registry ; COMP_ID ------------------------------ CATALOG CATPROC XDB JAVAVM
This installation must be performed as SYS.
When initjvm is called, the init parameter shared_pool_size must apparantly be set to at least 24M.