Home » RDBMS Server » Server Administration » Instance crashed... unable to restart the instance
| Instance crashed... unable to restart the instance [message #53658] |
Thu, 03 October 2002 09:55  |
Peter
Messages: 62
Registered: August 2000
|
Member |
|
|
Hi,
I was running two stored procedures (same) with different value for parameters on two different sessions. The instance crashed. The alert log file states:
oracle 9i 9.0.1.3
windows 2000 sp 3
Wed Oct 02 15:21:43 2002
Errors in file F:oracleoradatantprod2adminudumpORA02020.TRC:
ORA-00600: internal error code, arguments: [[kteuPropTime-2]], [[]], [[]], [[]], [[]], [[]], [[]], [[]]
Wed Oct 02 15:26:56 2002
Errors in file F:oracleoradatantprod2adminbdumpntprod2SMON.TRC:
ORA-00600: internal error code, arguments: [[kteuPropTime-2]], [[]], [[]], [[]], [[]], [[]], [[]], [[]]
Wed Oct 02 15:26:59 2002
Fatal internal error happened while SMON was doing active transaction recovery.
Wed Oct 02 15:26:59 2002
Errors in file F:oracleoradatantprod2adminbdumpntprod2SMON.TRC:
ORA-00600: internal error code, arguments: [[kteuPropTime-2]], [[]], [[]], [[]], [[]], [[]], [[]], [[]]
SMON: terminating instance due to error 600
Wed Oct 02 15:27:09 2002
Instance terminated by SMON, pid = 2120
Dump file F:oracleoradatantprod2adminbdumpntprod2ALRT.LOG
When I started the database again after the crash, the instance mounts and crash recovery is successful but fails while doing cache recovery.
Here is the message from trace file:
Wed Oct 02 15:27:09 2002
Instance terminated by SMON, pid = 2120
Dump file F:oracleoradatantprod2adminbdumpntprod2ALRT.LOG
Wed Oct 02 15:34:53 2002
ORACLE V9.0.1.3.1 - Production vsnsta=0
vsnsql=10 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Starting up ORACLE RDBMS Version: 9.0.1.3.1.
System parameters with non-default values:
processes = 200
timed_statistics = TRUE
shared_pool_size = 318767104
sga_max_size = 1080327152
control_files = E:oracleoradatantprod2ctlCONTROL01.CTL, F:oracleoradatantprod2ctlCONTROL02.CTL
db_block_checksum = TRUE
db_block_size = 4096
db_writer_processes = 2
db_cache_size = 419430400
compatible = 9.0.1
log_buffer = 31457280
log_checkpoint_interval = 0
log_checkpoint_timeout = 0
db_file_multiblock_read_count= 16
db_create_file_dest = F:oracleoradatantprod2avm
db_create_online_log_dest_1= F:oracleoradatantprod2avm
db_create_online_log_dest_2= F:oracleoradatantprod2avm
db_create_online_log_dest_3= F:oracleoradatantprod2avm
fast_start_mttr_target = 1800
undo_management = AUTO
undo_tablespace = UNDOTBS
undo_retention = 3600
remote_login_passwordfile= EXCLUSIVE
db_domain = vpn1.veros.com
global_names = TRUE
instance_name = ntprod2
dispatchers = (PROTOCOL=TCP)(SER=MODOSE), (PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer), (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
utl_file_dir = F:oracleoradatantprod2
job_queue_processes = 1
background_dump_dest = F:oracleoradatantprod2adminbdump
user_dump_dest = F:oracleoradatantprod2adminudump
core_dump_dest = F:oracleoradatantprod2admincdump
sort_area_size = 1048576
sort_area_retained_size = 524288
db_name = ntprod2
open_cursors = 300
ifile = E:oracleadminntprod2pfileinit.ora
optimizer_mode = CHOOSE
parallel_automatic_tuning= TRUE
pga_aggregate_target = 104857600
workarea_size_policy = AUTO
PMON started with pid=2
DBW0 started with pid=3
DBW1 started with pid=4
LGWR started with pid=5
CKPT started with pid=6
SMON started with pid=7
RECO started with pid=8
CJQ0 started with pid=9
Wed Oct 02 15:34:55 2002
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Oct 02 15:34:57 2002
alter database mount exclusive
Wed Oct 02 15:35:03 2002
Successful mount of redo thread 1, with mount id 480756643.
Wed Oct 02 15:35:03 2002
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed Oct 02 15:35:03 2002
alter database open
Wed Oct 02 15:35:04 2002
Beginning crash recovery of 1 threads
Wed Oct 02 15:35:04 2002
Started first pass scan
Wed Oct 02 15:35:07 2002
Completed first pass scan
Wed Oct 02 15:35:49 2002
Started recovery at
Thread 1: logseq 2296, block 6753, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 6 Seq 2296 Reading mem 0
Mem# 0 errs 0: E:ORACLEORADATANTPROD2RDOREDO6A.RDO
Mem# 1 errs 0: F:ORACLEORADATANTPROD2RDOREDO6B.RDO
Wed Oct 02 15:36:50 2002
Ended recovery at
Thread 1: logseq 2296, block 191052, scn 0.771326412
74751 data blocks read, 74635 data blocks written, 184299 redo blocks read
Crash recovery completed successfully
Wed Oct 02 15:36:51 2002
Thread 1 advanced to log sequence 2297
Thread 1 opened at log sequence 2297
Current log# 4 seq# 2297 mem# 0: E:ORACLEORADATANTPROD2RDOREDO4A.RDO
Current log# 4 seq# 2297 mem# 1: F:ORACLEORADATANTPROD2RDOREDO4B.RDO
Successful open of redo thread 1.
Wed Oct 02 15:36:51 2002
SMON: enabling cache recovery
Wed Oct 02 15:36:52 2002
Errors in file F:oracleoradatantprod2adminudumpORA01168.TRC:
ORA-00600: internal error code, arguments: [[kteuPropTime-2]], [[]], [[]], [[]], [[]], [[]], [[]], [[]]
Wed Oct 02 15:36:54 2002
Errors in file F:oracleoradatantprod2adminudumpORA01168.TRC:
ORA-00600: internal error code, arguments: [[kteuPropTime-2]], [[]], [[]], [[]], [[]], [[]], [[]], [[]]
Wed Oct 02 15:36:54 2002
Error 600 happened during db open, shutting down database
USER: terminating instance due to error 600
Instance terminated by USER, pid = 1168
ORA-1092 signalled during: alter database open...
Can somebody please help me to bring back the database. It is very very urgent. The database is running on noarchivelog mode.
Regards
Peter
|
|
|
|
|
|
Goto Forum:
Current Time: Thu Sep 19 17:57:03 CDT 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
