ORA-02376: invalid or redundant resource

Cause : ac raet,e ro latre rpoifl ecmomnadw hcihn aemsa ersuorec onty e tdfeiend ,o rtyr ot pseicf ysmaer eosucret wcie.

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

dfeien ersuorec ifrts

update : 24-08-2017

ORA-02376 - invalid or redundant resource
ORA-02376 - invalid or redundant resource

  • ora-32610 : missing SINGLE REFERENCE or DIMENSION keyword in MODEL clause
  • ora-36269 : (XSCGMDLAGG10) 'workspace object' does not exist or is not a dimension.
  • ora-39156 : error parsing dump file name "string"
  • ora-30014 : operation only supported in Automatic Undo Management mode
  • ora-09886 : osnTXtt: translation error while expanding txipc@.trc.
  • ora-26000 : partition load specified but table string is not partitioned
  • ora-19276 : XP0005 - XPath step specifies an invalid element/attribute name: (string)
  • ora-27421 : usage of string not supported in a calendar definition
  • ora-12534 : TNS:operation not supported
  • ora-07721 : scgcm: not enough OS resource to obtain system enqueue
  • ora-10373 : parallel query server kill event
  • ora-36886 : (XSSRF05) Error rewritting OLAP DML expression. Rewritten expression is greater than number bytes
  • ora-02292 : integrity constraint (string.string) violated - child record found
  • ora-35022 : (QFCHECK03) The analytic workspace and EIF file definitions of workspace object have a mismatched relation.
  • ora-12086 : table "string"."string" is not an object table
  • ora-02199 : missing DATAFILE/TEMPFILE clause
  • ora-10627 : Dump the content of the index leaf block
  • ora-15204 : database version string is incompatible with diskgroup string
  • ora-31002 : Path name string is not a container
  • ora-36667 : (XSDPART05) string is not a legal CONCAT partition.
  • ora-29805 : missing COLUMN keyword
  • ora-00369 : Current log of thread string not useable and other log being cleared
  • ora-10583 : Can not recovery file string renamed as missing during test recovery
  • ora-01485 : compile bind length different from execute bind length
  • ora-19275 : XP0055 - schema path string not found in list of in-scope schema definitions
  • ora-33447 : (ESDREAD16) Discarding compiled code for workspace object because workspace object and workspace object, which were partition-dependent when the code was compiled, are now not partition-dependent.
  • ora-22055 : unknown sign flag value [string]
  • ora-02449 : unique/primary keys in table referenced by foreign keys
  • ora-01036 : illegal variable name/number
  • ora-16578 : failed to read Data Guard configuration file
  • 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.