7 Replies Latest reply on Feb 5, 2013 1:42 PM by user647652

    ORA-28002: the password will expire within 18446744073709551193 days

    user647652
      Got this logging into Oracle 10.2.0.5.0:
      SQL> conn ersweb@comsat
      Enter password:
      ERROR:
      ORA-28002: the password will expire within 18446744073709551193 days

      Why would I get this message?

      The login profile is DEFAULT.


      SQL> select * from dba_profiles where profile = 'DEFAULT';

      PROFILE RESOURCE_NAME RESOURCE LIMIT
      ------------------------------ -------------------------------- -------- ---------
      DEFAULT COMPOSITE_LIMIT KERNEL UNLIMITED
      DEFAULT SESSIONS_PER_USER KERNEL UNLIMITED
      DEFAULT CPU_PER_SESSION KERNEL UNLIMITED
      DEFAULT CPU_PER_CALL KERNEL UNLIMITED
      DEFAULT LOGICAL_READS_PER_SESSION KERNEL UNLIMITED
      DEFAULT LOGICAL_READS_PER_CALL KERNEL UNLIMITED
      DEFAULT IDLE_TIME KERNEL UNLIMITED
      DEFAULT CONNECT_TIME KERNEL UNLIMITED
      DEFAULT PRIVATE_SGA KERNEL UNLIMITED
      DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 10
      DEFAULT PASSWORD_LIFE_TIME PASSWORD UNLIMITED
      DEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITED
      DEFAULT PASSWORD_REUSE_MAX PASSWORD UNLIMITED
      DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD NULL
      DEFAULT PASSWORD_LOCK_TIME PASSWORD UNLIMITED
      DEFAULT PASSWORD_GRACE_TIME PASSWORD UNLIMITED