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 : 23-05-2017
ORA-12200

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

  • ora-01084 : invalid argument in OCI call
  • ora-07200 : slsid: oracle_sid not set.
  • ora-31453 : invalid value string for parameter, expecting: Y, N, or NULL
  • ora-36640 : (XSDUNION19) Concat dimension workspace object cannot be changed to UNIQUE because base dimension workspace object does not have a TEXT or ID datatype.
  • ora-25119 : LOGGING/NOLOGGING option already specified
  • ora-24351 : invalid date passed into OCI call
  • ora-19609 : %s is from different backup set: stamp string count string
  • ora-01567 : dropping log string would leave less than 2 log files for instance string (thread string)
  • ora-38303 : invalid option for PURGE TABLESPACE
  • ora-17503 : ksfdopn:string Failed to open file string
  • ora-29346 : invalid tablespace list
  • ora-29929 : missing SCAN Keyword
  • ora-31017 : Error generating unique OID for XML document
  • ora-32109 : invalid column or parameter position
  • ora-32639 : Aggregate functions on reference MODELs are not allowed
  • ora-14459 : missing GLOBAL keyword
  • ora-25436 : invalid table alias: string
  • ora-31217 : DBMS_LDAP: PL/SQL - Invalid LDAP newparent.
  • ora-19682 : file string not in block media recovery context
  • ora-12556 : TNS:no caller
  • ora-07474 : snclrd: close error, unable to close sgadef.dbf file.
  • ora-02171 : invalid value for MAXLOGHISTORY
  • ora-14108 : illegal partition-extended table name syntax
  • ora-24907 : invalid pair of callback and recepient protocol attributes
  • ora-00291 : numeric value required for PARALLEL option
  • ora-00232 : snapshot control file is nonexistent, corrupt, or unreadable
  • ora-19652 : cannot apply offline-range record to datafile string: file is fuzzy
  • ora-31623 : a job is not attached to this session via the specified handle
  • ora-12609 : TNS: Receive timeout occurred
  • ora-00114 : missing value for system parameter SERVICE_NAMES
  • 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.