ORA-16506: out of memory

Cause : Process exceeded private or shared memory limits.

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

Check for memory leaks, increase system parameters and restart.

update : 30-04-2017

ORA-16506 - out of memory
ORA-16506 - out of memory

  • ora-12706 : this CREATE DATABASE character set is not allowed
  • ora-01663 : the contents of tablespace 'string' is constantly changing
  • ora-30132 : invalid key index supplied
  • ora-31187 : Cannot Add Node 'string' (type='string') to Simple Type Node 'string'
  • ora-19336 : Missing XML root element
  • ora-09824 : Unable to enable allowmacaccess privilege.
  • ora-08277 : Cannot set environment variable
  • ora-06731 : TLI Driver: cannot alloc t_call
  • ora-24073 : cannot specify RETENTION_TIME on exception queue string.string
  • ora-25112 : maximum number of BITMAP index columns is 30
  • ora-19576 : datafile string not defined in control file
  • ora-16113 : applying change to table or sequence string
  • ora-16824 : Fast-Start Failover and other warnings detected for the database
  • ora-12203 : TNS:unable to connect to destination
  • ora-23472 : materialized view "string"."string" must be atomically refreshed
  • ora-19101 : CONTENT keyword expected
  • ora-01916 : keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END/DROP expected
  • ora-32011 : cannot restore SPFILE to location already being used by the instance
  • ora-01113 : file string needs media recovery
  • ora-12041 : cannot record ROWIDs for index-organized table "string"."string"
  • ora-16114 : applying DDL transaction with commit SCN string
  • ora-24391 : invalid fetch operation
  • ora-12919 : Can not drop the default permanent tablespace
  • ora-32123 : Attribute number is out of range
  • ora-13447 : GeoRaster metadata BRS error
  • ora-02159 : installed DLM does not support releasable locking mode
  • ora-30972 : invalid ALTER INDEX option for XML Index
  • ora-35756 : (VCTODT02) 'number' is not a valid date because number is out of range for a year.
  • ora-03262 : the file is non-empty
  • ora-09796 : szrbuild: malloc of role name failed.
  • 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.