ORA-16707: the value of the property string is invalid, valid values are string

Cause : An invalid property value was entered while broker management of the database was disabled.

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

Reset the value to a correct one.

update : 21-07-2017
ORA-16707

ORA-16707 - the value of the property string is invalid, valid values are string
ORA-16707 - the value of the property string is invalid, valid values are string

  • ora-00290 : operating system archival error occurred. See error below
  • ora-37112 : OLAP API requires Oracle 9.2 or later
  • ora-34489 : (MXMAINT06) You cannot maintain workspace object because it is a SURROGATE.
  • ora-02397 : exceeded PRIVATE_SGA limit, you are being logged off
  • ora-31101 : Token "string" not given while locking resource "string"
  • ora-25331 : cannot downgrade because there are commit-time queue tables
  • ora-31025 : Invalid document element
  • ora-23356 : masterdef recognizes a master which does not recognize the masterdef
  • ora-26008 : Invalid syntax or bind variable in SQL string for column string. string
  • ora-16767 : SQL Apply unexpectedly online
  • ora-09751 : pw_attachPorts: server call pws_attach failed.
  • ora-29353 : The transportable list is too long.
  • ora-03275 : duplicate DEALLOCATE option specification
  • ora-15077 : could not locate ASM instance serving a required diskgroup
  • ora-32056 : invalid number of extents
  • ora-25440 : invalid table alias: string
  • ora-06774 : TLI Driver: error sending break mode
  • ora-32001 : write to SPFILE requested but no SPFILE specified at startup
  • ora-06793 : TLI Driver: server cannot create new process
  • ora-01533 : cannot rename file 'string'; file does not belong to tablespace
  • ora-16709 : standby archived log location settings conflict with flash recovery area
  • ora-02158 : invalid CREATE INDEX option
  • ora-15191 : Internal ASM testing event number 15191
  • ora-13442 : GeoRaster metadata SRS error
  • ora-26528 : local store callback proc phase failed for 'string.string'
  • ora-01629 : max # extents (string) reached saving undo for tablespace string
  • ora-23319 : parameter value string is not appropriate
  • ora-28267 : Invalid NameSpace Value
  • ora-30397 : multiple JOIN KEY clauses specified for the same child level
  • ora-13434 : GeoRaster metadata cellRepresentation error
  • 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.