scott account locked in SQL Plus

Question

When I am trying to logging to Oracle Sql plus by entering 'scott' as username and 'tiger' as password, it shows 'the account is locked'. How to unlock 'scott' account. The screen shot of SQL Plus CLI is given below.

Answer 1

You must be coming from the good old days of Oracle 8 :) It was finally acknowledged that a non-trivial amount of production DB instances were running with that account and it's default password still in it's initial setup form which is why Oracle has eventually patched that security hole.

To your specific question - here's a link (first hit in Google search, actually) that explain it.

Edit: Pasting the answer from the link into here for your convenience:

Here's how to lock or unlock Oracle database user accounts.

SQL> ALTER USER username ACCOUNT LOCK;

SQL> ALTER USER username ACCOUNT UNLOCK;