VMCD.ORG » 处理一个ORA-00600: internal error code, arguments: [keltnfy-ldmInit] 错误

今天偶尔碰到一个ORA-600错误：

[oracle@honcho ~]$ sqlplus sys/oracle@honcho as sysdba

SQL*Plus: Release 10.2.0.1.0 – Production on Sat Oct 29 18:25:11 2011

Connected to an idle instance.

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []

查看日志：
Starting ORACLE instance (normal)
Cannot determine all dependent dynamic libraries for /proc/self/exe
Unable to find dynamic library libocr10.so in search paths
RPATH = /ade/aime1_build2101/oracle/has/lib/:/ade/aime1_build2101/oracle/lib/:/ade/aime1_build2101/oracle/has/lib/:
LD_LIBRARY_PATH is not set!
The default library directories are /lib and /usr/lib
Unable to find dynamic library libocrb10.so in search paths
Unable to find dynamic library libocrutl10.so in search paths
Unable to find dynamic library libocrutl10.so in search paths
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Sat Oct 29 17:57:10 2011
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 134217728
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
sga_target = 444596224
control_files = /u01/app/oracle/oradata/honcho/control01.ctl, /u01/app/oracle/oradata/honcho/control02.ctl,

/u01/app/oracle/oradata/honcho/control03.ctl
db_block_size = 8192
__db_cache_size = 297795584
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = /u01/app/oracle/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=honchoXDB)
job_queue_processes = 10
background_dump_dest = /u01/app/oracle/admin/honcho/bdump
user_dump_dest = /u01/app/oracle/admin/honcho/udump
core_dump_dest = /u01/app/oracle/admin/honcho/cdump
audit_file_dest = /u01/app/oracle/admin/honcho/adump
db_name = honcho
open_cursors = 300
pga_aggregate_target = 147849216
Sat Oct 29 17:57:21 2011
Errors in file /u01/app/oracle/admin/honcho/udump/honcho_ora_7660.trc:
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []
Sat Oct 29 17:57:21 2011
USER: terminating instance due to error 600
Instance terminated by USER, pid = 7660
Sat Oct 29 18:00:43 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Sat Oct 29 18:01:04 2011
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 134217728
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
sga_target = 444596224
control_files = /u01/app/oracle/oradata/honcho/control01.ctl, /u01/app/oracle/oradata/honcho/control02.ctl,

其实环境变量已经设置了：
export ORACLE_SID=honcho
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0.1/db_1
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib

export NLS_DATE_FORMAT=’yyyy-mm-dd hh24:mi:ss’
umask 022

查找matelink 未果

最终找到了一点端倪：
[oracle@honcho ~]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost

编辑/etc/hosts
[oracle@honcho ~]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost

192.168.1.99 honcho

[oracle@honcho ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 – Production on Sat Oct 29 18:02:33 2011

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 444596224 bytes
Fixed Size 1219904 bytes
Variable Size 142607040 bytes
Database Buffers 297795584 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.