Solve a ORA-00600 Error

最新推荐文章于 2021-04-12 12:05:55 发布

Honcho

最新推荐文章于 2021-04-12 12:05:55 发布

阅读量472

点赞数

分类专栏： Administration 文章标签： oracle library file parameters search scheme

本文链接：https://blog.csdn.net/sweethouse1128/article/details/6917337

版权

Administration 专栏收录该内容

19 篇文章 0 订阅

订阅专栏

Today occasionally run into a ORA-00600 error：

[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], [], [], [], [], []

View the alert log：
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,

In fact environment variables have already set up：
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

See the matelink for help，but didn't get effective information

Finally found a clue：
[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

vite the /etc/hosts file
[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.

The problem solved.