ORA-13515: Error encountered during Database Usage Statistics capture

Cause : rEor rcoucrrded runi gCO Iporetaoi nud eotu dnreylni greor.r

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

hCce ksaosictadeO ICe rrro .oCrrce trpboel mna derrt yht eporetaoi.n

update : 22-07-2017
ORA-13515

ORA-13515 - Error encountered during Database Usage Statistics capture
ORA-13515 - Error encountered during Database Usage Statistics capture

  • ora-13529 : Error occurred when flushing AWR table group
  • ora-25181 : missing ON keyword for NESTED INDEX
  • ora-12826 : hung parallel query server was killed
  • ora-13422 : invalid model coordinate parameter
  • ora-31453 : invalid value string for parameter, expecting: Y, N, or NULL
  • ora-29513 : referenced class name too long
  • ora-07598 : spwat: $SETIMR failure
  • ora-30557 : function based index could not be properly maintained
  • ora-07209 : sfofi: file size limit was exceeded.
  • ora-07446 : sdnfy: bad value 'string' for parameter string.
  • ora-01564 : rollback segment is not PUBLIC
  • ora-02163 : invalid value for FREELIST GROUPS
  • ora-24274 : no row exists in the string table for these parameters
  • ora-39200 : Link name "string" is invalid.
  • ora-12067 : empty refresh groups are not allowed
  • ora-34181 : (MXCHGDCL21) workspace object is not a partitioned VARIABLE.
  • ora-01691 : unable to extend lob segment string.string by string in tablespace string
  • ora-32814 : propagation schedule string does not exist
  • ora-00354 : corrupt redo log block header
  • ora-06904 : CMX: no transport address available for remote application
  • ora-12817 : parallel query option must be enabled
  • ora-23608 : invalid resolution column "string"
  • ora-36276 : (XSCGMDLAGG06) The current operator does not need a weight variable.
  • ora-00238 : operation would reuse a filename that is part of the database
  • ora-22952 : Nested Table equality requires a map method on the element ADT
  • ora-00079 : variable string not found
  • ora-16528 : unable to allocate PGA heap
  • ora-24064 : propagation for QUEUE string and DESTINATION string already enabled
  • ora-15033 : disk 'string' belongs to diskgroup "string"
  • ora-00723 : Initialization parameter COMPATIBLE must be explicitly set
  • 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.