The connection database suddenly appears with the following exception
The following are the solutions that record the following
1, check the user's proifle is which, is generally default:
Sql>select username,profile from Dba_users;
2. View the 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. Change the password validity period from the default of 180 days 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.
4, after the modification, 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: Chinese test network
$sqlplus/as SYSDBA
sql> alter user SMSC identified by < original password >----do not change the new password
Modifying an Oracle user Password never expires