ORA-22866: default character set is of varying width

Cause : A hcarcate rLO Bwa sdeifne dbu tth edeaful tchraacetr est si nto fxiedw idht.

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

Enusret ha tth echraacetr est si o ffiexd iwdt hbeofred efniin gchraacetr OLBs.

update : 23-06-2017
ORA-22866

ORA-22866 - default character set is of varying width
ORA-22866 - default character set is of varying width

  • ora-24000 : invalid value string, string should be of the form [SCHEMA.]NAME
  • ora-19958 : potential deadlock involving DIAG process
  • ora-01651 : unable to extend save undo segment by string for tablespace string
  • ora-22995 : TABLESPACE DEFAULT option is invalid in this context
  • ora-07741 : slemop: $OPEN failure
  • ora-07449 : sc: usnewlock failed.
  • ora-00275 : media recovery has already been started
  • ora-19377 : no "SQL Tuning Set" with name like "string" exists for owner like "string"
  • ora-04017 : invalid value string (length = string) for parameter max_dump_file_size
  • ora-40225 : model is currently in use by another process
  • ora-09926 : Unable to set effective privilege set of the server
  • ora-25220 : enqueue failed, signature not specified for a non-repudiable queue
  • ora-24005 : must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables
  • ora-39211 : unable to retrieve dumpfile information as specified
  • ora-06921 : CMX: getdatmsg illegal datatype
  • ora-29365 : parameters string and string cannot both be set
  • ora-26515 : no master log available for 'string.string'
  • ora-13033 : Invalid data in the SDO_ELEM_INFO_ARRAY in SDO_GEOMETRY object
  • ora-02251 : subquery not allowed here
  • ora-32019 : The parameter SPFILE cannot be updated in the server parameter file.
  • ora-02846 : Unkillable server
  • ora-01512 : error renaming log file string - new file string not found
  • ora-27486 : insufficient privileges
  • ora-38721 : Invalid file number.
  • ora-24306 : bad buffer for piece
  • ora-14046 : a partition may be split into exactly two new partitions
  • ora-36270 : (XSCGMDLAGG03) The parameter list for the AGGREGATION function includes duplicate values.
  • ora-24352 : invalid COBOL display type passed into OCI call
  • ora-36740 : A CHILDLOCK was detected in your valueset
  • ora-24359 : OCIDefineObject not invoked for a Object type or Reference
  • 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.