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

Development login database times error as follows: ERROR:ORA-28002: the password will expire within 7 days the default profile before Oracle 11g has no password expiration limit. In Oracle 11g, the default profile enabled password expiration time is 180d, you can remove this restriction. Query the settings of password expiration parameter of default profile sys@yangdb > select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME';PROFILE RESOURCE_NAME RESOURCE LIMIT--DEFAULT PASSWORD_LIFE_TIME PASSWORD 180

Set the default profile password to never expire and take effect immediately without restarting sys@yangdb > ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;Profile altered. For expired ones, to reset the password, you can use the same sys@yangdb > alter user APP identified by xxxapp;User altered as the previous password.

By the way, explain the password-related parameters: sys@yangdb > select * from dba_profiles where profile='DEFAULT' and RESOURCE_NAME like 'PASSWORD%' PROFILE RESOURCE_NAME RESOURCE LIMIT-- DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 10DEFAULT PASSWORD_LIFE_TIME PASSWORD UNLIMITEDDEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITEDDEFAULT PASSWORD_REUSE_MAX PASSWORD UNLIMITEDDEFAULT PASSWORD The _ VERIFY_FUNCTION PASSWORD NULLDEFAULT PASSWORD_LOCK_TIME PASSWORD 1DEFAULT PASSWORD_GRACE_TIME PASSWORD 7FAILED_LOGIN_ATTEMPTS integer sets the number of times you can fail when logging in to the ORACLE database. Once a user attempts to log in to the database at this value, the user's account is locked and can only be unlocked by DBA. PASSWORD_LIFE_TIME sets the validity period of the password (number of days), and once this time is exceeded, the password must be reset. The default is UNLIMITED.PASSWORD_REUSE_TIME. Many systems do not allow users to re-enable passwords that have been used in the past. The resource item sets the number of days it will take for an invalid password before the user can reuse the password. The default is the number of times UNLIMITED.PASSWORD_REUSE_MAX must reset a previously used password before it can be re-enabled (the number of times it is reused). PASSWORD_LOCK_TIME sets the number of days the account is locked (when login failure reaches FAILED_LOGIN_ATTEMPTS). PASSWORD_GRACE_TIME sets a grace period for the password to be reset before the password expires. When the password expires, a warning message displays the number of days when you log in. If the password is not changed within the grace days, the password will become invalid. PASSWORD_VERITY_FUNCTION this resource entry allows a PL/SQL to be called to authenticate the password. ORACLE has provided scripts for the application, but users can develop their own verification scripts if they want. The setting of this parameter is the name of the PL/SQL function. The default is NULL.

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.