ORA:01092 Oracle Instance terminated.Disconnection forced.
Hi,
Today morning when i was importing power gone. When i restarted my system, database is giving "ORA:01092 Oracle Instance terminated.Disconnection forced." error. I am sending *.trc and *ALRT.log files contents along with this message.
*ALRT.log
---------
Recovery of Online Redo Log: Thread 1 Group 1 Seq 7006 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ORACLENP\REDO01.LOG
SMON: terminating instance due to error 600
Instance terminated by SMON, pid = 824
Dump file D:\oracle\admin\oraclenp\bdump\oraclenpALRT.LOG
Wed Oct 09 11:53:07 2002
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 , CPU type 586
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
processes = 500
shared_pool_size = 15223206
large_pool_size = 714400
java_pool_size = 32768
control_files = D:\oracle\oradata\oraclenp\control01.ctl, D:\oracle\oradata\oraclenp\control02.ctl, D:\oracle\oradata\oraclenp\control03.ctl
db_block_buffers = 3743
db_block_size = 8192
compatible = 8.1.0.0.0
log_archive_start = TRUE
log_archive_dest_1 = location=D:\oracle\oradata\oraclenp\archive
log_archive_format = %%ORACLE_SID%%T%TS%S.ARC
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
db_domain = codecache.com
global_names = TRUE
distributed_transactions = 500
instance_name = oraclenp
service_names = oraclenp
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = oraclenp
open_cursors = 300
os_authent_prefix =
utl_file_dir = d:\temp
parallel_max_servers = 5
background_dump_dest = D:\oracle\admin\oraclenp\bdump
user_dump_dest = D:\oracle\admin\oraclenp\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
Wed Oct 09 11:53:10 2002
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=8
ARC0: Archival started
Wed Oct 09 11:53:10 2002
ARCH: STARTING ARCH PROCESSES COMPLETE
Wed Oct 09 11:53:13 2002
alter database mount exclusive
Wed Oct 09 11:53:20 2002
Successful mount of redo thread 1, with mount id 1555195824.
Wed Oct 09 11:53:20 2002
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed Oct 09 11:53:20 2002
alter database open
Beginning crash recovery of 1 threads
Wed Oct 09 11:53:22 2002
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 1 Seq 7006 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ORACLENP\REDO01.LOG
Wed Oct 09 11:53:23 2002
Thread recovery: finish rolling forward thread 1
Thread recovery: 9 data blocks read, 9 data blocks written, 35 redo blocks read
Crash recovery completed successfully
Wed Oct 09 11:53:24 2002
Thread 1 advanced to log sequence 7007
Thread 1 opened at log sequence 7007
Current log# 2 seq# 7007 mem# 0: D:\ORACLE\ORADATA\ORACLENP\REDO02.LOG
Successful open of redo thread 1.
Wed Oct 09 11:53:24 2002
ARC0: media recovery disabled
Wed Oct 09 11:53:24 2002
SMON: enabling cache recovery
SMON: enabling tx recovery
Wed Oct 09 11:53:30 2002
Errors in file D:\oracle\admin\oraclenp\bdump\oraclenpSMON.TRC:
ORA-00600: internal error code, arguments: [4137], [], [], [], [], [], [], []
Wed Oct 09 11:53:39 2002
Completed: alter database open
Wed Oct 09 11:53:45 2002
ORACLE Instance oraclenp (pid = 6) - Error 600 encountered while recovering transaction (2, 9).
Wed Oct 09 11:53:45 2002
Errors in file D:\oracle\admin\oraclenp\bdump\oraclenpSMON.TRC:
ORA-00600: internal error code, arguments: [4137], [], [], [], [], [], [], []
Wed Oct 09 11:53:57 2002
Errors in file D:\oracle\admin\oraclenp\bdump\oraclenpSMON.TRC:
ORA-00600: internal error code, arguments: [4194], [5], [19], [], [], [], [], []
*.trc
-----
*** SESSION ID:(6.5) 2002-10-09 12:28:57.809
*** 2002-10-09 12:28:57.809
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [4194], [5], [19], [], [], [], [], []
Current SQL statement for this session:
update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6,cache=:7,highwater=:8,audit$=:9 where obj#=:1
Please help it is very very urgent.
Thanks in advance.