ORA-10269: Don't do coalesces of free space in SMON

Cause : settin gthis eevnt preevnts SMNO from oding free spacec oalescse

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


update : 27-06-2017

ORA-10269 - Don't do coalesces of free space in SMON
ORA-10269 - Don't do coalesces of free space in SMON

  • ora-30475 : feature not enabled: string
  • ora-28177 : incorrect Kerberos ticket version
  • ora-22312 : must specify either CASCADE or INVALIDATE option
  • ora-12566 : TNS:protocol error
  • ora-12829 : Deadlock - itls occupied by siblings at block string of file string
  • ora-07282 : sksaprd: string overflow.
  • ora-02050 : transaction string rolled back, some remote DBs may be in-doubt
  • ora-28037 : Cannot Get Session Key for RACF Authentication
  • ora-07683 : sou2os: $SETPRV reset error
  • ora-19698 : %s is from different database: id=string, db_name=string
  • ora-33002 : (XSAGDNGL00) In AGGMAP workspace object, the FLOOR argument of number must be less than the CEILING argument of number.
  • ora-30977 : invalid Value Index option for XML Index
  • ora-14010 : this physical attribute may not be specified for an index partition
  • ora-29964 : missing ADD or DROP keyword
  • ora-01289 : cannot add duplicate logfile string
  • ora-15009 : ASM disk "string" does not exist
  • ora-01878 : specified field not found in datetime or interval
  • ora-33066 : (XSAGDNGL32) In AGGMAP workspace object, the hierarchy dimension QDR workspace object must be a hierarchy dimension of the relation.
  • ora-13359 : extent does not have an area
  • ora-30625 : method dispatch on NULL SELF argument is disallowed
  • ora-12521 : TNS:listener does not currently know of instance requested in connect descriptor
  • ora-14176 : this attribute may not be specified for a hash partition
  • ora-06260 : NETNTT: cannot write to remote process
  • ora-06766 : TLI Driver: close failed during release
  • ora-33282 : (DBERR11) Cannot wait for analytic workspace string to become available since doing so would cause a deadlock.
  • ora-19587 : error occurred reading string bytes at block number string
  • ora-13830 : SQL profile with category string already exists for this SQL statement
  • ora-02162 : invalid value for MAXDATAFILES
  • ora-07498 : spstp: Unable to open /dev/resched.
  • ora-27100 : shared memory realm already exists
  • 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.