ORA-27192: skgfcls: sbtclose2 returned error - failed to close file

Cause : sbtclose2 returned an error. This happens while closing a backup file during a backup or restore operation.

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

This error is returned from the media management software which is linked with Oracle. There should be additional messages which explain the cause of the error. This error usually requires contacting the media management vendor.

update : 21-08-2017
ORA-27192

ORA-27192 - skgfcls: sbtclose2 returned error - failed to close file
ORA-27192 - skgfcls: sbtclose2 returned error - failed to close file

  • ora-01496 : specified chain row table form incorrect
  • ora-32580 : both SYS and SYSTEM passwords must be provided
  • ora-02368 : file string is not valid for this load operation
  • ora-02235 : this table logs changes to another table already
  • ora-09952 : scgcmn: lk_open_convert unexpected return: open failed
  • ora-22884 : object modification failed
  • ora-10943 : trace name context forever
  • ora-27399 : job type EXECUTABLE requires the CREATE EXTERNAL JOB privilege
  • ora-10360 : enable dbwr consistency checking
  • ora-31633 : unable to create master table "string.string"
  • ora-01576 : The instance string is not enabled
  • ora-09988 : error while detaching SGA
  • ora-22854 : invalid option for LOB storage index
  • ora-36685 : (XSDPART23) Only CONCAT partition templates can be subpartitioned.
  • ora-02494 : invalid or missing maximum file size in MAXSIZE clause
  • ora-00356 : inconsistent lengths in change description
  • ora-31456 : error executing a procedure in the DBMS_CDC_UTILITY package
  • ora-26502 : error resignal
  • ora-07237 : slemcl: invalid file handle, seals do not match.
  • ora-14511 : cannot perform operation on a partitioned object
  • ora-09841 : soacon: Name translation failure.
  • ora-30439 : refresh of 'string.string' failed because of string
  • ora-37603 : (XSPGERRTEMPSYSTEM) Ran out of temporary storage while writing to a system temporary analytic workspace. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.
  • ora-29865 : indextype is invalid
  • ora-32015 : unable to restore SPFILE
  • ora-14163 : subpartition number string: INITRANS value must be less than MAXTRANS value
  • ora-07483 : snlkget: cannot convert(get) lock.
  • ora-07804 : slpdtb: number too large for supplied buffer
  • ora-36208 : (XSAGOP05N) In AGGMAP workspace object, you can only specify NAOPERATOR string with the PROPORTIONAL or EVEN operators, not string.
  • ora-32145 : Environment not specified
  • 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.