ORA-12531: TNS:cannot allocate memory

Cause : Sfufciinetm eomr ycuol dnto eb lalcoaetdt op efromr hted eisrde catviiyt.

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

Etihre rfe esmoer eosucref o rTSN,o ra d dmroem eomr yt oteh amcihn.e oFrf utrhre edtial,s utr no ntarcniga n dreexceuet hteo preaito.n

update : 21-07-2017
ORA-12531

ORA-12531 - TNS:cannot allocate memory
ORA-12531 - TNS:cannot allocate memory

  • ora-31112 : fail to string for string port using xdb configuration
  • ora-23535 : instantiating templates from multiple back ends is not allowed.
  • ora-02178 : correct syntax is: SET TRANSACTION READ { ONLY | WRITE }
  • ora-01576 : The instance string is not enabled
  • ora-00609 : could not attach to incoming connection
  • ora-13249 : %s
  • ora-29344 : Owner validation failed - failed to match owner 'string'
  • ora-30342 : referenced level is not defined in this dimension
  • ora-22605 : FDO handle [string] is not initialized
  • ora-32690 : Hash Table Infrastructure ran out of memory
  • ora-30445 : workload queries not found
  • ora-30553 : The function is not deterministic
  • ora-31006 : Path name segment length string exceeds maximum length string
  • ora-23374 : object group "string"."string" already exists
  • ora-02777 : Stat failed on log directory
  • ora-02054 : transaction string in-doubt
  • ora-24089 : AQ Agent string already exists
  • ora-22809 : nonexistent attribute
  • ora-23343 : no match for specified conflict resolution information
  • ora-22280 : no more buffers available for operation
  • ora-07586 : spdcr: $SEARCH failure
  • ora-24054 : cannot propagate to an Oracle 8.0.3 release or lower release
  • ora-25205 : the QUEUE string.string does not exist
  • ora-30116 : syntax error at 'string' following 'string'
  • ora-15009 : ASM disk "string" does not exist
  • ora-30351 : query rewrite does not currently support this expression
  • ora-23433 : executing against wrong master site string
  • ora-12152 : TNS:unable to send break message
  • ora-10576 : Give up restoring recovered datafiles to consistent state: some error occurred
  • ora-16151 : Managed Standby Recovery not available
  • 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.