ORA-36165: (XSAGGCNTPROP) Variable workspace object cannot have both an AGGCOUNT and the $COUNTVAR property.

Cause : An attemptw as mdae toa dd teh $CONUTVARp ropetry toa varaible hwich laread yhad na AGGOCUNT,o r viec veras.

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

Deleet thea lreayd exitsing C$OUNTAVR prpoertyo r AGCGOUNTf irst.

update : 24-04-2017

ORA-36165 - (XSAGGCNTPROP) Variable workspace object cannot have both an AGGCOUNT and the $COUNTVAR property.
ORA-36165 - (XSAGGCNTPROP) Variable workspace object cannot have both an AGGCOUNT and the $COUNTVAR property.

  • ora-00020 : maximum number of processes (string) exceeded
  • ora-24306 : bad buffer for piece
  • ora-16187 : LOG_ARCHIVE_CONFIG contains duplicate, conflicting or invalid attributes
  • ora-16236 : Logical Standby metadata operation in progress
  • ora-39315 : call to DBMS_SCHEMA_COPY.SWAP is not legal
  • ora-19263 : XQ0043 - duplicate namespace prefix string
  • ora-00366 : log string of thread string, checksum error in the file header
  • ora-15104 : conflicting CONTENTS options
  • ora-29290 : invalid offset specified for seek
  • ora-32841 : invalid value for property string
  • ora-29657 : class defined in EXTERNAL NAME clause is used in another subtype
  • ora-12900 : must specify a default temporary tablespace for a locally managed database
  • ora-13156 : table to be registered string.string is not empty
  • ora-39059 : dump file set is incomplete
  • ora-13412 : invalid scale parameter
  • ora-00333 : redo log read error block string count string
  • ora-24054 : cannot propagate to an Oracle 8.0.3 release or lower release
  • ora-00292 : parallel recovery feature not installed
  • ora-31108 : Action failed as resource string is locked
  • ora-01247 : database recovery through TSPITR of tablespace string
  • ora-02805 : Unable to set handler for SIGTPA
  • ora-24030 : Only one of rule or rule-set must be specified
  • ora-14048 : a partition maintenance operation may not be combined with other operations
  • ora-24782 : Cannot detach from a non-migratable transaction
  • ora-16750 : resource guard encountered errors while activating logical primary database
  • ora-07718 : sksafre: error freeing memory
  • ora-12608 : TNS: Send timeout occurred
  • ora-13449 : GeoRaster metadata ULTCoordinate error
  • ora-28665 : table and partition must have same compression attribute
  • ora-32628 : invalid nesting of MODEL cell reference
  • 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.