{"id":399,"date":"2018-07-17T10:25:41","date_gmt":"2018-07-17T13:25:41","guid":{"rendered":"http:\/\/rodrigosilvaesilva.com.br\/?p=399"},"modified":"2018-07-17T10:25:41","modified_gmt":"2018-07-17T13:25:41","slug":"ora-28001-the-password-has-expired","status":"publish","type":"post","link":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/2018\/07\/17\/ora-28001-the-password-has-expired\/","title":{"rendered":"ORA-28001: the password has expired"},"content":{"rendered":"<p>Ao realizar a an\u00e1lise de uma rotina de backup Data Pump me deparei com seguinte erro no log abaixo:<\/p>\n<pre class=\"lang:plsql decode:true\">EXP-00056: ORACLE error 28001 encountered\nORA-28001: the password has expired\nEXP-00030: Unexpected End-Of-File encountered while reading input\nEXP-00000: Export terminated unsuccessfully<\/pre>\n<p>Verificando contas com senha expirada.<\/p>\n<pre class=\"lang:plsql decode:true \">SYSTEM@ORCL&gt; select username, account_status from dba_users where lock_date is not null;\n\nUSERNAME                       ACCOUNT_STATUS\n------------------------------ --------------------------------\nFLOWS_FILES                    EXPIRED &amp; LOCKED\nMDSYS                          EXPIRED &amp; LOCKED\nORDDATA                        EXPIRED &amp; LOCKED\nORDSYS                         EXPIRED &amp; LOCKED\nCTXSYS                         EXPIRED &amp; LOCKED\nANONYMOUS                      EXPIRED &amp; LOCKED\nEXFSYS                         EXPIRED &amp; LOCKED\nOUTLN                          EXPIRED &amp; LOCKED\nDIP                            EXPIRED &amp; LOCKED\nAPEX_PUBLIC_USER               EXPIRED &amp; LOCKED\nWMSYS                          EXPIRED &amp; LOCKED\nXDB                            EXPIRED &amp; LOCKED\nORACLE_OCM                     EXPIRED &amp; LOCKED\nAPPQOSSYS                      EXPIRED &amp; LOCKED\nORDPLUGINS                     EXPIRED &amp; LOCKED\nXS$NULL                        EXPIRED &amp; LOCKED\nAPEX_030200                    EXPIRED &amp; LOCKED\nSI_INFORMTN_SCHEMA             EXPIRED &amp; LOCKED\nSYSTEM                         EXPIRED &amp; LOCKED\n\n18 rows selected.\n<\/pre>\n<p>Analisando profile do usu\u00e1rio SYSTEM<\/p>\n<pre class=\"lang:plsql decode:true\">SYSTEM@ORCL &gt; select username, profile from dba_users where username='SYSTEM';\n\nUSERNAME                       PROFILE\n------------------------------ ------------------------------\nSYSTEM                         DEFAULT\n<\/pre>\n<p>Analisando DBA_PROFILES<\/p>\n<pre class=\"lang:plsql decode:true\">SYSTEM@ORCL&gt; select RESOURCE_NAME, LIMIT from dba_profiles where RESOURCE_NAME='PASSWORD_LIFE_TIME';\n\nRESOURCE_NAME                    LIMIT\n-------------------------------- ----------------------------------------\nPASSWORD_LIFE_TIME               180\n<\/pre>\n<p>Est\u00e1 definido 180 dias por default.<\/p>\n<p>Alterando Profile para ilimitado.<\/p>\n<pre class=\"lang:plsql decode:true\">SYSTEM@ORCL&gt; ALTER PROFILE default LIMIT PASSWORD_LIFE_TIME UNLIMITED;\n\nProfile altered.\n<\/pre>\n<p>Verificando novamente DBA_PROFILES.<\/p>\n<pre class=\"lang:plsql decode:true\">SYSTEM@ORCL&gt; select RESOURCE_NAME, LIMIT from dba_profiles where RESOURCE_NAME='PASSWORD_LIFE_TIME';\n\nRESOURCE_NAME                    LIMIT\n-------------------------------- ----------------------------------------\nPASSWORD_LIFE_TIME               UNLIMITED\n<\/pre>\n<p>Alterando a senha.<\/p>\n<pre class=\"lang:plsql decode:true \">SYSTEM@ORCL&gt; ALTER USER system IDENTIFIED BY password;         \nUser altered.<\/pre>\n<p>Desbloqueando a conta.<\/p>\n<pre class=\"lang:default decode:true \">SYSTEM@ORCL&gt; ALTER USER system ACCOUNT UNLOCK;\nUser altered.<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ao realizar a an\u00e1lise de uma rotina de backup Data Pump me deparei com seguinte erro no log abaixo: 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. SYSTEM@ORCL&gt; select username, account_status from dba_users where lock_date is not&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[136,137,138,245],"class_list":["post-399","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-exp-00000","tag-exp-00030","tag-exp-00056","tag-ora-28001"],"_links":{"self":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/399","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=399"}],"version-history":[{"count":0,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/399\/revisions"}],"wp:attachment":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=399"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=399"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=399"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}