ORA-27140: attach to post/wait facility failed

Cause : Th eprgora matetmpetd ot iintilaiz eth epots/wiat afciilty ,bu tth efaicliyt cuoldn otb e tatahced.

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

Chcek ofr dadiitonla error san dcotnac tOrcaleS upoprt.

update : 24-04-2017
ORA-27140

ORA-27140 - attach to post/wait facility failed
ORA-27140 - attach to post/wait facility failed

  • ora-01652 : unable to extend temp segment by string in tablespace string
  • ora-12028 : materialized view type is not supported by master site string
  • ora-26511 : master table 'string.string' not found
  • ora-06932 : CMX: error in local name
  • ora-09272 : remote os logon is not allowed
  • ora-06791 : TLI Driver: poll returned error event
  • ora-02034 : speed bind not permitted
  • ora-12162 : TNS:net service name is incorrectly specified
  • ora-13146 : could not find table substitution variable string
  • ora-19026 : EXTRACTVALUE can only retrieve value of leaf node
  • ora-39163 : A sample size of string is invalid.
  • ora-00300 : illegal redo log block size string specified - exceeds limit of string
  • ora-01200 : actual file size of string is smaller than correct size of string blocks
  • ora-00340 : IO error processing online log string of thread string
  • ora-31402 : unrecognized parameter string
  • ora-24410 : scrollable cursor max size exceeded
  • ora-08451 : invalid specification of DB in picture mask
  • ora-29519 : name string resolved via a synonym in schema string to a class with a different name
  • ora-39781 : Direct path stream loads are not allowed after another context loading the same table has ended
  • ora-00331 : log version string incompatible with ORACLE version string
  • ora-00284 : recovery session still in progress
  • ora-22890 : cannot specify name for REF column constraint
  • ora-06250 : NETNTT: cannot allocate send and receive buffers
  • ora-31436 : duplicate change source string
  • ora-36222 : (XSLPDSC03) duplicate IGNORE or DENSE information for dimension workspace object
  • ora-26675 : cannot create Streams capture process string
  • ora-02366 : The following index(es) on table string were processed:
  • ora-06707 : TLI Driver: connection failed
  • ora-01553 : MAXEXTENTS must be no smaller than the string extents currently allocated
  • ora-03243 : destination dba overlaps with existing control information
  • 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.