Wednesday, September 12, 2007

HowTo Reset SYSMAN's password

Resetting SYSMAN's password Oracle 10gR2

1. Set environment variables

set ORACLE_HOME=yourOracleHome
set PATH=$ORACLE_HOME/bin:$PATH (assuming unix OS)

2. Shutdown EM and ensure your console is completely shutdown.
emctl stop dbconsole
emctl status dbconsole

3. From a SQL plus prompt modify sysman's password
SQL> alter user SYSMAN identified by yourNewPassword;

4. Verify you can open a sqlplus session with the sysman user using the reseted password.
sqlplus sysman/yourNewPassword

5. Reconfigure password
a. Change directory to ORACLE_HOME/hostname_sid/sysman/config
b. Backup file
c. Edit the file
d. Look for the line beginning with:
Replace the encrypted value by the new password value
e. Look for the line:
Replace TRUE by FALSE

6. Start the EM service
emctl start dbconsole

7. Verify the above written password has been changed to an encrypted version in the file.

8. Your EM DB Control should be up and running by now.

No comments: