ORA-12829: Deadlock - itls occupied by siblings at block string of file string

Cause : aparllles atetemtnf iael debacsu ela ltisli nht eucrrne tlbco kra ecoucipdeb yislbnisgo fht easemt arsncaitno.

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

nircaeesM XARTNA Sfot ehb olkco rerudect ehd geer efop ralaelilmsf rot ehs atetemtn .eRxecetu eht etstamene.tR pero tuspscioisue evtn snit arecf li eotO arlc euSppro teSvrcisei freor repsrsist.

update : 25-04-2017

ORA-12829 - Deadlock - itls occupied by siblings at block string of file string
ORA-12829 - Deadlock - itls occupied by siblings at block string of file string

  • ora-26665 : STREAMS process string already exists
  • ora-04061 : existing state of string has been invalidated
  • ora-29382 : validation of pending area failed
  • ora-27084 : unable to get/set file status flags
  • ora-19584 : file string already in use
  • ora-24403 : error occured while trying to destroy the connection pool
  • ora-16739 : redo transport service for standby database "string" unexpectedly online
  • ora-23466 : flavor requires missing object "string"."string"
  • ora-38502 : invalid XML tag: string
  • ora-07500 : scglaa: $cantim unexpected return
  • ora-01485 : compile bind length different from execute bind length
  • ora-08121 : Number of indexes need to be maintained offline exceeds limit for DML
  • ora-36976 : (XSRELGID00) The format of the GROUPINGID command is: GROUPINGID [relation1] INTO {variable | relation2 | surrogate} [USING levelrelation] [INHIERARCHY {inhvariable | valueset}] [LEVELORDER levelordervs] The source relation can be omitted only when using both surrogate gid and level order valueset.
  • ora-08184 : attempting to re-enable Flashback while in Flashback mode
  • ora-24150 : evaluation context string.string does not exist
  • ora-26510 : materialized view name: 'string' is greater than max. allowed length of string bytes
  • ora-13799 : threshold not found
  • ora-16605 : unable to delete template, template is in use
  • ora-23451 : flavor string already defined for object group "string"."string"
  • ora-29318 : datafile string is online
  • ora-25153 : Temporary Tablespace is Empty
  • ora-01159 : file is not from same database as previous files - wrong database id
  • ora-01293 : mounted database required for specified LogMiner options
  • ora-02205 : only SELECT and ALTER privileges are valid for sequences
  • ora-19507 : failed to retrieve sequential file, handle="string", parms="string"
  • ora-01262 : Stat failed on a file destination directory
  • ora-15170 : cannot add entry 'string' in directory 'string'
  • ora-24952 : register, unregister or post has incorrect collection count
  • ora-01637 : rollback segment 'string' is being used by another instance (#string)
  • ora-22132 : hexadecimal string does not correspond to a valid REF
  • 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.