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 : 24-04-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-30655 : cannot select FOR UPDATE from external organized table
  • ora-02332 : cannot create index on attributes of this column
  • ora-01062 : unable to allocate memory for define buffer
  • ora-25147 : UNIFORM SIZE value greater than maximum extent size
  • ora-28201 : Not enough privileges to enable application role 'string'
  • ora-13901 : Object string was not found.
  • ora-02829 : No segment of the proper size is available
  • ora-09208 : sftcls: error closing file
  • ora-36164 : (XSMXAGGR07) When using the COUNTVAR clause, the number of variables to be aggregated (number) must match the number of COUNTVAR variables (number).
  • ora-25304 : Cannot use priority order queues for capture LCRs
  • ora-16234 : restarting to reset Logical Standby apply
  • ora-13778 : no new name or owner specified for "SQL Tuning Set"
  • ora-07427 : spstp: cannot change directory to dbs.
  • ora-06437 : ssaio: the asynchronous write was unable to write to the database file.
  • ora-25254 : time-out in LISTEN while waiting for a message
  • ora-19248 : XQ0028 - invalid node in document constructor
  • ora-37005 : (AWLISTALL03) number readers
  • ora-32774 : more than one file was specified for bigfile tablespace string
  • ora-24389 : Invalid scrollable fetch parameters
  • ora-01985 : cannot create user as LICENSE_MAX_USERS parameter exceeded
  • ora-32696 : HTI: No free slot
  • ora-32578 : password for SYS already specified
  • ora-29808 : specified primary operator binding does not exist
  • ora-28366 : invalid database encryption operation
  • ora-12219 : TNS:missing community name from address in ADDRESS_LIST
  • ora-06446 : ssvpstevrg: Failed with unexpected error number.
  • ora-03235 : max # extents (string) reached in table string.string subpartition string
  • ora-15101 : no action specified
  • ora-25223 : user_data type used is not supported
  • ora-38471 : ROWIDs for table aliases cannot be null
  • 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.