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

Thread: OEM Problem

  1. #1
    Join Date
    Oct 2006
    Posts
    18

    OEM Problem

    Changed SYS and SYSTEM passwords for security reasons and by mistake changed passwords for SYSMAN and DBSNMP accounts as well. Had problem connecting to OEM after that, so changed passwords back to original but still OEM does not show correct status for database instance, listener and agent connection to database. All three are shown as down. Also on top shows error The database target is currently unavailable.

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,470

    Cool


    You cannot just change the SYSMAN password from SQL*Plus, You need to do this (as per Metalink):

    To reset the SYSMAN password -
    1. Stop all Oracle Management Servers (OMS) currently connected to the EM Repository.
    2. From one of the OMS systems, use SQLPLUS to connect to the EM Repository Database. The connection attempt must be made using the EM Repository schema user's account.
    3. Execute the SQL script: %Oracle_home%\sysman\admin\vduresetsysman.sql
    4. Restart each OMS.
    5. Launch the EM Console. Logon as sysman with a password of oem_temp and change the password when prompted. Make sure the sysman and oem_temp are all lower case.

    Last edited by LKBrwn_DBA; 11-09-2006 at 02:41 PM.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Oct 2006
    Posts
    18
    Thanks

  4. #4
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,470

    Thumbs up


    No prob, glad to help!
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

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