Change the ORMB DB User Password

After the DB user password is changed by DBA, or after the ORMB schema is refreshed from other environment and need keep the password of old one. The DB user password needs to be changed as per Oracle Doc.

For example, CISADM_TEST was refreshed from CISADM_PROD. In database, the password is still the one of CISADM_PROD.

SQL> select * from CI_WFM_OPT where ext_opt_type in ('F1DP','F1DU');

WFM_NAME SEQ_NUM        VERSION    WFM_OPT_VAL                                       EXT_
------------ ---------- ---------- ------------------------------------------------  ----
F1_DBCONINFO 1          1          ENC(m94Ug7/qXRpNj4PaaI/Wq9Lasp/6RI76LOrbouIMN0Q=) F1DP
F1_DBCONINFO 1          1          CISADM_PROD                                       F1DU

Change DB user password as per Oracle Doc:

Appendix C : Changing the DB User Password 
If you have changed the database user password, you need to execute the following steps before installing the rollup pack for Oracle Utilities Application Framework Version 4.3.0.1.0:
Download and apply the single fix available for Bug 22505470 - PATCHES APPEND EXTRA SPACE TO STRINGS AND ADD DB SERVICE CONNECTION SUPPORT on the application and database environments.
Perform the following steps on the application environment:
Change the DB Name using the configureEnv command.
Execute the initialSetup utility using the following command:

AIX, Linux:

 $SPLEBASE/bin/initialSetup.sh

Windows: 

%SPLEBASE%\bin\initialSetup.cmd

Execute the invokeDBUpdatePatch utility to change the database user name and password using the following command:

AIX, Linux: 

$SPLEBASE/bin/invokeDBUpdatePatch.sh -b

Windows: 

%SPLEBASE%\bin\invokeDBUpdatePatch.cmd –b

Check the password is changed with new user name:

SQL> select * from CI_WFM_OPT where ext_opt_type in ('F1DP','F1DU');

WFM_NAME SEQ_NUM        VERSION    WFM_OPT_VAL                                       EXT_
------------ ---------- ---------- ------------------------------------------------  ----
F1_DBCONINFO 1          1          ENC(fGXkVOgDO5OUv63oEMCGpd9mujCEIrw5+/DkKn+QSUQ=) F1DP
F1_DBCONINFO 1          1          CISADM_TEST                                       F1DU
Advertisements
This entry was posted in ORMB and tagged , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s