Jump to Navigation

188 - ORA-28002: the password will expire within string days

It give you an error ORA-28002: the password will expire within string days.
You installed Oracle Database as it is, the default password policy is set to 180 days. You could not change
that default settings.

1. Check the profile for specific user

# sqlplus / as sysdba
SQL> SELECT profile FROM dba_users WHERE username = 'USER01';

2. Check the default setting

SQL> SELECT resource_name,resource_type, limit FROM dba_profiles WHERE profile='DEFAULT';

3. If you want unlimited on PASSWORD_LIFE_TIME

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

4. If you want to change the password for a specific user

SQL> ALTER user system identified by "pass123";

5. If you want to lock a specific user

SQL> ALTER user user01 account lock;

 

 

Oracle:


Main menu 2

Story | by Dr. Radut