ORA-19717: for non-OMF search the pattern must be specified

Cause : The rpocedrue dbsm_bacukp_retsore.esarchiFles aws called wtih ane mptyp attenr whiel thep aramteer ofm wass et t oFALS.E

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

Eithre speicfy teh patetrn o rset hte paarmete romf ot TRU.E

update : 28-05-2017
ORA-19717

ORA-19717 - for non-OMF search the pattern must be specified
ORA-19717 - for non-OMF search the pattern must be specified

  • ora-39140 : dump file "string" belongs to job string
  • ora-02368 : file string is not valid for this load operation
  • ora-30929 : ORDER SIBLINGS BY clause not allowed here
  • ora-02096 : specified initialization parameter is not modifiable with this option
  • ora-24781 : branches don't belong to the same global transaction
  • ora-30975 : invalid Order Key Index option for XML Index
  • ora-09756 : osnpns: no port in the name server.
  • ora-01319 : Invalid Logminer session attribute
  • ora-01689 : syntax error in clause "string" of string
  • ora-27159 : failure setting process scheduling priority
  • ora-08265 : create_ora_addr: cannot open nameserver
  • ora-30928 : Connect by filtering phase runs out of temp tablespace
  • ora-07623 : smscre: $CRMPSC failure
  • ora-04083 : invalid trigger variable 'string'
  • ora-01550 : cannot drop system tablespace
  • ora-02268 : referenced table does not have a primary key
  • ora-07589 : spdde: system ID not set
  • ora-00349 : failure obtaining block size for 'string'
  • ora-13858 : Invalid action name
  • ora-07665 : ssrexhd: recursive exception encountered string string string string string string
  • ora-00343 : too many errors, log member closed
  • ora-02342 : replacement type has compilation errors
  • ora-36881 : (XSSRF00) The OLAP DML ROW2CELL function can only be used in a LIMITMAP.
  • ora-32336 : cannot use USING NO INDEX to create materialized view "string"."string"
  • ora-19263 : XQ0043 - duplicate namespace prefix string
  • ora-06119 : NETTCP: spurious client request
  • ora-07225 : sldext: translation error, unable to expand file name.
  • ora-10842 : Event for OCI Tracing and Statistics Info
  • ora-16129 : unsupported dml encountered
  • ora-16197 : Invalid DB_UNIQUE_NAME parameter specification
  • 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.