My Oracle Support Banner

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

Last updated on FEBRUARY 22, 2023

Applies to:

Oracle Warehouse Builder - Version to [Release 11.2]
Oracle Warehouse Builder - Version 10.2 to 11.2 [Release 10.2 to 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.


To view full details, sign in with your My Oracle Support account.

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

In this Document
 Reset the registration details for the Control Center
 Update the Location Credentials stored in the Control Center  (This will update the locations that have been registered with the Control Center)
 Update the Location Credentials stored in the Design Repository part of the Unified Repository

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.