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 02, 2022
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterOracle 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 |