Oracle In-Memory Advisor Not Working (Doc ID 2280944.1)

Last updated on JULY 13, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

In a 12.1.0.2 database with Database Vault, the installation of the in-memory advisor fails with the following error:

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY DBMS_INMEMORY_ADVISOR_PRVT:

LINE/COL ERROR
-------- -----------------------------------------------------------------
10310/23 PL/SQL: Item ignored
10310/23 PLS-201: identifier 'UTL_FILE' must be declared
10312/5 PL/SQL: Statement ignored
10312/5 PLS-320: the declaration of the type of this expression is incomplete or malformed

10313/5 PL/SQL: Statement ignored
10313/22 PLS-320: the declaration of the type of this expression is incomplete or malformed

10328/23 PL/SQL: Item ignored
10328/23 PLS-201: identifier 'UTL_FILE' must be declared
10349/7 PL/SQL: Statement ignored
10349/7 PLS-320: the declaration of the type of this expression is incomplete or malformed

10355/9 PL/SQL: Statement ignored
10355/28 PLS-320: the declaration of the type of this expression is incomplete or malformed

10359/7 PL/SQL: Statement ignored
10359/24 PLS-320: the declaration of the type of this expression is incomplete or malformed

BEGIN
*
ERROR at line 1:
ORA-4063: package body "IMADVISOR.DBMS_INMEMORY_ADVISOR_PRVT" has errors
ORA-6508: PL/SQL: could not find program unit being called:
"IMADVISOR.DBMS_INMEMORY_ADVISOR_PRVT"
ORA-6512: at line 8

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