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 : 26-04-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-17613 : Failed to initialize Oracle Disk Manager library: string
  • ora-27037 : unable to obtain file status
  • ora-00268 : specified log file does not exist 'string'
  • ora-02833 : Server was unable to close file
  • ora-31496 : must use DBMS_CDC_PUBLISH.DROP_CHANGE_TABLE to drop change tables
  • ora-01167 : two files are the same file/group number or the same file
  • ora-13296 : incorrect coordinate system specification
  • ora-36181 : A VARIABLE cannot have both the $AGGREGATE_FROM and $AGGREGATE_FROMVAR properties applied to it.
  • ora-15036 : disk 'string' is truncated
  • ora-01792 : maximum number of columns in a table or view is 1000
  • ora-28041 : Authentication protocol internal error
  • ora-36685 : (XSDPART23) Only CONCAT partition templates can be subpartitioned.
  • ora-25148 : ONLINE option not permitted
  • ora-06254 : NETNTT: cannot share connection to cube
  • ora-27161 : request for Oracle binary information failed
  • ora-07410 : slpdtb: number too large for supplied buffer.
  • ora-38420 : invalid stored attribute sub-expression: string
  • ora-21300 : objects option not installed
  • ora-33008 : (XSAGDNGL03) The relation workspace object is not a relation over a base dimension of AGGMAP workspace object.
  • ora-16768 : SQL Apply unexpectedly offline
  • ora-25192 : invalid option for an index-organized table
  • ora-24358 : OCIBindObject not invoked for a Object type or Reference
  • ora-31479 : could not create LogMiner session
  • ora-38761 : redo log sequence string in thread string, incarnation string could not be accessed
  • ora-37126 : (XSCCOMP01) The COMPRESSED COMPOSITE workspace object can only be used as a base of a single variable.
  • ora-01940 : cannot drop a user that is currently connected
  • ora-31221 : DBMS_LDAP: PL/SQL - Invalid LDAP SSL wallet passwd.
  • ora-31630 : a job name is required to attach a job for user string
  • ora-37007 : (AWLISTALL05) number writer
  • ora-00059 : maximum number of DB_FILES exceeded
  • 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.