Sign up ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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


share|improve this question

1 Answer 1

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
share|improve this answer
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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.