"The
superior reasoning power...revealed in the incomprehensible
universe, forms my idea of God."
-Albert
Einstein (1879-1955)
|
How to change the SYSMAN
user password for the Oracle Grid Control?
I installed Grid Control
with a repository in the same server. It was working fine. I went to
repository database and changed the SYSMAN password. Since then I have
problem and my Management Server is not working. Can you please let me
know what should I do?
You should be very careful
when you change the SYSMAN password for the Oracle Grid Control.
Remember that the SYSMAN user is the owner of the Enterprise Manager
10g (OEM) repository schema. Therefore not only you must change the
password in the database, you should change the SYSMAN password in the
Enterprise Manager configuration files too.
The following are the steps
for changing the SYSMAN password for the Oracle Grid Control.
1. Stop 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 stop all the processes.
# opmnctl stopall
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;
c. Exit Sqlplus
3. On each
management server host, cd to the OMS $ORACLE_HOME/sysman/config
directory
a. backup the emoms.properties file
b. edit the emoms.properties file and modify the parameters;
oracle.system.eml.mntr.emdRepPwd=new_password
oracle.sysman.eml.mntr.emdRepPwdEncrypted=FALSE
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" VERSION="1.0">
<Property NAME="MachineName" VALUE="host.us.oracle.com"/>
<Property NAME="Port" VALUE="1521"/>
<Property NAME="SID" VALUE="sid"/>
<Property NAME="UserName"
VALUE="552f2080d6d8c3c6" ENCRYPTED="TRUE"/>
<Property NAME="password" VALUE="newpassword"
ENCRYPTED="FALSE"/>
..
..
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
# ./emctl start 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.
# opmnctl startall
|