ORACLE ERROR: Ora-28002: password will expire in 7 days

sqlplus /nolog

conn /as sysdba

SELECT username,PROFILE FROM dba_users;

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

alter user smailes identified by  123456;

Leave a Reply