EM 13c: IN-memory Advisor Not Installed
Last updated on JUNE 18, 2016
Applies to:Enterprise Manager for Oracle Database - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
Using the In-Memory advisor feature of Enterprise Manager 13c Cloud Control results in the following message:
In-Memory Advisor is either not installed (or installed version is less than 188.8.131.52.1) on the target or the DB user does not have access to run the advisor. Run the Install advisor job to install the advisor.
Submitting the job (Install Advisor) by clicking the link in the message ends with the following error:
Target Name: MY_DB
Target Type: oracle_database
DB users with access to the IM-Advisor: XYZ_USER
java.sql.SQLException: ORA-04063: package body "XYZ_USER.IMADVISOR_INSTALLATION" has errors
ORA-06508: PL/SQL: could not find program unit being called: "XYZ_USER.IMADVISOR_INSTALLATION"
ORA-06512: at line 116Installing IM-Advisor with the following parameters:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms