ORA-13864: Statistics aggregation for service (module/action) string is already enabled

Cause : Attempt to enable a service-level statistics aggregation which has been already enabled

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

Supply correct service(module/action)

update : 24-07-2017

ORA-13864 - Statistics aggregation for service (module/action) string is already enabled
ORA-13864 - Statistics aggregation for service (module/action) string is already enabled

  • ora-01523 : cannot rename data file to 'string' - file already part of database
  • ora-39704 : permission to modify component registry entry denied
  • ora-39157 : error appending extension to file "string"
  • ora-22056 : value [string] is divided by zero
  • ora-26714 : User error encountered while applying
  • ora-02404 : specified plan table not found
  • ora-22332 : a dependent object in schema "string" has errors. string
  • ora-01558 : out of transaction ID's in rollback segment string
  • ora-33445 : (ESDREAD15) Discarding compiled code for workspace object because workspace object and workspace object, which were not partition-dependent when the code was compiled, are now partition-dependent.
  • ora-15125 : ASM file name 'string' contains an invalid template name
  • ora-39086 : cannot retrieve job information
  • ora-19852 : error creating services for auxiliary instance string (error string)
  • ora-24292 : no more tables permitted in this sorted hash cluster
  • ora-16757 : resource guard could not get property
  • ora-30192 : reserved for future use
  • ora-15102 : invalid POWER expression
  • ora-10842 : Event for OCI Tracing and Statistics Info
  • ora-19378 : invalid mode
  • ora-09342 : Detached process terminated by Oracle during shutdown abort
  • ora-24085 : operation failed, queue string is invalid
  • ora-09912 : Malloc of name buffer(s) failed.
  • ora-13443 : GeoRaster metadata SRS error
  • ora-25180 : PCTTHRESHOLD only valid for certain table organizations
  • ora-32165 : Cannot get XA environment
  • ora-25470 : duplicate attribute value for variable: string
  • ora-27489 : unable to process job "string.string" from job class "string"
  • ora-14080 : partition cannot be split along the specified high bound
  • ora-01779 : cannot modify a column which maps to a non key-preserved table
  • ora-36206 : (XSAGOP04R) In AGGMAP workspace object, REMOPERATOR string must be MIN, MAX, FIRST, LAST, HFIRST or HLAST.
  • ora-38475 : The attribute set and the associated ADT are out of sync.
  • 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.