Reset Sysman Password

{lang: 'ar'}

When you log on to the Console for the first time,you are prompted to change the password for Sysman, as Sysman is a Super Administrator account with unlimited privileges. What happens if you don’t remember the changed password subsequently?

 

Can you log on using the default password again? The answer is No. What can be done to reset the password? Oracle provides a script called vduResetSysman.sql to reset the Sysman password. This script is located at $ORACLE_HOME/sysman/admin directory. vduResetSysman.sql has to be run as the Repository Owner. As the name implies, Repository Owner is the person who owns the Repository tablespace and is created at the time of configuring OMS.

 

Steps to Reset Sysman Password
  • Open SQL*Plus
  • Connect as the Repository Owner. For example,if your Repository Owner is oem and has the password oem

SQL >connect oem/oem
Run the script vduResetSysman.sql. For this example, the location of ORACLE_HOME is C:/oracleora92
SQL> @c:oracleora92/sysmanadmin/vduResetSysman.sql
1 row updated.
Commit complete.
SQL>

  • Close SQL*Plus
  • Launch Console and use default credentials to sign in (sysman/oem_temp)
  • Change password
Changes in Release 10g

In Oracle Enterprise Manager 10g, SYSMAN password can be reset directly from SQL * Plus by using the ‘alter user command ..’ as is normally done. However, there are preliminary steps to be done before and after changing the password. Refer to ‘Oracle Enterprise Manager Advanced Configuration’ guide for details.

Click here for reuse options!

Copyright 2007 referpages

No related posts.

Speak Your Mind

*

Page optimized by WP Minify WordPress Plugin