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 : 27-06-2017

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

  • ora-00386 : use_indirect_data_buffers not supported
  • ora-08117 : Index Organized Table operation released its block pin
  • ora-27021 : sequential file handle must be specified
  • ora-15054 : disk "string" does not exist in diskgroup "string"
  • ora-14313 : Value string does not exist in partition string
  • ora-02878 : sou2o: Variable smpdidini overwritten
  • ora-02246 : missing EVENTS text
  • ora-01509 : specified name 'string' does not match actual 'string'
  • ora-28583 : remote references are not permitted during agent callbacks
  • ora-03134 : Connections to this server version are no longer supported.
  • ora-01085 : preceding errors in deferred rpc to "string.string.string"
  • ora-31067 : XML nodes must be updated with valid nodes and of the same type
  • ora-00474 : SMON process terminated with error
  • ora-31643 : unable to close dump file "string"
  • ora-24031 : invalid value, string should be non-NULL
  • ora-39218 : type check on object type "string"."string" failed
  • ora-16605 : unable to delete template, template is in use
  • ora-01724 : floating point precision is out of range (1 to 126)
  • ora-30345 : circular dimension hierarchy
  • ora-07264 : spwat: semop error, unable to decrement semaphore.
  • ora-27039 : create file failed, file size limit reached
  • ora-36839 : (XSLMGEN09) Cube string.string!string measure string is missing a COLUMNNAME property value
  • ora-38604 : FI including & excluding cursor item-id type must match input cursor item-id type
  • ora-08102 : index key not found, obj# string, file string, block string (string)
  • ora-01947 : TEMPORARY TABLESPACE already specified
  • ora-13462 : invalid blocking specification
  • ora-04042 : procedure, function, package, or package body does not exist
  • ora-37603 : (XSPGERRTEMPSYSTEM) Ran out of temporary storage while writing to a system temporary analytic workspace. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.
  • ora-36834 : (XSLMGEN04) Column tag is greater than 30 bytes
  • ora-30564 : Index maintainence clause not allowed for ADD partition to RANGE partitioned tables
  • 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.