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 : 25-04-2017
ORA-25299

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

  • ora-16408 : Incompatible archival Redo Branch lineage
  • ora-23455 : flavor string contains object "string"
  • ora-25007 : functions or methods not allowed in WHEN clause
  • ora-06321 : IPA: Cannot reach the remote side
  • ora-40223 : data mining model import failed, job name=string, error=string
  • ora-10661 : Invalid option specified
  • ora-00956 : missing or invalid auditing option
  • ora-39149 : cannot link privileged user to non-privileged user
  • ora-13860 : Invalid service name
  • ora-30068 : Internal Event to turn on nested
  • ora-02218 : invalid INITIAL storage option value
  • ora-09882 : sstasfre/sstasdel: shmctl error, unable to remove tas shm page
  • ora-38853 : cannot mark instance string (redo thread string) as disabled
  • ora-36402 : (XSSPROP03) The property '$string' requires a leading "$" because it is a system-reserved property name.
  • ora-12098 : cannot comment on the materialized view
  • ora-31104 : Cannot find lock with token "string" on "string" for unlock
  • ora-19681 : block media recovery on control file not possible
  • ora-39950 : invalid parameter for PLSQL warnings flag
  • ora-38719 : Invalid DUMP FLASHBACK object.
  • ora-38438 : getVarchar not possible due to "string" datatype in the attribute set
  • ora-16068 : redo log file activation identifier mismatch
  • ora-10948 : trace name context forever
  • ora-10900 : extent manager fault insertion event #string
  • ora-24329 : invalid character set identifier
  • ora-16546 : missing or invalid piece
  • ora-16950 : Remote mapped cursors are not supported by this feature.
  • ora-12815 : value for INSTANCES must be greater than 0
  • ora-31190 : Resource string is not a version-controlled resource
  • ora-30752 : column or table string is not substitutable
  • ora-10854 : Sets poll count used for AQ listen code under RAC
  • 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.