ORA-30966: error detected in the XML Index layer

Cause : Unepxectde erorr.

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

Fil ea bgu.

update : 17-08-2017
ORA-30966

ORA-30966 - error detected in the XML Index layer
ORA-30966 - error detected in the XML Index layer

  • ora-14105 : RECOVERABLE/UNRECOVERABLE may not be specified in this context
  • ora-01253 : cannot start online backup - file string in recovery manager backup
  • ora-01555 : snapshot too old: rollback segment number string with name "string" too small
  • ora-40303 : invalid prior probability specification
  • ora-28358 : improper set key syntax
  • ora-36836 : (XSLMGEN06) Dimension string.string!string hierarchy string level string is missing a PHYSICALNAME property value
  • ora-01515 : error dropping log group string: no such log
  • ora-30681 : improper value for argument EXTENSIONS_CMD_SET
  • ora-12209 : TNS:encountered uninitialized global
  • ora-19012 : Cannot convert XML fragment to the required datatype
  • ora-13460 : GeoRaster metadata SRS error
  • ora-01670 : new datafile string needed for standby database recovery
  • ora-29931 : specified association does not exist
  • ora-10852 : Enable tracing for Enqueue Dequeue Operations
  • ora-31107 : Action failed as resource "string" is locked by name lock
  • ora-38740 : Usable blocks value string is not valid.
  • ora-25450 : error string during evaluation of rule set string.string
  • ora-01865 : not a valid era
  • ora-26725 : cannot downgrade apply handlers
  • ora-30933 : Element 'string' may not appear at this point within parent 'string'
  • ora-27019 : tape filename length exceeds limit (SBTOPMXF)
  • ora-14403 : cursor invalidation detected after getting DML partition lock
  • ora-13043 : failed to read metadata from the _SDOLAYER table
  • ora-40109 : inconsistent logical data record
  • ora-00285 : TIME not given as a string constant
  • ora-08210 : Requested I/O error
  • ora-07492 : scgrcl: cannot close lock.
  • ora-06314 : IPA: Event set up failure
  • ora-02347 : cannot grant privileges on columns of an object table
  • ora-36342 : (SNSYN200) The format of the CLEAR command is: CLEAR [ ALL | STATUS ] [ AGGREGATES | CHANGES | PRECOMPUTES | NONPRECOMPUTES | CACHE ] FROM var1 [var2, var3...] [USING aggmap]
  • 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.