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 : 25-04-2017
ORA-27197

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

  • ora-26025 : SKIP_INDEX_MAINTENANCE option requested
  • ora-14058 : partition number string: INITRANS value must be less than MAXTRANS value
  • ora-10924 : import storage parse error ignore event
  • ora-29361 : value string is outside valid range of 0 to 100
  • ora-19030 : Method invalid for non-schema based XML Documents.
  • ora-26091 : requested direct path operation not supported
  • ora-01859 : a non-alphabetic character was found where an alphabetic was expected
  • ora-29970 : Specified registration id does not exist
  • ora-07274 : spdcr: access error, access to oracle denied.
  • ora-13451 : GeoRaster metadata scaling function error
  • ora-30962 : inconsistent ODCI input arguments
  • ora-38723 : Invalid SCN expression.
  • ora-26018 : Column string in table string does not exist
  • ora-36810 : (XSTBLFUNC05) Analytic workspace object number does not exist.
  • ora-30348 : ADD and DROP cannot both be specified
  • ora-27250 : OS system call failure
  • ora-29874 : warning in the execution of ODCIINDEXALTER routine
  • ora-25303 : Buffered operation allowed only on the owner instance
  • ora-14026 : PARTITION and CLUSTER clauses are mutually exclusive
  • ora-06592 : CASE not found while executing CASE statement
  • ora-00406 : COMPATIBLE parameter needs to be string or greater
  • ora-01226 : file header of log member is inconsistent with other members
  • ora-04042 : procedure, function, package, or package body does not exist
  • ora-27472 : invalid metadata attribute string
  • ora-24045 : invalid agent address string, agent address should be of the form [SCHEMA.]NAME[@DATABASE LINK]
  • ora-36278 : (XSCGMDLAGG07) workspace object does not exist or is not valueset.
  • ora-14099 : all rows in table do not qualify for specified partition
  • ora-28155 : user 'string' specified as a proxy is actually a role
  • ora-19605 : input filename must be specified
  • ora-12335 : database (link name string) is not open
  • 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.