The cause of triggering this error and related factors
is due to the default profile setting "Password_life_time=180 days" in oracle11g, which is in Oracle 11g
There is a password expiration issue.
Second, the error phenomenon:
ORA-28000 errors are reported after the user is locked out, and you are prompted that you cannot log on to the database sql> Conn system/oracleerror:ora-28000:the account was lockedwarning:you are no Longer connected to ORACLE. Sql>
Third, the solution:
Follow these steps: 1, to see which user's proifle is, generally default:sql> select Username,profile from dba_users where username= ' SYSTEM '; USERNAME profile------------------------------------------------------------SYSTEM defaultsql>2, view password expiration settings for the specified profile (such as default):sql> SELECT * from dba_profiles s WHERE s.profile= ' DEFAULT ' and Reso Urce_name= ' Password_life_time '; Profile resource_name RESOURCE LIMIT------------------------------------------- -------------------------------------------------------------------DEFAULT password_life_time PASSWORD 180day3, change the password validity period from the default of 180 days to "unlimited": Sql>alter profile default limitpassword_life_timeunlimited; no restart after modification The database will be active immediately. 4, after the modification, has not been prompted ORA-28002 warning account will not encounter the same prompt, the account has been prompted to unlock only. $sqlplus/as sysdbasql> alter user SYSTEM account unlock; User Altered.5, if you are unable to log in, perform the re-configuration once password is OK. (As good as the original password) sql> alter USER system identified by Oracle; User altered.
oracle11g Startup parameter Resource_limit whether it is set to False or true, the password validity period is valid and must be modified in the above manner. The account name above is changed according to the account name you are actually using.
Oracle 11g Password expiration is locked ORA-28000 the account is locked