Friday, November 14, 2008

Change default password admin OWSM: Oracle Web Service Manager (10.1.3.3):

There is no GUI availible to change passwords of the Oracle Web Service Manager
Change the file manageUserGroups.properties first make a copy:
cd $ORACLE_HOME/owsm/bin
cp manageUserGroups.properties manageUserGroups.properties.org
vi manageUserGroups.properties

Contents of the file:

#============== Recommendation =======================
#Since all passwords property values, db_password, user_password
#are in clear text, for security reason, we recommend those values
#be deleted right after the use of command-line user/group management
#tool (manageusergroups.xml) and not be kept in this file.

#============== Provide your Database Connection Properties below
# Sample DB Connection Values
#db_url=jdbc:oracle:thin:@//{HOSTNAME_DATABASE}:{PORT}/{ORACLE_SID}
#db_driver=oracle.jdbc.driver.OracleDriver
#db_user=ORAWSM
#db_password=xxxxxxxxxxxxxxxxxxxxxxxx

db_url=jdbc:oracle:thin:@//{HOSTNAME_DATABASE}:{PORT}/{ORACLE_SID}
db_driver=oracle.jdbc.driver.OracleDriver
db_user=ORAWSM
db_password=xxxxxxxxxxxxxxxxxxxxxxxx

#============== User Parameters
# Sample User Values
#user_id=ctang
#user_name=Administrator
#user_password=mypasswrod
#user_email=admin@admin.com

#user_id=
#user_name=
#user_password=
#user_email=

user_id=admin
user_name=admin user
user_password={PASSWORD}
user_email=wsmadmin@xxxx.xxx

group_id=su1-grp
group_desc=super user group

#============== Group Parameters
# Sample Group Values
#group_id=IT-INFR
#group_desc=IT Infrastructure

#group_id=
#group_desc=

Change the {PASSWORD} value with the new password.

Remove the old admin user and the group to which the user belongs

cd $ORACLE_HOME/owsm/bin
./wsmadmin.sh manageUserGroups deleteUserGroup

Output:

Buildfile: $ORACLE_HOME/owsm/bin/../scripts/manageusergroups.xml
set-classpath-oracle:
[echo] Setting Oracle Classpath

manage-del-user-group:
[java] SUCCESS : Mapping between user "admin" and Group "su1-grp" successfully deleted from database.

BUILD SUCCESSFUL
Total time: 1 second

Delete the user:

./wsmadmin.sh manageUserGroups deleteUser

Output:

Buildfile: $ORACLE_HOME/owsm/bin/../scripts/manageusergroups.xml

set-classpath-oracle:
[echo] Setting Oracle Classpath

manage-del-user:
[java] SUCCESS : User "admin" successfully deleted from database.

BUILD SUCCESSFUL
Total time: 1 second

Create new user:
cd $ORACLE_HOME/owsm/bin
./wsmadmin.sh manageUserGroups addUser

Output:

Buildfile: $ORACLE_HOME/owsm/bin/../scripts/manageusergroups.xml

set-classpath-oracle:
[echo] Setting Oracle Classpath

manage-add-user:
[java] SUCCESS : User "admin" successfully added into database.

BUILD SUCCESSFUL
Total time: 1 second

Create an usergroup and add the admin user to this group.
./wsmadmin.sh manageUserGroups addUserGroup

Output:

Buildfile: $ORACLE_HOME/owsm/bin/../scripts/manageusergroups.xml

set-classpath-oracle:
[echo] Setting Oracle Classpath

manage-add-user-group:
[java] SUCCESS : Mapping between user "admin" and group "su1-grp" successfully added into the database.

BUILD SUCCESSFUL
Total time: 1 second

For more information Metalink note: 428513.1

2 comments:

  1. Hi, I had to go through the steps to change the password for the admin user for OWSM. Then I created a little java program to simply change the password in the database without having to create the temporary user. Too bad that oracle does not provide this out of the box.

    Jean

    ReplyDelete

comment