First, the causes of this error and related factors
is due to "password_life_time=180 Day" set in default profile in oracle11g, which in Oracle 11g is
There is a password expiration problem.
Second, the error phenomenon:
When the user is locked out, they report ORA-28000 errors and are prompted not to log on to the database
sql> conn system/oracle
Error: Ora-28000:the account is
locked
warning:you are no longer connected to ORACLE.
Sql>
Third, the solution:
Follow these steps: 1, to view the user's proifle is which, is generally default:sql> select Username,profile from dba_users where username= ' SYSTEM '; USERNAME profile------------------------------------------------------------SYSTEM Default sql> 2, view password expiration settings for a specified profile (such as DEFAULT): sql> SELECT * from dba_profiles s WHERE s.profile= ' DEFAULT '
D resource_name= ' password_life_time '; Profile resource_name RESOURCE LIMIT------------------------------------------ --------------------------------------------------------------------DEFAULT password_life_time
PASSWORD 180DAY 3, the password is valid from the default of 180 days modified to "unrestricted": Sql>alter profile default limitpassword_life_timeunlimited;
You do not need to restart the database after the modification, and will take effect immediately.
4, after the modification, has not been prompted ORA-28002 warning account will not encounter the same prompts, the account has been prompted to unlock the only.
$sqlplus/as sysdba sql> alter user SYSTEM account unlock;
User altered. 5, if you can not log in, the implementation of a password to configure the OK.
(As good as the original password) sql> alter USER system identified by Oracle; UserAltered.
oracle11g Startup Parameters Resource_limit whether set to False or true, the password validity period is valid and must be modified in the above way. The account name above is changed according to the account name that you are actually using.