My Oracle Support Banner

DBMS_SHARED_POOL Not Installed or Package Body Missing (ORA-6550, ORA-4067) (Doc ID 121571.1)

Last updated on NOVEMBER 14, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 7.3.4.0 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Solaris on SPARC (32-bit)

Symptoms

Problem:
========

You are attempting to use the DBMS_SHARED_POOL Package and you receive
an error indicating that the package has not been installed:

  execute DBMS_SHARED_POOL.sizes(0);
  begin DBMS_SHARED_POOL.sizes(0); end;

  ERROR at line 1:
  ORA-06550: line 1, column 7:
  PLS-00201: identifier 'DBMS_SHARED_POOL.SIZES' must be declared
  ORA-06550: line 1, column 7:
  PL/SQL: Statement ignored

You run the dbmspool.sql script and then attempt to run the same
operation again and receive an error that the package body is missing.

  ORA-04068: existing state of packages has been discarded
  ORA-04067: not executed, package body "SYS.DBMS_SHARED_POOL" does not exist
  ORA-06508: PL/SQL: could not find program unit being called
  ORA-06512: at line 1

 

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!

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