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 : 21-09-2017
ORA-27140

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

  • ora-06541 : PL/SQL: compilation error - compilation aborted
  • ora-30160 : Unable to access the file
  • ora-13044 : the specified tile size is smaller than the tolerance
  • ora-24044 : source string and destination string object types do not match
  • ora-28270 : Malformed user nickname for password authenticated global user.
  • ora-12469 : no user levels found for user string and policy string
  • ora-36778 : (XSPGTRLOW) The amount of available temporary storage is still low. Free some temporary storage immediately. You can do so, for example, by UPDATING or DETACHING an analytic workspace.
  • ora-19108 : WHITESPACE keyword expected
  • ora-03217 : invalid option for alter of TEMPORARY TABLESPACE
  • ora-25140 : %s space policy cannot be specified for the string extent management
  • ora-09791 : slembdf: translation error, unable to translate error file name.
  • ora-25259 : cannot specify protocol for agent
  • ora-38493 : feature not enabled : Expression Filter index
  • ora-19259 : XQ0039 - duplicate parameter name string in function declaration
  • ora-24129 : table name string does not start with string prefix
  • ora-12704 : character set mismatch
  • ora-19115 : too many context items specified
  • ora-09919 : Unable to set label of dedicated server
  • ora-00109 : invalid value for attribute string: string
  • ora-13485 : error occurred during compression or decompression: string
  • ora-39706 : schema 'string' not found
  • ora-04079 : invalid trigger specification
  • ora-30076 : invalid extract field for extract source
  • ora-16708 : the state supplied to resource guard is invalid
  • ora-09265 : spwat: error temporarily suspending process
  • ora-00287 : specified change number string not found in thread string
  • ora-00130 : invalid listener address 'string'
  • ora-19125 : fn:exactly-one() called with a sequence containing zero or more than one item
  • ora-12011 : execution of string jobs failed
  • ora-32342 : The EXPLAIN_MVIEW facility failed to explain the materialized view statement
  • 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.