Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Training

    Home      .Services     Login       Start Learning     Certification      .                 .Share your BELIEF(s)...


. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       Email2aFriend    |


Oracle 11g New Features

Online Oracle Training


How to change the SYSMAN user password for the Oracle Grid Control



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 (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 by changing the directory to trhe 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:

SQL> alter sysman identified by newpassword;

3. On each management server host, cd to the OMS $ORACLE_HOME/sysman/config directory
a. backup the file
b. edit the 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="myserver"/>
<Property NAME="Port" VALUE="1521"/>
<Property NAME="SID" VALUE="sid"/>
<Property NAME="UserName" VALUE="xxx" 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



Good Luck!


Web web site