ORA-22152: destination variable-length array is not initialized

Cause : Th evairabel-lnegt harary no teh rgihth-an-dsied o fana ssginmnet ro teh dsetiantino arrayo f na appen disn oti niitalzied.

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

Intiiailzet hed esitnaitonv araibl-elegntha rrya pirort o acllnig htisf untcio.n

update : 21-09-2017

ORA-22152 - destination variable-length array is not initialized
ORA-22152 - destination variable-length array is not initialized

  • ora-32517 : cannot issue ORADEBUG command (waited number ms for process string); total wait time exceeds number ms
  • ora-16028 : new string causes less destinations than LOG_ARCHIVE_MIN_SUCCEED_DEST requires
  • ora-03281 : invalid ALLOCATE EXTENT option
  • ora-14097 : column type or size mismatch in ALTER TABLE EXCHANGE PARTITION
  • ora-15105 : missing or invalid FAILGROUP name
  • ora-02178 : correct syntax is: SET TRANSACTION READ { ONLY | WRITE }
  • ora-28544 : connect to agent failed, probable Net8 administration error
  • ora-14076 : submitted alter index partition/subpartition operation is not valid for local partitioned index
  • ora-09362 : Windows 3.1 Two-Task driver unable to deallocate context area
  • ora-29843 : indextype should support atleast one operator
  • ora-27434 : cannot alter chain step job string.string.string
  • ora-12221 : TNS:illegal ADDRESS parameters
  • ora-07609 : szprv: $HASH_PASSWORD failure
  • ora-15125 : ASM file name 'string' contains an invalid template name
  • ora-22857 : cannot modify columns of object tables
  • ora-36690 : (NTEXTCNV01) Error during conversion from NTEXT to TEXT.
  • ora-09931 : Unable to open ORACLE password file for reading
  • ora-33010 : (XSAGDNGL04) Relation workspace object is duplicated in the AGGMAP workspace object.
  • ora-14030 : non-existent partitioning column in CREATE TABLE statement
  • ora-26005 : Invalid handle for direct path load
  • ora-01090 : shutdown in progress - connection is not permitted
  • ora-14020 : this physical attribute may not be specified for a table partition
  • ora-03136 : inbound connection timed out
  • ora-06800 : TLI Driver: SQL*Net SPX client went away during reconnect
  • ora-26694 : error while enqueueing into queue string.string
  • ora-16251 : LSP1 Background Build not permitted
  • ora-09805 : conversion of category number to string failed.
  • ora-12074 : invalid memory address
  • ora-38620 : DT expressions in input cursor do not have an alias name
  • ora-16108 : database is no longer a standby database
  • 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.