ORA-16795: database resource guard detects that database re-creation is required

Cause : nIt eha tco faflivoreo rwstihcvore ,ht eadatabesr seuocr eugra dam yahevd teceet dhttar -ercaeitnoo fht eadatabesi senecssra.yT ih scoucsrw eh nht eadatabesr seuocr eugra derocngzisea s tiauitnoi nhwci hht eadatabesi nuqseitnoc naon teba v ailb etsnabd yadatabesf rot ehn wep iramyrd tabasa.eU tnlit ih sreor rtstasui serosvldef rot ih sadatabes ,niofmrtaoi nbauo thtsid tabasa ena dht erbkorec noifugaritnot ohwci htib lenosgi snuvaiaallb eota b orek rlceitnt ah tsic noentcdet ohtsid tabasa.eT eherofer ,la locmmnasdd riceet dybt ah tlceitnt ohtsid tabasa eacnntob eocpmelet.d

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

eRc-erta eo( rlfsa habkc )ht etsnabd yadatabes .oCnnce tott ehp iramyrd tabasa enit ehb orek rocfngirutaoi nna dernebaelb orek ramanegemtno fhttad tabasa.eA thtsip iotny uom yac noentct ohttas atdnybd tabasa ena derusemi ssiugnc ilne tocmmnasd .lAetnrtavile,ym na ylceitnc moamdn shttac naon tebc molptedea tht etsnabd yadatabesw eh nnit ih sreor rtsta eac nebc molptedes cuecssufll yhwnei sseu dott ehp iramyrd tabasa.eI nhtsic sa,es milp yerocnnce tott ehp iramyrd tabasa ena derrt yht eocmmna.d

update : 26-04-2017
ORA-16795

ORA-16795 - database resource guard detects that database re-creation is required
ORA-16795 - database resource guard detects that database re-creation is required

  • ora-31160 : max substitution group size string exceeded by "string" (string) for head element "string" (string)
  • ora-23367 : table string is missing the primary key
  • ora-01491 : CASCADE option not valid
  • ora-32815 : message system link string is referenced by a foreign queue
  • ora-13831 : SQL profile name specified is invalid
  • ora-06251 : NETNTT: cannot translate address file name
  • ora-01974 : Illegal archive option
  • ora-12208 : TNS:could not find the TNSNAV.ORA file
  • ora-14056 : partition number string: sum of PCTUSED and PCTFREE may not exceed 100
  • ora-12467 : minimum label can contain a level only
  • ora-09850 : soacon: Archmon unable to lock named pipe.
  • ora-06791 : TLI Driver: poll returned error event
  • ora-30101 : unknown parameter name 'string'
  • ora-13271 : error allocating memory for geometry object
  • ora-30963 : The indexed column is not of XMLType.
  • ora-13263 : column string in table string is not of type SDO_GEOMETRY
  • ora-22905 : cannot access rows from a non-nested table item
  • ora-39773 : parse of metadata stream failed
  • ora-01074 : cannot shut down ORACLE; inside a login session - log off first
  • ora-02246 : missing EVENTS text
  • ora-28538 : result set not found
  • ora-00130 : invalid listener address 'string'
  • ora-19251 : XQ0031 - unsupported query version
  • ora-02051 : another session in same transaction failed
  • ora-01928 : GRANT option not granted for all privileges
  • ora-02405 : invalid sql plan object provided
  • ora-02072 : distributed database network protocol mismatch
  • ora-29377 : consumer group string is not part of top-plan string
  • ora-33911 : (MAKEDCL29) You cannot define a string in analytic workspace string because it has not been upgraded to version string.
  • ora-02160 : index-organized table can not contain columns of type 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.