AboutElliot Mak Expertise I can answer questions with regarding to Oracle DB (8i, 9i, 10g) installation, configuration, administration, Data Guard, and SQL.
Experience I am an Oracle DBA, Senior PA, Project Manager, and Data Architect with 10 years of experience.
Question hello this is anil,
I have the problem while logging to the SQL*PLUS.
after i entered the username and password as "scott/tiger".it giving the following error
"The account is locked."
plz send me the solution
Answer Good day Anil,
Here is what you need to do:
1. Logon to the database using SYSTEM or SYS account
2. Unlock the account
alter user <username> account unlock;
here is an example:
SQL> conn scott/tiger@oradb13
ERROR:
ORA-28000: the account is locked
Warning: You are no longer connected to ORACLE.
SQL> conn system@oradb13
Enter password: ******
Connected.
SQL> select username, account_status from dba_users
2 where username = 'SCOTT';
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
SCOTT EXPIRED & LOCKED
SQL> alter user scott account unlock;
User altered.
SQL> select username, account_status from dba_users
2 where username = 'SCOTT';
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
SCOTT EXPIRED
SQL> conn scott/tiger@oradb13
ERROR:
ORA-28001: the password has expired
Changing password for scott
New password: *****
Retype new password: *****
Password changed
Connected.
SQL>
Hope it helps. If you shall have any questions, please don't hesitate to contact me.
