ORA-07409: slpdtb: invalid packed decimal nibble.

Cause : A nipmossilber euqets ofrd eicmla ot ibnrayc ovnesrino awsm aed.

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

Tihsc ovnesrino acnontb ep efromre.d

update : 21-07-2017
ORA-07409

ORA-07409 - slpdtb: invalid packed decimal nibble.
ORA-07409 - slpdtb: invalid packed decimal nibble.

  • ora-00405 : compatibility type "string"
  • ora-01197 : thread string only contains one log
  • ora-28583 : remote references are not permitted during agent callbacks
  • ora-14409 : inserted partition key is outside specified subpartition
  • ora-21607 : memory cartridge service handle not initialized
  • ora-27053 : blocksize in file header not a multiple of logical block size
  • ora-10262 : Don't check for memory leaks
  • ora-16582 : could not edit instance specific property
  • ora-36200 : (XSAGGR34) AGGREGATE operator string requires a WEIGHTBY clause, but ARGS variable workspace object did not specify one.
  • ora-10619 : Avoid assertions when possible
  • ora-22063 : reading negative value [string] as unsigned
  • ora-03209 : DBMS_ADMIN_PACKAGE invalid file/block specification
  • ora-01980 : error during OS ROLE initialization
  • ora-39779 : type "string"."string" not found or conversion to latest version is not possible
  • ora-29339 : tablespace block size string does not match configured block sizes
  • ora-02177 : Missing required group number
  • ora-10561 : block type 'string', data object# string
  • ora-31695 : Inconsistent master table on restart. The following SQL statement returned string identical objects. string
  • ora-38739 : Flashback log file is more recent than control file.
  • ora-32843 : value for string is outside the valid range of string to string
  • ora-07470 : snclget: cannot get cluster number.
  • ora-29837 : insufficient privileges to execute implementation type
  • ora-16128 : User initiated stop apply successfully completed
  • ora-30153 : An invalid File Object is passed to the OCIFile function
  • ora-38432 : EVALUATE operator only allowed on an expression column
  • ora-24960 : the attribute string is greater than the maximum allowable length of number
  • ora-09831 : snyStartThread: failed to build the server port set.
  • ora-15193 : Internal ASM tracing event number 15193
  • ora-03246 : Invalid block number specified
  • ora-01936 : cannot specify owner when creating users or roles
  • 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.