Sysman account locked

23 Jul

When you get error ora-28000 when using database console or Enterprise Manager => the sysman account is locked [locked(timed)]. Do the following to reset the password (remember to make a copy of the file before editing):

 

  1. stop database console (through service)
  2. change password for user sysman
  3. E:\Oracle\product\11.1.0\db_1\dbora2.npta.no_SID\sysman\emd
    • <Property NAME=”UserName” VALUE=”SYSMAN” ENCRYPTED=”FALSE”/>
      <Property NAME=”password” VALUE=”<new_password>” ENCRYPTED=”FALSE”/>
  4. E:\Oracle\product\11.1.0\db_1\dbora2.npta.no_SID\sysman\config
    • oracle.sysman.eml.mntr.emdRepPwd= <new_password> 
    • oracle.sysman.eml.mntr.emdRepPwdEncrypted= FALSE 
  5. startup up db console (service)
  6. login using the new password

 

http://www.articles.freemegazone.com/oracle-sysman-account-locked.php?ref=1

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: