ORA-27190: skgfrd: sbtread2 returned error

Cause : bsrtae derutnrdea nreor.rT ih sahppne shwli eerdani g aabkcpuf li eudirgna r seotero eparitno.

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

hTsie rrroi serutnrdef or mht eemid aamanegemtns fowtra ehwci hsil niek diwhtO arlc.eT ehers ohlu deba ddtioian lemssgasew ihhce pxalnit ehc uaeso fht ereor.rT ih sreor rsuaull yeruqrisec noattcni ght eemid aamanegemtnv neod.r

update : 27-05-2017
ORA-27190

ORA-27190 - skgfrd: sbtread2 returned error
ORA-27190 - skgfrd: sbtread2 returned error

  • ora-31000 : Resource 'string' is not an XDB schema document
  • ora-30772 : opaque types do not have default constructors
  • ora-37135 : (XSCCOMP10) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object. The RELATION statement for dense dimension workspace object must precede RELATION statements over the bases of the COMPRESSED COMPOSITE.
  • ora-14518 : partition contains rows corresponding to values being dropped
  • ora-02399 : exceeded maximum connect time, you are being logged off
  • ora-21300 : objects option not installed
  • ora-02186 : tablespace resource privilege may not appear with other privileges
  • ora-10659 : Segment being shrunk is not a lob
  • ora-06028 : NETASY: unable to intialise for logging
  • ora-01517 : log member: 'string'
  • ora-36670 : (XSDPART08) workspace object is an INTEGER or NTEXT dimension, or contains an INTEGER or NTEXT dimension. INTEGER and NTEXT dimensions cannot be used as partition dimensions.
  • ora-00447 : fatal error in background process
  • ora-07228 : rtecho: unable to restore terminal to echo mode.
  • ora-30200 : Wrong NLS item was passed into OCINlsGetInfo()
  • ora-01751 : Invalid dump undo option
  • ora-23339 : duplicate conflict resolution information
  • ora-37602 : (XSPGERRTEMPUSER) Ran out of temporary storage while writing to analytic workspace string. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.
  • ora-01605 : missing numbers in clause "string" of string
  • ora-26665 : STREAMS process string already exists
  • ora-10655 : Segment can be shrunk
  • ora-07617 : $FORMAT_CLASS failed translating the binary label to a string
  • ora-38454 : attribute set not defined for the column being indexed
  • ora-19279 : XQuery dynamic type mismatch: expected singleton sequence - got multi-item sequence
  • ora-30990 : insufficient privileges to change owner of resource string
  • ora-27032 : failed to obtain file size limit
  • ora-02490 : missing required file size in RESIZE clause
  • ora-00215 : must be at least one control file
  • ora-01257 : cannot reuse database file string, unknown file size
  • ora-02825 : Request on free list was not free
  • ora-00133 : value of string is too long
  • 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.