ORA-28051: the account is locked

Cause : The enterprise user has consecutively entered the wrong password for maximum number of times specified in the realm's password policy profile.

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

Contact the directory administrator.

update : 27-05-2017

ORA-28051 - the account is locked
ORA-28051 - the account is locked

  • ora-06020 : NETASY: initialisation failure
  • ora-02466 : The SIZE and INITRANS options cannot be altered for HASH CLUSTERS.
  • ora-30018 : Create Rollback Segment failed, USN string is out of range
  • ora-01551 : extended rollback segment, pinned blocks released
  • ora-21560 : argument string is null, invalid, or out of range
  • ora-09911 : Incorrect user password.
  • ora-19709 : numeric parameter must be non-negative integer
  • ora-13761 : invalid filter
  • ora-01232 : cannot start online backup - file string is being made read-only
  • ora-24071 : cannot perform operation string, queue table string is being migrated
  • ora-16540 : invalid argument
  • ora-14064 : Index with Unusable partition exists on unique/primary constraint key
  • ora-01517 : log member: 'string'
  • ora-02083 : database name has illegal character 'string'
  • ora-22308 : operation not allowed on evolved type
  • ora-01483 : invalid length for DATE or NUMBER bind variable
  • ora-06763 : TLI Driver: error sending disconnect
  • ora-12077 : temporary updatable materialized view log does not exist
  • ora-19105 : invalid XQueryX: expected text node - got string
  • ora-29703 : error occurred in global enqueue service operation
  • ora-32690 : Hash Table Infrastructure ran out of memory
  • ora-09204 : sfotf: error opening temporary file
  • ora-15202 : cannot create additional ASM internal change segment
  • ora-29361 : value string is outside valid range of 0 to 100
  • ora-16530 : invalid buffer or length
  • ora-08108 : may not build or rebuild this type of index online
  • ora-16584 : illegal operation on a standby site
  • ora-36800 : (XSTBLFUNC00) The OLAP_TABLE function can only have a single LOOP statement within the LIMITMAP
  • ora-06566 : invalid number of rows specified
  • ora-37037 : (XSMLTDCL03) You cannot RENAME objects in analytic workspace string because it is attached in MULTI mode.
  • 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.