Shulou(Shulou.com)06/01 Report--

The determination is due to the default setting of "PASSWORD_LIFE_TIME= 180 days" in the default profile in oracle11g.

Check which user's proifle is, usually default:

Sql > SELECT username,PROFILE FROM dba_users

View the password validity settings for the specified profile, such as default:

Sql > SELECT * FROM dba_profiles s WHERE s.profile =\ 'DEFAULT\' AND resource_name=\ 'PASSWORD_LIFE_TIME\'

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

Sql > ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED

After the modification, there is no need to restart the database, it will take effect immediately.

After modification, accounts that have not been prompted for ORA-28002 warning will not encounter the same prompt again

Accounts that have been prompted must change their passwords again, for example:

$sqlplus / as sysdba

Sql > alter user smsc identified by-there is no need to change a new password

The password validity period is valid regardless of whether the oracle11g startup parameter resource_limit is set to false or true, so it must be modified in the above way. Please change the above account name according to the account name actually used.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.