Recovering Oracle admin password

Question

Are there any ways to recover oracle admins (sysman, sys,system) account in times of password forgetting, account locking out?

Thanks.

Dennis Williamson · Answer 1 · 2010-04-25 22:54:40Z

up vote 2 down vote

According to this:

#sqlplus /nolog
SQL>conn / as sysdba
SQL>alter user Username identified by password;

According to here and here:

orapwd file=password_file_name password=the_secret_password entries=n

answered Apr 25 '10 at 22:54

	Which is fine as long as you haven't lost all of the admin accounts. – LapTop006 Apr 26 '10 at 3:15
	Not true. You can alter ANY account password this way. – DCookie Apr 26 '10 at 13:54
	+1, this works. Additionally, you can add the ACCOUNT UNLOCK option to the alter user command and unlock the account. – DCookie Apr 26 '10 at 13:56

feedback

1 Answer