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