ORA-24787: remote cursors must be closed before a call completes

Cause : The prveious oeprationd id notc lose all the rmeote cusrors ito pened.S ince spearatedt ransacitons ar eenable,d this si not allowed.

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

Close lal remoet cursosr in eahc call,o r star ta regualr (nons-eparatde) tranasction.

update : 25-04-2017
ORA-24787

ORA-24787 - remote cursors must be closed before a call completes
ORA-24787 - remote cursors must be closed before a call completes

  • ora-12156 : TNS:tried to reset line from incorrect state
  • ora-26077 : direct path column array is not initialized
  • ora-07217 : sltln: environment variable cannot be evaluated.
  • ora-19721 : Cannot find datafile with absolute file number string in tablespace string
  • ora-01350 : must specify a tablespace name
  • ora-01662 : tablespace 'string' is non-empty and cannot be made temporary
  • ora-12150 : TNS:unable to send data
  • ora-00211 : control file does not match previous control files
  • ora-23403 : refresh group "string"."string" already exists
  • ora-32838 : exceeded maximum number of properties
  • ora-13437 : GeoRaster metadata blocking error
  • ora-06130 : NETTCP: host access denied
  • ora-38709 : Recovery Area is not enabled.
  • ora-38708 : not enough space for first flashback database log file
  • ora-13525 : error with computing space usage for sysaux occupant
  • ora-30069 : Auto Undo-Management Error simulation - test site = string
  • ora-39059 : dump file set is incomplete
  • ora-07260 : spdcr: wait error.
  • ora-08193 : Flashback Table operation is not allowed on temporary tables
  • ora-02719 : osnfop: fork failed
  • ora-38707 : Media recovery is not enabled.
  • ora-19201 : Datatype not supported
  • ora-23464 : flavor lacks column string of "string"."string"
  • ora-02304 : invalid object identifier literal
  • ora-12207 : TNS:unable to perform navigation
  • ora-12446 : Insufficient authorization for administration of policy string
  • ora-19654 : must use backup control file to switch file incarnations
  • ora-01979 : missing or invalid password for role 'string'
  • ora-13354 : incorrect offset in ELEM_INFO_ARRAY
  • ora-23383 : registration for materialized view repgroup "string"."string" failed at site string
  • 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.