{"id":638,"date":"2018-07-05T13:04:36","date_gmt":"2018-07-05T13:04:36","guid":{"rendered":"http:\/\/dbtut.com\/?p=638"},"modified":"2018-11-08T11:37:04","modified_gmt":"2018-11-08T11:37:04","slug":"ora-28001-the-password-has-expired","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/07\/05\/ora-28001-the-password-has-expired\/","title":{"rendered":"ORA-28001: the password has expired"},"content":{"rendered":"

 <\/p>\n

When the user password expires, we get the error “ORA-28001: the password has expired<\/a>“.<\/p>\n

The expiration date of the user’s password is defined in the profile used by the user.<\/p>\n

You can find the details in the article titled “How To Create Oracle Profiles<\/a>“.<\/p>\n

To remove the expire of the user, we are connecting to the database via TOAD, and as you can see in the following screen shot, we select the Users tab on the left.<\/p>\n

Expired user appears with the x sign as shown below.<\/p>\n

We click on this user and we take the script on the right and edit it as follows.<\/p>\n

ALTER USER xUser\r\nIDENTIFIED BY VALUES 'S:B68277F2DDFB745BC95A95674BRT6YUHL34RT8UKL';<\/pre>\n
 <\/p>\n
In Oracle 12C, we can not do this in this way.<\/p>\n
To get the user script in Oracle12c, you can read the article titled “How To Get User’s Password With Hash On Oracle 12c<\/a>“.<\/p>\n
<\/p>\n
 <\/p>\n
When you run this script, you may get an error like the following.<\/p>\n
ORA-28007: the password cannot be reused<\/em><\/p>\n
<\/p>\n
 <\/p>\n
The reason you get this error is the PASSWORD_REUSE_MAX parameter, which is defined in the profile used by the user.<\/p>\n
You can see the user’s profile in the user’s create script.<\/p>\n
We select Profiles from the tab on the left side as below and click on Script in the right side.<\/p>\n
We copy the resulting script and paste it on a query screen in the Editor.<\/p>\n
We delete the line that passed the DROP phrase. And we change the CREATE expression to ALTER.<\/p>\n
We change the PASSWORD_REUSE_MAX parameter to UNLIMITED and run the script.<\/p>\n
<\/p>\n
 <\/p>\n
As I mentioned above, after modifying the profile used by the user, we run the script I mentioned at the beginning of the article to “alter” the user.<\/p>\n
Finally, remember to alter the profile to its original state.<\/p>\n
In the script that starts with “ALTER PROFILE”, you must run the script again by reversing the PASSWORD_REUSE_MAX parameter to its previous state.<\/p>\n\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
  When the user password expires, we get the error “ORA-28001: the password has expired“. The expiration date of the user’s password is defined in the profile used by the user. You can find the details in the article titled “How To Create Oracle Profiles“. To remove the expire of the user, we are connecting …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","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,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[714,713,710,716,715,712,369,717,711],"class_list":["post-638","post","type-post","status-publish","format-standard","","category-oracle","tag-alter-profile","tag-ora-28001","tag-ora-28001-the-password-has-expired","tag-ora-28007","tag-ora-28007-the-password-cannot-be-reused","tag-password-expired","tag-password_reuse_max","tag-the-password-cannot-be-reused","tag-the-password-has-expired"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":445,"today_views":0},"yoast_head":"\nORA-28001: the password has expired - Database Tutorials<\/title>\n<meta name=\"description\" content=\"ORA-28001: the password has expired\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/07\/05\/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 - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"ORA-28001: the password has expired\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/07\/05\/ora-28001-the-password-has-expired\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-05T13:04:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-08T11:37:04+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/596.png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\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:\/\/dbtut.com\/index.php\/2018\/07\/05\/ora-28001-the-password-has-expired\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/05\/ora-28001-the-password-has-expired\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"ORA-28001: the password has expired\",\"datePublished\":\"2018-07-05T13:04:36+00:00\",\"dateModified\":\"2018-11-08T11:37:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/05\/ora-28001-the-password-has-expired\/\"},\"wordCount\":333,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/05\/ora-28001-the-password-has-expired\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/596.png\",\"keywords\":[\"ALTER PROFILE\",\"ORA-28001\",\"ORA-28001: the password has expired\",\"ORA-28007\",\"ORA-28007: the password cannot be reused\",\"password expired\",\"PASSWORD_REUSE_MAX\",\"the password cannot be reused\",\"the password has expired\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/07\/05\/ora-28001-the-password-has-expired\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/05\/ora-28001-the-password-has-expired\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/05\/ora-28001-the-password-has-expired\/\",\"name\":\"ORA-28001: the password has expired - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/05\/ora-28001-the-password-has-expired\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/05\/ora-28001-the-password-has-expired\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/596.png\",\"datePublished\":\"2018-07-05T13:04:36+00:00\",\"dateModified\":\"2018-11-08T11:37:04+00:00\",\"description\":\"ORA-28001: the password has expired\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/05\/ora-28001-the-password-has-expired\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/07\/05\/ora-28001-the-password-has-expired\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/05\/ora-28001-the-password-has-expired\/#primaryimage\",\"url\":\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/596.png\",\"contentUrl\":\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/596.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/05\/ora-28001-the-password-has-expired\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ORA-28001: the password has expired\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ORA-28001: the password has expired - Database Tutorials","description":"ORA-28001: the password has expired","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:\/\/dbtut.com\/index.php\/2018\/07\/05\/ora-28001-the-password-has-expired\/","og_locale":"en_US","og_type":"article","og_title":"ORA-28001: the password has expired - Database Tutorials","og_description":"ORA-28001: the password has expired","og_url":"https:\/\/dbtut.com\/index.php\/2018\/07\/05\/ora-28001-the-password-has-expired\/","og_site_name":"Database Tutorials","article_published_time":"2018-07-05T13:04:36+00:00","article_modified_time":"2018-11-08T11:37:04+00:00","og_image":[{"url":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/596.png","type":"","width":"","height":""}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/05\/ora-28001-the-password-has-expired\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/05\/ora-28001-the-password-has-expired\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"ORA-28001: the password has expired","datePublished":"2018-07-05T13:04:36+00:00","dateModified":"2018-11-08T11:37:04+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/05\/ora-28001-the-password-has-expired\/"},"wordCount":333,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/05\/ora-28001-the-password-has-expired\/#primaryimage"},"thumbnailUrl":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/596.png","keywords":["ALTER PROFILE","ORA-28001","ORA-28001: the password has expired","ORA-28007","ORA-28007: the password cannot be reused","password expired","PASSWORD_REUSE_MAX","the password cannot be reused","the password has expired"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/07\/05\/ora-28001-the-password-has-expired\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/05\/ora-28001-the-password-has-expired\/","url":"https:\/\/dbtut.com\/index.php\/2018\/07\/05\/ora-28001-the-password-has-expired\/","name":"ORA-28001: the password has expired - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/05\/ora-28001-the-password-has-expired\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/05\/ora-28001-the-password-has-expired\/#primaryimage"},"thumbnailUrl":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/596.png","datePublished":"2018-07-05T13:04:36+00:00","dateModified":"2018-11-08T11:37:04+00:00","description":"ORA-28001: the password has expired","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/05\/ora-28001-the-password-has-expired\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/07\/05\/ora-28001-the-password-has-expired\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/05\/ora-28001-the-password-has-expired\/#primaryimage","url":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/596.png","contentUrl":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/596.png"},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/05\/ora-28001-the-password-has-expired\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"ORA-28001: the password has expired"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/638","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=638"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/638\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=638"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=638"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=638"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}