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 : 26-07-2017

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

  • ora-38312 : original name is used by an existing object
  • ora-40004 : penalty must be negative for BLAST-N
  • ora-09315 : sql2tt: two-task error translating ORACLE_EXECUTABLE
  • ora-23331 : column group string does not exist
  • ora-26021 : index string.string partition string loaded successfully with string keys
  • ora-16016 : archived log for thread string sequence# string unavailable
  • ora-32113 : Null object passed
  • ora-13152 : invalid HHCODE type
  • ora-19753 : error writing to change tracking file
  • ora-13704 : Invalid value "string" specified for parameter "string".
  • ora-12832 : Could not allocate slaves on all specified instances
  • ora-13702 : Snapshot IDs specified by the range [string, string] are equal.
  • ora-14308 : partition bound element must be one of: string, datetime or interval literal, number, or NULL
  • ora-27033 : failed to obtain file size limit
  • ora-31108 : Action failed as resource string is locked
  • ora-13617 : The specified task string already executing
  • ora-25184 : column name expected
  • ora-37135 : (XSCCOMP10) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object. The RELATION statement for dense dimension workspace object must precede RELATION statements over the bases of the COMPRESSED COMPOSITE.
  • ora-25963 : join index must be created on tables
  • ora-14195 : ALLOCATE STORAGE may not be specified for RANGE or LIST partitioned object
  • ora-01568 : cannot set space quota on PUBLIC
  • ora-07482 : snlmini: cannot create lock manager instance.
  • ora-06600 : LU6.2 Driver: SNA software is not loaded
  • ora-12086 : table "string"."string" is not an object table
  • ora-02296 : cannot enable (string.string) - null values found
  • ora-15077 : could not locate ASM instance serving a required diskgroup
  • ora-28365 : wallet is not open
  • ora-16602 : object must be disabled to perform this operation
  • ora-19647 : non-zero LEVEL cannot be specified when INCREMENTAL is FALSE
  • ora-14618 : cannot drop the last value of subpartition
  • 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.