ORA-28001: thepasswordhasexpiredscott/tiger

Today, when using oracle11, using the default sqlplus account scott login, found an error, unable to log on to the ORA-28001: thepasswordhasexpiredscotttig

When using oracle 11 today, log on with scott, the default account in sqlplus, and an error is reported, unable to log on to ORA-28001: the password has expired scott/tig

ORA-28001: the password has expired scott/tiger

When using Oracle 11 today, use the default account scott in sqlplus 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.