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 : 20-08-2017

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

  • ora-15182 : ASMLIB [string] version mismatch, ORACLE version [string]
  • ora-02007 : can't use ALLOCATE or DEALLOCATE options with REBUILD
  • ora-13505 : SYSAUX tablespace can not be made read only
  • ora-02143 : invalid STORAGE option
  • ora-38746 : error occurred while restoring data block (file# string, block# string)
  • ora-27025 : skgfqsbi: invalid media manager context area size
  • ora-23615 : Block number string does not exist for script string
  • ora-31498 : description and remove_description cannot both be specified
  • ora-30485 : missing ORDER BY expression in the window specification
  • ora-13015 : the window definition is not valid
  • ora-26508 : null materialized view connection
  • ora-14176 : this attribute may not be specified for a hash partition
  • ora-13643 : The task can not be interrupted or cancelled.
  • ora-12068 : updatable mview log for mview "string"."string" does not exist
  • ora-22310 : ALTER TYPE error. Refer to table "string"."string" for errors
  • ora-15060 : template "string" does not exist
  • ora-38771 : unnamed datafile(s) added to control file by flashback recovery
  • ora-13049 : unable to determine tolerance value from table _SDODIM
  • ora-30005 : missing or invalid WAIT interval
  • ora-15176 : file 'string' already has an alias associated with it
  • ora-06004 : NETASY: dialogue file open failure
  • ora-21700 : object does not exist or is marked for delete
  • ora-12832 : Could not allocate slaves on all specified instances
  • ora-12234 : TNS:Redirect to destination
  • ora-16197 : Invalid DB_UNIQUE_NAME parameter specification
  • ora-38720 : Missing log file number.
  • ora-23447 : missing user parameter value
  • ora-07684 : sou2os: supervisor stack reset error
  • ora-16218 : This database is already preparing to switch over.
  • ora-00314 : log string of thread string, expected sequence# string doesn't match string
  • 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.