How to Reset SAP* Password
It is often that we may forget or miss the password for User SAP*. Here you can see how to reset the SAP* password
The following below steps shows how to Reset the Password for SAP*
1) Parameter login/no_automatic_user_sapstar = 0
Set the Value to 0 (ZERO)
after you reset the password make the value to 1
2) Reset Password
I)Login to the DBADMIN in OS
Logon to database server and switch to ora user (e.g. oraalr) under UNIX ( under Windows).