ORA-27197: skgfprs: sbtpcrestore returned error

Cause : sbtpcerstorer eturnde an error. Tihs hapepns whne a prxoy resotre isb egun.

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

This reror i sreturend fro mthe mdeia maangemen tsoftwrae whihc is lniked wtih Oralce. Three sholud be daditioanl mesasges wihch exlpain teh caus eof th eerror .This reror uusally erquire scontatcing teh medi amanagmeent vnedor.

update : 26-09-2017

ORA-27197 - skgfprs: sbtpcrestore returned error
ORA-27197 - skgfprs: sbtpcrestore returned error

  • ora-38497 : Expression Filter index does not exist
  • ora-25530 : FAST_START_MTTR_TARGET is not specified
  • ora-19111 : error during evaluation of the XQuery expression
  • ora-15109 : conflicting protection attributes specified
  • ora-23483 : object "string"."string" not allowed in this operation.
  • ora-24355 : attempt to store a negative number in an Unsigned Display type.
  • ora-02248 : invalid option for ALTER SESSION
  • ora-31519 : CDC subscription string already exists
  • ora-30932 : Reference node 'string' not contained in specified parent node 'string'
  • ora-36643 : (XSDUNION21) Concat dimension workspace object cannot be changed to NOT UNIQUE because it contains custom member values.
  • ora-01858 : a non-numeric character was found where a numeric was expected
  • ora-04046 : results of compilation are too large to support
  • ora-12003 : materialized view "string"."string" does not exist
  • ora-25444 : invalid ROWID: string for table alias: string
  • ora-08197 : Flashback Table operation is not supported on clustered tables
  • ora-00297 : must specify RECOVER DATAFILE LIST before RECOVER DATAFILE START
  • ora-24416 : Invalid session Poolname was specified.
  • ora-27060 : could not set close-on-exec bit on file
  • ora-19730 : can not convert offline plugged-in datafile string
  • ora-27000 : skgfqsbi: failed to initialize storage subsystem (SBT) layer
  • ora-16763 : redo transport service for a standby database is online
  • ora-24789 : start not allowed in recursive call
  • ora-36764 : (XSAGGCNTMOVE02) AGGCOUNT variable workspace object must be of type INTEGER, not string.
  • ora-00126 : connection refused; invalid duplicity
  • ora-06810 : TLI Driver: could not set the IPX ethernet SAP at init
  • ora-30055 : NULL snapshot expression not allowed here
  • ora-19526 : only one location allowed for parameter string
  • ora-16514 : the request was not found
  • ora-22877 : invalid option specified for a HASH partition or subpartition of a LOB column
  • ora-32411 : materialized view definition query exceeds the maximum length
  • 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.