19 Mar 2015

Oracle recovery-reset password SYS

To reset the password for the user SYS,
you need to sign on to Oracle as sysdba from within the same server where Oracle is running,
you should be able to log on without a password,
at this point simply change the password.



sqlplus /nolog
connect / as sysdba
ALTER USER SYS IDENTIFIED BY "change_on_install";


note: always remeber the passwords are case sensitive starting form oracle 10.

In some cases this methos may not work. Then the situation becomes complicated ... you can start trying to find another user with sysdba privileges, or you may


No comments: