ORA-12200: TNS:could not allocate memory

Cause : Out of memory on machine.

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

Reconfigure machine to have more storage or run fewer applications while the Interchange is running.

update : 26-06-2017
ORA-12200

ORA-12200 - TNS:could not allocate memory
ORA-12200 - TNS:could not allocate memory

  • ora-29963 : missing BINDING keyword
  • ora-14099 : all rows in table do not qualify for specified partition
  • ora-36270 : (XSCGMDLAGG03) The parameter list for the AGGREGATION function includes duplicate values.
  • ora-07636 : smsdbp: $MGBLSC failure
  • ora-30338 : illegal dimension hierachy name
  • ora-06311 : IPA: Maximum number of servers reached
  • ora-16724 : the intended state for the database has been set to OFFLINE
  • ora-13154 : invalid precision specified
  • ora-01704 : string literal too long
  • ora-02762 : file number to be cancelled is greater than the maximum.
  • ora-14327 : Some index [sub]partitions could not be rebuilt
  • ora-28276 : Invalid ORACLE password attribute.
  • ora-19244 : XQ0024 - invalid attribute node in element constructor
  • ora-23469 : %s is different between templates
  • ora-38752 : file string does not exist
  • ora-09361 : Windows 3.1 Two-Task driver unable to lock context area
  • ora-30976 : invalid Parent Order Key Index option for XML Index
  • ora-08263 : ora_addr: cannot free listener address
  • ora-26530 : unable to build materialized view refresh control list
  • ora-30487 : ORDER BY not allowed here
  • ora-16783 : instance string not open for read and write access
  • ora-12531 : TNS:cannot allocate memory
  • ora-01600 : at most one "string" in clause "string" of string
  • ora-38787 : Creating the first guaranteed restore point requires mount mode when flashback database is off.
  • ora-19580 : %s conversation not active
  • ora-00370 : potential deadlock during kcbchange operation
  • ora-02001 : user SYS is not permitted to create indexes with freelist groups
  • ora-24339 : cannot set server group name after connecting to server
  • ora-19204 : Non-scalar value 'string' is marked as XML attribute
  • ora-33000 : (AGOPEN00) AGGMAP workspace object cannot be accessed because it was compiled by a more recent version of string.
  • 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.