今天偶尔碰到一个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
Copyright (c) 1982, 2005, Oracle. All rights reserved.
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,
/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 18:01:14 2011
Errors in file /u01/app/oracle/admin/honcho/udump/honcho_ora_7775.trc:
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []
Sat Oct 29 18:01:14 2011
USER: terminating instance due to error 600
Instance terminated by USER, pid = 7775
Sat Oct 29 18:02:38 2011
其实环境变量已经设置了：
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
Copyright (c) 1982, 2005, Oracle. All rights reserved.
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.
codemore code
~~~~