ORA-27163: out of memory

Cause : The program ran out of memory when allocating a temporary data structure.

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

Increase the amount of memory on the system.

update : 18-08-2017
ORA-27163

ORA-27163 - out of memory
ORA-27163 - out of memory

  • ora-19512 : file search failed
  • ora-06569 : Collection bound by bind_array contains no elements
  • ora-00041 : active time limit exceeded - session terminated
  • ora-32606 : missing NAV keyword in MODEL clause
  • ora-08108 : may not build or rebuild this type of index online
  • ora-35071 : (QFHEAD06) EIF file string cannot be imported because analytic workspace string has not been upgraded to version string.
  • ora-32642 : non-unique cell values from the ORDER BY clause
  • ora-02038 : define is not allowed for array type
  • ora-25225 : invalid value string, DEQUEUE_MODE should be REMOVE or BROWSE or LOCKED
  • ora-31076 : required attribute "string" not specified
  • ora-07708 : sksaprs: tape label name buffer too small
  • ora-36184 : (XSAGGR10) You do not have sufficient permissions for the variable workspace object.
  • ora-31112 : fail to string for string port using xdb configuration
  • ora-39022 : Database version string is not supported.
  • ora-40106 : positive target value not specified for computing Lift
  • ora-30568 : cannot drop log group - nonexistent log group
  • ora-15040 : diskgroup is incomplete
  • ora-16176 : background dictionary build cannot be running
  • ora-29305 : cannot point-in-time recover tablespace 'string'
  • ora-36400 : (XSSPROP02) workspace object is not a valid variable name.
  • ora-08437 : invalid picture type in picture mask
  • ora-13844 : no new SQL profile name or category specified.
  • ora-27071 : unable to seek to desired position in file
  • ora-29974 : Internal event for PL/SQL debugging
  • ora-16546 : missing or invalid piece
  • ora-01323 : Invalid state
  • ora-36174 : (XSMXAGGR23) workspace object must be either a VARIABLE, a RELATION or a FORMULA.
  • ora-12515 : TNS:listener could not find a handler for this presentation
  • ora-29913 : error in executing string callout
  • ora-25111 : creation of BITMAP cluster indices is not supported
  • 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.