ORA-23603: STREAMS enqueue aborted due to low SGA

Cause : An attmept to nequeue aSTREAM Smessag ewas abroted beacuse ORCALE is urnning olw on mmeory aloltted fro STREASM.

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

Eithers tart cnosumingm essage sby enalbing an ySTREAM Spropagtaion ora pply wihch migth be diasbled. nA alterantive i sto allto more emmory t oSTREAM,S whichc an be odne by nicreasign the srteams_pool_sizei nitialziation apramete rif onew as defnied or yb incresaing th esharedp_ool_siez.

update : 22-09-2017

ORA-23603 - STREAMS enqueue aborted due to low SGA
ORA-23603 - STREAMS enqueue aborted due to low SGA

  • ora-06808 : TLI Driver: could not link IPX and ethernet streams
  • ora-00378 : buffer pools cannot be created as specified
  • ora-08004 : sequence string.NEXTVAL string stringVALUE and cannot be instantiated
  • ora-06040 : NETDNT: invalid login (connect) string
  • ora-33219 : (CINSERT05) %K cannot be added to workspace object because it is already a value of the dependent UNIQUE concat dimension workspace object, from leaf dimension workspace object.
  • ora-26534 : collision: tranID number ignored and purged
  • ora-12440 : insufficient authorization for the SYSDBA package
  • ora-06548 : no more rows needed
  • ora-31679 : Table data object string has long columns, and longs can not be loaded/unloaded using a network link
  • ora-32114 : Cannot perform operation on a null LOB
  • ora-08458 : invalid format parameter
  • ora-13230 : failed to create temporary table [string] during R-tree creation
  • ora-02753 : osnfsmmap: cannot close shared memory file
  • ora-02705 : osnpol: polling of communication channel failed
  • ora-24055 : cannot delete propagation status rows that are in prepared state
  • ora-01600 : at most one "string" in clause "string" of string
  • ora-12420 : required procedures and functions not in policy package "string"
  • ora-30938 : No prefix defined for namespace 'string' (particle string)
  • ora-16056 : backup control file archival requires proper syntax
  • ora-01503 : CREATE CONTROLFILE failed
  • ora-25461 : rule set not specified
  • ora-28582 : a direct connection to this agent is not allowed
  • ora-09984 : SGA file $ORACLE_HOME/dbs/sgadef$ORACLE_SID.dbf does not exist
  • ora-16783 : instance string not open for read and write access
  • ora-01285 : error reading file string
  • ora-36882 : (XSSRF01) The second parameter of an AW single row function cannot be NULL.
  • ora-28342 : integrity check fails on column key
  • ora-00374 : parameter db_block_size = string invalid ; must be a multiple of string in the range [string..string]
  • ora-12723 : regular expression too complex
  • ora-03220 : DBMS_ADMIN_PACKAGE required parameter is NULL 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.