[Translated from mos] the user account in oracle db is locked-view the attempts made by oracle users, mosoracle

[Translated from mos] the user account in oracle db is locked-view the attempts made by oracle users, mosoracle

Reference Original:

Users Accounts Getting Locked. (docid 791037.1)

 

In fact, this article is written for other oracle software products, but it is related to db when user locking is involved.

I have not translated all of this article, but I have translated the most useful one:

--- The lcount Column records the number of times that oracle users log on to the database with the wrong password.

 

Select lcount from SYS. USER $ where name = '<USERNAME>'

Users in oracle are locked

The scott user was locked when you installed oracle,
To log on to scott, you must unlock it.
Log in as sys or system administrator.
Use alter user scott account unlock; To unlock user scott

Hope to help you

User lock issues in oracle 11g

Alter user scott account unlock
Add a semicolon.
Alter user scott account unlock;
The oracle command ends with a semicolon.

---
The above is helpful to you.