ORA-27147: post/wait reset failed

Cause : OS system call failed

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

check errno and contact Oracle Support

update : 23-08-2017
ORA-27147

ORA-27147 - post/wait reset failed
ORA-27147 - post/wait reset failed

  • ora-36820 : (XSLMINFO00) The LIMITMAPINFO function encountered an error while parsing the LIMITMAP.
  • ora-12224 : TNS:no listener
  • ora-33557 : (MAINTCHK01) You cannot string values of dimension workspace object during a loop over it.
  • ora-13852 : Tracing for service(module/action) string is not enabled
  • ora-16260 : Waiting to replace partial or corrupt logfile (thread# string, sequence# string)
  • ora-16252 : Rebuild operation not permitted
  • ora-13336 : failure in converting standard diminfo/geometry to LRS dim/geom
  • ora-23371 : column string unknown in table string
  • ora-13002 : specified level is out of range
  • ora-22314 : method information mismatch in ALTER TYPE
  • ora-09320 : szrfc: unable to obtain the list of valid OS roles
  • ora-01607 : cannot add logfile to the specified instance
  • ora-39021 : Database compatibility version string is not supported.
  • ora-33282 : (DBERR11) Cannot wait for analytic workspace string to become available since doing so would cause a deadlock.
  • ora-02703 : osnpopipe: pipe creation failed
  • ora-00350 : log string of instance string (thread string) needs to be archived
  • ora-01502 : index 'string.string' or partition of such index is in unusable state
  • ora-26089 : LONG column "string" must be specified last
  • ora-25182 : feature not currently available for index-organized tables
  • ora-00329 : archived log begins at change string, need change string
  • ora-38486 : FUNCTION/PACKAGE/TYPE already exists for the attribute set
  • ora-02183 : valid options: ISOLATION_LEVEL { SERIALIZABLE | READ COMMITTED }
  • ora-02222 : invalid PCTINCREASE storage option value
  • ora-16751 : resource guard encountered errors in switchover to primary database
  • ora-03205 : partition name is required when partitioned type is specified
  • ora-30363 : columns in a dimension column list must be in the same relation
  • ora-06748 : TLI Driver: cannot allocate t_discon
  • ora-32600 : RETENTION and PCTVERSION cannot be used together
  • ora-39130 : Object type string not imported. Base object name conflicts with the master table
  • ora-38602 : FI invalid input cursor
  • 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.