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



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
  • 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 clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy