ORA-01000: Maximum Open Cursors Exceeded In Trace Alert and Flashback Archive: Error ORA-1000 in SQL "select max(FA#) from SYS_FBA_FA" in MMON file

(Doc ID 1630565.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 13-Sep-2016***

Symptoms

1) Several ORA-01000: maximum open cursors exceeded in alert.log

2)MMON signals ORA-01000: maximum open cursors exceeded

and(possible)

-> Flashback Archive: Error ORA-1000 in MMON trace file ;

EXAMPLE of MMON traces :

-----------------------------
*** 2014-02-14 11:44:48.985
Flashback Archive: Error ORA-1000 in SQL "select max(FA#) from SYS_FBA_FA"

*** 2014-02-14 11:44:48.985
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=0, mask=0x0)
----- Error Stack Dump -----
ORA-01000: maximum open cursors exceeded

*** 2014-02-14 11:44:48.985
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=0, mask=0x0)
----- Error Stack Dump -----
ORA-01000: maximum open cursors exceeded
jskcStartTimeSelect returned error 1000
jskcSartTimeSelect: err =1000

*** 2014-02-14 11:45:01.044
*** KEWROCISTMTEXEC - encountered error: (ORA-01000: maximum open cursors exceeded
ORA-01000: maximum open cursors exceeded
ORA-01000: maximum open cursors exceeded
)  

 Similar stack:

skdstdst <- ksedst1 <- ksedst <- dbkedDefDump <- ksedmp <- dbkdaKsdActDriver <- dbgdaExecuteAction <- dbgdaRunAction<- dbgdRunActions <- dbgdProcessEventActions <- dbgdChkEventKgErr<- dbkdChkEventRdbmsErr <- ksfpec <- dbgePostErrorKGE <- dbkePostKGE_kgsf <- kgeselv <- ksesecl0 <- kxsOpenACursor <- opiopr <- opikpr <- opiodr <- rpidrus <- skgmstack <- rpiswu2 <- kprball <- kprbope<- kqdOpenBundledCursor <- kgscGetCursor <- kqdobr <- kqrReadFromDB

Changes

 n/a

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms