ORA-28000: the account is locked Solution
Ora28000 the account islocked
ORA-28000: the account is locked-Solution
Second
Alter User Username account unlock;
The third way in PLSQL developer is to prompt the ora-28000 the account is locked when logging on with Scott/tiger.
Solution:
After Oracle10g is installed, use Scott/tiger for testing. The following error message is displayed:
Oracle10g the account is locked
Oracle10g the password has expired
Cause: Scott of Oracle10g cannot log on by default.
Solution:
(1) Conn sys/sys as sysdba; // Log On As A DBA
(2) alter user Scott account unlock; // then unlock
(3) Conn Scott/tiger // a dialog box is displayed, which allows you to change the password.
Enter cmd in running mode, enter sqlplus in DOS mode, and log on with the System user name. The password is the one you entered when oracle was just installed.
Orcl. After logging in.
SQL> conn sys/sys as sysdba;
As sysdba should write conn system/orcl as sysdba ;)
Connected.
SQL> alter user Scott account unlock;
User altered.
SQL> commit;
Commit complete.
SQL> conn Scott/tiger // enter the new password and confirm the password. OK
Password Changed
Connected.