My Oracle Support Banner

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 FEBRUARY 21, 2019

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.