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 03:41 PM.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
Reply With Quote