Monday, April 26, 2010
Resolving ORACLE ERROR:ORA-28000: the account is locked
From your command prompt, type
sqlplus "/ as sysdba"
Once logged in as SYSDBA, you need to unlock the scott account
SQL> alter user scott account unlock;
SQL> grant connect, resource to scott;
sqlplus "/ as sysdba"
Once logged in as SYSDBA, you need to unlock the scott account
SQL> alter user scott account unlock;
SQL> grant connect, resource to scott;
Subscribe to:
Posts (Atom)