Friday, September 11, 2009

Change sysman and dbsnmp password for dbconsole 10G

1) Change sysman password:

On node the dbconsole is running

$ export ORACLE_SID=MYDB
$ emctl stop dbconsole --If you have RAC stop dbconsole on other(s) node(s) also.

$ sqlplus sys as sysdba

SQL>alter user sysman identified by newpass;

SQL>exit;

If you are on 10.2.0.4 and up
$ emctl setpasswd dbconsole
   provide the new password

Prior 10.2.0.4
Go to $ORACLE_HOME/host_sid/sysman/config (if RAC on each node)
Save the file emoms.properties to emoms.properties.orig
Edit the file emoms.properties
Search for the line beginning with:
oracle.sysman.eml.mntr.emdRepPwd=
Replace the encrypted value by the new password value
Search for the line:
oracle.sysman.eml.mntr.emdRepPwdEncrypted=TRUE
Replace TRUE by FALSE

$ emctl start dbconsole --If you have RAC start dbconsole on the other(s) node(s) also.

Check that the password has been encrypted
Edit the file $ORACLE_HOME/host_sid/sysman/config/emoms.properties (if RAC on each node)
Search for the line beginning with:
oracle.sysman.eml.mntr.emdRepPwd=
Check that the password is encrypted
Search for the line beginning with:
oracle.sysman.eml.mntr.emdRepPwdEncrypted=
Check that the value is TRUE

2) Change dbsnmp password:

On node the dbconsole is running
$ export ORACLE_SID=MYDB
$ emctl stop dbconsole --If you have RAC stop dbconsole on other(s) node(s) also.
$ sqlplus sys as sysdba
SQL>alter user dbsnmp identified by newpass;
SQL>exit;

Go to $ORACLE_HOME/host_sid/sysman/emd (if RAC On each node):
Save the file targets.xml to targets.xml.orig
Edit the file targets.xml
Find all occurrences of
Property NAME="password" VALUE="" ENCRYPTED="TRUE"
Replace the encrypted value by the new password value
Replace TRUE by FALSE

On node the dbconsole is running
$ emctl start dbconsole --If you have RAC stop dbconsole on other(s) node(s) also.

References
Oracle Support notes : 259379.1 & 259387.1

No comments:

Post a Comment