急急!!ORA-01092: ORACLE instance terminated. Disconnection forced
C:\Documents and Settings\Administrator>sqlplus logSQL*Plus: Release 8.1.7.0.0 - Production on 星期四 8月 20 10:50:07 2009
(c) Copyright 2000 Oracle Corporation. All rights reserved.
SQL> conn sys/manager as sysdba
ERROR:
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL> 请问怎么解决?Wed Aug 19 14:34:54 2009
LGWR: terminating instance due to error 600
Instance terminated by LGWR, pid = 1536
Dump file D:\oracle\admin\ldjyjdb\bdump\ldjyjdbALRT.LOG
Wed Aug 19 15:05:36 2009
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
processes = 150
shared_pool_size = 139075891
large_pool_size = 614400
java_pool_size = 20971520
control_files = D:\oracle\oradata\ldjyjdb\control01.ctl, D:\oracle\oradata\ldjyjdb\control02.ctl, D:\oracle\oradata\ldjyjdb\control03.ctl
db_block_buffers = 50931
db_block_size = 8192
compatible = 8.1.0
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = FALSE
distributed_transactions = 10
instance_name = ldjyjdb
service_names = ldjyjdb
mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
open_links = 4
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = ldjyjdb
open_cursors = 300
os_authent_prefix =
job_queue_processes = 4
job_queue_interval = 60
parallel_max_servers = 5
background_dump_dest = D:\oracle\admin\ldjyjdb\bdump
user_dump_dest = D:\oracle\admin\ldjyjdb\udump
max_dump_file_size = 10240
oracle_trace_collection_name=
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
SNP0 started with pid=8
SNP1 started with pid=9
SNP2 started with pid=10
SNP3 started with pid=11
Wed Aug 19 15:05:39 2009
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Aug 19 15:05:40 2009
alter database mount exclusive
Wed Aug 19 15:05:47 2009
Successful mount of redo thread 1, with mount id 2719296587.
Wed Aug 19 15:05:47 2009
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed Aug 19 15:05:47 2009
alter database open
Wed Aug 19 15:05:47 2009
Errors in file D:\oracle\admin\ldjyjdb\bdump\ldjyjdbLGWR.TRC:
ORA-00600: internal error code, arguments: [3705], [1], [1], [1], [2], [], [], []ldjyjdbLGWR.TRC内容
Dump of memory from 0x2ABA1BCC to 0x2ABA1C0C
2ABA1BC0 2ABA1BB4 [...*]
2ABA1BD0 00000003 00000000 40000000 40400000 [...........@..@@]
2ABA1BE0 0072BFE0 0072C020 00000000 00000000 [..r. .r.........]
2ABA1BF0 00000000 00000170 0072BF40 0072BF60 [[email protected].`.r.]
2ABA1C00 00000000 0000010D 2ABA1BC0 [...........*]
ub1 * kwqit_p [2AB7FD90, 2AB7FD94) = 00000000
ub1 * kwqin_p [2AB7FD94, 2AB7FD98) = 00000000
ub1 kwqiz_p [2AB7FD98, 2AB7FD9C) = 00000000
ub4 kwqis_p [2AB7FD9C, 2AB7FDA0) = 00000000
ub4 kwqil_p [2AB7FDA0, 2AB7FDA4) = 00000000
kwqpoidnd * kwqpo_p [2AB7FDA4, 2AB7FDA8) = 00000000
kwqpsctx * kwqps_p [2AB7FDA8, 2AB7FDAC) = 00000000
kwqprctx * kwqpr_p [2AB7FDAC, 2AB7FDB0) = 00000000
kgghst * kwqma_p [2AB7FDB0, 2AB7FDB4) = 2ABA1B70
Dump of memory from 0x2ABA1B70 to 0x2ABA1BB0
2ABA1B70 2ABA1B58 00000003 00000000 40000000 [X..*...........@]
2ABA1B80 40400000 008BA6B0 008BA740 00000000 [..@@....@.......]
2ABA1B90 00000000 00000000 00000058 008BA9C0 [........X.......]
2ABA1BA0 008BAA00 00000000 00000019 2ABA1B64 [............d..*]
kwqjw * kwqjwh_p [2AB7FDB4, 2AB7FDB8) = 00000000
knceug * kncem_p [2AB7FDB8, 2AB7FDBC) = 00000000
ub1 kkziu_p [2AB7FDBC, 2AB7FDC0) = 00000009
hogxdef* hogcu_p [2AB7FDC0, 2AB7FDC4) = 00000000
ub4 ksmugmg2 [2AB7FDC4, 2AB7FDC8) = 0000CDCD
error 600 detected in background process
C:\Documents and Settings\Administrator>sqlplus logSQL*Plus: Release 8.1.7.0.0 - Production on 星期四 8月 20 10:50:07 2009
(c) Copyright 2000 Oracle Corporation. All rights reserved.
SQL> conn sys/manager as sysdba
ERROR:
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL> 请问怎么解决?Wed Aug 19 14:34:54 2009
LGWR: terminating instance due to error 600
Instance terminated by LGWR, pid = 1536
Dump file D:\oracle\admin\ldjyjdb\bdump\ldjyjdbALRT.LOG
Wed Aug 19 15:05:36 2009
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
processes = 150
shared_pool_size = 139075891
large_pool_size = 614400
java_pool_size = 20971520
control_files = D:\oracle\oradata\ldjyjdb\control01.ctl, D:\oracle\oradata\ldjyjdb\control02.ctl, D:\oracle\oradata\ldjyjdb\control03.ctl
db_block_buffers = 50931
db_block_size = 8192
compatible = 8.1.0
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = FALSE
distributed_transactions = 10
instance_name = ldjyjdb
service_names = ldjyjdb
mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
open_links = 4
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = ldjyjdb
open_cursors = 300
os_authent_prefix =
job_queue_processes = 4
job_queue_interval = 60
parallel_max_servers = 5
background_dump_dest = D:\oracle\admin\ldjyjdb\bdump
user_dump_dest = D:\oracle\admin\ldjyjdb\udump
max_dump_file_size = 10240
oracle_trace_collection_name=
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
SNP0 started with pid=8
SNP1 started with pid=9
SNP2 started with pid=10
SNP3 started with pid=11
Wed Aug 19 15:05:39 2009
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Aug 19 15:05:40 2009
alter database mount exclusive
Wed Aug 19 15:05:47 2009
Successful mount of redo thread 1, with mount id 2719296587.
Wed Aug 19 15:05:47 2009
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed Aug 19 15:05:47 2009
alter database open
Wed Aug 19 15:05:47 2009
Errors in file D:\oracle\admin\ldjyjdb\bdump\ldjyjdbLGWR.TRC:
ORA-00600: internal error code, arguments: [3705], [1], [1], [1], [2], [], [], []ldjyjdbLGWR.TRC内容
Dump of memory from 0x2ABA1BCC to 0x2ABA1C0C
2ABA1BC0 2ABA1BB4 [...*]
2ABA1BD0 00000003 00000000 40000000 40400000 [...........@..@@]
2ABA1BE0 0072BFE0 0072C020 00000000 00000000 [..r. .r.........]
2ABA1BF0 00000000 00000170 0072BF40 0072BF60 [[email protected].`.r.]
2ABA1C00 00000000 0000010D 2ABA1BC0 [...........*]
ub1 * kwqit_p [2AB7FD90, 2AB7FD94) = 00000000
ub1 * kwqin_p [2AB7FD94, 2AB7FD98) = 00000000
ub1 kwqiz_p [2AB7FD98, 2AB7FD9C) = 00000000
ub4 kwqis_p [2AB7FD9C, 2AB7FDA0) = 00000000
ub4 kwqil_p [2AB7FDA0, 2AB7FDA4) = 00000000
kwqpoidnd * kwqpo_p [2AB7FDA4, 2AB7FDA8) = 00000000
kwqpsctx * kwqps_p [2AB7FDA8, 2AB7FDAC) = 00000000
kwqprctx * kwqpr_p [2AB7FDAC, 2AB7FDB0) = 00000000
kgghst * kwqma_p [2AB7FDB0, 2AB7FDB4) = 2ABA1B70
Dump of memory from 0x2ABA1B70 to 0x2ABA1BB0
2ABA1B70 2ABA1B58 00000003 00000000 40000000 [X..*...........@]
2ABA1B80 40400000 008BA6B0 008BA740 00000000 [..@@....@.......]
2ABA1B90 00000000 00000000 00000058 008BA9C0 [........X.......]
2ABA1BA0 008BAA00 00000000 00000019 2ABA1B64 [............d..*]
kwqjw * kwqjwh_p [2AB7FDB4, 2AB7FDB8) = 00000000
knceug * kncem_p [2AB7FDB8, 2AB7FDBC) = 00000000
ub1 kkziu_p [2AB7FDBC, 2AB7FDC0) = 00000009
hogxdef* hogcu_p [2AB7FDC0, 2AB7FDC4) = 00000000
ub4 ksmugmg2 [2AB7FDC4, 2AB7FDC8) = 0000CDCD
error 600 detected in background process
解决方案 »
- 用sqlplus能不能插入blob,clob,long raw和bfile等数据类型的值
- 存储过程 创建表的问题
- 在调用oci中的OCIStmtExecute出现ORA-24324:service handle not initlize
- oracle 11i能在windows server 2008上安装吗?
- 建数据库时字符集的问题
- dblink导数据的问题
- Oracle 9i问题,救急~~~~~~
- 下面一条语句为何执行不成功,(在sql server 下是没问题的)
- 请问数据库安全审计的数据字典视图有哪些呢?急急急。。。 请各位帮帮我 万分感谢!
- 初学者的疑惑,请老鸟赐教!
- 我的库中有无效对象(函数,过程,视图),编译后,可以通过。但是,隔几个小时候,又出现了上次的无效对象,不知道是什么原因造成
- unix下两个oracle数据库同步问题
看看这个
http://topic.csdn.net/t/20040821/21/3297310.html
这个我不懂,等别人来解答
你可以先google下自己先想想办法