ORA-24194: attempt to read data in a message as the wrong type

Cause : Accoridng toJ MS spceificaiton, smoe typ econvesrions ewre no tallowde.

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

Make usre tou se th ecorretc READf unctino to rterievem essag edata.

update : 26-09-2017

ORA-24194 - attempt to read data in a message as the wrong type
ORA-24194 - attempt to read data in a message as the wrong type

  • ora-23416 : table "string"."string" does not contain a primary key constraint
  • ora-22864 : cannot ALTER or DROP LOB indexes
  • ora-38707 : Media recovery is not enabled.
  • ora-13363 : no valid ETYPE in the geometry
  • ora-14162 : subpartition "string": sum of PCTUSED and PCTFREE may not exceed 100
  • ora-07425 : sdpri: error string in translating dump file location.
  • ora-31035 : Could not bind locked resource to path string/string
  • ora-13026 : unknown element type for element string.string.string
  • ora-31053 : The value of the depth argument in the operator cannot be negative
  • ora-24198 : attempt to use an invalid operation ID
  • ora-33449 : (ESDREAD17) Discarding compiled code for workspace object because the partition method or partition dimension of number has changed since it was compiled.
  • ora-32012 : failure in processing system parameters from restored SPFILE
  • ora-16556 : error message is in XML already
  • ora-28003 : password verification for the specified password failed
  • ora-01136 : specified size of file string (string blocks) is less than original size of string blocks
  • ora-30927 : Unable to complete execution due to failure in temporary table transformation
  • ora-07275 : unable to send signal to process
  • ora-07628 : smsfre: sga not mapped
  • ora-23468 : missing string string
  • ora-38854 : cannot mark instance string (redo thread string) as disabled
  • ora-02780 : Name given for the core dump directory is invalid
  • ora-31518 : change column string already exists in CDC change table string.string
  • ora-24061 : cannot specify non-zero SECONDARY_INSTANCE if PRIMARY_INSTANCE was zero
  • ora-19651 : cannot apply offline-range record to datafile string: SCN mismatch
  • ora-12717 : Cannot issue ALTER DATABASE NATIONAL CHARACTER SET when NCLOB, NCHAR or NVARCHAR2 data exists
  • ora-13217 : invalid parameters supplied in ALTER INDEX statement
  • ora-14074 : partition bound must collate higher than that of the last partition
  • ora-02259 : duplicate UNIQUE/PRIMARY KEY specifications
  • ora-07453 : requested resource manager plan schema does not contain OTHER_GROUPS
  • ora-15130 : diskgroup "string" is being dismounted
  • 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.