Most Read

Most Read

Setting up Team Discussion Board

SharePoint 2007 has a Team Discussion Board that is used to initiate discussion and get replies on topics of interest. This article outlines the steps required to setup a discussion board, managing...
+ Full Article

More Popular Articles

Recent Articles

Recent Articles

Repeating Excel Header Rows

If your worksheet has several pages, it will be useful to have the header row repeat in all the pages. This will improve productivity as the user need not flip to the first page to view the header...
+ Full Article

More Recent Articles
Reset Sysman Password PDF Print E-mail
Saturday, 27 October 2007 08:37
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.


Trackback(0)
Comments (0)add
Write comment

security image
Write the displayed characters


busy
Last Updated on Saturday, 03 November 2007 09:56
 

now browsing!

We have 42 guests online

Training

UPK Training

UPK Developer Training Course Description  Overview Understanding Developer menu and toolbar itemsSetting Developer PreferencesManaging FoldersManaging DocumentsCreating Views
+ Full Article

More on Training

Featured

Oracle Tutor Procedure Writing

Oracle Tutor is a process and training documentation tool used for Oracle Applications. How to write a good procedure? There are some preliminary steps to be taken care that would help in drafting a...
+ Full Article

More Featured Articles

Sharepoint

Sharepoint Row Highlight using Behaviors

If you have a long list of items in a Sharepoint list, you may find it convenient to highlight the current row the cursor is on. While there are couple of ways of accomplishing this, this article...
+ Full Article

More on Sharepoint

Windows

Windows XP Password Reset Disk

What do you do if you do not remember the password in your Home PC. At work, you can request the Help Desk or Administrator to reset the password. For your Home PC you can create a Password Reset...
+ Full Article

More on Windows
 

Sedo - Buy and Sell Domain Names and Websites project info: referpages.com Statistics for project referpages.com etracker® web controlling instead of log file analysis