Help - Search - Members - Calendar
Full Version: users password forgotten
Oracle DBA Forums > Oracle > Oracle Forum
mfran2002
hello,
i use oracle10g and i forgot my user password
i remember there's a procedure (command line) to reassign the password...

someone may tell me how to?

thanks

PS: is this procedure for user "system" or "sys" too?
Asma
alter user <username> identified by <pswd>;
you need to have admin rights to do so/ connect with db.

use orapwd utility for sys pasword.

QUOTE (mfran2002 @ Mar 14 2007, 03:16 PM) *
hello,
i use oracle10g and i forgot my user password
i remember there's a procedure (command line) to reassign the password...

someone may tell me how to?

thanks

PS: is this procedure for user "system" or "sys" too?
mfran2002
so, to reassign "sys" password i use:

orapwd file=pwddb.ora password="newpwd"

is it right?
i do specify user "sys" or not?
Asma
dont have any idea if you are on windows or unix plateform.

for windows, consider first stopping the service and than do so.
you might want to put files in the appropriate folder/directory. so give path too in the file name. on windows it would be like D:\Oracle\ora920\database or on unix it should be like $ORACLE_HOME/dbs
you dont need to use "quotes" for password




QUOTE (mfran2002 @ Mar 14 2007, 03:31 PM) *
so, to reassign "sys" password i use:

orapwd file=pwddb.ora password="newpwd"

is it right?
i do specify user "sys" or not?
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.