生产排故_ORA-01000: maximum open cursors exceeded

最新推荐文章于 2025-05-19 16:55:13 发布

db_murphy

最新推荐文章于 2025-05-19 16:55:13 发布

阅读量2.4k

点赞数

CC 4.0 BY-SA版权

分类专栏： oracle

本文链接：https://blog.youkuaiyun.com/db_murphy/article/details/102961323

【引言】
项目组今天来找，反馈应用程序日志记录了一连接在昨晚发生连接中断现象，让查一查数据库端有何异常。对应昨晚异常发生时间点，在库alert日志中找到相应时间段的报错信息，报错信息如下：

【报错信息】

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x337FA00010000] [PC:0x400000000714AE40, $cold_kqdReleaseACursor()] [flags: 0x0, count: 1]
Errors in file /oracle/diag/diag/rdbms/ethandb/ethandb/trace/ethandb_ora_8260.trc  (incident=766554):
ORA-07445: exception encountered: core dump [kqdReleaseACursor()] [SIGSEGV] [ADDR:0x337FA00010000] [PC:0x400000000714AE40] [Address not mapped to object] []
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
Incident details in: /oracle/diag/diag/rdbms/ethandb/ethandb/incident/incdir_766554/ethandb_ora_8260_i766554.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.

问题现象也很明显：见上述alert日志报错“ORA-01000: maximum open cursors exceeded”。