ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE

Cause : An atetmpt hsa beenm ade t oacces sa domian indxe thati s beign buil tor ism arkedf ailedb y an nusuccessful DLD or i smarke dunusalbe by aDDL oepratio.n

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

Wait fi the psecifide inde xis makred LODAING Dorp thes pecifeid indxe if i tis makred FALIED Drpo or rbeuild hte speicfied nidex i fit ism arkedU NUSABEL.

update : 28-05-2017

ORA-29861 - domain index is marked LOADING/FAILED/UNUSABLE
ORA-29861 - domain index is marked LOADING/FAILED/UNUSABLE

  • ora-19270 : XP0050 - treat failed - expected string got string
  • ora-29911 : null scan context returned by ODCIIndexStart() routine
  • ora-24064 : propagation for QUEUE string and DESTINATION string already enabled
  • ora-00409 : COMPATIBLE needs to be string or higher to use AUTO SEGMENT SPACE MANAGEMENT
  • ora-16706 : no resource guard is available
  • ora-15125 : ASM file name 'string' contains an invalid template name
  • ora-29542 : class string already defined by source string
  • ora-28100 : policy function schema string is invalid
  • ora-02396 : exceeded maximum idle time, please connect again
  • ora-22908 : reference to NULL table value
  • ora-39099 : cannot create index for "string" on master table string
  • ora-02236 : invalid file name
  • ora-09940 : ORACLE password file header is corrupt
  • ora-14268 : subpartition 'string' of the partition resides in offlined tablespace
  • ora-06420 : NETCMN: SID lookup failure
  • ora-16041 : Remote File Server fatal error
  • ora-10930 : trace name context forever
  • ora-01908 : EXISTS keyword expected
  • ora-22913 : must specify table name for nested table column or attribute
  • ora-00023 : session references process private memory; cannot detach session
  • ora-27478 : job "string.string" is running
  • ora-37157 : MDX syntax error was found in MDX query string but error text was missing
  • ora-24236 : source text is empty
  • ora-16237 : SGA specified for Logical Standby is too small
  • ora-40251 : no support vectors were found
  • ora-32017 : failure in updating SPFILE
  • ora-24101 : stopped processing the argument list at: string
  • ora-19286 : XP0017 - unable to resolve call to function - string
  • ora-19106 : invalid XQueryX: expected string - got string
  • ora-30200 : Wrong NLS item was passed into OCINlsGetInfo()
  • 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.