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 : 20-08-2017
ORA-28001

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

  • ora-29358 : resource plan string does not exist
  • ora-16816 : incorrect database role
  • ora-38786 : Flash recovery area is not enabled.
  • ora-19250 : XQ0030 - too many values to validate expression
  • ora-39024 : wrong schema specified for job
  • ora-30019 : Illegal rollback Segment operation in Automatic Undo mode
  • ora-02445 : Exceptions table not found
  • ora-07548 : sftopn: Maximum number of files already open
  • ora-12226 : TNS:operating system resource quota exceeded
  • ora-09761 : pw_destroyPorts: server call pws_stop_instance failed.
  • ora-40303 : invalid prior probability specification
  • ora-00057 : maximum number of temporary table locks exceeded
  • ora-24125 : Object string.string has changed
  • ora-12473 : The procedure is disabled when Label Security is used with OID.
  • ora-14270 : table is not partitioned by Range or Hash or List method
  • ora-13334 : LRS segments not connected
  • ora-13195 : failed to generate maximum tile value
  • ora-24421 : OCISessionRelease cannot be used to release this session.
  • ora-07629 : smpall: $EXPREG failure
  • ora-13201 : invalid parameters supplied in CREATE INDEX statement
  • ora-01595 : error freeing extent (string) of rollback segment (string))
  • ora-12412 : policy package string is not installed
  • ora-13006 : the specified cell number is invalid
  • ora-12074 : invalid memory address
  • ora-07474 : snclrd: close error, unable to close sgadef.dbf file.
  • ora-32124 : Illegal attribute passed
  • ora-10865 : Control tracing of notification operations
  • ora-28110 : policy function or package string.string has error
  • ora-39702 : database not open for UPGRADE or DOWNGRADE
  • ora-27034 : maximum length of ORACLE_SID exceeded
  • 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.