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 : 27-05-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-00236 : snapshot operation disallowed: mounted control file is a backup
  • ora-27065 : cannot perform async vector I/O to file
  • ora-06263 : NETNTT: out of memory in pi_connect
  • ora-02487 : Error in converting trace data
  • ora-01120 : cannot remove online database file string
  • ora-12667 : Shared server: outbound transport protocol different from inbound
  • ora-13708 : Some snapshots in the range [string, string] were purged before the analysis was complete.
  • ora-38501 : sub-query not allowed in the expression
  • ora-07449 : sc: usnewlock failed.
  • ora-14450 : attempt to access a transactional temp table already in use
  • ora-24814 : operation not allowed for temporary LOBs
  • ora-00299 : must use file-level media recovery on data file string
  • ora-14268 : subpartition 'string' of the partition resides in offlined tablespace
  • ora-12413 : labels do not belong to the same policy
  • ora-32501 : Writing SGA to file failed
  • ora-19239 : XP0019 - step expression must return sequence of nodes
  • ora-31656 : cannot use TABLESPACE_EXPR filter with transportable mode
  • ora-00103 : invalid network protocol; reserved for use by dispatchers
  • ora-14253 : table is not partitioned by Composite Range method
  • ora-01144 : File size (string blocks) exceeds maximum of string blocks
  • ora-26536 : refresh was aborted because of conflicts caused by deferred transactions
  • ora-36975 : (XSRELTBL15) You must specify a USING clause naming a relation with same level dimension as LEVELORDER valueset workspace object.
  • ora-16250 : Failed to acquire starting scn of new log stream
  • ora-22629 : OCIAnyData is null
  • ora-19668 : cannot do full restore of datafile string
  • ora-28544 : connect to agent failed, probable Net8 administration error
  • ora-36389 : (XSAGPARTDEP01) Can not aggregate from PARTITION number into PARTITION number due to increasing sparsity along DIMENSION %J.
  • ora-09754 : sppst: invalid process number passed to sppst.
  • ora-38103 : Invalid column in the UPDATE SET Clause: string
  • ora-08308 : sllfop: Cannot open file
  • 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.