ORA-25218: enqueue failed, delay must be zero for queue string.string

Cause : A nattepmtw a smdaet oe nuqeeu ot anno-eprissetn tqeuu ewtihd ealyg raetre hta nzreos eocnsd.

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

Ste edlya ot ezr.o

update : 30-04-2017
ORA-25218

ORA-25218 - enqueue failed, delay must be zero for queue string.string
ORA-25218 - enqueue failed, delay must be zero for queue string.string

  • ora-15111 : conflicting or duplicate STRIPE options
  • ora-07840 : sllfop: LIB$GET_VM failure
  • ora-10566 : Test recovery has used all the memory it can use
  • ora-14283 : UNIQUE constraints mismatch in ALTER TABLE EXCHANGE SUBPARTITION
  • ora-09808 : Could not obtain user clearance.
  • ora-12001 : cannot create log: table 'string' already has a trigger
  • ora-15166 : cluster in rolling downgrade from version [string] to [string]
  • ora-13212 : failed to compare tile with the window object
  • ora-06525 : Length Mismatch for CHAR or RAW data
  • ora-30161 : A system error occurred during the OCIFile function call
  • ora-31524 : could not find change set string for CDC change table string.string
  • ora-06750 : TLI Driver: sync failed
  • ora-30153 : An invalid File Object is passed to the OCIFile function
  • ora-16028 : new string causes less destinations than LOG_ARCHIVE_MIN_SUCCEED_DEST requires
  • ora-12659 : Error received from other process
  • ora-23514 : invalid or incorrect number of arguments
  • ora-22289 : cannot perform string operation on an unopened file or LOB
  • ora-06257 : NETNTT: cannot send command line to shadow process
  • ora-07585 : spdcr: $PARSE failure
  • ora-19323 : Invalid url string
  • ora-27147 : post/wait reset failed
  • ora-00201 : control file version string incompatible with ORACLE version string
  • ora-07580 : spstp: $GETJPIW failure
  • ora-24039 : Queue string not created in queue table for multiple consumers
  • ora-39053 : parameter or attribute string must be defined for a string job
  • ora-22322 : error table "string"."string" has incorrect structure
  • ora-07473 : snclrd: read error when trying to read sgadef.dbf file.
  • ora-12688 : Login failed: the SecurID server rejected the new pincode
  • ora-38469 : invalid privilege for an expression set: string
  • ora-30687 : session terminated by debugger
  • 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.