Take the 2-minute tour ×
Server Fault is a question and answer site for professional 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?

Thanks.

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

 
discard

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