ORA-24804: Lob read/write functions called while another OCI LOB read/write streaming is in progress

Cause : Internal error.

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

Wait for the ongoing LOB streaming call to finish before issuing the next server call, or use OCIBreak() abort the current LOB streaming call.

update : 30-04-2017
ORA-24804

ORA-24804 - Lob read/write functions called while another OCI LOB read/write streaming is in progress
ORA-24804 - Lob read/write functions called while another OCI LOB read/write streaming is in progress

  • ora-06007 : NETASY: bad dialogue format
  • ora-13704 : Invalid value "string" specified for parameter "string".
  • ora-16553 : the Data Guard broker process (DMON) failed to shutdown
  • ora-01543 : tablespace 'string' already exists
  • ora-06959 : Buffer I/O quota is too small
  • ora-32301 : object-relational materialized views must be primary key based
  • ora-38495 : data type for the stored attribute string is inconsistent.
  • ora-19018 : Invalid character in XML tag 'string'
  • ora-22910 : cannot specify schema name for nested tables
  • ora-01361 : global name mismatch
  • ora-24070 : cannot upgrade queue table string while it is being downgraded
  • ora-00051 : timeout occurred while waiting for a resource
  • ora-31448 : invalid value for change_source
  • ora-16115 : %s\% of LogMiner dictionary loading is done
  • ora-02044 : transaction manager login denied: transaction in progress
  • ora-24332 : invalid object type
  • ora-00379 : no free buffers available in buffer pool string for block size stringK
  • ora-13224 : zero tolerance specified for layer in USER_SDO_GEOM_METADATA
  • ora-23334 : column string does not exist in table or column group
  • ora-31417 : column list contains control column string
  • ora-13827 : null or zero length attribute specified in SQL profile collection
  • ora-15169 : destination 'string' is a subdirectory of 'string'
  • ora-09758 : osnipn: could not check port in name server.
  • ora-02422 : missing or invalid schema element
  • ora-01674 : data file string is an old incarnation rather than current file
  • ora-02291 : integrity constraint (string.string) violated - parent key not found
  • ora-40291 : model cost not available
  • ora-16163 : LGWR network server host attach error
  • ora-31097 : Hierarchical Index not empty
  • ora-23401 : materialized view "string"."string" does not exist
  • 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.