oracle主机ip修改无法正常启动,报错:ORA-00600:internal error code

刚刚把装有oracle数据库的主机ip地址更改了一下,然后通过startup无法正常启动,报错如下:

ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], []

下面是亲自测试的解决方案:

1. 原因:修改主机名或者主机ip之后,通过hostname命令得到的主机名无法ping通,Oracle10g认为主机无法达到所以启动数据库报错

2. 解决方法一:在 /etc/hosts 中添加 一行解析名。

127.0.0.1 localhost.localdomain localhost

#::1 localhost6.localdomain6 localhost6

192.168.137.122 redhat

3. 解决方法二:修改 127.0.0.1的解析名

127.0.0.1 redhat localhost.localdomain localhost

#::1 localhost6.localdomain6 localhost6


阅读更多
换一批

ORA-00600: internal error code,求助!

06-09

异常信息如下:rnORA-00600: internal error code, arguments: [kglobpg_is_pkp], [0xF01A72C10], [], [], [], [], [], []rn看网上说的600错误原因很多,我发现arguments后面的东西有所不同。有没有人解释下[kglobpg_is_pkp], [0xF01A72C10], [], [], [], [], [], []这串是什么意思?rn存储过程是ETL_FUN_CLEAR调用ETL_PAC_CharConverterUtil,ETL_PAC_CharConverterUtil再调用java程序ClearCharUtil.toHalfAngle。rn按照以下程序,ETL_FUN_CLEAR如果发生异常,则会插入日志表数据记录日志(ETL_PRO_ADDLOG),并将入参直接返回,并继续执行后面的程序。可实际发生的是日表里插入了这条数据,内容就是SQLERRM中的内容,可记录完日志后程序中止了,没有继续运行。困扰好久了,求指教问题原因。rnrn此问题是偶发性问题,通过记录日志分析:近30天发生过1次,总体平均每三天一次,经常连续几天发生。rnrnoracle版本rnSELECT * FROM v$version ; rnOracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64birnPL/SQL Release 10.2.0.5.0 - ProductionrnCORE 10.2.0.5.0 ProductionrnTNS for Linux: Version 10.2.0.5.0 - ProductionrnNLSRTL Version 10.2.0.5.0 - Productionrnrn附上程序:rn[code=sql]rn FUNCTION ETL_FUN_CLEAR(i_table_name IN VARCHAR2,rn i_column_name IN VARCHAR2,rn i_value IN VARCHAR2) RETURN VARCHAR2 ISrn v_method_count number;rn v_value varchar2(200);rn v_method varchar2(100);rn v_tablename varchar2(100);rn v_columnname varchar2(100);rn BEGINrn v_value := i_value;rn v_value := ETL_PAC_CharConverterUtil.toHalfAngle(v_value);rn return v_value;rn exceptionrn when others thenrn ETL_PAC_BASE.ETL_PRO_ADDLOG('ETL_PAC_CLEAR',rn 'ETL_FUN_CLEAR',rn '',rn SQLCODE || '-' || v_method || '-' ||rn v_tablename || '-' || v_columnname || '-' || v_value,rn SQLERRM);rn return v_value;rn END ETL_FUN_CLEAR;rnrncreate or replace package body ETL_PAC_CharConverterUtil isrnrn -- Private type declarationsrn --type is ;rnrn -- Private constant declarationsrn -- constant := ;rnrn -- Private variable declarationsrn -- ;rnrn -- Function and procedure implementationsrn function toHalfAngle(v_value varchar2) return varchar2 ASrn language java name 'ClearCharUtil.toHalfAngle(java.lang.String) return java.lang.String';rn function removeAllChar(v_value varchar2) return varchar2 asrn language java name 'ClearCharUtil.removeAllChar(java.lang.String) return java.lang.String';rn function removeBlank(v_value varchar2) return varchar2 asrn language java name 'ClearCharUtil.removeBlank(java.lang.String) return java.lang.String';rn function removeSpareBlank(v_value varchar2) return varchar2 asrn language java name 'ClearCharUtil.removeSpareBlank(java.lang.String) return java.lang.String';rn--beginrn-- Initializationrn--;rnend ETL_PAC_CharConverterUtil;rnrncreate or replace and compile java source named "ClearCharUtil" asrnimport java.util.List;rnimport java.util.regex.Pattern;rnrnpublic class ClearCharUtil rnrn /**rn * 全角转半角 半角字符串rn * rn * @return Stringrn */rn public static String toHalfAngle(String str) rn char c[] = str.toCharArray();rn for (int i = 0; i < c.length; i++) rn if (c[i] == '\\u3000') rn c[i] = ' ';rn else if (c[i] > '\\uFF00' && c[i] < '\\uFF5F') rn c[i] = (char) (c[i] - 65248);rn rn rn String outStr = new String(c);rn return outStr;rn rnrn[/code]

没有更多推荐了,返回首页