ORA-19241: XP0021 - cast to type string failed

Cause : hT eavul eniiseda c sa txerpseisnoc uodln tob eactst oht eeruqridet py.e

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

iF xht eniup tott ehc sa txerpseisnot oebo f aactsbaelt py.e

update : 28-04-2017

ORA-19241 - XP0021 - cast to type string failed
ORA-19241 - XP0021 - cast to type string failed

  • ora-09261 : spdcr: error creating detached (background) process
  • ora-30029 : no active undo tablespace assigned to instance
  • ora-13018 : bad distance type
  • ora-02756 : osnfsmnam: name translation failure
  • ora-16224 : Database Guard is enabled
  • ora-36665 : (XSDPART03) workspace object is not in the dimension list of the PARTITION TEMPLATE.
  • ora-15101 : no action specified
  • ora-13907 : Threshold value is invalid.
  • ora-09880 : sstasfre/sstasdel: shmdt error, unable to detach tas write page
  • ora-06805 : TLI Driver: could not send datagram SAP packet for SPX
  • ora-30113 : error when processing file 'string'
  • ora-27195 : proxy copy not supported
  • ora-36641 : (XSDUNION20) The concat dimension must be defined as UNIQUE because base dimension workspace object contains custom member values.
  • ora-09788 : sllfrb: unable to read file.
  • ora-14299 : total number of partitions/subpartitions exceeds the maximum limit
  • ora-28354 : wallet already open
  • ora-06722 : TLI Driver: connection setup failure
  • ora-01129 : user's default or temporary tablespace does not exist
  • ora-13707 : Either the start snapshot string or the end snapshot string is incomplete or missing key statistics.
  • ora-31641 : unable to create dump file "string"
  • ora-01138 : database must either be open in this instance or not at all
  • ora-01665 : control file is not a standby control file
  • ora-24394 : invalid mode for destroying connection pool
  • ora-13119 : invalid edge_id [string]
  • ora-24021 : queue table definition not imported for string.string
  • ora-22851 : invalid CHUNK LOB storage option value
  • ora-24752 : OCI_TRANS_NEW flag must be specified for local transactions
  • ora-23319 : parameter value string is not appropriate
  • ora-16215 : history metadata inconsistency
  • ora-22627 : tc [string] must be that of object/varray/nested table
  • 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.