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 : 17-08-2017

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

  • ora-30038 : Cannot perform parallel insert on non-partitioned object
  • ora-00153 : internal error in XA library
  • ora-00311 : cannot read header from archived log
  • ora-32404 : snapshot log uses Change Data Capture which is not enabled for this database
  • ora-36185 : (XSAGGR11) workspace object does not have any AGGCOUNT information.
  • ora-01080 : error in shutting down ORACLE
  • ora-29867 : cannot create a domain index on a LONG column
  • ora-14455 : attempt to create referential integrity constraint on temporary table
  • ora-39006 : internal error
  • ora-27160 : process requested to perform operation
  • ora-27040 : file create error, unable to create file
  • ora-00720 : ALTER DATABASE RESET COMPATIBILITY command has been de-supported
  • ora-04065 : not executed, altered or dropped string
  • ora-30688 : maximum program calling depth exceeded
  • ora-22604 : TDS handle already generated
  • ora-00392 : log string of thread string is being cleared, operation not allowed
  • ora-06522 : %s
  • ora-29372 : identifier string is too long; it must be less than string characters
  • ora-39316 : call to DBMS_SCHEMA_COPY.CLEAN_UP is not legal
  • ora-02025 : all tables in the SQL statement must be at the remote database
  • ora-00000 : normal, successful completion
  • ora-30203 : Cannot open mesage file
  • ora-22331 : cannot alter an incomplete type
  • ora-30978 : The XML Index is not locally partitioned.
  • ora-31002 : Path name string is not a container
  • ora-12489 : default label not within clearance range
  • ora-13243 : specified operator is not supported for 3- or higher-dimensional R-tree
  • ora-21704 : cannot terminate cache or connection without flushing first
  • ora-16078 : media recovery disabled
  • ora-22925 : operation would exceed maximum size allowed for a LOB value
  • 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.