Oracle 11g User Password expiration solution __oracle

1, view the user's proifle is that, is generally default:sql>select username,profile from dba_users; 2. View password expiration settings for the specified profile (such as DEFAULT): Sql>select * from Dba_profiles s WHERE s.profile= ' DEFAULT ' and Resource_name= ' PASSWORD _life_time '; 3, the password will expire from the default of 180 days modified into "unrestricted": ALTER profile default LIMIT Password_life_time unlimited; 4, after the modification, has not been prompted ORA-28002 warning users will not encounter the same hint; the user who has been prompted must change the password again, for example: $sqlplus/as sysdba sql> alter user WAPGW ID Entified by < original password >----do not need to change the new password oracle11g startup parameter resource_limit The password validity period is valid regardless of whether it is set to False or True