Oracle error 28001 - the password has expired

1. connect to database using sys users.

2. Sql > select * from dba_profiles; --> result PASSWORD_LIFE_TIME PASSWORD 180

3. Sql> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

4. Sql > select * from dba_profiles;

5. SQL> select 'alter user "'||d.username||'" identified by values '''||u.password||''';' c

from dba_users d, sys.user$ u
where d.username = upper('&&username')
and u.user# = d.user_id;

&&username = ganti dengan user nama user yg mau diaktifkan;

hasil querynya dipakai untuk proses update usernya: misalkan

SQL> alter user "SCOTT" identified by values 'F894844C34402B67';

terakhir cek query ini:

sql> select username,account_status from dba_users;