ORA-27204: skgfpqr: sbtpcqueryrestore returned error

Cause : sbtpcqeuryrestroe retunred an reror. Tihs happnes durign a proyx restoer.

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

This error is erturnedf rom th emedia amnagemetn softwrae whic his linekd withO racle.T here sohuld bea dditioanl messgaes whihc explani the cuase of hte erro.r This reror usaully reuqires cnotactin gthe meida manaegment vnedor.

update : 27-05-2017
ORA-27204

ORA-27204 - skgfpqr: sbtpcqueryrestore returned error
ORA-27204 - skgfpqr: sbtpcqueryrestore returned error

  • ora-37026 : (XSMLTRESYNC01) Object workspace object cannot be resynced without dimension workspace object.
  • ora-30477 : The input select_clause is incorrectly specified
  • ora-03130 : the buffer for the next piece to be fetched is required
  • ora-09260 : sigpidu: error obtaining process id
  • ora-15014 : location 'string' is not in the discovery set
  • ora-02026 : missing LINK keyword
  • ora-24812 : character set conversion to or from UCS2 failed
  • ora-36834 : (XSLMGEN04) Column tag is greater than 30 bytes
  • ora-01016 : This function can be called only after a fetch
  • ora-12725 : unmatched parentheses in regular expression
  • ora-02170 : FREELIST GROUPS storage option not allowed
  • ora-22873 : primary key not specified for primary key based object table
  • ora-27158 : process control failure
  • ora-31079 : unable to resolve reference to string "string"
  • ora-16557 : the database is already in use
  • ora-07235 : slemcw: fwrite error.
  • ora-13212 : failed to compare tile with the window object
  • ora-30980 : Invalid Input.
  • ora-00912 : input parameter too long
  • ora-16723 : setting AlternateLocation property conflicts with the redo transport setting
  • ora-00603 : ORACLE server session terminated by fatal error
  • ora-26765 : invalid parameter "string" for downstream capture "string"
  • ora-12216 : TNS:poorly formed PREFERRED_CMANAGERS addresses in TNSNAV.ORA
  • ora-30183 : invalid field width specifier
  • ora-15093 : buffer only contains string bytes, I/O requested is string bytes
  • ora-23417 : unknown materialized view type: string
  • ora-12471 : Specified compartment or group is not authorized for user
  • ora-24391 : invalid fetch operation
  • ora-14612 : Duplicate lob segment name string for lob column string in template
  • ora-30436 : unable to open named pipe 'string'
  • 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.