Upgrade a 9.2.0.5 Oracle Apps intstance to 9.2.0.6

Upgrade a 9.2.0.5 Oracle Apps intstance to 9.2.0.6


select owner, count(*) from dba_objects
where status <> 'VALID'
group by owner
order by owner;

1. Shutdown instance if it is up and make sure ORACLE_HOME is 9.2.0.6
2. cp $ORACLE_ADMIN//pfile/init.ora.update to $ORACLE_ADMIN//pfile/init.ora
3. cd $ORACLE_HOME/rdbms/admin
4. startup migrate
5. spool patch__01.log (or 02, next one in line - do ls -ltr in $ORACLE_HOME/rdbms/admin to find out)
6. @?/rdbms/admin/catpatch.sql
7. @?/rdbms/admin/catcio.sql
8. spool off
9. cd $ORACLE_HOME/javavm/install
10. @?/javavm/install/jvmsec3.sql
11. @?/javavm/install/jvmsec5.sql
12. cd /orashr/patch/oracle64/9.2.0.6/4193295 (post-install step for this patch already applied to $O_H)
13. @catcpu.sh
14. compile sys invalids manually - should end up with just a few.
15. Gather stats for SYS - as sysdba
execute dbms_stats.gather_schema_stats('SYS',cascade=>TRUE,degree=>20);
16. cp $ORACLE_ADMIN//pfile/init.ora.save to $ORACLE_ADMIN//pfile/init.ora
17. Shutdown instance
18. Startup instance normally - $dbbin/start_db.sh -d
19. Change listener.ora for instance and bounce 9205LISTENER
20. Do adadmin / Compile apps schema
21. Check invalids below
22. Start ccmgrs for instance
23. start web/forms components

select owner, count(*) from dba_objects
where status <> 'VALID'
group by owner
order by owner;