My Oracle Support Banner

How To Change Passwords for DWADM, OWFMGR, BIREPO, DWUSER, SPLADM, SPLUSER, SPLREAD, OWBSYS, DWREAD and BIREPOWN? (Doc ID 1939532.1)

Last updated on JUNE 03, 2024

Applies to:

Oracle Utilities Business Intelligence - Version 2.4.0.0.0 to 2.4.0.0.0 [Release 2.4]
Information in this document applies to any platform.

Goal

Oracle Utilities Advanced Spatial and Operational Analytics (OUASA) 2.4.0 SP4 / Oracle Warehouse Builder (OWB) 11.2.0.3

A.

How to change DWADM password without Re-deploying OWB in OUBI?

In production OUBI, there is a requirement to change DWADM user password. After changing the db password and updating the same in configureEnv.sh, Oracle Utilities Business Intelligence (OUBI) load process goes to error.
If it needs OWBdeploy, it will wipe out the already loaded data. Is there a way to do this without affecting the existing data?

Error:

 

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
References


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