ORA-00600: 内部错误代码，参数: [KSMASG1], [4032], [4032], [

一、日志报错如下：

Mon May 31 15:54:18 2010

Errors in file /oracle/app/oracle/product/9.2.0/rdbms/log/nx_dss_ora_15290.trc:

ORA-00600: 内部错误代码，参数: [KSMASG1], [4032], [4032], [], [], [], [], []

二、查看错误原因

1.首先查看TRC文件，根据TRC文件内容，发现java代码无法编译

*** 2010-05-31 15:54:18.303

ksedmp: internal or fatal error

ORA-00600: 内部错误代码，参数: [KSMASG1], [4032], [4032], [], [], [], [], []

Current SQL statement for this session:

create and compile java source named mgb_oscmd as

import java.io.*;

import java.lang.*;

public class OSCmd extends Object {

    public static int OSCmd(String args) {

        Runtime rt = Runtime.getRuntime();

        int rc = -1;

        try {

            Process p = rt.exec(args);

            int bufSize = 4096;

            BufferedInputStream bis = new BufferedInputStream(p.getInputStream(), bufSize);

        int len;

        byte buffer[] = new byte[bufSize];

        while ((len = bis.read(buffer, 0, bufSize)) != -1)

                System.out.write(buffer, 0, len);

            rc = p.waitFor();

        } catch (Exception e) {

            e.printStackTrace();

            rc = -1;

        } finally {

            return rc;

        }

    }

}

 

2.查看JVM环境是否安装

SQL> select object_name from dba_objects where object_name like '%JAVA%';

 

OBJECT_NAME

--------------------------------------------------------------------------------

DBMS_JAVA_TEST

[C1] I_JAVASNM1

I_PROCEDUREJAVA$

I_TRIGGERJAVAC

I_TRIGGERJAVAF

I_TRIGGERJAVAM

I_TRIGGERJAVAS

JAVASNM$

KU$_JAVA_SOURCE_T

KU$_JAVA_SOURCE_VIEW

 

OBJECT_NAME

--------------------------------------------------------------------------------

PROCEDUREJAVA$

TRIGGERJAVAC$

TRIGGERJAVAF$

TRIGGERJAVAM$

TRIGGERJAVAS$

DBMS_JAVA_TEST

P_W_REP_ADD_BREW_JAVA_BILL

DA_HIB_FIELD_JAVA_MAP_ENABLE_L

 

19 rows selected.

SQL> !

/usr/bin/sh: java:  not found.

[C2] $

$

$ java -version

/usr/bin/sh: java:  not found.

$

3.如需安装，请按如下操作：执行下面ORACLE安装包，安装JVM

$ORACLE_HOME\javavm\install\initjvm.sql

4.查看JVM是否安装成功

Java -version

5.修改java池并重启数据库

SQL> ALTER SYSTEM SET java_pool_size=100M SCOPE = SPFILE;

SQL> SHUTDOWN IMMEDIATE

SQL> STARTUP

 

 

 [C1]视图资源不全

 [C2]$ 如果安装应显示如下信息：

java version "1.4.2.17"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2.17-071106-02:40)

Java HotSpot(TM) Server VM (build 1.4.2 1.4.2.17-071106-08:12-IA64N IA64, mixed mode)