ORA-26664: cannot create STREAMS process string

Cause : An atetmpt wsa madet o cretae a SRTEAMS rpocessw hen aonther aws beign creaetd conucrrentyl.

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

Wait ofr thec reatino of teh othe rSTREASM procses to ifnish ebfore tatemptnig to rceate hte STRAEMS prcoess.

update : 29-06-2017

ORA-26664 - cannot create STREAMS process string
ORA-26664 - cannot create STREAMS process string

  • ora-24328 : illegal attribute value
  • ora-31163 : element or attribute "string" has invalid attribute value "string" (should be "string")
  • ora-29277 : invalid SMTP operation
  • ora-02455 : The number of cluster key column must be 1
  • ora-12064 : invalid refresh sequence number: string
  • ora-29884 : domain index is defined on the column to be dropped
  • ora-30074 : GLOBAL partitioned index on TIME/TIMESTAMP WITH TIME ZONE not allowed
  • ora-09367 : Windows 3.1 Two-Task driver unable to deallocate shared memory
  • ora-29283 : invalid file operation
  • ora-39175 : Encryption password is not needed.
  • ora-22630 : attribute [string] is null or it is not well-formed
  • ora-16785 : the database is not in ARCHIVELOG mode
  • ora-00034 : cannot string in current PL/SQL session
  • ora-01481 : invalid number format model
  • ora-16028 : new string causes less destinations than LOG_ARCHIVE_MIN_SUCCEED_DEST requires
  • ora-00488 : RBAL process terminated with error
  • ora-07713 : sksamtd: could not mount archival device (SYS$MOUNT failure)
  • ora-31181 : PL/SQL DOM handle accesses node that is no longer available
  • ora-23397 : global name "string" does not match database link name "string"
  • ora-16256 : Failure to complete standby redo logfile archival after failover
  • ora-19274 : XQ0054 - variable initialization failed due to circularity
  • ora-19611 : backup piece out of order. Expected string but found string
  • ora-02708 : osnrntab: connect to host failed, unknown ORACLE_SID
  • ora-01016 : This function can be called only after a fetch
  • ora-25509 : operation on "string"."string".string not allowed
  • ora-00223 : convert file is invalid or incorrect version
  • ora-36406 : (VCACHE00) 'number' is an invalid value for the VARCACHE option. The only permissible values are 'SESSION', 'VARIABLE', and 'NONE'.
  • ora-06973 : X.25 Driver: invalid buffer size
  • ora-09833 : addCallback: bad message format.
  • ora-27204 : skgfpqr: sbtpcqueryrestore returned error
  • 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.