How To Update Oracle Warehouse Builder After a Database Cloning (Doc ID 434272.1)

Last updated on MAY 12, 2017

Applies to:

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

Goal

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.

Solution

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