Solve a ORA-00600 Error
来源:互联网 发布:彩票系统平台php源码 编辑:程序博客网 时间:2024/06/05 04:37
[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], [], [], [], [], []
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,
/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
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
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.
The problem solved.
- Solve a ORA-00600 Error
- there is a ora 00600 error in DO20L
- ORA-27501: IPC error creating a port
- Solve import caffe error
- Jenkins Error solve
- Ansible Error solve
- pip2 Error solve
- how to solve ORA-02293
- how to solve IMAil error ,550 unknown local host %s, not a gateway
- How to solve SQL Server Error 1222 i.e Unlock a SQL Server table
- ORA-00600[Qkabix] Error Caused by a Particular Query [ID 743212.1]
- ORA-00600: internal error code
- ORA Error Solutions——ORA-00020 ORA-00257 ORA-00600 ORA-01012 ORA-01031 ORA-01102
- How to solve error PRJ0050
- ASP Net - compilation error (Metadata file could not be found)-a fatal program hard to solve it.
- ORA-00600 internal error code, arguments
- ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], []
- ORA-00600: internal error code, arguments: [ksuinfos_modact1], [], [], [], [], [], [], []
- make Image uImage与zImage的区别
- font-size和font标签的size属性的区别
- Ubuntu11.10 删除桌面图标
- sql语句 替换数据
- 标准C++ include 语句格式
- Solve a ORA-00600 Error
- SQL Progeamming in SQLite of CRC-eDirectory
- Excel 强大的数据操纵能力
- 耍帅秘技——Eclipse快捷键大赏
- Step-by-Step: Installing SQL Server Management Studio2008 Express after Visual Studio 2010(zz)
- jQuery入门
- Windows XP U盘安装64位Win7旗舰版
- 不要发垃圾邮件给我
- 嵌入式开发板 s3c2410下的按键中断 buttons_drv.c and test.c