How to change the SYSMAN user password for the Oracle Grid Control
You should be very
you change the SYSMAN password
for the Oracle Grid Control.
Remember that the SYSMAN user is the owner of the Enterprise Manager
(OEM) repository schema. Therefore not only you must change the password
in the database, you should change the
password in the Enterprise Manager configuration files too.
The following are the steps for changing the
password for the Oracle Grid Control.
1. Stop the
instances that are associated with the repository by changing the
directory to trhe opmn/bin directory.
- execute the opmctl control command to stop all the processes.
2. Change the sysman password in the database:
a. Logon to sqlplus as a dba user
b. Issue the command:
alter sysman identified by newpassword;
3. On each management server host, cd to the OMS $ORACLE_HOME/sysman/config
a. backup the emoms.properties file
b. edit the emoms.properties file and modify the parameters;
NOTE: When you restart the OMS, the FALSE setting will change to TRUE
and the password will become encrypted in the file
4. Still on Management Repository host, cd to the AGENT_HOME/bin and
stop the agent:
./emctl stop agent
5. Next, cd to the AGENT_HOME/sysman/emd directory
a. Edit the targets.xml file and modify the oracle_emrep target
definition with the following in bold:
<Target TYPE="oracle_emrep" NAME="Management Services and Repository"
<Property NAME="MachineName" VALUE="myserver"/>
<Property NAME="Port" VALUE="1521"/>
<Property NAME="SID" VALUE="sid"/>
<Property NAME="UserName" VALUE="xxx" ENCRYPTED="TRUE"/>
<Property NAME="password" VALUE="newpassword"
b. Save the file. The TRUE value will change to FALSE and the
newpassword will become encrypted when you restart the Agent.
6. Issue the command (from the Agent O_H/bin):
- Change directory to the agent directory;
# cd $ORACLE_HOME/agent
7. Restart each of the OMS's
- Change directory to the bin directory;
# cd $ORACLE_HOME/bin
./emctl start oms
8.Start the OMS instances that are associated with the repository
- change the directory to opmn/bin directory.
# cd $ORACLE_HOME/opmn/bin
- execute the opmctl control command to start all the processes.