Oraclescott user unlock

Oracle cannot log on to Oracle using the scott user, prompting that the lock has been applied. If a connection exists, the unlock is successful. Similarly, we can unlock hr users.

Oracle cannot log on to Oracle using the scott user, prompting that the lock has been applied. If a connection exists, the unlock is successful. Similarly, we can unlock hr users.

Environment: Oracle 11g R2 + SQLPlus

Problem: Oracle cannot log on to Oracle using the scott user, prompting that the lock has been applied.

Solution: Open SQL Plus ----------> and execute the following command:

Run the following statement:

Conn scott/tiger;

If a connection exists, the unlock is successful. Similarly, we can unlock hr users.