Cara menangani error ORA-28001: THE PASSWORD HAS EXPIRED

Berikut cara menangani ORA-28001: THE PASSWORD HAS EXPIRED


1. Konek ke oracle database sebagai sysdba

C:\Users\Siry>sqlplus / as sysdba

2. Jalankan query berikut set password life time ke unlimitied.

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
Profile altered.

3. Set password untuk locked password

SQL> ALTER USER user_name IDENTIFIED BY password;
User altered.

4. Unlock akun user

SQL> ALTER USER user_name ACCOUNT UNLOCK;
User altered.

5. memastikan user tidak terlock lagi

SQL> SELECT USERNAME,ACCOUNT_STATUS FROM DBA_USERS;

USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
HR                             OPEN
ANONYMOUS                      OPEN
APEX_040000                    LOCKED
FLOWS_FILES                    LOCKED
XDB                            EXPIRED & LOCKED
CTXSYS                         EXPIRED & LOCKED
MDSYS                          EXPIRED & LOCKED
SYSTEM                         OPEN
SYS                            OPEN
user_name                      OPEN
SIRY                           OPEN

USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
APEX_PUBLIC_USER               LOCKED
XS$NULL                        EXPIRED & LOCKED
OUTLN                          EXPIRED & LOCKED

15 rows selected.

Demikian langkah-langkah untuk menangani error ORA-28001: THE PASSWORD HAS EXPIRED pada oracle database.

Sumber : https://hecpv.wordpress.com/2014/10/16/how-to-solve-ora-28001-the-password-has-expired/