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 : 27-06-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-30475 : feature not enabled: string
  • ora-31434 : purge is currently running
  • ora-02718 : osnprs: reset protocol error
  • ora-14274 : partitions being merged are not adjacent
  • ora-01023 : Cursor context not found (Invalid cursor number)
  • ora-37154 : OLAP API initialization error: (case string)
  • ora-22332 : a dependent object in schema "string" has errors. string
  • ora-28141 : error in creating audit index file
  • ora-12084 : must use ALTER MATERIALIZED VIEW to alter "string"."string"
  • ora-29828 : invalid name for implementation type
  • ora-33292 : (DBERR18) insufficient permissions to access analytic workspace string using the specified access mode.
  • ora-24405 : error occured while trying to create connections in the pool
  • ora-29903 : error in executing ODCIIndexFetch() routine
  • ora-12919 : Can not drop the default permanent tablespace
  • ora-38621 : Decision Tree maximum depth setting not between [2, 20]
  • ora-00366 : log string of thread string, checksum error in the file header
  • ora-22970 : name does not correspond to an object view
  • ora-39026 : master table is inconsistent on validation string
  • ora-13712 : Cannot perform ADDM analysis on AWR snapshots from previous releases. Snapshot version "string" do not match the database version "string".
  • ora-01890 : NLS error detected
  • ora-07511 : sscggtl: $enq unexpected return for master termination lock
  • ora-07220 : slspool: wait error.
  • ora-02460 : Inappropriate index operation on a hash cluster
  • ora-28342 : integrity check fails on column key
  • ora-24016 : cannot create QUEUE_TABLE, user string does not have execute privileges on QUEUE_PAYLOAD_TYPE string.string
  • ora-10863 : Control behavior of buffered background operations
  • ora-38855 : cannot mark instance string (redo thread string) as enabled
  • ora-30163 : The thread safety initialization failed
  • ora-00610 : Internal error code
  • ora-25178 : duplicate PCTTHRESHOLD storage option specification
  • 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.