Why I got “ORA-29547: Java system class not available: oracle/aurora/rdbms/Compiler”?
Question: The README file said to use the loadjava to upload xmlparserv2.jar and plsql.jar in order. When I tried to load xmlparserv2.jar using the following command loadjava -user test/test -r -v xmlparserv2.jar to upload the jar file into an 8i database. After much of the uploading, I got the following error messages: identical: oracle/xml/parser/v2/XMLConstants is unchanged from previously loaded file identical: org/xml/sax/Locator is unchanged from previously loaded file loading : META-INF/MANIFEST.MF creating : META-INF/MANIFEST.MF Error while creating resource META-INF/MANIFEST.MF ORA-29547: Java system class not available: oracle/aurora/rdbms/Compiler Answer: The JServer option is not properly installed if you’re getting errors like this during loadjava. You need to run INITJVM.SQL and INITDBJ.SQL to get the JavaVM properly installed. Usually these are in the ./javavm subdirectory of your Oracle Home.