19 9월

oracle : the password has expried to unlimited Hint

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 unlimited

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

Profile altered.

Recheck 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

UNLIMITED

by