Oracle password expired ORA-28002: solution to Password Expiration 7 days later

Today, the partner of Fuzhou University said that our database login password has expired. They cannot log on to the platform now. Hope to be resolved.

"ORA-28002: the password will expire in 7 days".

Cause: In oracle11g, "default profile" is set by default"PASSWORD_LIFE_TIME = 180As a result, the password of the oracle user must be changed within 180 days, or the connection will fail when the database is started.

Follow these steps to resolve the oracle Password Expiration:

1. Check the user's proifle, which is generally default:

SQL> SELECT username, PROFILE FROM dba_users;

2. view the password validity period settings of the specified profile (such as default:

SQL> SELECT * FROM dba_profiles s WHERE s. profile = 'default' AND resource_name = 'password _ LIFE_TIME ';

(If this is the case, it may prompt "You have not selected the bank of china". In fact, this is the case.

SELECT * FROM dba_profiles WHERE resource_name = 'password _ LIFE_TIME ';

That's all about me)

3. Change the password validity period from the default 180 days to "unlimited ":

SQL>Alter profile default limit PASSWORD_LIFE_TIME UNLIMITED;

If you want to change it to a limited value, for example, 60 days:

SQL> alter profile default limit PASSWORD_LIFE_TIME 60;

After modification, the database does not need to be restarted and takes effect immediately.

Other ideas

View the user's profile, which is generally DEFAULT

SQL> select * from dba_profiles where resource_type = 'Password ';

 

Cancel password management:

SQL> alter profile DEFAULT limit unlimited;
For example:
SQL> alter profile DEFAULT limit password_reuse_time unlimited;

Stop password verification function:

SQL> alter profile DEFAULT limit password_verify_function null;

Create a user-specific profile:

Create profile test LIMIT
SESSIONS_PER_USER UNLIMITED
CPU_PER_SESSION UNLIMITED
CPU _ per_call 3000
CONNECT_TIME 45
LOGICAL_READS_PER_SESSION DEFAULT
LOGICAL_READS_PER_CALL 1000
PRIVATE_SGA 15 K
COMPOSITE_LIMIT 5000000;

To change:

SQL> alter profile test limit PASSWORD_LIFE_TIME 60;

Change User profile