My Oracle Support Banner

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

Last updated on OCTOBER 31, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A 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:

NOTE: In the images and/or the document content below, the user information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product.  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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