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 : 27-06-2017

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

  • ora-02090 : network error: attempted callback+passthru
  • ora-14312 : Value string already exists in partition string
  • ora-19691 : %s is from different database: id=string, name=string
  • ora-16514 : the request was not found
  • ora-06440 : ssaio: the asynchronous read returned incorrect number of bytes
  • ora-13855 : Tracing for service (module/action) string on instance string is already enabled
  • ora-13430 : the GeoRaster object has null attribute(s)
  • ora-14037 : partition bound of partition "string" is too high
  • ora-30389 : the source statement is not compatible with the destination statement
  • ora-19704 : file name exceeds maximum length of string
  • ora-13008 : the specified date format has an invalid component
  • ora-30766 : cannot modify scope for a REF column with a REFERENCES constraint
  • ora-29322 : SCN string size too long -- maximum size 58 bytes/characters
  • ora-39113 : Unable to determine database version
  • ora-25187 : specified exceptions table form incorrect
  • ora-34363 : (MXDSS13) number other user writing
  • ora-12088 : cannot online redefine table "string"."string" with unsupported datatype
  • ora-15116 : invalid combination of ALTER DISKGROUP options
  • ora-12222 : TNS:no support is available for the protocol indicated
  • ora-19954 : control file is not current
  • ora-16763 : redo transport service for a standby database is online
  • ora-14401 : inserted partition key is outside specified partition
  • ora-22993 : specified input amount is greater than actual source amount
  • ora-34871 : (PERMIT06) Session-only value 'value' of workspace object has been deleted because a PERMIT change has revealed a duplicate value.
  • ora-01724 : floating point precision is out of range (1 to 126)
  • ora-06312 : IPA: Incorrect outgoing service name supplied
  • ora-29664 : Unable to generate the helper class for the defined type
  • ora-30928 : Connect by filtering phase runs out of temp tablespace
  • ora-01129 : user's default or temporary tablespace does not exist
  • ora-26674 : Column mismatch in 'string.string' (LCR: string type=string; DB: string type=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.