After upgrading below databases
from 11.2.0.3 to 11.2.0.4. We found OWB (Oracle Warehouse Builder) was still in
11.2.0.3.0. As per oracle Doc I have followed below steps to upgrade OWD to
11.2.0.4.
Before Status:
COMP_ID
COMP_NAME
VERSION
STATUS
---------------
----------------- ------------------------------ ----------
OWB
OWB
11.2.0.3.0
VALID
Work Around:
SQL>$ORACLE_HOME/owb/UnifiedRepos/clean_owbsys.sql
SQL>$ORACLE_HOME/owb/UnifiedRepos/cat_owb.sql
After Status:
COMP_ID
COMP_NAME
VERSION
STATUS
---------------
------------- ------------------------------ ----------
OWB
OWB
11.2.0.4.0
VALID
No comments:
Post a Comment