Home » Developer & Programmer » Warehouse Builder » Upgrade OWB from 10gr2 to 11gr2
Upgrade OWB from 10gr2 to 11gr2 [message #603784] Thu, 19 December 2013 06:35
Messages: 89
Registered: May 2005
Location: chennai

We have Oracle Database 10gr2 ( and OWB ( We are upgrading the database and OWB to 11gR2 (

I read the document on upgrading the repository and got cleared on the steps.

But I was not clear on upgrading the Location. I see we can use either upgradeloc.sh or WB_RT_RESET_LOCATION package.

1. Which one will be better? - Option 1 or 2

2. If I go through the option 1 (upgradeloc.sh)

-----upgradeloc.bat <host> <port> <service> <wks_owner_name> <wks_owner_pswd> <workspace_owner.workspace_name>----

Is wks_owner_name, workspace_owner ==>> all represents the WORKFLOW user which we will create during the Repository upgrade or both are different?

3. As OWB will be coming as part of Oracle RDBMS software (11gr2) applying all the required PSU patches on DB Home sufficent or is there any specific patch to apply on owb home

Previous Topic: OWB 11g on Windows to Solaris DB as target
Next Topic: New OWB Setup
Goto Forum:

Current Time: Tue Dec 01 01:58:18 CST 2015

Total time taken to generate the page: 0.08400 seconds