{"id":186,"date":"2011-07-26T04:35:53","date_gmt":"2011-07-26T04:35:53","guid":{"rendered":"https:\/\/adilfahim.com\/myblog\/?p=186"},"modified":"2011-07-26T04:35:53","modified_gmt":"2011-07-26T04:35:53","slug":"brbackupbrarchive-failed-warning-ora-28011-the-account-will-expire-soon-change-your-password-now","status":"publish","type":"post","link":"https:\/\/adilfahim.com\/myblog\/brbackupbrarchive-failed-warning-ora-28011-the-account-will-expire-soon-change-your-password-now\/","title":{"rendered":"BRBACKUP\/BRARCHIVE failed, warning ORA-28011: the account will expire soon; change your password now."},"content":{"rendered":"<p><strong>New LIMIT for &#8216;PASSWORD_LIFE_TIME&#8217; in Oracle 11g.<\/strong><\/p>\n<p>One of my colleague go through this solution.\u00a0 Hope this helps you.<\/p>\n<p>Some thing new in 11g, If you are using please rectify.<\/p>\n<div dir=\"ltr\">Any user in Oracle\u00a011g using DEFAULT profile, has a default limit for\u00a0PASSWORD_LIFE_TIME is 180 days, then that will be in GRACE period (Will never expire.)<\/div>\n<div dir=\"ltr\">So after 180 days it will throw the Warning ORA-28011: the account will expire soon; change your password now.<\/div>\n<div dir=\"ltr\">As a part of this if backups or jobs are scheduled from those user IDs, will start failing after 180 days.<\/div>\n<div dir=\"ltr\"><\/div>\n<div dir=\"ltr\"><strong>Note<\/strong>: Prior to Oracle Database\u00a011g Release 2 (11.2), the default was UNLIMITED. Ref SAP Note <strong><span style=\"text-decoration: underline;\"><span style=\"color: #0000ff;\">1519872<\/span><\/span><\/strong><\/div>\n<div dir=\"ltr\"><\/div>\n<div dir=\"ltr\"><span style=\"text-decoration: underline;\">Script to find out the same is,<\/span><\/div>\n<div dir=\"ltr\">select LIMIT,\u00a0RESOURCE_NAME from\u00a0dba_profiles where\u00a0 PROFILE = &#8216;DEFAULT&#8217; and\u00a0\u00a0RESOURCE_NAME in (&#8216;PASSWORD_GRACE_TIME&#8217;,&#8217;PASSWORD_LIFE_TIME&#8217;);<\/div>\n<div dir=\"ltr\"><\/div>\n<div dir=\"ltr\"><span style=\"text-decoration: underline;\">Remedy is,<\/span><\/div>\n<div dir=\"ltr\">ALTER PROFILE DEFAULT LIMIT\u00a0PASSWORD_LIFE_TIME UNLIMITED;<\/div>\n","protected":false},"excerpt":{"rendered":"<p>New LIMIT for &#8216;PASSWORD_LIFE_TIME&#8217; in Oracle 11g. One of my colleague go through this solution.\u00a0 Hope this helps you. Some thing new in 11g, If you are using please rectify. Any user in Oracle\u00a011g using DEFAULT profile, has a default limit for\u00a0PASSWORD_LIFE_TIME is 180 days, then that will be in GRACE period (Will never expire.) [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[5,8],"tags":[40,45,46,105,117,138,156,157,162,165,187,205],"class_list":["post-186","post","type-post","status-publish","format-standard","hentry","category-it","category-sap-updates","tag-backup","tag-brarchive","tag-brbackup","tag-failed","tag-grace","tag-limit","tag-oracle","tag-oracle-11g","tag-password","tag-period","tag-sap","tag-sapnote"],"_links":{"self":[{"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/posts\/186","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/comments?post=186"}],"version-history":[{"count":0,"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/posts\/186\/revisions"}],"wp:attachment":[{"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/media?parent=186"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/categories?post=186"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/tags?post=186"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}