Monday, January 5, 2009

Unlock Oracle account

SQL>sqlplus /nolog

SQL> connect sys/map3 as sysdba
Connected.
--map3 is SID of database

SQL> ALTER USER scott ACCOUNT UNLOCK;

User altered.

--After unlocking account I changed password to prash
SQL> ALTER USER scott IDENTIFIED BY prash;

User altered.

SOURCE:http://forums.oracle.com/forums/thread.jspa?messageID=1578430