Himu\’s Attempt at Blogging

Tidbits from my thoughts

Oracle 11g EM & Password Expiry

with one comment

I’ve faced this issue twice now – passwords expired after a certain time by default in Oracle 11g. But this also messes up EM (dbconsole) by locking up SYSMAN (status shown as LOCKED(TIMED)). The following link has the details on how to deal with change of password of SYSMAN and DBSNMP in Enterprise Manager: https://forums.oracle.com/forums/thread.jspa?threadID=1011436

In short:

  1. Reset password and unlock SYSMAN
    1. sqlplus /nolog
    2. conn / as sysdba
    3. alter user sysman identified by <pass>
    4. alter user sysman account unlock
  2. Make EM pick up the change
    1. emctl stop dbconsole
    2. emctl setpasswd dbconsole
    3. emctl secure dbconsole
    4. emctl start dbconsole
  3. Fireup EM and log on using SYS as SYSDBA
    1. EM will ask to change all expired/soon-to-be-expired passwords
  4. For DBSNMP please see the given link above
Advertisements

Written by mhimu

February 6, 2012 at 5:03 pm

Posted in Uncategorized

One Response

Subscribe to comments with RSS.

  1. Best answer I found. Succinct and worked perfectly. Thanks very much.

    RBerryman

    October 29, 2013 at 6:09 am


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: