Oracle数据库内部错误ORA-00604与解决方案-优快云博客

本文链接：https://blog.youkuaiyun.com/zhengjunwei2007/article/details/83948383

博客详细记录了遇到ORA-00604错误的过程，该错误是由于递归SQL执行时的问题导致。内容提到了在Spring JDBC操作中触发了这个错误，伴随着'maximum open cursors exceeded'的提示。解决方案包括调整数据库初始化参数文件initSID.ora中的OPEN_CURSORS值，以及设置事件跟踪等。同时，文中还提供了其他可能导致ORA-00604错误的原因及相应的解决策略。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

ORA-00600: 内部错误代码，参数: [], [], [], [], [], [], [], []
ORA-00604: 递归 SQL 层出现错误

异常代码：

org.springframework.jdbc.UncategorizedSQLException:

Hibernate operation: could not execute query; uncategorized SQLException for SQL

[select count(*) as col_0_0_ from HC_COMMENT.LEAVEWORD leaveword0_, HC_COMMENT.TOPIC topic1_ where leaveword0_.TOPIC_ID=topic1_.ID and leaveword0_.INFO_ID=108268 and topic1_.AREACODE='001' and leaveword0_.LEAVEWORD_DINGNUM+leaveword0_.LEAVEWORD_BACKNUM>=5]; SQL state [60000]; error code [604]; ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
; nested exception is java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded

        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
        at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
        at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)
        at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
        at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
        at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:921)
        at com.hc360.comment.dao.core.HibernateGenericDao.pagedQuery(HibernateGenericDao.java:231)
        at com.hc360.comment.dao.impl.FrontLeavewordDaoImpl.getHotNewLeaveword(FrontLeavewordDaoImpl.java:287)
        at com.hc360.comment.manager.impl.FrontLeavewordManagerImpl.getHotNewLeaveword(FrontLeavewordManagerImpl.java:274)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.

ORA-00604 记录