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 11.2.0.4 to 11.2.0.4 [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.

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

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
Goal
Solution
 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
References

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