My Oracle Support Banner

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

Last updated on NOVEMBER 24, 2019

Applies to:

Enterprise Manager for Oracle Database - Version 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 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: 


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.