ORA-24502: codepoint length overflows

Cause : Returned buffer has more codepoints than allowed

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

Set OCI_MAXCHAR_SIZE large enough to accommodate

update : 22-07-2017
ORA-24502

ORA-24502 - codepoint length overflows
ORA-24502 - codepoint length overflows

  • ora-36678 : (XSDPART16) workspace object is missing from one or more partition dimension lists.
  • ora-12171 : TNS:could not resolve connect identifier: string
  • ora-24407 : connection pool already exists
  • ora-13005 : recursive HHCODE function error
  • ora-06029 : NETASY: port assignment failure
  • ora-08340 : This command not allowed on nCUBE, only one thread is ever used.
  • ora-16204 : DDL successfully applied
  • ora-00219 : required control file size (string logical blocks) exceeds maximum allowable size (string logical blocks)
  • ora-02096 : specified initialization parameter is not modifiable with this option
  • ora-09882 : sstasfre/sstasdel: shmctl error, unable to remove tas shm page
  • ora-01371 : Complete LogMiner dictionary not found
  • ora-08313 : sllfop: could not allocate buffers
  • ora-22053 : overflow error
  • ora-04033 : Insufficient memory to grow pool
  • ora-25005 : cannot CREATE INSTEAD OF trigger on a read-only view
  • ora-06505 : PL/SQL: variable requires more than 32767 bytes of contiguous memory
  • ora-07631 : smcacx: $EXPREG failure
  • ora-26742 : Maximum number of ignored transactions exceeded
  • ora-15071 : ASM disk "string" is already being dropped
  • ora-23427 : deferred purge queue argument string out of range
  • ora-14138 : An unexpected error encountered during drop table operation
  • ora-25300 : Cannot drop buffer for queue with buffered subscribers
  • ora-03250 : Cannot mark this segment corrupt
  • ora-15163 : cluster not in rolling downgrade
  • ora-24356 : internal error while converting from to COBOL display type.
  • ora-09756 : osnpns: no port in the name server.
  • ora-08449 : invalid numeric symbol found in picture mask
  • ora-12461 : undefined level string for policy string
  • ora-22999 : CLOB or NCLOB data may have been corrupted
  • ora-24145 : evaluation context string.string already exists
  • 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.