DBMA_SHARED_POOL package is not executed on the Existing Database


Oracle provides a solid checking mechanism when it comes to checking the system for possible problems upon installing new functionality.
Today i faced a well written error on “DBMS_SHARED_POOL package is not executed on the Existing Database” while installing Oracle Enterprise Grid Control 10.2.0.3 on an existing 10.2 database at a customers request.

I found a quick and easy solution for my problem by checking if the package is indeed unavailable.

( When searching the install log , you will find the same string as a check from the installer “sqlQuery = select count(*) from dba_objects where owner=’SYS’ and object_name = ‘DBMS_SHARED_POOL’ and object_type in (‘PACKAGE’,’PACKAGE BODY’)” )


SQL> Select count(*) from dba_objects where OWNER = 'SYS'
AND object_name = 'DBMS_SHARED_POOL'
AND object_type IN ( 'PACKAGE','PACKAGE BODY') ; 2 3

COUNT(*)
----------
0

If this returns 0 , you need to install this package when proceeding :

SQL> @/u00/oracle/product/10.2.0/db/rdbms/admin/dbmspool.sql

Package created.

Grant succeeded.

View created.

Package body created.

SQL>

Recheck if the package is now available :

SQL> Select count(*) from dba_objects where OWNER = 'SYS'
AND object_name = 'DBMS_SHARED_POOL'
AND object_type IN ( 'PACKAGE','PACKAGE BODY') ;

COUNT(*)
----------
2

SQL>