| SURESH |
Posted: Jan 08, 2007 07:44:57 AM |
Total Post: 10
Joined: Jan, 2007
|
i have forgotten the my system,sys users passwords
can i recover that passwords
if their is any way to recover that passwords plz give me step for that
plz help me
thanks in advance
suresh kumar
mail_suresh_dba@yahoo.co.in
|
|
|
 SatyaN |
| Posted: Jan 09, 2007 02:11:15 PM |  |
|
Total Post: 28
Joined: Nov, 2006
|
I guess you can change the password if you want using orapwd utility.
First shutdown the db using O/S authentication .
like sqlplus "/as sysdba"..then orapwd and change the password for sys ..
then restart the db and change password for system..
|
|
|
|
|
| goldmonkey |
| Posted: Jan 25, 2007 12:58:04 PM | |
|
Total Post: 7
Joined: Jan, 2007
|
If you database is under UNIX. You can login as any user that belong to DBA group and sqlplus " / as sysdba" will let you login in without any password. Then you can use:
alter use sys identified by password;
to change it. You don't need to shutdown the database and better not touch the password file.
|
|
|
|
|
| goldmonkey |
| Posted: Jan 25, 2007 01:00:56 PM | |
|
Total Post: 7
Joined: Jan, 2007
|
There is no way to get the info what the password is from the database. You can only change it or hope it is document somewhere.
|
|
|
|
|
| positive |
| Posted: Jun 29, 2008 03:53:04 PM | |
|
Total Post: 483
Joined: Jun, 2008
|
create an os user with sysdba privilege and try logging in:
http://neworacledba.blogspot.com/
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
