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
prashanthgs
Messages: 83
Registered: May 2005
Location: chennai
Member
Hi,

We have Oracle Database 10gr2 (10.2.0.5) and OWB (10.2.0.3). We are upgrading the database and OWB to 11gR2 (11.2.0.3).

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

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


Current Time: Sat Jul 26 02:21:46 CDT 2014

Total time taken to generate the page: 0.09723 seconds