SyntaxFix
Write A Post
Hire A Developer
Questions
Check "PASSWORD_LIFE_TIME" by
Sql > select * from dba_profiles;
select * from dba_profiles;
Set to Never expire
Sql> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
Then reset the password of locked user.