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 : 23-05-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-13906 : The tablepace is not of the right type.
  • ora-22341 : cannot assign supertype instance to subtype
  • ora-16613 : initialization in progress for database
  • ora-29803 : missing ANCILLARY keyword
  • ora-02143 : invalid STORAGE option
  • ora-01027 : bind variables not allowed for data definition operations
  • ora-16747 : logical standby database guard could not be turned on
  • ora-01144 : File size (string blocks) exceeds maximum of string blocks
  • ora-16188 : LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance
  • ora-40215 : model string is incompatible with current operation
  • ora-12068 : updatable mview log for mview "string"."string" does not exist
  • ora-01214 : MAXLOGHISTORY may not exceed string
  • ora-07269 : spdcr: detached process died after exec.
  • ora-29327 : unsupported client compatibility mode used when talking to the server
  • ora-06431 : ssaio: Invalid Block number
  • ora-38303 : invalid option for PURGE TABLESPACE
  • ora-19852 : error creating services for auxiliary instance string (error string)
  • ora-13363 : no valid ETYPE in the geometry
  • ora-31153 : Cannot create schema URL with reserved prefix "http://xmlns.oracle.com/xdb/schemas/"
  • ora-07619 : $IDTOASC failed translating an integrity level
  • ora-28541 : Error in HS init file on line number.
  • ora-22339 : cannot alter to not final since its attribute column is substitutable
  • ora-19708 : log destination exceeds maximum length of string characters
  • ora-00029 : session is not a user session
  • ora-19609 : %s is from different backup set: stamp string count string
  • ora-38737 : Expected sequence number string doesn't match string
  • ora-06802 : TLI Driver: could not open the /etc/netware/yellowpages file
  • ora-02200 : WITH GRANT OPTION not allowed for PUBLIC
  • ora-12509 : TNS:listener failed to redirect client to service handler
  • ora-37038 : (XSMLTDCL04) You cannot change definitions of objects in analytic workspace string because it is attached in MULTI mode.
  • 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.