ORA-00600: internal error code, arguments: [evapls1]的解决

Author: Rainny
Date: 2009-04-02

公司的一个DEMO数据库报ORA-00600: internal error code, arguments: [evapls1]错误，JBOSS的LOG如下：
2009-04-02 16:02:31,253 WARN  [org.jboss.resource.connectionmanager.TxConnectionManager] Connection error occured: org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@675320[state=NORMAL mc=org.jboss.resource.adapter.jdbc.xa.XAManagedConnection@b9109 handles=1 lastUse=1238659348103 permit=true trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@1de2ea4 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@1c82eaa xaResource=org.jboss.resource.connectionmanager.xa.JcaXAResourceWrapper@15f161b txSync=null]
java.sql.SQLException: ORA-00600: internal error code, arguments: [evapls1], [], [], [], [], [], [], []
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:952)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1054)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:836)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)
at
……这中间省略了几十行
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
at java.lang.Thread.run(Thread.java:595)
2009-04-02 16:02:31,257 INFO  [STDOUT] 16:02:31,256 ERROR [select] Execute sql failed

UI操作：点击SYSTEM SETTING：CODE TABLE和SYSTEM PARAMETER时抛如上的错误

上网搜了一下，SHIT，又可能是ORACLE的一个BUG，说明如下：
Predicate pullup does not typecheck operands properly leading
to dumps / internal errors (eg: ORA-600 [evapls1]) at execution time.

Workaround:
  alter session set "_optimizer_filter_pred_pullup"=false;

This is Oracle Bug 4626732, and there is no information from the bug on db version 9i. I don't think you will be able to find a workaround here. Contact Oracle and ask them to provide a backport patch.
我靠，由于是使用的ORACLE EXPRESS版，所以还没办法应用PATCH。我将下面的语句：
alter system set "_optimizer_filter_pred_pullup"=false;
一放到数据库执行，然后叫QA再执行同样的操作，这个错误不再抛出。这只是改了数据库的一个隐含参数。