1/24/10

How to unlock Soctt account in oracle10g if sys password is unknown

c:> sqlplus /nolog -------------------------your sqlplus installation directory
SQL> connect / as sysdba
SQL> SHO USER
USER is "SYS"
SQL> ALTER USER sys IDENTIFIED BY ora10g;------ this is your sys pwd

SQL> ALTER USER scott IDENTIFIED BY tiger account unlock;


now open sql+ using scott tiger.