Ao realizar a análise de uma rotina de backup Data Pump me deparei com seguinte erro no log abaixo:
|
1 2 3 4 |
EXP-00056: ORACLE error 28001 encountered ORA-28001: the password has expired EXP-00030: Unexpected End-Of-File encountered while reading input EXP-00000: Export terminated unsuccessfully |
Verificando contas com senha expirada.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 |
SYSTEM@ORCL> select username, account_status from dba_users where lock_date is not null; USERNAME ACCOUNT_STATUS ------------------------------ -------------------------------- FLOWS_FILES EXPIRED & LOCKED MDSYS EXPIRED & LOCKED ORDDATA EXPIRED & LOCKED ORDSYS EXPIRED & LOCKED CTXSYS EXPIRED & LOCKED ANONYMOUS EXPIRED & LOCKED EXFSYS EXPIRED & LOCKED OUTLN EXPIRED & LOCKED DIP EXPIRED & LOCKED APEX_PUBLIC_USER EXPIRED & LOCKED WMSYS EXPIRED & LOCKED XDB EXPIRED & LOCKED ORACLE_OCM EXPIRED & LOCKED APPQOSSYS EXPIRED & LOCKED ORDPLUGINS EXPIRED & LOCKED XS$NULL EXPIRED & LOCKED APEX_030200 EXPIRED & LOCKED SI_INFORMTN_SCHEMA EXPIRED & LOCKED SYSTEM EXPIRED & LOCKED 18 rows selected. |
Analisando profile do usuário SYSTEM
|
1 2 3 4 5 |
SYSTEM@ORCL > select username, profile from dba_users where username='SYSTEM'; USERNAME PROFILE ------------------------------ ------------------------------ SYSTEM DEFAULT |
Analisando DBA_PROFILES
|
1 2 3 4 5 |
SYSTEM@ORCL> select RESOURCE_NAME, LIMIT from dba_profiles where RESOURCE_NAME='PASSWORD_LIFE_TIME'; RESOURCE_NAME LIMIT -------------------------------- ---------------------------------------- PASSWORD_LIFE_TIME 180 |
Está definido 180 dias por default.
Alterando Profile para ilimitado.
|
1 2 3 |
SYSTEM@ORCL> ALTER PROFILE default LIMIT PASSWORD_LIFE_TIME UNLIMITED; Profile altered. |
Verificando novamente DBA_PROFILES.
|
1 2 3 4 5 |
SYSTEM@ORCL> select RESOURCE_NAME, LIMIT from dba_profiles where RESOURCE_NAME='PASSWORD_LIFE_TIME'; RESOURCE_NAME LIMIT -------------------------------- ---------------------------------------- PASSWORD_LIFE_TIME UNLIMITED |
Alterando a senha.
|
1 2 |
SYSTEM@ORCL> ALTER USER system IDENTIFIED BY password; User altered. |
Desbloqueando a conta.
|
1 2 |
SYSTEM@ORCL> ALTER USER system ACCOUNT UNLOCK; User altered. |