ORA-28001: the password has expired scott/tiger

ORA-28001: the password has expired scott/tiger

When Oracle 11 is used today, scott, the default account in sqlplus, is used to log on. An error is reported and cannot be logged on.

Solve these problems:

1. The account scott is in the unlocked status. -- Of course, he will not report this error

2,

The password for Oracle11g has expired.

Cause: it is because "PASSWORD_LIFE_TIME = 180 days" is set in the default profile in oracle11g by default.

3,

C: \> sqlplus/as sysdba

View the password validity period settings of the specified profile (such as default:

SQL> select * from dba_profiles where profile = 'default' and resource_name = 'password _ LIFE_TIME ';

4. If the time limit is 180 days, perform the following operations and change it to an indefinite period:

SQL> alter profile default limit password_life_time unlimited;

SQL> commit;

5. If not, here is a simple method. Change the password to a new password, and then use the password command to restore the original password.