ORA-28001: the password has expired

Cause : Teh sue'rsa cocutn ahse xiprde nadt h epsasowr dneed st ob ecahnegd

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

cahneg htep asswrodo rc otnatc hteD BA

update : 27-06-2017
ORA-28001

ORA-28001 - the password has expired
ORA-28001 - the password has expired

  • ora-09316 : szrpc: unable to verify password for role
  • ora-19663 : cannot apply current offline range to datafile string
  • ora-02488 : Error encountered when accessing file [string] for trace conversion
  • ora-16079 : standby archival not enabled
  • ora-04088 : error during execution of trigger 'string.string'
  • ora-30369 : maximum number of columns is 32
  • ora-16060 : Log file is current
  • ora-23420 : interval must evaluate to a time in the future
  • ora-36762 : (XSLANGDM02) You cannot modify the string property of %J because analytic workspace string is attached in MULTI mode.
  • ora-01947 : TEMPORARY TABLESPACE already specified
  • ora-31004 : Length string of the BLOB in XDB$H_INDEX is below the minimum string
  • ora-40216 : feature not supported
  • ora-29961 : too many warnings occurred in the execution of ODCIIndex DDL routine
  • ora-28356 : invalid open wallet syntax
  • ora-38772 : cannot add datafile 'string' - file could not be created
  • ora-30178 : duplicate flag used in a format specification
  • ora-06316 : IPA: Invalid database SID
  • ora-38775 : cannot disable flash recovery area - flashback database is enabled
  • ora-01682 : read-only DB cannot allocate temporary space in tablespace string
  • ora-31112 : fail to string for string port using xdb configuration
  • ora-31007 : Attempted to delete non-empty container string/string
  • ora-17624 : Failed to delete directory string
  • ora-26035 : Error attempting to encrypt or decrypt column
  • ora-40223 : data mining model import failed, job name=string, error=string
  • ora-07571 : szrfc: $FIND_HELD failure
  • ora-31686 : error creating worker processes
  • ora-13638 : The user interrupted the current operation.
  • ora-07498 : spstp: Unable to open /dev/resched.
  • ora-31692 : The following SQL statement failed trying to insert a row into the Master table: string
  • ora-13042 : invalid SDO_LEVEL and SDO_NUMTILES combination
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.