Oracle 11g error ORA-28000 the account is locked

Oracle 11g error ORA-28000 the account is locked I. the cause and related factors of this error are caused by the default setting of "PASSWORD_LIFE_TIME = 180 days" in the default profile in oracle11g, there is a password expiration problem in Oracle 11g. Www.2cto.com 2. error phenomenon: After the user is locked, the ORA-28000 error will be reported, and prompt cannot log on to the Database SQL> conn system/oracleERROR: ORA-28000: the account is locked Warning: you are no longer connected to ORACLE. SQL> 3. Solution: perform the following operations: 1. Check which proifle is used by the user, generally default: SQL> select username, profile from dba_users where username = 'system'; username profile www.2cto.com ------------------------------ ---------------------------- system defaultsql> 2. view the specified Overview Set the password validity period for files (such as default): SQL> SELECT * FROM dba_profiles s WHERE s. profile = 'default' AND resource_name = 'password _ LIFE_TIME '; PROFILE RESOURCE_NAME resource limit ---------------------------- expiration -------- modify DEFAULT PASSWORD_LIFE_TIME PASSWORD 180DAY3. Change the PASSWORD validity period from the DEFAULT 180 days to "UNLIMITED": SQL> ALTER PROFILE DEFAULT LIMITPASSWORD_LIFE_TIME UNLIMITED; It takes effect immediately without restarting the database. Www.2cto.com 4. After modification, the account that has not been prompted for a ORA-28002 warning will no longer receive the same prompt; the account that has been prompted only needs to be unlocked. $ Sqlplus/as sysdbaSQL> alter user system account unlock; User altered. (Just like the original password) SQL> alter user system identified by oracle; User altered. the oracle11g startup parameter resource_limit takes effect regardless of whether it is set to false or true. Therefore, you must modify the password in the preceding method. The preceding account name must be changed based on the actual account name. From the wuweilong Column