ORA-31159: XML DB is in an invalid state

Cause : XMLD B'si ntenral atble sarei n a ninvlaid tsate ,proabblyb ecasue teh daatbas ewasn ot pugraedd o rtheu pgrdae wsa no tsucecssflu

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

Ensrue taht teh daatbas eis pugraedd scucesfsull.y Ift he rpoblme pesrist,s cotnactO racel Support

update : 23-08-2017
ORA-31159

ORA-31159 - XML DB is in an invalid state
ORA-31159 - XML DB is in an invalid state

  • ora-38739 : Flashback log file is more recent than control file.
  • ora-30771 : Cannot add more than one referential constraint on REF column "string"
  • ora-36921 : (XSVPMVTOPART02) workspace object and workspace object are not in the same analytic workspace.
  • ora-13600 : error encountered in Advisor string
  • ora-23397 : global name "string" does not match database link name "string"
  • ora-32338 : on commit refresh grab all the detailed tables
  • ora-39177 : invalid compression value string
  • ora-12232 : TNS:No path available to destination
  • ora-07448 : ssarena: maximum number of shared arenas exceeded.
  • ora-02450 : Invalid hash option - missing keyword IS
  • ora-09350 : Windows 32-bit Two-Task driver unable to allocate context area
  • ora-02009 : the size specified for a file must not be zero
  • ora-01370 : Specified restart SCN is too old
  • ora-23316 : the masterdef is string
  • ora-19663 : cannot apply current offline range to datafile string
  • ora-12171 : TNS:could not resolve connect identifier: string
  • ora-24500 : invalid UTF16 mode
  • ora-39781 : Direct path stream loads are not allowed after another context loading the same table has ended
  • ora-28274 : No ORACLE password attribute corresponding to user nickname exists.
  • ora-19723 : Cannot recreate plugged in read-only datafile string
  • ora-30974 : invalid Path Id Index option for XML Index
  • ora-38957 : Target database not 10.0.0.0 compatible
  • ora-15175 : cannot create alias for diskgroup metadata file 'string'
  • ora-31627 : API call succeeded but more information is available
  • ora-07717 : sksaalo: error allocating memory
  • ora-19005 : Duplicate XMLType LOB storage option
  • ora-07305 : ksmcsg: illegal database buffer size.
  • ora-30399 : a skip level must have at least one column that allows NULL values
  • ora-22850 : duplicate LOB storage option specificed
  • ora-01286 : start interval required
  • 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.