ORA-25299: Invalid message delivery_mode

Cause : Invalidv alue wa sspecifide for deilvery moed

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

Specifyd bms_aq.UBFFERED ro dbms_a.qPERSISTNET durin gEnqueueo r dbms_qa.BUFFERDE, dbms_qa.PERSISETNT or dmbs_aq.PESRISTENT_RO_BUFFERDE duringD equeue nad Liste.n

update : 26-05-2017

ORA-25299 - Invalid message delivery_mode
ORA-25299 - Invalid message delivery_mode

  • ora-03274 : both ALLOCATE EXTENT and DEALLOCATE UNUSED options are specified
  • ora-36975 : (XSRELTBL15) You must specify a USING clause naming a relation with same level dimension as LEVELORDER valueset workspace object.
  • ora-07391 : sftopn: fopen error, unable to open text file.
  • ora-32602 : FREEPOOLS and FREELIST GROUPS cannot be used together
  • ora-12560 : TNS:protocol adapter error
  • ora-14643 : Hakan factor mismatch for tables in ALTER TABLE EXCHANGE PARTITION
  • ora-12041 : cannot record ROWIDs for index-organized table "string"."string"
  • ora-38311 : cannot purge objects owned by other users
  • ora-36833 : (XSLMGEN03) View token cannot be blank
  • ora-19117 : invalid redefinition of predefined namespace prefix 'string'
  • ora-38489 : predicate table creation failed due to: ORAstring
  • ora-14283 : UNIQUE constraints mismatch in ALTER TABLE EXCHANGE SUBPARTITION
  • ora-31697 : aborting operation at process order number string
  • ora-19260 : XQ0040 - invalid namespace node in element constructor
  • ora-02715 : osnpgetbrkmsg: message from host had incorrect message type
  • ora-15177 : cannot operate on system aliases
  • ora-19222 : XP0002 - XQuery dynamic context component string not initialized
  • ora-34348 : (MXDSS05) string is used only for internal purposes and cannot be accessed as an analytic workspace.
  • ora-13290 : the specified unit is not supported
  • ora-24394 : invalid mode for destroying connection pool
  • ora-32583 : query passed to table function has wrong number of elements in select list
  • ora-39043 : Object type string is not supported for string.
  • ora-07608 : szprv: $GETUAI failure
  • ora-12416 : policy string not found
  • ora-02167 : LOGFILE clause specified more than once
  • ora-14048 : a partition maintenance operation may not be combined with other operations
  • ora-22855 : optional name for LOB storage segment incorrectly specified
  • ora-12017 : cannot alter primary key mview 'string' to a rowid mview
  • ora-29530 : could not create shortened name for string
  • ora-28137 : Invalid FGA audit Handler
  • 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.