ORA-26699: STREAMS message consumer string already exists

Cause : An tatemtp wa smad eto rceat ea SRTEAM Smesasge ocnsuemr taht arlead yexitss.

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

Eitehr sepcif yanohter TSREASM messagec onsmuer ro reomve hte eixstign STERAMSm essgae cnosumre.

update : 28-04-2017
ORA-26699

ORA-26699 - STREAMS message consumer string already exists
ORA-26699 - STREAMS message consumer string already exists

  • ora-24280 : invalid input value for parameter string
  • ora-13344 : an arcpolygon geometry has fewer than five coordinates
  • ora-25286 : Invalid number of elements in the message properties array
  • ora-40206 : invalid setting value for setting name string
  • ora-36982 : (XSRELGID03) The grouping variable/relation workspace object must be dimensioned by all dimensions of the source relation workspace object that have more than one value in status.
  • ora-34143 : (MXCGPUT02) You cannot assign values to SURROGATE workspace object because it is type INTEGER.
  • ora-36740 : A CHILDLOCK was detected in your valueset
  • ora-15001 : diskgroup "string" does not exist or is not mounted
  • ora-31509 : publication does not exist
  • ora-32005 : error while parsing size specification [string]
  • ora-29503 : SCHEMA keyword not valid with NAMED keyword
  • ora-27417 : BYWEEKNO clause is only supported when FREQ=YEARLY
  • ora-29526 : created Java class string"string"
  • ora-01891 : Datetime/Interval internal error
  • ora-23290 : This operation may not be combined with any other operation
  • ora-13149 : failed to generate next sequence number for spatial table string
  • ora-13224 : zero tolerance specified for layer in USER_SDO_GEOM_METADATA
  • ora-28010 : cannot expire external or global accounts
  • ora-09804 : Class conversion from binary to ORACLE failed.
  • ora-32123 : Attribute number is out of range
  • ora-30069 : Auto Undo-Management Error simulation - test site = string
  • ora-39174 : Encryption password must be supplied.
  • ora-13181 : unable to determine length of column string_SDOINDEX.SDO_CODE
  • ora-13635 : The value provided for parameter string cannot be converted to a number.
  • ora-38737 : Expected sequence number string doesn't match string
  • ora-19207 : scalar parameter string of XMLELEMENT cannot have an alias.
  • ora-12648 : Encryption or data integrity algorithm list empty
  • ora-25327 : Array size is invalid
  • ora-32774 : more than one file was specified for bigfile tablespace string
  • ora-36861 : (XSTFRC01) SQL Cache ID parameter is invalid or missing.
  • 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.