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

Last updated on DECEMBER 14, 2016

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

OUASA 2.4.0 SP4 / 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, 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

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