{"id":945,"date":"2013-12-07T13:40:07","date_gmt":"2013-12-07T13:40:07","guid":{"rendered":"http:\/\/blogs.silicontechnix.com\/?p=945"},"modified":"2013-12-07T13:40:07","modified_gmt":"2013-12-07T13:40:07","slug":"ora-28002-the-password-will-expire-within-7-days","status":"publish","type":"post","link":"https:\/\/blogs.silicontechnix.com\/?p=945","title":{"rendered":"ORA-28002: the password will expire within 7 days"},"content":{"rendered":"<p>ORA-28002: the password will expire within 7 days<br \/>\nCause: The user&#8217;s account is about to about to expire and the password needs<br \/>\nto be changed.<br \/>\nAction: Change the password or contact the database administrator.<\/p>\n<p>Reference: Oracle Documentation<br \/>\n[roboshot url=&#8221;https:\/\/blogs.silicontechnix.com\/?p=945&#8243; width=&#8221;80&#8243; newpage=&#8221;TRUE&#8221;]<br \/>\nSolutions:<!--more--><\/p>\n<p>1) Simply change the password to avoid it temporary<\/p>\n<pre class=\"brush:sql\">[oracle@db ~]$ sqlplus scott\/tiger\r\n\r\nSQL*Plus: Release 11.2.0.1.0 Production on Wed Jun 20 14:08:01 2012\r\n\r\nCopyright (c) 1982, 2009, Oracle. All rights reserved.\r\n\r\nERROR:\r\nORA-28002: the password will expire within 7 days\r\n\r\nConnected to:\r\nOracle Database 11g Release 11.2.0.1.0 - 64bit Production\r\n\r\nSQL&gt; PASSWORD\r\nChanging password for SCOTT\r\nOld password:\r\nNew password:\r\nRetype new password:\r\nPassword changed<\/pre>\n<p>2) Set PASSWORD_LIFE_TIME of the profile assigned user to UNLIMITED<br \/>\nthen change the password to avoid it permanently<\/p>\n<pre class=\"brush:sql\">[oracle@db ~]$ sqlplus scott\/tiger\r\n\r\nSQL*Plus: Release 11.2.0.1.0 Production on Wed Jun 20 14:08:01 2012\r\n\r\nCopyright (c) 1982, 2009, Oracle. All rights reserved.\r\n\r\nERROR:\r\nORA-28002: the password will expire within 7 days\r\n\r\nConnected to:\r\nOracle Database 11g Release 11.2.0.1.0 - 64bit Production\r\n\r\nSQL&gt; connect \/ as sysdba\r\nConnected.\r\n\r\nSQL&gt; SELECT PROFILE FROM dba_users WHERE username = 'SCOTT';\r\n\r\nPROFILE\r\n------------------------------\r\nDEFAULT\r\n\r\nSQL&gt; SELECT LIMIT FROM DBA_PROFILES WHERE PROFILE='DEFAULT'\r\nAND RESOURCE_NAME='PASSWORD_LIFE_TIME';\r\n\r\nLIMIT\r\n----------------------------------------\r\n60\r\n\r\nSQL&gt; ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;\r\n\r\nProfile altered.\r\n\r\nSQL&gt; SELECT ACCOUNT_STATUS FROM DBA_USERS WHERE USERNAME='SCOTT';\r\n\r\nACCOUNT_STATUS\r\n--------------------------------\r\nEXPIRED(GRACE)<\/pre>\n<pre class=\"brush:sql\">SQL&gt; connect scott\/tiger\r\nConnected.\r\n\r\nSQL&gt; PASSWORD\r\nChanging password for SCOTT\r\nOld password:\r\nNew password:\r\nRetype new password:\r\nPassword changed<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>ORA-28002: the password will expire within 7 days Cause: The user&#8217;s account is about to about to expire and the password needs to be changed. Action: Change the password or contact the database administrator. Reference: Oracle Documentation [roboshot url=&#8221;https:\/\/blogs.silicontechnix.com\/?p=945&#8243; width=&#8221;80&#8243; newpage=&#8221;TRUE&#8221;] Solutions:<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_s2mail":"no","jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false},"version":2}},"categories":[95],"tags":[432,430,429,433,385,76,431],"class_list":["post-945","post","type-post","status-publish","format-standard","hentry","category-system-administration","tag-11g","tag-7-days","tag-expire","tag-ora-28002","tag-oracle","tag-password","tag-password-expire-in-7-days"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p12j6H-ff","_links":{"self":[{"href":"https:\/\/blogs.silicontechnix.com\/index.php?rest_route=\/wp\/v2\/posts\/945","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.silicontechnix.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.silicontechnix.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.silicontechnix.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.silicontechnix.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=945"}],"version-history":[{"count":2,"href":"https:\/\/blogs.silicontechnix.com\/index.php?rest_route=\/wp\/v2\/posts\/945\/revisions"}],"predecessor-version":[{"id":948,"href":"https:\/\/blogs.silicontechnix.com\/index.php?rest_route=\/wp\/v2\/posts\/945\/revisions\/948"}],"wp:attachment":[{"href":"https:\/\/blogs.silicontechnix.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=945"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.silicontechnix.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=945"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.silicontechnix.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=945"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}