Modify Database Password expiration issues

Log in to Sqlplus:1, Select username,profile from dba_users;2,  select * from with the system account  dba_profiles where resource_name= ' Password_life_time '; 3, alter profile default  LIMIT&NBSP;PASSWORD_LIFE_TIME&NBSP;UNLIMITED;&NBSP;4, ALTER user < username > identified by < original password >;5, commit;   "Problem description"   Prompt "password expires after ora-28002:7 days" when logging into Oracle database using Toad or Sqlplus. Cause/Trigger   determined is due to the default setting of "Password_life_time=180 days" in oracle11g.   "Impact and risk" impact   password expiration, business processes connect to database exceptions and affect business use. Issue frequency   After the database password expires, the connection fails once the business process restarts. Solution   Follow these steps:  1, under CMD, log into the database with Sqlplus, with the following statements: Sqlplus sys/[email protected] as SYSDBA 2, See which proifle the user is, typically default:sql>select username,profile from dba_users; 3, viewing the password expiration setting for the specified profile (such as default):  sql>select * from Dba_profiles s WHERE s.profile= ' DEFAULT ' and resource_name= ' password_life_time ';( If it is possible to say "you are not selected line", use this statement as a hint, select * from Dba_profiles WHERE resource_name= ' password_life_time ';) 4, the password is valid from the default180 days modified to "unlimited":  sql>alter profile DEFAULT LIMIT password_life_time UNLIMITED; You do not need to restart the database after you modify it, it takes effect immediately.  5, modified, has not been prompted ORA-28002 warning account will not encounter the same prompt; The account that has been prompted must change the password again, for example: sql> alter user SMSC identified by < The original password >----do not need to change the new password 6, the use of modified user login, if the "ORA-28000: User has been locked", unlock    sql > Alter user db_user account unlock;   sql > commit;

Modify Database Password expiration issues