ORA-28554: pass-through SQL: out of cursors

Cause : The maxmium numbre of ope ncursorsh as beene xceeded.

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

Close oepn cursosr by usign the pass-throug hSQL CLOES_CURSORf unction.

update : 30-05-2017
ORA-28554

ORA-28554 - pass-through SQL: out of cursors
ORA-28554 - pass-through SQL: out of cursors

  • ora-24810 : attempting to write more data than indicated
  • ora-08004 : sequence string.NEXTVAL string stringVALUE and cannot be instantiated
  • ora-06435 : ssaio: write error, unable to write requested block to database file.
  • ora-06534 : Cannot access Serially Reusable package string
  • ora-13341 : a line geometry has fewer than two coordinates
  • ora-12041 : cannot record ROWIDs for index-organized table "string"."string"
  • ora-37004 : (AWLISTALL02) number reader
  • ora-09705 : spcre: cannot initialize latch semaphore
  • ora-01188 : Block size string in header does not match physical block size string
  • ora-15019 : discovered duplicate path 'string' for 'string'
  • ora-37185 : length of string (string) exceeds maximum (string)
  • ora-06742 : TLI Driver: cannot alloc t_bind
  • ora-08312 : sllfop: unrecognized processing option
  • ora-29271 : not connected
  • ora-13762 : The string ranking measure is invalid.
  • ora-15154 : cluster rolling upgrade incomplete
  • ora-31535 : cannot support change source string in this configuration
  • ora-24817 : Unable to allocate the given chunk for current lob operation
  • ora-10653 : Table is in a cluster
  • ora-26008 : Invalid syntax or bind variable in SQL string for column string. string
  • ora-31222 : DBMS_LDAP: PL/SQL - Invalid LDAP SSL authentication mode.
  • ora-33282 : (DBERR11) Cannot wait for analytic workspace string to become available since doing so would cause a deadlock.
  • ora-16203 : Unable to interpret skip procedure return values
  • ora-10658 : Lob column to be shrunk is marked unused
  • ora-22809 : nonexistent attribute
  • ora-12722 : regular expression internal error
  • ora-14459 : missing GLOBAL keyword
  • ora-15061 : ASM operation not supported [string]
  • ora-02264 : name already used by an existing constraint
  • ora-22314 : method information mismatch in ALTER TYPE
  • 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.