Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Duplicate DBMS_SHARED_POOL object in database prior to upgrade

edited Dec 6, 2016 7:08PM in Database Install/Upgrade/Opatch (MOSC) 3 commentsAnswered ✓

Hi,

We are currently on Oracle 11.2.0.3 and this Saturday we are planning to upgrade to 11.2.0.4 on new servers.

I was reviewing the checklist of what to review prior to the upgrade.

So I ran the duplicate objects check:

select OBJECT_NAME, OBJECT_TYPE from

DBA_OBJECTS where OBJECT_NAME||OBJECT_TYPE

in (select OBJECT_NAME||OBJECT_TYPE from

DBA_OBJECTS where OWNER='SYS') and

OWNER='SYSTEM' and OBJECT_NAME not in

('AQ$_SCHEDULES_PRIMARY', 'AQ$_SCHEDULES',

'DBMS_REPCAT_AUTH');

It came back with DBMS_SHARED_POOL PACKAGE

I had a closer look and could see:

SYS DBMS_SHARED_POOL 2013-06-08:21:48:00

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center