Home » RDBMS Server » Enterprise Manager » Changing password of sysman and DBSNMP users (Oracle 10g (10.2.0.3.0) on Linux 64 bit)
Changing password of sysman and DBSNMP users [message #305285] Mon, 10 March 2008 05:39 Go to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
Hi,
When i changed my sysman and dbsnmp password, these users are frequently locking.

For sysman password change i do the following steps.

1) emctl stop dbconsole
2) change password of sysman and dbsnmp from sql
3) Post sysman password change to emoms.properties file
4) Post DBSNMP password change in targets.xml
4) emctl start dbconsole.



DBSNMO AND SYSMAN users were locked.

Stop dbconsole again

Unlock the user sysman and dbsnmp

then again restart dbconsole

Sysman user locked

Another thing do we need to have same password for dbsnmp and sysman


Following is the message

Enterprise Manager is not able to connect to the database instance. The state of the components are listed below.

Browser is showing All the components are up like instance, Agent and Listener with green arrows.



Regards,

MIFI

[Updated on: Mon, 10 March 2008 07:06]

Report message to a moderator

Re: Changing password of sysman and DBSNMP users [message #305611 is a reply to message #305285] Tue, 11 March 2008 06:27 Go to previous messageGo to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
Is there any one who have experience of changing sysman password
Re: Changing password of sysman and DBSNMP users [message #306452 is a reply to message #305611] Fri, 14 March 2008 05:26 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

1. Stop the OMS instances that are associated with the repository

Quote:
opmnctl stopall


2. Change the sysman password in the database:
a. Logon to sqlplus as a dba user
b. Issue the command:

Quote:
alter user sysman identified by newpassword;


c. Exit Sqlplus

3. On each management server host, cd to the OMS

Quote:
$ORACLE_HOME/sysman/config directory
a. backup the emoms.properties file
b. edit the emoms.properties file and modify the parameters;
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:
Quote:

<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" "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):
./emctl start agent

7. Restart each of the OMS's
emctl start oms

8.Start the OMS instances that are associated with the repository
opmnctl startall
Re: Changing password of sysman and DBSNMP users [message #307925 is a reply to message #306452] Thu, 20 March 2008 06:29 Go to previous messageGo to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
you may be telling this about EM GRID CONTROLLER, as the command is not there by the name of opmnctl.

I am using Enterpriser manager controller and i use emctl stop dbconsole to stop agent as well as EM.

Secondly the folder by the name agent_home is not there

In step 5 target_xml is changed for DBSNMP USER password or for sysman

Re: Changing password of sysman and DBSNMP users [message #309932 is a reply to message #307925] Sun, 30 March 2008 02:19 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Change SYSMAN password
Previous Topic: Grid Control together with dbconsole
Next Topic: ORA-12638
Goto Forum:
  


Current Time: Fri Mar 29 04:35:58 CDT 2024