Sanity Check Before Upgrade/Migration

Check for Invalid Objects

select unique OBJECT_NAME, OBJECT_TYPE,
OWNER from DBA_OBJECTS where
STATUS='INVALID';

–> Fix all INVALID objects BEFORE the upgrade or migration
if invalid objects found on SYS/SYSTEM need to fix it.

@?/rdbms/admin/utlrp.sql

Check for Duplicate Objects

Check for duplicate objects on SYS/SYSTEM

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');

–> Fix all DUPLICATE objects BEFORE the upgrade or migration
Note:1030426.6 How to Clean Up Duplicate Objects Owned by SYS and SYSTEM Schema

Check for Invalid Components

select substr(COMP_ID, 1,10) compid,
substr(COMP_NAME,1,24) compname, STATUS,
VERSION from DBA_REGISTRY where
STATUS'VALID';

–>Try to fix all NON VALID components BEFORE the upgrade
compile using @?/rdbms/admin/utlrp.sql but if it dows not fix it. see notes

Note:472937.1 Information On Installed Database Components
Note:753041.1 How to diagnose Components with NON VALID status

Purge Recycle Bin (10g/11g)

purge DBA_RECYCLEBIN;

Remove Old Parameters

.
.
_always_semi_join=off
_unnest_subquery=false

optimizer_features_enable=9.2.0.8

event = "10061 trace name context forever, level 10"

.
.

.
.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s