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 : 22-09-2017
ORA-36165

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-10663 : Object has rowid based materialized views
  • ora-24507 : invalid combination of character set ids
  • ora-22865 : more than one column specified
  • ora-09281 : sllfop: error opening file
  • ora-30727 : duplicate referential constraint for a REF column
  • ora-24328 : illegal attribute value
  • ora-00031 : session marked for kill
  • ora-33557 : (MAINTCHK01) You cannot string values of dimension workspace object during a loop over it.
  • ora-39726 : unsupported add/drop column operation on compressed tables
  • ora-07468 : spwat: mset error, unable to set semaphore.
  • ora-08448 : syntax error in DECIMAL-POINT environment clause
  • ora-16257 : Switchover initiated stop apply successfully completed
  • ora-13362 : disjoint sub-element in a compound polygon
  • ora-02736 : osnfpm: illegal default shared memory address
  • ora-06021 : NETASY: connect failed
  • ora-24054 : cannot propagate to an Oracle 8.0.3 release or lower release
  • ora-02183 : valid options: ISOLATION_LEVEL { SERIALIZABLE | READ COMMITTED }
  • ora-37114 : OLAP API bootstrap error: (string)
  • ora-00446 : background process started when not expected
  • ora-38795 : warning: FLASHBACK succeeded but OPEN RESETLOGS would get error below
  • ora-01579 : write error occurred during recovery
  • ora-00090 : failed to allocate memory for cluster database ORADEBUG command
  • ora-30770 : Cannot specify storage options for fixed size opaque type
  • ora-35019 : (QFCHECK07) The Analytic Workspace and EIF file definitions of workspace object have different partition dimensions.
  • ora-07304 : ksmcsg: illegal redo buffer size.
  • ora-06422 : NETCMN: Error in sending data
  • ora-28025 : missing or null external name
  • ora-16754 : resource guard could not activate standby database
  • ora-01322 : No such table
  • ora-40104 : invalid training data for model build
  • 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.