Sunday, January 10, 2010

load catbundle and recompile views

It looks we missed one step for new database creation in the past , especially for new database creation.

As our practice is to install oracle software first prior to database creation. This make it easier to forget loading catbundle.sql and view recompilation, according to readme.html of any CPU/PSU published after Jan 2008. The relevant section for are :

10g.

3.3.2.1 Loading Modified .sql Files into the Database
3.3.2.2 Recompiling Views in the Database
3.3.5 Post Installation Instructions for New and Upgraded Databases

11g.

2.3.3 Post Installation Instructions
2.3.4 Post Installation Instructions for Databases Created or Upgraded after Installation of PSU 11.1.0.7.1 in the Oracle Home

Relevant sql for checking are :

SELECT * FROM registry$history where ID = '6452863';

select * from dba_registry_history;