At the beginning of oracle, Scott's account was locked. scottlock

At the beginning of oracle, Scott's account was locked. scottlock

1. First, you need to unlock the Scott account and enter alter user scott account unlock. Then, a prompt is displayed, indicating that the scott account has expired and the password has expired (expired );

2. Check the scott account validity period. Enter select * from dba_profiles s where s. profile = 'default' and resource_name = 'password _ life_time ';

3. Set the scott account validity period to unlimited. Enter alter profile default limit password_life_time unlimited;

4. Finally, change scott's account password to "root" and enter "alter user scott identified by root.