POiSON WORLD

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;

Comments

comments

Tags: #dba_immam, #dbaimmam, #immam_dba, #immamDba, #woesofdba, DBAimmam, ImmamDBA, ORA-28000, ORA28000, Oracle, Oracle Application, Oracle Database, Oracle DBA, oracle error, woesOfDba

This entry was posted on Monday, February 9th, 2026 at 2:29 pm and is filed under Oracle Queries. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.