unixadmin.free.fr just another IBM blog and technotes backup

22avr/11

Change Oracle system password impact Enterprise Manager login

Change Oracle system password impact Enterprise Manager login in Oracle 10g

There is much information on the web but a SYSMAN account locked prevented EM to connect to database.

Stop Oracle Enterprise Manager

emctl stop dbconsole
emctl status dbconsole

Connect to database as sysdba and change system password

sqlplus / as sysdba

alter user sys identified by NewPassword ;
alter user system identified by NewPassword ;
alter user dbsnmp identified by NewPassword ;
alter user sysman identified by NewPassword ;

In file ${ORACLE_HOME}/`hostname`_${ORACLE_SID}/sysman/config/emoms.properties, modify the lines:

oracle.sysman.eml.mntr.emdRepUser=SYSMAN
oracle.sysman.eml.mntr.emdRepPwd=d0355495a68cd5ae
oracle.sysman.eml.mntr.emdRepPwdEncrypted=TRUE

by

oracle.sysman.eml.mntr.emdRepUser=SYSMAN
oracle.sysman.eml.mntr.emdRepPwd=Newpassword
oracle.sysman.eml.mntr.emdRepPwdEncrypted=FALSE

Open file ${ORACLE_HOME}/`hostname`_${ORACLE_SID}/sysman/emd/targets.xml and modify the lines:

<Property NAME="UserName" VALUE="2ed7f792e30adc89" ENCRYPTED="TRUE"/>
<Property NAME="password" VALUE="c8d4082a472b36ae" ENCRYPTED="TRUE"/>

by

<Property NAME="UserName" VALUE="dbsnmp" ENCRYPTED="FALSE"/>
<Property NAME="password" VALUE="Newpassword" ENCRYPTED="FALSE"/>

Before restart Oracle Enterprise Manager check if SYSMAN is not LOCKED like bellow

SQL> SELECT username, account_status FROM dba_users WHERE username IN ('SYSMAN','DBSNMP');

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
DBSNMP                         OPEN
SYSMAN                         LOCKED(TIMED)

Unlock SYSMAN account

SQL> alter user sysman identified by newpassword account unlock;

SQL> SELECT username, account_status FROM dba_users WHERE username IN ('SYSMAN','DBSNMP');


USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
SYSMAN                         OPEN
DBSNMP                         OPEN

Now you can start Oracle Enterprise Manager

emctl start dbconsole

After restart Oracle Enterprise Manager check the encryption of newpassword in targets.xml and emoms.properties files.

Source
http://fadace.developpez.com/oracle/pwd/

Commentaires () Trackbacks (0)

Aucun commentaire pour l'instant


Leave a comment

(required)

Aucun trackbacks pour l'instant