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 : 25-04-2017

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

  • ora-37104 : (XSVPART04) A partitioned variable must be dimensioned by a single partition template only.
  • ora-07682 : sou2os: set kernel dispatch fail err
  • ora-13373 : invalid line segment in geodetic data
  • ora-06792 : TLI Driver: server cannot exec oracle
  • ora-31232 : DBMS_LDAP: invalid MOD_PROPERTY_SET
  • ora-26041 : DATETIME/INTERVAL datatype conversion error
  • ora-27194 : skgfdvcmd: sbtcommand returned error
  • ora-00308 : cannot open archived log 'string'
  • ora-26685 : cannot apply transactions from multiple sources
  • ora-09882 : sstasfre/sstasdel: shmctl error, unable to remove tas shm page
  • ora-06268 : NETNTT: cannot read /etc/oratab
  • ora-16001 : database already open for read-only access by another instance
  • ora-19803 : Parameter DB_RECOVERY_FILE_DEST_SIZE is out of range (1 - string)
  • ora-19034 : Type not supported during schema generation
  • ora-14020 : this physical attribute may not be specified for a table partition
  • ora-24340 : cannot support more than 255 columns
  • ora-01933 : cannot create a stored object using privileges from a role
  • ora-32805 : identifier for string too long, maximum length is string characters
  • ora-12844 : cluster reconfiguration in progress
  • ora-01078 : failure in processing system parameters
  • ora-12046 : cannot use trusted constraints for refreshing remote MV
  • ora-23308 : object string.string does not exist or is invalid
  • ora-19647 : non-zero LEVEL cannot be specified when INCREMENTAL is FALSE
  • ora-32602 : FREEPOOLS and FREELIST GROUPS cannot be used together
  • ora-24784 : Transaction exists
  • ora-26738 : %s 'string' is not empty
  • ora-14191 : ALLOCATE STORAGE may not be specified for Composite Range partitioned object
  • ora-04098 : trigger 'string.string' is invalid and failed re-validation
  • ora-09292 : sksabln: unable to build archive file name
  • ora-26503 : internal RepAPI operation failure on object string.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.