How to fix the Oracle error QSM-00519: Summary Advisor is not installed. Please execute INITQSMA.SQL.?

In this post, you’ll learn more about the Oracle ErrorQSM-00519: Summary Advisor is not installed. Please execute INITQSMA.SQL. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

QSM-00519: Summary Advisor is not installed. Please execute INITQSMA.SQL.

Reason for the Error QSM-00519: Summary Advisor is not installed. Please execute INITQSMA.SQL.

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

How to fix the Error QSM-00519: Summary Advisor is not installed. Please execute INITQSMA.SQL. ?

You can fix this error in Oracle by following the below steps

Log into the database with SYSDBA privileges. Execute the INITQSMA.SQL script found in the ADMIN directory under the ORACLE home. **** **** Messages 520-700 are in the 9i Summary Advisor Java modules 701-708 are Hypothetical Workload generator journal messages