DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Starting EM Error

  1. #1
    Join Date
    Jun 2013
    Location
    United States
    Posts
    10

    Starting EM Error

    Hello all

    I am trying to log into the Enterprise Manager and I got the error message:
    (Agent Connection to Instance
    Status
    Failed
    Details ORA-28001: the password has expired (DBD ERROR: OCISessionBegin)

    How can I resolve this please?

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    So when you type sysman into the username field and the password into the password field,
    and the application tells you that the sysman password is expired, do you then try to log into
    sqlplus as sysman and change the sysman password? To know if an expired password
    is you only problem, you should look at the log files associated with OEM.

    Also when asking for help, you should post the operating system and version of OEM along
    with your question, in case that is relevant to the issue. But to keep this from happening,
    you may want to change the password expiration policy for the sysman user to not expire.
    To know which profile is being used, look at the profile field of the dba_users view, and then
    look for the expiration for that profile.

    In summary when a password is expired, you should change the password.

  3. #3
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492
    Changing the SYSMAN password is not strait forward, you need to follow the instructions in one of these Oracle support documents:

    How To Change the Password of the Database User Sysman (DB Control Repository Schema) [ID 259379.1]
    or
    How to Change the Password of SYSMAN User in 10g and 11g Grid Control? [ID 270516.1]

    Otherwise if you have single instance database with dbcontrol (and you have DBA access), you could assign to the SYSMAN user a profile which does not expire the password and does not require you NOT to use the same password (if you change it).
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  4. #4
    Join Date
    Jun 2013
    Location
    United States
    Posts
    10
    Hello guys,

    Thank you. I went to the command line and and able to change the password. I followed the instruction about how to change the password at the command line, when I came to the EM it asks for the new password and I was able to change it. Now I could log into the EM properly.

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width