Conn as sysdba $ sqlplus /nolog SQL> conn /as sysdba Change password first! SQL> ALTER USER [USERID] IDENTIFIED by [PASSWORD]; Check password life time SQL> select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME'; PROFILE RESOURCE_NAME RESOURCE ------------------------------ -------------------------------- -------- LIMIT ---------------------------------------- DEFAULT PASSWORD_LIFE_TIME PASSWORD 180 Set password life time to […]