We have Oracle Database 10gr2 (10.2.0.5) and OWB (10.2.0.3). We are upgrading the database and OWB to 11gR2 (126.96.36.199).
I read the document on upgrading the repository and got cleared on the steps.
But I was not clear on upgrading the Location. Do we really need to upgrade the locations after upgrading the repsoitory?
I see we can use either upgradeloc.sh or WB_RT_RESET_LOCATION package for upgrading the Location.
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?