Saturday, September 12, 2009

Reset password in oracle

At first log in the server where oracle is installed using administrative account of the OS. Then set the ORACLE_SID user variable to the name of database service. So, if your database service name is orcl, then set the variable ORACLE_SID to value orcl. Then -

Log in sqlplus from command prompt of the server using the following command-

sqlplus "/as sysdba"

now you are connected.

Then you can change sys password by the following command-

alter user sys identified by *******;


Thus your password is reset. Now you can connect by any client s/w of oracle.