Oracle unlocks SCOTT/TIGER users

Oracle unlocks SCOTT/TIGER users

1. Verify the current system status for SCOTT users:

Select * from dba_users where upper (username) = 'Scott ';

ACCOUNT_STATUS: EXPIRED & LOCKED

2. Unlock SCOTT users:

Conn sys/bitservice @ ttonline as sysdba;

Alter user scott account unlock;

Select * from dba_users where upper (username) = 'Scott ';

ACCOUNT_STATUS: EXPIRED

3. Connect SCOTT User:

Conn scott/tiger @ ttonline; indicates that the user has expired. Please enter a new password: tiger

Conn scott/tiger @ ttonline; the user can be connected normally this time.

4. view the SCOTT user status:

Conn sys/bitservice @ ttonline as sysdba;

Select * from dba_users where upper (username) = 'Scott ';

ACCOUNT_STATUS: OPEN