Thursday, December 17, 2009

upgrade 11g R1 to 11g R2 without DBUA

1. update the timezone file for ease, refere

2. then follow the same step as in 10g to 11g

3. Few modifications

instead of utlu111i.sql use utlu112i.sql,
utlu111s.sql use utlu112s.sql

Find out about the invalid views with
SELECT count(*) FROM dba_invalid_objects;
SELECT distinct object_name FROM dba_invalid_objects;