Oracle Error QSM-00518: Java is not enabled. Please execute INITJVM.SQL and INITQSMA.SQL

Oracle Error Message

QSM-00518: Java is not enabled. Please execute INITJVM.SQL and INITQSMA.SQL

Reason for the Error

The current database has has not be created or upgraded to support Java stored procedures. Summary Advisor requires Java stored procedures.

Solution

Log into the database with SYSDBA privileges. Execute the INITJVM.SQL script which is found in the ORACLE home directory under JAVAVM. Next, execute the INITQSMA.SQL script found in the ADMIN directory under the ORACLE home.