The cause of triggering this error and related factors
This is due to the default profile setting "Password_life_time=180 days" in oracle11g. In Oracle 11g is
There are password expiration issues.
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, for example: 1, to see which proifle the user is. Usually default:sql> select Username,profile from dba_users where username= ' SYSTEM '; USERNAME profile------------------------------------------------------------SYSTEM DEFAULTSQL>2, view password validity settings for the specified profile (such as default):sql> SELECT * from dba_profiles s WHERE s.profile= ' default ' an D resource_name= ' password_life_time '; Profile resource_name RESOURCE LIMIT------------------------------------------- -------------------------------------------------------------------DEFAULT password_life_time PASSWORD 180day3, the PASSWORD validity period from the default of 180 days to change to "unlimited": Sql>alter profile default limitpassword_life_timeunlimited; Do not need to restart the database, will be effective immediately. 4, after the change. Accounts that have not been prompted for ORA-28002 warnings will not encounter the same prompt again. An account that has been prompted simply needs to be unlocked.$sqlplus/as sysdbasql> alter user SYSTEM account unlock; User Altered.5, assuming that you are not logged in. Run and reconfigure once password is OK. (As good as the original password) sql> alter USER system identified by Oracle; User altered.
oracle11g Startup Parameters Resource_limit whether set to False or True,password validity is valid, it must be changed in the above way. The account name above should be changed based on the actual use of account names.
Copyright notice: This article Bo Master original article. Blog, not reproduced without consent.
Oracle 11g password expired is locked for reporting ORA-28000 the account is locked