ORA-24355: attempt to store a negative number in an Unsigned Display type.

Cause : A nattepmtw a smdaet oc ovnetr angeaitv enmubre nit oa nusninge ddsipalyt yep.

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

Pelaes hcekc hten ubme ri nteh adtbaaes ro hcagnet h edfeiendd aattpye.

update : 28-07-2017

ORA-24355 - attempt to store a negative number in an Unsigned Display type.
ORA-24355 - attempt to store a negative number in an Unsigned Display type.

  • ora-14307 : partition contains too many list values
  • ora-31697 : aborting operation at process order number string
  • ora-09929 : GLB of two labels is invalid
  • ora-12040 : master rollback segment option not support by master site string
  • ora-09824 : Unable to enable allowmacaccess privilege.
  • ora-26675 : cannot create Streams capture process string
  • ora-21600 : path expression too long
  • ora-02227 : invalid cluster name
  • ora-02728 : osnfop: access error on oracle executable
  • ora-10841 : Default un-inintialized charact set form to SQLCS_IMPLICIT
  • ora-07650 : sigunc: $GETJPIW failure
  • ora-01429 : Index-Organized Table: no data segment to store overflow row-pieces
  • ora-33098 : (APABBR01) A value of 'string' is not valid for the workspace object option.
  • ora-12715 : invalid character set specified
  • ora-31409 : one or more values for input parameters are incorrect
  • ora-07844 : sllfop: LIB$GET_VM failure
  • ora-31066 : Insertion of string into string creates a cycle
  • ora-09212 : sfwfbmt: error writing to file
  • ora-01618 : redo thread string is not enabled - cannot mount
  • ora-22851 : invalid CHUNK LOB storage option value
  • ora-12210 : TNS:error in finding Navigator data
  • ora-36260 : (XSAGHIERPART00) Aggregating from partition %J to partition %J over hierarchy workspace object creates an increase in sparsity.
  • ora-12818 : invalid option in PARALLEL clause
  • ora-06920 : CMX: getbrkmsg illegal datatype
  • ora-14315 : cannot merge a partition with itself
  • ora-16658 : unobserved Fast-Start Failover configuration
  • ora-09266 : spawn: error starting an Oracle process
  • ora-39307 : operation is illegal without an initial clone
  • ora-28038 : disallow O2LOGON
  • ora-38462 : invalid attribute list
  • 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.