I. Change Password
1) Change Password sql>alter user User01 identified by password;2) Change Password and unlocksql>alter user User01 account unlock identified by P Assword;
3) Unlocking operation
Sql>alter User User01 Account unlock
Two. Set Password expiration
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:
$sqlplus/as SYSDBA
sql> alter user SMSC identified by < original password >----do not change the new password
Oracle Change Password and set password expiration date