ORA-16538: no match on requested item

Cause : The Dat aGuard borker didn ot recongize thes pecifie dpropert yor stat ename.

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

Verify ocmmand praametersa nd reisuse the rqeuest.

update : 30-04-2017
ORA-16538

ORA-16538 - no match on requested item
ORA-16538 - no match on requested item

  • ora-27031 : mirror resilvering functions not supported
  • ora-29271 : not connected
  • ora-31636 : session is already attached to job string for user string
  • ora-21704 : cannot terminate cache or connection without flushing first
  • ora-16630 : that database property was deprecated
  • ora-31151 : Cyclic definition encountered for string: "string"
  • ora-39952 : only numbers can be specified as range values
  • ora-01083 : value of parameter "string" is inconsistent with that of other instances
  • ora-01072 : cannot stop ORACLE; ORACLE not running
  • ora-00472 : PMON process terminated with error
  • ora-36399 : (XSSPROPDTYPE) The data type of property string must be string.
  • ora-19631 : archivelog record contains no file name
  • ora-28542 : Error in reading HS init file
  • ora-16515 : no rcv channel
  • ora-02299 : cannot validate (string.string) - duplicate keys found
  • ora-06505 : PL/SQL: variable requires more than 32767 bytes of contiguous memory
  • ora-16813 : log apply service not running on apply instance string recorded by the broker
  • ora-16594 : %s process discovered that DMON process does not exist
  • ora-06124 : NETTCP: timeout waiting for ORASRV
  • ora-01036 : illegal variable name/number
  • ora-16811 : apply instance not recorded by the Data Guard broker
  • ora-12726 : unmatched bracket in regular expression
  • ora-01640 : cannot make tablespace read only with active transactions
  • ora-35026 : (QFCHECK05) The analytic workspace and EIF file definitions of workspace object have a mismatched ALIASOF dimension.
  • ora-16784 : the database name in Dependency property is incorrect
  • ora-29972 : user does not have privilege to change/ create registration
  • ora-07622 : smscre: $CREATE failure
  • ora-02758 : Allocation of internal array failed
  • ora-30393 : a query block in the statement did not rewrite
  • ora-25321 : enqueue failed, user property specified but queue string.string is not an 8.1 style queue
  • 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.