How To Update Oracle Warehouse Builder After a Database Cloning

(Doc ID 434272.1)

Last updated on FEBRUARY 22, 2018

Applies to:

Oracle Warehouse Builder - Version 10.2 to 11.2 [Release 10.2 to 11.2]
Oracle Warehouse Builder - Version to [Release 11.2]
Information in this document applies to any platform.


After the Database hosting Warehouse Builder 10.2/11.1/11.2 Control Center has been cloned, the Warehouse Builder internals metadata need to be updated to reflect the  Host Name, Port, Service Name changes.

Since the Cloning Utility available with Warehouse Builder 9.2.x and 10.1.x (Location_Util) is not supported with Warehouse Builder 10.2 and higher, this note gives the steps to be performed.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms