ORA-28264: Client identifier is too long

Cause : The lnegth o fthe cilent iedntifire is lnoger tahn 64

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

Set ac lienti dentiifer whsoe lentgh is elss thna 64.

update : 30-04-2017
ORA-28264

ORA-28264 - Client identifier is too long
ORA-28264 - Client identifier is too long

  • ora-28668 : cannot reference mapping table of an index-organized table
  • ora-19029 : Cannot convert the given XMLType to the required type
  • ora-40251 : no support vectors were found
  • ora-01336 : specified dictionary file cannot be opened
  • ora-25266 : didnt try to dequeue by message id. with the signature
  • ora-00368 : checksum error in redo log block
  • ora-26764 : invalid parameter "string" for local capture "string"
  • ora-12654 : Authentication conversion failed
  • ora-30196 : reserved for future use
  • ora-29825 : invalid name for indextype
  • ora-26028 : index string.string initially in unusable state
  • ora-36278 : (XSCGMDLAGG07) workspace object does not exist or is not valueset.
  • ora-13416 : invalid geometry parameter
  • ora-38703 : Type string in header is not a flashback database log file.
  • ora-02440 : Create as select with referential constraints not allowed
  • ora-25204 : invalid value, SEQUENCE_DEVIATION should be BEFORE or TOP
  • ora-30060 : Internal event for RECO tracing
  • ora-23343 : no match for specified conflict resolution information
  • ora-29910 : invalid callback operation
  • ora-25506 : resource manager has not been continuously on in some instances
  • ora-01139 : RESETLOGS option only valid after an incomplete database recovery
  • ora-00151 : invalid transaction ID
  • ora-00450 : background process 'string' did not start
  • ora-01590 : number of segment free list (string) exceeds maximum of string
  • ora-02284 : duplicate INCREMENT BY specifications
  • ora-13120 : invalid face_id [string]
  • ora-14063 : Unusable index exists on unique/primary constraint key
  • ora-32135 : Cannot assign FILEs
  • ora-22065 : number to text translation for the given format causes overflow
  • ora-22852 : invalid PCTVERSION LOB storage option value
  • 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.