Home » » Oracle Database account is locked

Oracle Database account is locked

Written By Psychic Zero on Tuesday, April 4, 2017 | 4:24 PM

Resolving ORACLE ERROR:ORA-28000: the account is locked

After installation of Oracle10g, there was a problem ..couldnt login using SQL+. None of the accounts(scott/tiger) worked . At last a quick web search gave the solution . Here is what it is:


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;

By thekkadath on Mar 20, 2006

Source Oracle Blogs.



0 comments:

Post a Comment