Oracle Tips

Steps for Changing the SYSMAN Password in 10.2.0.5 and 11.1 Grid Control

When using 10.2.0.5 or 11.1 OMS, all the above steps can be performed by executing a single command:
cd <OMS_HOME>/bin
emctl config oms -change_repos_pwd -change_in_db
Example of output for OMS 10.2.0.5 running on Windows:
C:\app\oracle\oms10g>emctl config oms -change_repos_pwd -change_in_db
Oracle Enterprise Manager 10g Release 5 Grid Control
Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
Enter Repository User's Current Password :
Enter Repository User's New Password :
Changing password in backend ...
Password changed in backend successfully.
Changing monitoring credentials ...
Monitoring credentials changed successfully.
Updating emoms.properties....
emoms.properties updated successfully....
Please bounce OMS.
Successfully changed repository password.
If you have multiple OMS's in your environment, please run this cmd on all of them
Note:
1. The above command
- will prompt you for the current password and the new password.
- will modify the sysman password in the repository database, in the emoms.properties configuration file / WLS Credential store and the monitoring credentials for the ‘OMS and Repository’ target.
- will ask you to bounce the OMS once the command is completed successfully
- for 11G, the command will modify the password for sysman and sysman_mds users in the repository database, modify the password in the credential store and change the monitoring credentials for the ‘OMS and Repository’ target.
2. The ‘-change_in_db’ parameter is optional and is used to change the SYSMAN password in the repository database.
- If the sysman password is manually modified in the repository database, this option need not be specified.
- When this parameter is specified, the command will prompt for the current sysman password.
- If the current sysman password is lost / unknown then:
a) Log in to your Repository database as SYS and run:
SQL> ALTER USER SYSMAN IDENTIFIED BY <newpassword>;
where newpassword is the new password you want for SYSMAN.
b) From a command prompt run:
cd $OMS_HOME/bin
./emctl config oms -change_repos_pwd
Provide newpassword when prompted.
3. If using multiple OMS, then execute the above command on one of the OMS.
On the Additional OMS, execute:
<OMS_HOME>/bin
emctl config oms -change_repos_pwd