{"id":120,"date":"2015-08-03T14:15:15","date_gmt":"2015-08-03T14:15:15","guid":{"rendered":"https:\/\/dbadave.co.uk\/?p=120"},"modified":"2016-02-09T22:43:05","modified_gmt":"2016-02-09T22:43:05","slug":"ora-28001-the-password-has-expired","status":"publish","type":"post","link":"https:\/\/dbadave.co.uk\/ora-28001-the-password-has-expired\/","title":{"rendered":"ORA-28001 The Password Has Expired"},"content":{"rendered":"

One error that shows its head a lot and always seems to confuse a lot of people is the “ORA-28001 The Password Has Expired<\/strong><\/em>” error.<\/p>\n

Starting with Oracle database 10g, if you do a default database installation then all passwords will default to expiring within 180 days. So what a lot of people find is that they install the Oracle database, configure their application to connect to it, everything is fine for six months and then suddenly the application stops working because the account it uses can no longer connect to the database.<\/p>\n

How To Turn Off Password Expiration<\/strong><\/em><\/h2>\n

Of course, having a robust security policy in place is always a good idea but you may not be too worried about setting passwords to expire in development or test environments. If that is the case it is a simple task to turn off the password expiration. The password expiry policy for each account is inherited from that account’s profile. You can find the account’s profile using the following SQL statement (obviously you should substitute the actual username in the Where clause):<\/p>\n

select profile from dba_users where username = ‘USERNAME’;<\/em><\/p>\n

You can check the profile’s password expiration policy using the following SQL statement (again, you should substitute the actual profile returned from the above SQL statement in the Where clause below):<\/p>\n

select password_life_time from dba_profiles where profile = ‘PROFILE’;<\/em><\/p>\n

If the password_life_time is set to anything other than “UNLIMITED’, then you have a password expiration policy set. To turn it off, use the following SQL statement:<\/p>\n

alter profile PROFILE limit password_life_time unlimited;<\/em><\/p>\n

If You Have Already Hit “The ORA-28001 The Password Has Expired” Error<\/strong><\/em><\/h2>\n

If you have already hit the “ORA-28001 The Password Has Expired” error, then you may have user accounts that have expired. To check the status of user accounts in the database you can execute the following SQL statement:<\/p>\n

select username, account_status, lock_date, expiry_date from dba_users order by username;<\/em><\/p>\n

If users show up with an account_status of “EXPIRED(GRACE)”, then this means their password has expired but they are still in the grace period where they can reset it themselves as their account is not yet locked.<\/p>\n

If the account_status is anything other than this, apart from “OPEN”, then the account has been locked and must be unlocked and the password changed. You can unlock the account using the SQL command:\u00a0alter user USERNAME account unlock;\u00a0<\/em>Then you can reset the password as follows:\u00a0alter user USERNAME identified by NEW_PASSWORD;<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

One error that shows its head a lot and always seems to confuse a lot of people is the “ORA-28001 The Password Has Expired” error. Starting with Oracle database 10g, if you do a default database installation then all passwords will default to expiring within 180 days. So what a lot of people find is … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":371,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[],"yoast_head":"\nORA-28001 The Password Has Expired (HOW TO FIX)<\/title>\n<meta name=\"description\" content=\"The "ORA-28001 The Password Has Expired" error is a common one due to Oracle defaults. Learn how to fix it and turn off password expiration. READ MORE NOW.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbadave.co.uk\/ora-28001-the-password-has-expired\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ORA-28001 The Password Has Expired (HOW TO FIX)\" \/>\n<meta property=\"og:description\" content=\"The "ORA-28001 The Password Has Expired" error is a common one due to Oracle defaults. Learn how to fix it and turn off password expiration. READ MORE NOW.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbadave.co.uk\/ora-28001-the-password-has-expired\/\" \/>\n<meta property=\"og:site_name\" content=\"DBA Dave - Oracle Training\" \/>\n<meta property=\"article:published_time\" content=\"2015-08-03T14:15:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-02-09T22:43:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/08\/ORA-28001-the-password-has-expired-error.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"770\" \/>\n\t<meta property=\"og:image:height\" content=\"340\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbadave.co.uk\/ora-28001-the-password-has-expired\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbadave.co.uk\/ora-28001-the-password-has-expired\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/dbadave.co.uk\/#\/schema\/person\/c51b3c9b3e2e2e9bbd141a719c024c40\"},\"headline\":\"ORA-28001 The Password Has Expired\",\"datePublished\":\"2015-08-03T14:15:15+00:00\",\"dateModified\":\"2016-02-09T22:43:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbadave.co.uk\/ora-28001-the-password-has-expired\/\"},\"wordCount\":432,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbadave.co.uk\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbadave.co.uk\/ora-28001-the-password-has-expired\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/08\/ORA-28001-the-password-has-expired-error.jpg\",\"articleSection\":[\"Oracle Errors\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbadave.co.uk\/ora-28001-the-password-has-expired\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbadave.co.uk\/ora-28001-the-password-has-expired\/\",\"url\":\"https:\/\/dbadave.co.uk\/ora-28001-the-password-has-expired\/\",\"name\":\"ORA-28001 The Password Has Expired (HOW TO FIX)\",\"isPartOf\":{\"@id\":\"https:\/\/dbadave.co.uk\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbadave.co.uk\/ora-28001-the-password-has-expired\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbadave.co.uk\/ora-28001-the-password-has-expired\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/08\/ORA-28001-the-password-has-expired-error.jpg\",\"datePublished\":\"2015-08-03T14:15:15+00:00\",\"dateModified\":\"2016-02-09T22:43:05+00:00\",\"description\":\"The \\\"ORA-28001 The Password Has Expired\\\" error is a common one due to Oracle defaults. Learn how to fix it and turn off password expiration. READ MORE NOW.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbadave.co.uk\/ora-28001-the-password-has-expired\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbadave.co.uk\/ora-28001-the-password-has-expired\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbadave.co.uk\/ora-28001-the-password-has-expired\/#primaryimage\",\"url\":\"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/08\/ORA-28001-the-password-has-expired-error.jpg\",\"contentUrl\":\"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/08\/ORA-28001-the-password-has-expired-error.jpg\",\"width\":770,\"height\":340,\"caption\":\"ORA-28001 The Password Has Expired Error\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbadave.co.uk\/ora-28001-the-password-has-expired\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbadave.co.uk\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ORA-28001 The Password Has Expired\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbadave.co.uk\/#website\",\"url\":\"https:\/\/dbadave.co.uk\/\",\"name\":\"DBA Dave - Oracle Training\",\"description\":\"Expert DBA Tips & Advice\",\"publisher\":{\"@id\":\"https:\/\/dbadave.co.uk\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbadave.co.uk\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbadave.co.uk\/#organization\",\"name\":\"DBA Dave\",\"url\":\"https:\/\/dbadave.co.uk\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbadave.co.uk\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2016\/02\/dba-dave-logo.png\",\"contentUrl\":\"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2016\/02\/dba-dave-logo.png\",\"width\":170,\"height\":50,\"caption\":\"DBA Dave\"},\"image\":{\"@id\":\"https:\/\/dbadave.co.uk\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbadave.co.uk\/#\/schema\/person\/c51b3c9b3e2e2e9bbd141a719c024c40\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbadave.co.uk\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3d6ad3f291a149878281854f13654bf0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3d6ad3f291a149878281854f13654bf0?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\/\/dbadave.co.uk\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ORA-28001 The Password Has Expired (HOW TO FIX)","description":"The \"ORA-28001 The Password Has Expired\" error is a common one due to Oracle defaults. Learn how to fix it and turn off password expiration. READ MORE NOW.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbadave.co.uk\/ora-28001-the-password-has-expired\/","og_locale":"en_US","og_type":"article","og_title":"ORA-28001 The Password Has Expired (HOW TO FIX)","og_description":"The \"ORA-28001 The Password Has Expired\" error is a common one due to Oracle defaults. Learn how to fix it and turn off password expiration. READ MORE NOW.","og_url":"https:\/\/dbadave.co.uk\/ora-28001-the-password-has-expired\/","og_site_name":"DBA Dave - Oracle Training","article_published_time":"2015-08-03T14:15:15+00:00","article_modified_time":"2016-02-09T22:43:05+00:00","og_image":[{"width":770,"height":340,"url":"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/08\/ORA-28001-the-password-has-expired-error.jpg","type":"image\/jpeg"}],"author":"admin","twitter_misc":{"Written by":"admin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbadave.co.uk\/ora-28001-the-password-has-expired\/#article","isPartOf":{"@id":"https:\/\/dbadave.co.uk\/ora-28001-the-password-has-expired\/"},"author":{"name":"admin","@id":"https:\/\/dbadave.co.uk\/#\/schema\/person\/c51b3c9b3e2e2e9bbd141a719c024c40"},"headline":"ORA-28001 The Password Has Expired","datePublished":"2015-08-03T14:15:15+00:00","dateModified":"2016-02-09T22:43:05+00:00","mainEntityOfPage":{"@id":"https:\/\/dbadave.co.uk\/ora-28001-the-password-has-expired\/"},"wordCount":432,"commentCount":0,"publisher":{"@id":"https:\/\/dbadave.co.uk\/#organization"},"image":{"@id":"https:\/\/dbadave.co.uk\/ora-28001-the-password-has-expired\/#primaryimage"},"thumbnailUrl":"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/08\/ORA-28001-the-password-has-expired-error.jpg","articleSection":["Oracle Errors"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbadave.co.uk\/ora-28001-the-password-has-expired\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbadave.co.uk\/ora-28001-the-password-has-expired\/","url":"https:\/\/dbadave.co.uk\/ora-28001-the-password-has-expired\/","name":"ORA-28001 The Password Has Expired (HOW TO FIX)","isPartOf":{"@id":"https:\/\/dbadave.co.uk\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbadave.co.uk\/ora-28001-the-password-has-expired\/#primaryimage"},"image":{"@id":"https:\/\/dbadave.co.uk\/ora-28001-the-password-has-expired\/#primaryimage"},"thumbnailUrl":"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/08\/ORA-28001-the-password-has-expired-error.jpg","datePublished":"2015-08-03T14:15:15+00:00","dateModified":"2016-02-09T22:43:05+00:00","description":"The \"ORA-28001 The Password Has Expired\" error is a common one due to Oracle defaults. Learn how to fix it and turn off password expiration. READ MORE NOW.","breadcrumb":{"@id":"https:\/\/dbadave.co.uk\/ora-28001-the-password-has-expired\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbadave.co.uk\/ora-28001-the-password-has-expired\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbadave.co.uk\/ora-28001-the-password-has-expired\/#primaryimage","url":"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/08\/ORA-28001-the-password-has-expired-error.jpg","contentUrl":"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/08\/ORA-28001-the-password-has-expired-error.jpg","width":770,"height":340,"caption":"ORA-28001 The Password Has Expired Error"},{"@type":"BreadcrumbList","@id":"https:\/\/dbadave.co.uk\/ora-28001-the-password-has-expired\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbadave.co.uk\/"},{"@type":"ListItem","position":2,"name":"ORA-28001 The Password Has Expired"}]},{"@type":"WebSite","@id":"https:\/\/dbadave.co.uk\/#website","url":"https:\/\/dbadave.co.uk\/","name":"DBA Dave - Oracle Training","description":"Expert DBA Tips & Advice","publisher":{"@id":"https:\/\/dbadave.co.uk\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbadave.co.uk\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbadave.co.uk\/#organization","name":"DBA Dave","url":"https:\/\/dbadave.co.uk\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbadave.co.uk\/#\/schema\/logo\/image\/","url":"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2016\/02\/dba-dave-logo.png","contentUrl":"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2016\/02\/dba-dave-logo.png","width":170,"height":50,"caption":"DBA Dave"},"image":{"@id":"https:\/\/dbadave.co.uk\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbadave.co.uk\/#\/schema\/person\/c51b3c9b3e2e2e9bbd141a719c024c40","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbadave.co.uk\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3d6ad3f291a149878281854f13654bf0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3d6ad3f291a149878281854f13654bf0?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/dbadave.co.uk\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/posts\/120"}],"collection":[{"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/comments?post=120"}],"version-history":[{"count":13,"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/posts\/120\/revisions"}],"predecessor-version":[{"id":372,"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/posts\/120\/revisions\/372"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/media\/371"}],"wp:attachment":[{"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/media?parent=120"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/categories?post=120"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/tags?post=120"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}