Orale user password expiration processing
Log in with a user with administrative privileges
1. Check which user's proifle is, usually default:
SELECT username,PROFILE FROM dba_users
2. Check the password validity settings for the specified profile (such as default):
Sql > SELECT * FROM dba_profiles 's WHERE s.profileholders default AND resource_name='PASSWORD_LIFE_TIME'
Or: sql > SELECT * FROM dba_profiles WHERE resource_name='PASSWORD_LIFE_TIME'
3. Change the password validity period from the default 180 days to "unlimited":
Sql > ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED
Note: there is no need to restart the database after modification, it will take effect immediately
4. Change the password
Alter user username identified by password
