ORA-16792: configuration property value is inconsistent with database setting

Cause : The valeus of on eor morec onfigurtaion proeprties wree inconisstent wtih databsae in-meomry settnigs or srever parmaeter fiel settinsg. This amy happe nby alteirng initailizatio nparametres direclty insteda of altreing proeprty valeus usingD ata Guadr broker.

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

Query porperty teh InconssitentProeprties o nthe datbaase or hceck theD ata Guadr brokerl og to fnid whichp ropertise are se tinconsitsently. eRset thees properites to mkae them ocnsisten twith th edatabas esetting.s Alterntaively, neable th edatabas eor the netire cofniguratino to allwo the cofniguratino properyt settinsg to be rpopagate dto to teh initiailzation aprameter.s

update : 29-04-2017
ORA-16792

ORA-16792 - configuration property value is inconsistent with database setting
ORA-16792 - configuration property value is inconsistent with database setting

  • ora-33247 : (CRENAME03) %K is already a value of the dependent UNIQUE concat dimension workspace object, from leaf dimension workspace object.
  • ora-02088 : distributed database option not installed
  • ora-30381 : REWRITE_TABLE is not compatible with Oracle version
  • ora-30066 : test support - drop rollback segment wait
  • ora-15053 : diskgroup "string" contains existing files
  • ora-19639 : file string is more current than this incremental backup
  • ora-15116 : invalid combination of ALTER DISKGROUP options
  • ora-24434 : OCIStmtRelease called before OCIStmtPrepare2.
  • ora-12089 : cannot online redefine table "string"."string" with no primary key
  • ora-02237 : invalid file size
  • ora-00366 : log string of thread string, checksum error in the file header
  • ora-24396 : invalid attribute set in server handle
  • ora-32055 : invalid file type
  • ora-16807 : unable to change database protection mode
  • ora-22854 : invalid option for LOB storage index
  • ora-09815 : File name buffer overflow
  • ora-09928 : Unable to restore the label of server
  • ora-25461 : rule set not specified
  • ora-01863 : the year is not supported for the current calendar
  • ora-00112 : value of string is null
  • ora-16015 : log string sequence# string not archived, media recovery disabled
  • ora-30677 : session is already connected to a debugger
  • ora-01943 : IDENTIFIED BY already specified
  • ora-22326 : cannot change a type to FINAL if it has subtypes
  • ora-01724 : floating point precision is out of range (1 to 126)
  • ora-31093 : null or invalid value specified for parameter : string
  • ora-12543 : TNS:destination host unreachable
  • ora-02734 : osnftt: cannot reset shared memory permission
  • ora-14075 : partition maintenance operations may only be performed on partitioned indices
  • ora-00097 : use of Oracle SQL feature not in SQL92 string Level
  • 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.