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
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.
ReplyDeleteJean
Thanks for thhis
ReplyDelete