Blog maintained by TechnoGems

Tuesday, April 21, 2009

How to Change Oracle ORAWSM Database Password

If you are reading this you already know that the WSM uses the ORAWSM user in the infra database. If you need to change the Oracle database password for the ORAWSM user, you would guess that you will may have to change the password in some configuration files for the webservices manager to use the new password. However that process is not that simple. Here are the steps you need to follow.



Step 1: Change the password directly in the database.

Login as sysdba and change the password of orawsm.

Step 2: Change the password in WSM configuration files
Reffer to steps described in the following url. (Content copied here for your reference.)
http://download.oracle.com/docs/cd/B31017_01/integrate.1013/b31007.pdf (appendix C - Changing Passwords)

The following procedure describes how to change a database password for a single instance of an Oracle WSM Database.
To change a password for a single database instance
1. Edit the attribute db.password in the ORACLE_HOME/owsm/bin/coresv.properties file.
2. From the command prompt, execute the following command:
wsmadmin encodePasswords coresv.properties dataload.messagelog.db.password
3. From the command prompt, execute the wsmadmin copyDBConfig command:
wsmadmin copyDBConfig
4. From the command prompt, execute the wsmadmin deploy command:
wsmadmin deploy application_server_password component
See Appendix B, "Oracle Web Services Manager WSMADMIN Commands" for more information.

The following procedure describes how to change your database password when you have multiple instances of Oracle WSM Database.

To update and reconcile a password for multiple database instances
1. Update the relevant attribute in the application properties file for each application.
These are located under ORACLE_HOME/owsm/config/application_name.
2. Update and reconcile the passwords for all the database instances.
3. From the command prompt, execute the wsmadmin encodePassword command
for each affected file:
wsmadmin encodePasswords path_to_file properties
4. From the command prompt, execute the wsmadmin deploy command:
wsmadmin deploy application_server_password component
See Appendix B, "Oracle Web Services Manager WSMADMIN Commands" for more
information.

Step 3: Change the password in the policy configuration for each gateway defined.

For each gateway and agent in your system, there is a property - cfluent.messagelog.db.password - which has to be manually changed to the correct password value for your OWSM schema, as it is left unaffected by the redeployment of the OWSM applications.
This is handled through the OWSM console by accessing the properties screen for each gateway and agent (Policy Management > Manage Policies > Edit Component Properties).
The password that you enter should be the actual password with no encryption. The value will be encrypted before it is stored in to the orawsm.policy_manager_objects table.