CODEWITHSUNDEEP
sql-serverdatabasesqlplus
PaDi
PaDi

Reputation: 265

How to unlock an sqlplus user?

I am using the following command to login to the DB server: sqlplus admin/admin@tstdb1

It was working fine till last night.

But now it is giving the error saying ERROR: ORA-28000: the account is locked

How can I solve this?

Thanks in advance.. :)

Upvotes: 1

Views: 15490

Answers (3)

user3274006
user3274006

Reputation: 89

Login to the database as system user 

C:>sqlplus sys/sys@tstdb1 as sysdba

and execute the following command in SQL prompt

ALTER USER user_name IDENTIFIED BY password ACCOUNT UNLOCK;

Upvotes: 2

Muhammad Mahmood Rauf
Muhammad Mahmood Rauf

Reputation: 17

Following statement may solve your problem, but make sure to execute this using some admin account.

ALTER USER USER_NAME 
    IDENTIFIED BY PASSWORD_HERE;

ALTER USER USER_NAME ACCOUNT UNLOCK;

Replace USER_NAME and PASSWORD_HERE with your desired values.

Upvotes: 0

Digital Alchemist
Digital Alchemist

Reputation: 2332

You can try this to unlock!

1- Open SQL Plus

2- Login as SYSDBA

SQL> conn /as sysdba

3- Unlock the account

SQL> ALTER USER username ACCOUNT UNLOCK;

To lock the account

SQL> ALTER USER username ACCOUNT LOCK;

Upvotes: 0

Related Questions