EM 13c: IN-memory Advisor Not Installed (Doc ID 2121740.1)

Last updated on JUNE 18, 2016

Applies to:

Enterprise Manager for Oracle Database - Version 13.1.1.0.0 and later
Information in this document applies to any platform.

Symptoms

 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 1.0.0.0.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:

Installing IM-Advisor with the following parameters:
Target Name: MY_DB
Target Type: oracle_database
Directory: /oracle-export
Tablespace: USERS
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: 




Cause

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