ORA-26666: cannot alter STREAMS process string

Cause : An attempt was made to alter a STREAMS process that is currently running.

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

Stop the STREAMS process and reissue the command.

update : 26-07-2017

ORA-26666 - cannot alter STREAMS process string
ORA-26666 - cannot alter STREAMS process string

  • ora-24430 : Null values for sqltext and key were specified.
  • ora-28008 : invalid old password
  • ora-29926 : association already defined for the object
  • ora-16798 : unable to complete terminal recovery on the standby database
  • ora-31185 : DOM Nodes do not belong to the same DOM Document
  • ora-22336 : table contained 8.0 image format, must specify INCLUDING DATA
  • ora-02229 : invalid SIZE option value
  • ora-25965 : fact table must be included in the from clause
  • ora-25332 : Invalid release value string for queue table compatible parameter
  • ora-06928 : CMX: wrong ORACLE_SID
  • ora-12731 : invalid collation class in regular expression
  • ora-00607 : Internal error occurred while making a change to a data block
  • ora-06793 : TLI Driver: server cannot create new process
  • ora-24501 : invalid UTF16 string passed in
  • ora-19271 : XP0051 - invalid atomic type definition
  • ora-32828 : Messaging Gateway agent must be running
  • ora-12951 : Attempt to change default permanent tablespace to temporary
  • ora-30683 : failure establishing connection to debugger
  • ora-25114 : invalid file number specified in the DUMP DATAFILE/TEMPFILE command
  • ora-26763 : invalid file type "string"
  • ora-24356 : internal error while converting from to COBOL display type.
  • ora-12704 : character set mismatch
  • ora-01112 : media recovery not started
  • ora-24238 : object settings argument passed to DBMS_UTILITY.INVALIDATE is not legal
  • ora-32315 : REFRESH FAST of "string"."string" unsupported after mixed DML and Direct Load
  • ora-16068 : redo log file activation identifier mismatch
  • ora-09710 : soarcv: buffer overflow.
  • ora-30021 : Operation not allowed on undo tablespace
  • ora-27471 : window "string.string" is already closed
  • ora-36163 : (XSMXAGGR06) The AGGREGATE function cannot be run on more than one variable at a time.
  • 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.