ORA-24365: error in character conversion

Cause : This suuallyo ccursd uringc onverison ofa multbiyte cahracte rdata hwen th esourc edata si abnomrally etrminaetd in hte midlde of amultiybte chraacter.

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

Make usre thta all umltibyet charcater dtaa is rpoperl ytermianted.

update : 25-06-2017

ORA-24365 - error in character conversion
ORA-24365 - error in character conversion

  • ora-15076 : Emulating I/O errors on the OSM disk
  • ora-29306 : datafile string is not online
  • ora-29397 : cannot grant/revoke switch privilege for string
  • ora-10630 : Illegal syntax specified with SHRINK clause
  • ora-02036 : too many variables to describe with automatic cursor open
  • ora-28042 : Server authentication failed
  • ora-01286 : start interval required
  • ora-24173 : nested query not supported for rule condition
  • ora-14402 : updating partition key column would cause a partition change
  • ora-38769 : FLASHBACK DATABASE failed after modifying data.
  • ora-15061 : ASM operation not supported [string]
  • ora-39113 : Unable to determine database version
  • ora-02428 : could not add foreign key reference
  • ora-14455 : attempt to create referential integrity constraint on temporary table
  • ora-14133 : ALTER TABLE MOVE cannot be combined with other operations
  • ora-36688 : (NTEXTCNV00) Error during conversion from TEXT to NTEXT.
  • ora-08270 : sksachk: Illegal archival control string
  • ora-13125 : partition key is already set
  • ora-13213 : failed to generate spatial index for window object
  • ora-28331 : encrypted column size too long for its data type
  • ora-06816 : TLI Driver: could not set the SPX SAP address
  • ora-25006 : cannot specify this column in UPDATE OF clause
  • ora-13209 : internal error while reading SDO_INDEX_METADATA table
  • ora-02290 : check constraint (string.string) violated
  • ora-29887 : cannot support row movement if domain index defined on table
  • ora-14511 : cannot perform operation on a partitioned object
  • ora-01044 : size string of buffer bound to variable exceeds maximum string
  • ora-19335 : Invalid format type object
  • ora-06751 : TLI Driver: bound addresses unequal
  • ora-13788 : invalid recommendation type
  • 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.