Scenario: After upgrading the database from 11.2.0.3 to 11.2.0.4 one of the component (OWB) is not upgraded
Step 1: Check the registry status and found OWB is not upgraded to 11.2.0.4
SQL> select substr(comp_name,1,40) comp_name, status, substr(version,1,10) version from
dba_registry order by comp_name; 2
COMP_NAME STATUS VERSION
---------------------------------------- ----------- ----------
JServer JAVA Virtual Machine VALID 11.2.0.4.0
OLAP Analytic Workspace VALID 11.2.0.4.0
OLAP Catalog VALID 11.2.0.4.0
OWB VALID 11.2.0.3.0
Oracle Application Express VALID 3.2.1.00.1
Oracle Database Catalog Views VALID 11.2.0.4.0
Oracle Database Java Packages VALID 11.2.0.4.0
Oracle Database Packages and Types VALID 11.2.0.4.0
Oracle Enterprise Manager VALID 11.2.0.4.0
Oracle Expression Filter VALID 11.2.0.4.0
Oracle Multimedia VALID 11.2.0.4.0
COMP_NAME STATUS VERSION
---------------------------------------- ----------- ----------
Oracle OLAP API VALID 11.2.0.4.0
Oracle Rules Manager VALID 11.2.0.4.0
Oracle Text VALID 11.2.0.4.0
Oracle Workspace Manager VALID 11.2.0.4.0
Oracle XDK VALID 11.2.0.4.0
Oracle XML Database VALID 11.2.0.4.0
Spatial VALID 11.2.0.4.0
18 rows selected.
Step 2: Now we have to do the following two activities
a) execute the script $ORACLE_HOME\owb\UnifiedRepos\clean_owbsys.sql
b) execute the script $ORACLE_HOME\owb\UnifiedRepos\cat_owb.sql
SQL>
bash-3.00$ cd $ORACLE_HOME
bash-3.00$ pwd
/ultimus/oracle/product/11.2.0.4/db_1
bash-3.00$ cd ow
owb/ owm/
bash-3.00$ cd owb/UnifiedRepos/
bash-3.00$ pwd
/ultimus/oracle/product/11.2.0.4/db_1/owb/UnifiedRepos
bash-3.00$
bash-3.00$ ls -lrt
total 290
-rw-r--r-- 1 oracle dba 63 Apr 1 2006 bug5060857.sql
-rw-r--r-- 1 oracle dba 111 Apr 1 2006 bug5087832.sql
-rw-r--r-- 1 oracle dba 540 Apr 1 2006 bug5072235.sql
-rw-r--r-- 1 oracle dba 792 Apr 1 2006 patch_paris_repos_sys.sql
-rwxr-x--- 1 oracle dba 4446 Apr 1 2006 patch_paris_repos.sh
-rw-r--r-- 1 oracle dba 4610 Apr 1 2006 patch_paris_repos.bat
-rw-r--r-- 1 oracle dba 3756 Apr 1 2006 bug5092719.sql
-rw-r--r-- 1 oracle dba 96 Aug 14 2006 wkspDrop.xml
-rw-r--r-- 1 oracle dba 189 Aug 16 2006 wkspInstall.xml
-rw-r--r-- 1 oracle dba 324 Oct 29 2007 racsetup.xml
-rw-r--r-- 1 oracle dba 56 Jan 6 2008 wkspUserInstall.xml
-rw-r--r-- 1 oracle dba 56 Jan 6 2008 wkspUserDrop.xml
-rw-r--r-- 1 oracle dba 163 Sep 26 2008 clean_owbsys.sql
-rw-r--r-- 1 oracle dba 142 Sep 26 2008 clean_owbmeta.sql
-rw-r--r-- 1 oracle dba 74 Dec 4 2008 unlock_owbsys.sql
-rw-r--r-- 1 oracle dba 6070 May 5 2009 reposDrop.xml
-rw-r--r-- 1 oracle dba 688 May 5 2009 licenseInstall.xml
-rw-r--r-- 1 oracle dba 768 May 15 2009 remote_owb_install.sql
-rw-r--r-- 1 oracle dba 39435 Dec 19 2010 part_owb.sql
-rw-r--r-- 1 oracle dba 7180 Oct 4 2012 cat_owbmeta.sql
-rw-r--r-- 1 oracle dba 44656 Oct 14 2012 reposInstall.xml
-rw-r--r-- 1 oracle dba 4372 Feb 12 2013 cat_owb_reposupgrade.sql
-rw-r--r-- 1 oracle dba 11828 Jul 8 2013 cat_owb.sql
-rw-r--r-- 1 oracle dba 2714 Jul 11 2013 reset_owbcc_home.sql
********* execute the script $ORACLE_HOME\owb\UnifiedRepos\clean_owbsys.sql
bash-3.00$ sqlplus
SQL*Plus: Release 11.2.0.4.0 Production on Sun Nov 5 10:24:38 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter user-name: /as sysdba
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> @clean_owbsys.sql
User dropped.
User dropped.
Role dropped.
Role dropped.
Role dropped.
********* execute the script $ORACLE_HOME\owb\UnifiedRepos\cat_owb.sql
User altered.
User altered.
NOTE: To associate the Control Center with the correct OWB home, now run owb/UnifiedRepos/reset_owbcc_home.sql. You must run the script as a user with java admin privileges. For example, connect as sys as sysdba to run the script.
SQL>
Step 3: Now check the status of OWB
SQL> select substr(comp_name,1,40) comp_name, status, substr(version,1,10) version from
dba_registry order by comp_name; 2
COMP_NAME STATUS VERSION
---------------------------------------- ----------- ----------
JServer JAVA Virtual Machine VALID 11.2.0.4.0
OLAP Analytic Workspace VALID 11.2.0.4.0
OLAP Catalog VALID 11.2.0.4.0
OWB VALID 11.2.0.4.0
Oracle Application Express VALID 3.2.1.00.1
Oracle Database Catalog Views VALID 11.2.0.4.0
Oracle Database Java Packages VALID 11.2.0.4.0
Oracle Database Packages and Types VALID 11.2.0.4.0
Oracle Enterprise Manager VALID 11.2.0.4.0
Oracle Expression Filter VALID 11.2.0.4.0
Oracle Multimedia VALID 11.2.0.4.0
COMP_NAME STATUS VERSION
---------------------------------------- ----------- ----------
Oracle OLAP API VALID 11.2.0.4.0
Oracle Rules Manager VALID 11.2.0.4.0
Oracle Text VALID 11.2.0.4.0
Oracle Workspace Manager VALID 11.2.0.4.0
Oracle XDK VALID 11.2.0.4.0
Oracle XML Database VALID 11.2.0.4.0
Spatial VALID 11.2.0.4.0
18 rows selected.
SQL>
Thats it !!!!!!
Step 1: Check the registry status and found OWB is not upgraded to 11.2.0.4
SQL> select substr(comp_name,1,40) comp_name, status, substr(version,1,10) version from
dba_registry order by comp_name; 2
COMP_NAME STATUS VERSION
---------------------------------------- ----------- ----------
JServer JAVA Virtual Machine VALID 11.2.0.4.0
OLAP Analytic Workspace VALID 11.2.0.4.0
OLAP Catalog VALID 11.2.0.4.0
OWB VALID 11.2.0.3.0
Oracle Application Express VALID 3.2.1.00.1
Oracle Database Catalog Views VALID 11.2.0.4.0
Oracle Database Java Packages VALID 11.2.0.4.0
Oracle Database Packages and Types VALID 11.2.0.4.0
Oracle Enterprise Manager VALID 11.2.0.4.0
Oracle Expression Filter VALID 11.2.0.4.0
Oracle Multimedia VALID 11.2.0.4.0
COMP_NAME STATUS VERSION
---------------------------------------- ----------- ----------
Oracle OLAP API VALID 11.2.0.4.0
Oracle Rules Manager VALID 11.2.0.4.0
Oracle Text VALID 11.2.0.4.0
Oracle Workspace Manager VALID 11.2.0.4.0
Oracle XDK VALID 11.2.0.4.0
Oracle XML Database VALID 11.2.0.4.0
Spatial VALID 11.2.0.4.0
18 rows selected.
Step 2: Now we have to do the following two activities
a) execute the script $ORACLE_HOME\owb\UnifiedRepos\clean_owbsys.sql
b) execute the script $ORACLE_HOME\owb\UnifiedRepos\cat_owb.sql
SQL>
bash-3.00$ cd $ORACLE_HOME
bash-3.00$ pwd
/ultimus/oracle/product/11.2.0.4/db_1
bash-3.00$ cd ow
owb/ owm/
bash-3.00$ cd owb/UnifiedRepos/
bash-3.00$ pwd
/ultimus/oracle/product/11.2.0.4/db_1/owb/UnifiedRepos
bash-3.00$
bash-3.00$ ls -lrt
total 290
-rw-r--r-- 1 oracle dba 63 Apr 1 2006 bug5060857.sql
-rw-r--r-- 1 oracle dba 111 Apr 1 2006 bug5087832.sql
-rw-r--r-- 1 oracle dba 540 Apr 1 2006 bug5072235.sql
-rw-r--r-- 1 oracle dba 792 Apr 1 2006 patch_paris_repos_sys.sql
-rwxr-x--- 1 oracle dba 4446 Apr 1 2006 patch_paris_repos.sh
-rw-r--r-- 1 oracle dba 4610 Apr 1 2006 patch_paris_repos.bat
-rw-r--r-- 1 oracle dba 3756 Apr 1 2006 bug5092719.sql
-rw-r--r-- 1 oracle dba 96 Aug 14 2006 wkspDrop.xml
-rw-r--r-- 1 oracle dba 189 Aug 16 2006 wkspInstall.xml
-rw-r--r-- 1 oracle dba 324 Oct 29 2007 racsetup.xml
-rw-r--r-- 1 oracle dba 56 Jan 6 2008 wkspUserInstall.xml
-rw-r--r-- 1 oracle dba 56 Jan 6 2008 wkspUserDrop.xml
-rw-r--r-- 1 oracle dba 163 Sep 26 2008 clean_owbsys.sql
-rw-r--r-- 1 oracle dba 142 Sep 26 2008 clean_owbmeta.sql
-rw-r--r-- 1 oracle dba 74 Dec 4 2008 unlock_owbsys.sql
-rw-r--r-- 1 oracle dba 6070 May 5 2009 reposDrop.xml
-rw-r--r-- 1 oracle dba 688 May 5 2009 licenseInstall.xml
-rw-r--r-- 1 oracle dba 768 May 15 2009 remote_owb_install.sql
-rw-r--r-- 1 oracle dba 39435 Dec 19 2010 part_owb.sql
-rw-r--r-- 1 oracle dba 7180 Oct 4 2012 cat_owbmeta.sql
-rw-r--r-- 1 oracle dba 44656 Oct 14 2012 reposInstall.xml
-rw-r--r-- 1 oracle dba 4372 Feb 12 2013 cat_owb_reposupgrade.sql
-rw-r--r-- 1 oracle dba 11828 Jul 8 2013 cat_owb.sql
-rw-r--r-- 1 oracle dba 2714 Jul 11 2013 reset_owbcc_home.sql
********* execute the script $ORACLE_HOME\owb\UnifiedRepos\clean_owbsys.sql
bash-3.00$ sqlplus
SQL*Plus: Release 11.2.0.4.0 Production on Sun Nov 5 10:24:38 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter user-name: /as sysdba
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> @clean_owbsys.sql
User dropped.
User dropped.
Role dropped.
Role dropped.
Role dropped.
********* execute the script $ORACLE_HOME\owb\UnifiedRepos\cat_owb.sql
User altered.
User altered.
NOTE: To associate the Control Center with the correct OWB home, now run owb/UnifiedRepos/reset_owbcc_home.sql. You must run the script as a user with java admin privileges. For example, connect as sys as sysdba to run the script.
SQL>
Step 3: Now check the status of OWB
SQL> select substr(comp_name,1,40) comp_name, status, substr(version,1,10) version from
dba_registry order by comp_name; 2
COMP_NAME STATUS VERSION
---------------------------------------- ----------- ----------
JServer JAVA Virtual Machine VALID 11.2.0.4.0
OLAP Analytic Workspace VALID 11.2.0.4.0
OLAP Catalog VALID 11.2.0.4.0
OWB VALID 11.2.0.4.0
Oracle Application Express VALID 3.2.1.00.1
Oracle Database Catalog Views VALID 11.2.0.4.0
Oracle Database Java Packages VALID 11.2.0.4.0
Oracle Database Packages and Types VALID 11.2.0.4.0
Oracle Enterprise Manager VALID 11.2.0.4.0
Oracle Expression Filter VALID 11.2.0.4.0
Oracle Multimedia VALID 11.2.0.4.0
COMP_NAME STATUS VERSION
---------------------------------------- ----------- ----------
Oracle OLAP API VALID 11.2.0.4.0
Oracle Rules Manager VALID 11.2.0.4.0
Oracle Text VALID 11.2.0.4.0
Oracle Workspace Manager VALID 11.2.0.4.0
Oracle XDK VALID 11.2.0.4.0
Oracle XML Database VALID 11.2.0.4.0
Spatial VALID 11.2.0.4.0
18 rows selected.
SQL>
Thats it !!!!!!
