Home » RDBMS Server » Server Administration » Re: ORA-01092: Oracle instance terminated. Disconnection forced. error
| Re: ORA-01092: Oracle instance terminated. Disconnection forced. error [message #52214] |
Tue, 09 July 2002 06:23 |
Moutts
Messages: 8
Registered: December 2001
|
Junior Member |
|
|
I did some research based on your guidance. I found the reason for shutdown. If you look at this file, it says that the instance is terminated becoz it could not write it to control file. I also have attached the control file. It looks like it could not able to write in the control file.
I installed oracle on the other server, which is working fine. Please advice me to proceed further with this issue.
-------------------------------------------------------
Dump file E:oracleadminnbcdevbdumpnbcdevALRT.LOG
Fri Jun 21 16:11:12 2002
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
processes = 150
shared_pool_size = 52428800
large_pool_size = 614400
java_pool_size = 20971520
control_files = E:oracleoradatanbcdevcontrol01.ctl, E:oracleoradatanbcdevcontrol02.ctl, E:oracleoradatanbcdevcontrol03.ctl
db_block_buffers = 19200
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 = TRUE
distributed_transactions = 500
instance_name = nbcdev
service_names = nbcdev
mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
open_links = 4
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = nbcdev
open_cursors = 300
os_authent_prefix =
job_queue_processes = 0
job_queue_interval = 10
parallel_max_servers = 5
background_dump_dest = E:oracleadminnbcdevbdump
user_dump_dest = E:oracleadminnbcdevudump
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
Fri Jun 21 16:11:14 2002
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Jun 21 16:11:15 2002
create controlfile reuse set database nbcdev
datafile 'E:oracleoradatanbcdevsystem01.dbf',
'E:oracleoradatanbcdevtemp01.dbf',
'E:oracleoradatanbcdevrbs01.dbf',
'E:oracleoradatanbcdevindx01.dbf',
'E:oracleoradatanbcdevtools01.dbf',
'E:oracleoradatanbcdevdr01.dbf',
'E:oracleoradatanbcdevusers01.dbf'
logfile 'E:oracleoradatanbcdevredo01.log' size 1M,
'E:oracleoradatanbcdevredo02.log' size 1M,
'E:oracleoradatanbcdevredo03.log' size 1M resetlogs
Fri Jun 21 16:11:41 2002
Successful mount of redo thread 1, with mount id 2137187644.
Fri Jun 21 16:11:41 2002
Completed: create controlfile reuse set database nbcdev
dataf
Fri Jun 21 16:11:41 2002
alter database nbcdev open resetlogs
RESETLOGS after incomplete recovery UNTIL CHANGE 282235
Fri Jun 21 16:11:41 2002
Errors in file E:oracleadminnbcdevudumpORA02280.TRC:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'E:ORACLEORADATANBCDEVREDO03.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
Fri Jun 21 16:11:41 2002
Errors in file E:oracleadminnbcdevudumpORA02280.TRC:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'E:ORACLEORADATANBCDEVREDO02.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
Fri Jun 21 16:11:41 2002
Errors in file E:oracleadminnbcdevudumpORA02280.TRC:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: 'E:ORACLEORADATANBCDEVREDO01.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
Fri Jun 21 16:11:42 2002
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: E:ORACLEORADATANBCDEVREDO03.LOG
Successful open of redo thread 1.
Fri Jun 21 16:11:42 2002
SMON: enabling cache recovery
Fri Jun 21 16:11:42 2002
Dictionary check beginning
Dictionary check complete
Fri Jun 21 16:11:43 2002
SMON: enabling tx recovery
Fri Jun 21 16:11:51 2002
Completed: alter database nbcdev open resetlogs
Fri Jun 21 16:11:51 2002
alter database nbcdev character set WE8ISO8859P1
Fri Jun 21 16:11:52 2002
Thread 1 advanced to log sequence 2
Current log# 2 seq# 2 mem# 0: E:ORACLEORADATANBCDEVREDO02.LOG
Thread 1 advanced to log sequence 3
Current log# 3 seq# 3 mem# 0: E:ORACLEORADATANBCDEVREDO01.LOG
Thread 1 advanced to log sequence 4
Current log# 1 seq# 4 mem# 0: E:ORACLEORADATANBCDEVREDO03.LOG
Thread 1 advanced to log sequence 5
Current log# 2 seq# 5 mem# 0: E:ORACLEORADATANBCDEVREDO02.LOG
Fri Jun 21 16:11:55 2002
Completed: alter database nbcdev character set WE8ISO8859P1
Fri Jun 21 16:11:55 2002
alter database nbcdev national character set WE8ISO8859P1
Completed: alter database nbcdev national character set WE8IS
Fri Jun 21 16:11:55 2002
alter database rename global_name to "nbcdev"
Completed: alter database rename global_name to "nbcdev"
Fri Jun 21 16:11:55 2002
Restarting dead background process EMN0
EMN0 started with pid=11
Fri Jun 21 16:11:56 2002
Shutting down instance (normal)
License high water mark = 1
Fri Jun 21 16:11:59 2002
ALTER DATABASE CLOSE NORMAL
Fri Jun 21 16:11:59 2002
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Jun 21 16:12:00 2002
Thread 1 closed at log sequence 5
Fri Jun 21 16:12:00 2002
Completed: ALTER DATABASE CLOSE NORMAL
Fri Jun 21 16:12:00 2002
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
archiving is disabled
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
processes = 150
shared_pool_size = 52428800
large_pool_size = 614400
java_pool_size = 20971520
control_files = E:oracleoradatanbcdevcontrol01.ctl, E:oracleoradatanbcdevcontrol02.ctl, E:oracleoradatanbcdevcontrol03.ctl
db_block_buffers = 19200
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 = TRUE
distributed_transactions = 500
instance_name = nbcdev
service_names = nbcdev
mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
open_links = 4
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = nbcdev
open_cursors = 300
os_authent_prefix =
job_queue_processes = 4
job_queue_interval = 10
parallel_max_servers = 5
background_dump_dest = E:oracleadminnbcdevbdump
user_dump_dest = E:oracleadminnbcdevudump
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
Fri Jun 21 16:12:07 2002
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Jun 21 16:12:08 2002
alter database mount
Fri Jun 21 16:12:15 2002
Successful mount of redo thread 1, with mount id 2137174367.
Fri Jun 21 16:12:15 2002
Database mounted in Exclusive Mode.
Completed: alter database mount
Fri Jun 21 16:12:15 2002
alter database open
Fri Jun 21 16:12:15 2002
Thread 1 opened at log sequence 5
Current log# 2 seq# 5 mem# 0: E:ORACLEORADATANBCDEVREDO02.LOG
Successful open of redo thread 1.
Fri Jun 21 16:12:15 2002
SMON: enabling cache recovery
SMON: enabling tx recovery
Fri Jun 21 16:12:15 2002
Updating character set in controlfile to WE8ISO8859P1
Completed: alter database open
Fri Jun 21 16:12:26 2002
Thread 1 advanced to log sequence 6
Current log# 3 seq# 6 mem# 0: E:ORACLEORADATANBCDEVREDO01.LOG
Fri Jun 21 16:20:14 2002
/* OracleOEM */ CREATE TABLESPACE "I25213TXN" LOGGING DATAFILE 'E:ORACLEORADATANBCDEVI25213TXN1.ora' SIZE 250M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE 32767M DEFAULT STORAGE ( INITIAL 128K NEXT 128K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 )
Fri Jun 21 16:20:23 2002
Completed: /* OracleOEM */ CREATE TABLESPACE "I25213TXN" LOGG
Fri Jun 21 16:21:23 2002
/* OracleOEM */ CREATE TABLESPACE "I25213CAT" LOGGING DATAFILE 'E:ORACLEORADATANBCDEVI25213CAT1.ora' SIZE 250M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE 32767M DEFAULT STORAGE ( INITIAL 128K NEXT 128K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 )
Fri Jun 21 16:21:31 2002
Completed: /* OracleOEM */ CREATE TABLESPACE "I25213CAT" LOGG
Fri Jun 21 16:22:06 2002
/* OracleOEM */ ALTER TABLESPACE "I25213CAT" MINIMUM EXTENT 64K
Fri Jun 21 16:22:06 2002
Completed: /* OracleOEM */ ALTER TABLESPACE "I25213CAT" MINIM
Fri Jun 21 16:22:13 2002
/* OracleOEM */ ALTER TABLESPACE "I25213TXN" MINIMUM EXTENT 64K
Completed: /* OracleOEM */ ALTER TABLESPACE "I25213TXN" MINIM
Fri Jun 21 16:38:03 2002
Thread 1 advanced to log sequence 7
Current log# 1 seq# 7 mem# 0: E:ORACLEORADATANBCDEVREDO03.LOG
Thread 1 advanced to log sequence 8
Current log# 2 seq# 8 mem# 0: E:ORACLEORADATANBCDEVREDO02.LOG
Thread 1 advanced to log sequence 9
Current log# 3 seq# 9 mem# 0: E:ORACLEORADATANBCDEVREDO01.LOG
Thread 1 advanced to log sequence 10
Current log# 1 seq# 10 mem# 0: E:ORACLEORADATANBCDEVREDO03.LOG
Thread 1 advanced to log sequence 11
Current log# 2 seq# 11 mem# 0: E:ORACLEORADATANBCDEVREDO02.LOG
Thread 1 advanced to log sequence 12
Current log# 3 seq# 12 mem# 0: E:ORACLEORADATANBCDEVREDO01.LOG
Thread 1 advanced to log sequence 13
Current log# 1 seq# 13 mem# 0: E:ORACLEORADATANBCDEVREDO03.LOG
Thread 1 advanced to log sequence 14
Current log# 2 seq# 14 mem# 0: E:ORACLEORADATANBCDEVREDO02.LOG
Thread 1 advanced to log sequence 15
Current log# 3 seq# 15 mem# 0: E:ORACLEORADATANBCDEVREDO01.LOG
Thread 1 advanced to log sequence 16
Current log# 1 seq# 16 mem# 0: E:ORACLEORADATANBCDEVREDO03.LOG
Thread 1 advanced to log sequence 17
Current log# 2 seq# 17 mem# 0: E:ORACLEORADATANBCDEVREDO02.LOG
Thread 1 advanced to log sequence 18
Current log# 3 seq# 18 mem# 0: E:ORACLEORADATANBCDEVREDO01.LOG
Thread 1 advanced to log sequence 19
Current log# 1 seq# 19 mem# 0: E:ORACLEORADATANBCDEVREDO03.LOG
Thread 1 advanced to log sequence 20
Current log# 2 seq# 20 mem# 0: E:ORACLEORADATANBCDEVREDO02.LOG
Thread 1 advanced to log sequence 21
Current log# 3 seq# 21 mem# 0: E:ORACLEORADATANBCDEVREDO01.LOG
Thread 1 advanced to log sequence 22
Current log# 1 seq# 22 mem# 0: E:ORACLEORADATANBCDEVREDO03.LOG
Thread 1 advanced to log sequence 23
Current log# 2 seq# 23 mem# 0: E:ORACLEORADATANBCDEVREDO02.LOG
Thread 1 advanced to log sequence 24
Current log# 3 seq# 24 mem# 0: E:ORACLEORADATANBCDEVREDO01.LOG
Thread 1 advanced to log sequence 25
Current log# 1 seq# 25 mem# 0: E:ORACLEORADATANBCDEVREDO03.LOG
Thread 1 advanced to log sequence 26
Current log# 2 seq# 26 mem# 0: E:ORACLEORADATANBCDEVREDO02.LOG
Thread 1 cannot allocate new log, sequence 27
Checkpoint not complete
Current log# 2 seq# 26 mem# 0: E:ORACLEORADATANBCDEVREDO02.LOG
Thread 1 advanced to log sequence 27
Current log# 3 seq# 27 mem# 0: E:ORACLEORADATANBCDEVREDO01.LOG
Thread 1 advanced to log sequence 28
Current log# 1 seq# 28 mem# 0: E:ORACLEORADATANBCDEVREDO03.LOG
Thread 1 advanced to log sequence 29
Current log# 2 seq# 29 mem# 0: E:ORACLEORADATANBCDEVREDO02.LOG
Thread 1 cannot allocate new log, sequence 30
Checkpoint not complete
Current log# 2 seq# 29 mem# 0: E:ORACLEORADATANBCDEVREDO02.LOG
Thread 1 advanced to log sequence 30
Current log# 3 seq# 30 mem# 0: E:ORACLEORADATANBCDEVREDO01.LOG
Thread 1 advanced to log sequence 31
Current log# 1 seq# 31 mem# 0: E:ORACLEORADATANBCDEVREDO03.LOG
Thread 1 advanced to log sequence 32
Current log# 2 seq# 32 mem# 0: E:ORACLEORADATANBCDEVREDO02.LOG
Thread 1 advanced to log sequence 33
Current log# 3 seq# 33 mem# 0: E:ORACLEORADATANBCDEVREDO01.LOG
Thread 1 cannot allocate new log, sequence 34
Checkpoint not complete
Current log# 3 seq# 33 mem# 0: E:ORACLEORADATANBCDEVREDO01.LOG
Thread 1 advanced to log sequence 34
Current log# 1 seq# 34 mem# 0: E:ORACLEORADATANBCDEVREDO03.LOG
Thread 1 advanced to log sequence 35
Current log# 2 seq# 35 mem# 0: E:ORACLEORADATANBCDEVREDO02.LOG
Thread 1 cannot allocate new log, sequence 36
Checkpoint not complete
Current log# 2 seq# 35 mem# 0: E:ORACLEORADATANBCDEVREDO02.LOG
Thread 1 advanced to log sequence 36
Current log# 3 seq# 36 mem# 0: E:ORACLEORADATANBCDEVREDO01.LOG
Thread 1 advanced to log sequence 37
Current log# 1 seq# 37 mem# 0: E:ORACLEORADATANBCDEVREDO03.LOG
Thread 1 advanced to log sequence 38
Current log# 2 seq# 38 mem# 0: E:ORACLEORADATANBCDEVREDO02.LOG
Thread 1 advanced to log sequence 39
Current log# 3 seq# 39 mem# 0: E:ORACLEORADATANBCDEVREDO01.LOG
Thread 1 advanced to log sequence 40
Current log# 1 seq# 40 mem# 0: E:ORACLEORADATANBCDEVREDO03.LOG
Thread 1 advanced to log sequence 41
Current log# 2 seq# 41 mem# 0: E:ORACLEORADATANBCDEVREDO02.LOG
Thread 1 advanced to log sequence 42
Current log# 3 seq# 42 mem# 0: E:ORACLEORADATANBCDEVREDO01.LOG
Thread 1 advanced to log sequence 43
Current log# 1 seq# 43 mem# 0: E:ORACLEORADATANBCDEVREDO03.LOG
Thread 1 advanced to log sequence 44
Current log# 2 seq# 44 mem# 0: E:ORACLEORADATANBCDEVREDO02.LOG
Thread 1 advanced to log sequence 45
Current log# 3 seq# 45 mem# 0: E:ORACLEORADATANBCDEVREDO01.LOG
Thread 1 advanced to log sequence 46
Current log# 1 seq# 46 mem# 0: E:ORACLEORADATANBCDEVREDO03.LOG
Thread 1 advanced to log sequence 47
Current log# 2 seq# 47 mem# 0: E:ORACLEORADATANBCDEVREDO02.LOG
Thread 1 advanced to log sequence 48
Current log# 3 seq# 48 mem# 0: E:ORACLEORADATANBCDEVREDO01.LOG
Thread 1 advanced to log sequence 49
Current log# 1 seq# 49 mem# 0: E:ORACLEORADATANBCDEVREDO03.LOG
Thread 1 advanced to log sequence 50
Current log# 2 seq# 50 mem# 0: E:ORACLEORADATANBCDEVREDO02.LOG
Thread 1 advanced to log sequence 51
Current log# 3 seq# 51 mem# 0: E:ORACLEORADATANBCDEVREDO01.LOG
Thread 1 advanced to log sequence 52
Current log# 1 seq# 52 mem# 0: E:ORACLEORADATANBCDEVREDO03.LOG
Thread 1 advanced to log sequence 53
Current log# 2 seq# 53 mem# 0: E:ORACLEORADATANBCDEVREDO02.LOG
Fri Jun 21 16:41:05 2002
Thread 1 advanced to log sequence 54
Current log# 3 seq# 54 mem# 0: E:ORACLEORADATANBCDEVREDO01.LOG
Thread 1 advanced to log sequence 55
Current log# 1 seq# 55 mem# 0: E:ORACLEORADATANBCDEVREDO03.LOG
Thread 1 advanced to log sequence 56
Current log# 2 seq# 56 mem# 0: E:ORACLEORADATANBCDEVREDO02.LOG
Thread 1 advanced to log sequence 57
Current log# 3 seq# 57 mem# 0: E:ORACLEORADATANBCDEVREDO01.LOG
Thread 1 advanced to log sequence 58
Current log# 1 seq# 58 mem# 0: E:ORACLEORADATANBCDEVREDO03.LOG
Thread 1 advanced to log sequence 59
Current log# 2 seq# 59 mem# 0: E:ORACLEORADATANBCDEVREDO02.LOG
Thread 1 advanced to log sequence 60
Current log# 3 seq# 60 mem# 0: E:ORACLEORADATANBCDEVREDO01.LOG
Thread 1 advanced to log sequence 61
Current log# 1 seq# 61 mem# 0: E:ORACLEORADATANBCDEVREDO03.LOG
Thread 1 advanced to log sequence 62
Current log# 2 seq# 62 mem# 0: E:ORACLEORADATANBCDEVREDO02.LOG
Thread 1 advanced to log sequence 63
Current log# 3 seq# 63 mem# 0: E:ORACLEORADATANBCDEVREDO01.LOG
Thread 1 advanced to log sequence 64
Current log# 1 seq# 64 mem# 0: E:ORACLEORADATANBCDEVREDO03.LOG
Thread 1 advanced to log sequence 65
Current log# 2 seq# 65 mem# 0: E:ORACLEORADATANBCDEVREDO02.LOG
Thread 1 advanced to log sequence 66
Current log# 3 seq# 66 mem# 0: E:ORACLEORADATANBCDEVREDO01.LOG
Thread 1 advanced to log sequence 67
Current log# 1 seq# 67 mem# 0: E:ORACLEORADATANBCDEVREDO03.LOG
Thread 1 advanced to log sequence 68
Current log# 2 seq# 68 mem# 0: E:ORACLEORADATANBCDEVREDO02.LOG
Thread 1 advanced to log sequence 69
Current log# 3 seq# 69 mem# 0: E:ORACLEORADATANBCDEVREDO01.LOG
Thread 1 advanced to log sequence 70
Current log# 1 seq# 70 mem# 0: E:ORACLEORADATANBCDEVREDO03.LOG
Thread 1 advanced to log sequence 71
Current log# 2 seq# 71 mem# 0: E:ORACLEORADATANBCDEVREDO02.LOG
Thread 1 advanced to log sequence 72
Current log# 3 seq# 72 mem# 0: E:ORACLEORADATANBCDEVREDO01.LOG
Thread 1 advanced to log sequence 73
Current log# 1 seq# 73 mem# 0: E:ORACLEORADATANBCDEVREDO03.LOG
Tue Jun 25 22:40:40 2002
Errors in file E:oracleadminnbcdevbdumpnbcdevCKPT.TRC:
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'E:ORACLEORADATANBCDEVCONTROL02.CTL'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.
Tue Jun 25 22:40:40 2002
CKPT: terminating instance due to error 221
Instance terminated by CKPT, pid = 2172
Dump file E:oracleadminnbcdevbdumpnbcdevALRT.LOG
Thu Jun 27 11:03:33 2002
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
processes = 150
shared_pool_size = 52428800
large_pool_size = 614400
java_pool_size = 20971520
control_files = E:oracleoradatanbcdevcontrol01.ctl, E:oracleoradatanbcdevcontrol02.ctl, E:oracleoradatanbcdevcontrol03.ctl
db_block_buffers = 19200
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 = TRUE
distributed_transactions = 500
instance_name = nbcdev
service_names = nbcdev
mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
open_links = 4
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = nbcdev
open_cursors = 300
os_authent_prefix =
job_queue_processes = 4
job_queue_interval = 10
parallel_max_servers = 5
background_dump_dest = E:oracleadminnbcdevbdump
user_dump_dest = E:oracleadminnbcdevudump
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
Thu Jun 27 11:03:37 2002
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Jun 27 11:03:37 2002
alter database mount exclusive
Thu Jun 27 11:03:44 2002
Successful mount of redo thread 1, with mount id 2137707280.
Thu Jun 27 11:03:44 2002
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Thu Jun 27 11:03:44 2002
alter database open
Beginning crash recovery of 1 threads
Thu Jun 27 11:03:45 2002
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 1 Seq 73 Reading mem 0
Mem# 0 errs 0: E:ORACLEORADATANBCDEVREDO03.LOG
Thu Jun 27 11:03:45 2002
Thread recovery: finish rolling forward thread 1
Thread recovery: 0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Thu Jun 27 11:03:45 2002
Thread 1 advanced to log sequence 74
Thread 1 opened at log sequence 74
Current log# 2 seq# 74 mem# 0: E:ORACLEORADATANBCDEVREDO02.LOG
Successful open of redo thread 1.
Thu Jun 27 11:03:46 2002
SMON: enabling cache recovery
SMON: enabling tx recovery
Thu Jun 27 11:04:00 2002
Completed: alter database open
Thu Jun 27 22:43:43 2002
Errors in file E:oracleadminnbcdevbdumpnbcdevCKPT.TRC:
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'E:ORACLEORADATANBCDEVCONTROL01.CTL'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.
Thu Jun 27 22:43:43 2002
CKPT: terminating instance due to error 221
Dump file E:oracleadminnbcdevbdumpnbcdevALRT.LOG
Mon Jul 01 11:39:56 2002
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
processes = 150
shared_pool_size = 52428800
large_pool_size = 614400
java_pool_size = 20971520
control_files = E:oracleoradatanbcdevcontrol01.ctl, E:oracleoradatanbcdevcontrol02.ctl, E:oracleoradatanbcdevcontrol03.ctl
db_block_buffers = 19200
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 = TRUE
distributed_transactions = 500
instance_name = nbcdev
service_names = nbcdev
mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
open_links = 4
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = nbcdev
open_cursors = 300
os_authent_prefix =
job_queue_processes = 4
job_queue_interval = 10
parallel_max_servers = 5
background_dump_dest = E:oracleadminnbcdevbdump
user_dump_dest = E:oracleadminnbcdevudump
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
Mon Jul 01 11:39:59 2002
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Jul 01 11:40:00 2002
alter database mount exclusive
Mon Jul 01 11:40:07 2002
Successful mount of redo thread 1, with mount id 2138071575.
Mon Jul 01 11:40:07 2002
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Mon Jul 01 11:40:07 2002
alter database open
Beginning crash recovery of 1 threads
Mon Jul 01 11:40:07 2002
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 2 Seq 74 Reading mem 0
Mem# 0 errs 0: E:ORACLEORADATANBCDEVREDO02.LOG
Mon Jul 01 11:40:07 2002
Thread recovery: finish rolling forward thread 1
Thread recovery: 0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Mon Jul 01 11:40:08 2002
Thread 1 advanced to log sequence 75
Thread 1 opened at log sequence 75
Current log# 3 seq# 75 mem# 0: E:ORACLEORADATANBCDEVREDO01.LOG
Successful open of redo thread 1.
Mon Jul 01 11:40:08 2002
SMON: enabling cache recovery
SMON: enabling tx recovery
Mon Jul 01 11:40:22 2002
Completed: alter database open
Mon Jul 01 22:59:11 2002
Errors in file E:oracleadminnbcdevbdumpnbcdevCKPT.TRC:
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'E:ORACLEORADATANBCDEVCONTROL02.CTL'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.
Mon Jul 01 22:59:11 2002
CKPT: terminating instance due to error 221
Instance terminated by CKPT, pid = 1800
Dump file E:oracleadminnbcdevbdumpnbcdevALRT.LOG
Tue Jul 02 10:16:11 2002
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
processes = 150
shared_pool_size = 52428800
large_pool_size = 614400
java_pool_size = 20971520
control_files = E:oracleoradatanbcdevcontrol01.ctl, E:oracleoradatanbcdevcontrol02.ctl, E:oracleoradatanbcdevcontrol03.ctl
db_block_buffers = 19200
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 = TRUE
distributed_transactions = 500
instance_name = nbcdev
service_names = nbcdev
mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
open_links = 4
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = nbcdev
open_cursors = 300
os_authent_prefix =
job_queue_processes = 4
job_queue_interval = 10
parallel_max_servers = 5
background_dump_dest = E:oracleadminnbcdevbdump
user_dump_dest = E:oracleadminnbcdevudump
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
Tue Jul 02 10:16:14 2002
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Jul 02 10:16:14 2002
alter database mount exclusive
Tue Jul 02 10:16:21 2002
Successful mount of redo thread 1, with mount id 2138241269.
Tue Jul 02 10:16:21 2002
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Jul 02 10:16:21 2002
alter database open
Beginning crash recovery of 1 threads
Tue Jul 02 10:16:22 2002
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 3 Seq 75 Reading mem 0
Mem# 0 errs 0: E:ORACLEORADATANBCDEVREDO01.LOG
Tue Jul 02 10:16:22 2002
Thread recovery: finish rolling forward thread 1
Thread recovery: 0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Tue Jul 02 10:16:22 2002
Thread 1 advanced to log sequence 76
Thread 1 opened at log sequence 76
Current log# 1 seq# 76 mem# 0: E:ORACLEORADATANBCDEVREDO03.LOG
Successful open of redo thread 1.
Tue Jul 02 10:16:23 2002
SMON: enabling cache recovery
SMON: enabling tx recovery
Tue Jul 02 10:16:37 2002
Completed: alter database open
Tue Jul 02 23:12:55 2002
Errors in file E:oracleadminnbcdevbdumpnbcdevCKPT.TRC:
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'E:ORACLEORADATANBCDEVCONTROL01.CTL'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.
Tue Jul 02 23:12:55 2002
CKPT: terminating instance due to error 221
Instance terminated by CKPT, pid = 1088
Dump file E:oracleadminnbcdevbdumpnbcdevALRT.LOG
Fri Jul 05 11:20:13 2002
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
processes = 150
shared_pool_size = 52428800
large_pool_size = 614400
java_pool_size = 20971520
control_files = E:oracleoradatanbcdevcontrol01.ctl, E:oracleoradatanbcdevcontrol02.ctl, E:oracleoradatanbcdevcontrol03.ctl
db_block_buffers = 19200
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 = TRUE
distributed_transactions = 500
instance_name = nbcdev
service_names = nbcdev
mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
open_links = 4
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = nbcdev
open_cursors = 300
os_authent_prefix =
job_queue_processes = 4
job_queue_interval = 10
parallel_max_servers = 5
background_dump_dest = E:oracleadminnbcdevbdump
user_dump_dest = E:oracleadminnbcdevudump
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
Fri Jul 05 11:20:17 2002
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Jul 05 11:20:17 2002
alter database mount exclusive
Fri Jul 05 11:20:24 2002
Successful mount of redo thread 1, with mount id 2138462840.
Fri Jul 05 11:20:24 2002
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Fri Jul 05 11:20:24 2002
alter database open
Beginning crash recovery of 1 threads
Fri Jul 05 11:20:24 2002
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 1 Seq 76 Reading mem 0
Mem# 0 errs 0: E:ORACLEORADATANBCDEVREDO03.LOG
Fri Jul 05 11:20:25 2002
Thread recovery: finish rolling forward thread 1
Thread recovery: 0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Fri Jul 05 11:20:25 2002
Thread 1 advanced to log sequence 77
Thread 1 opened at log sequence 77
Current log# 2 seq# 77 mem# 0: E:ORACLEORADATANBCDEVREDO02.LOG
Successful open of redo thread 1.
Fri Jul 05 11:20:25 2002
SMON: enabling cache recovery
SMON: enabling tx recovery
Fri Jul 05 11:20:39 2002
Completed: alter database open
Sat Jul 06 09:45:41 2002
Errors in file E:oracleadminnbcdevbdumpnbcdevCKPT.TRC:
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'E:ORACLEORADATANBCDEVCONTROL02.CTL'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.
Sat Jul 06 09:45:41 2002
CKPT: terminating instance due to error 221
Instance terminated by CKPT, pid = 1804
Dump file E:oracleadminnbcdevbdumpnbcdevALRT.LOG
Mon Jul 08 08:29:18 2002
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
processes = 150
shared_pool_size = 52428800
large_pool_size = 614400
java_pool_size = 20971520
control_files = E:oracleoradatanbcdevcontrol01.ctl, E:oracleoradatanbcdevcontrol02.ctl, E:oracleoradatanbcdevcontrol03.ctl
db_block_buffers = 19200
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 = TRUE
distributed_transactions = 500
instance_name = nbcdev
service_names = nbcdev
mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
open_links = 4
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = nbcdev
open_cursors = 300
os_authent_prefix =
job_queue_processes = 4
job_queue_interval = 10
parallel_max_servers = 5
background_dump_dest = E:oracleadminnbcdevbdump
user_dump_dest = E:oracleadminnbcdevudump
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
Mon Jul 08 08:29:21 2002
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Jul 08 08:29:22 2002
alter database mount exclusive
Mon Jul 08 08:29:29 2002
Successful mount of redo thread 1, with mount id 2138700008.
Mon Jul 08 08:29:29 2002
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Mon Jul 08 08:29:29 2002
alter database open
Beginning crash recovery of 1 threads
Mon Jul 08 08:29:29 2002
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 2 Seq 77 Reading mem 0
Mem# 0 errs 0: E:ORACLEORADATANBCDEVREDO02.LOG
Mon Jul 08 08:29:29 2002
Thread recovery: finish rolling forward thread 1
Thread recovery: 0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Mon Jul 08 08:29:30 2002
Thread 1 advanced to log sequence 78
Thread 1 opened at log sequence 78
Current log# 3 seq# 78 mem# 0: E:ORACLEORADATANBCDEVREDO01.LOG
Successful open of redo thread 1.
Mon Jul 08 08:29:30 2002
SMON: enabling cache recovery
SMON: enabling tx recovery
Mon Jul 08 08:29:43 2002
Completed: alter database open
Mon Jul 08 23:07:13 2002
Errors in file E:oracleadminnbcdevbdumpnbcdevCKPT.TRC:
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'E:ORACLEORADATANBCDEVCONTROL01.CTL'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.
Mon Jul 08 23:07:13 2002
CKPT: terminating instance due to error 221
Instance terminated by CKPT, pid = 1788
Dump file E:oracleadminnbcdevbdumpnbcdevALRT.LOG
Tue Jul 09 09:08:13 2002
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
processes = 150
shared_pool_size = 52428800
large_pool_size = 614400
java_pool_size = 20971520
control_files = E:oracleoradatanbcdevcontrol01.ctl, E:oracleoradatanbcdevcontrol02.ctl, E:oracleoradatanbcdevcontrol03.ctl
db_block_buffers = 19200
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 = TRUE
distributed_transactions = 500
instance_name = nbcdev
service_names = nbcdev
mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
open_links = 4
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = nbcdev
open_cursors = 300
os_authent_prefix =
job_queue_processes = 4
job_queue_interval = 10
parallel_max_servers = 5
background_dump_dest = E:oracleadminnbcdevbdump
user_dump_dest = E:oracleadminnbcdevudump
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
Tue Jul 09 09:08:16 2002
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Jul 09 09:08:17 2002
alter database mount exclusive
Tue Jul 09 09:08:24 2002
Successful mount of redo thread 1, with mount id 2138838920.
Tue Jul 09 09:08:24 2002
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Jul 09 09:08:24 2002
alter database open
Beginning crash recovery of 1 threads
Tue Jul 09 09:08:24 2002
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 3 Seq 78 Reading mem 0
Mem# 0 errs 0: E:ORACLEORADATANBCDEVREDO01.LOG
Tue Jul 09 09:08:24 2002
Thread recovery: finish rolling forward thread 1
Thread recovery: 0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Tue Jul 09 09:08:25 2002
Thread 1 advanced to log sequence 79
Thread 1 opened at log sequence 79
Current log# 1 seq# 79 mem# 0: E:ORACLEORADATANBCDEVREDO03.LOG
Successful open of redo thread 1.
Tue Jul 09 09:08:25 2002
SMON: enabling cache recovery
SMON: enabling tx recovery
Tue Jul 09 09:08:32 2002
Completed: alter database open
Dump file E:oracleadminnbcdevbdumpnbcdevALRT.LOG
Tue Jul 09 09:23:50 2002
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
processes = 150
shared_pool_size = 52428800
large_pool_size = 614400
java_pool_size = 20971520
control_files = E:oracleoradatanbcdevcontrol01.ctl, E:oracleoradatanbcdevcontrol02.ctl, E:oracleoradatanbcdevcontrol03.ctl
db_block_buffers = 19200
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 = TRUE
distributed_transactions = 500
instance_name = nbcdev
service_names = nbcdev
mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
open_links = 4
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = nbcdev
open_cursors = 300
os_authent_prefix =
job_queue_processes = 4
job_queue_interval = 10
parallel_max_servers = 5
background_dump_dest = E:oracleadminnbcdevbdump
user_dump_dest = E:oracleadminnbcdevudump
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
Tue Jul 09 09:23:53 2002
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Jul 09 09:23:53 2002
alter database mount exclusive
Tue Jul 09 09:24:00 2002
Successful mount of redo thread 1, with mount id 2138787888.
Tue Jul 09 09:24:00 2002
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Jul 09 09:24:00 2002
alter database open
Beginning crash recovery of 1 threads
Tue Jul 09 09:24:01 2002
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 1 Seq 79 Reading mem 0
Mem# 0 errs 0: E:ORACLEORADATANBCDEVREDO03.LOG
Tue Jul 09 09:24:01 2002
Thread recovery: finish rolling forward thread 1
Thread recovery: 20 data blocks read, 20 data blocks written, 47 redo blocks read
Crash recovery completed successfully
Tue Jul 09 09:24:01 2002
Thread 1 advanced to log sequence 80
Thread 1 opened at log sequence 80
Current log# 2 seq# 80 mem# 0: E:ORACLEORADATANBCDEVREDO02.LOG
Successful open of redo thread 1.
Tue Jul 09 09:24:02 2002
SMON: enabling cache recovery
SMON: enabling tx recovery
Tue Jul 09 09:24:14 2002
Completed: alter database open
Dump file E:oracleadminnbcdevbdumpnbcdevALRT.LOG
Tue Jul 09 09:36:22 2002
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
processes = 150
shared_pool_size = 52428800
large_pool_size = 614400
java_pool_size = 20971520
control_files = E:oracleoradatanbcdevcontrol01.ctl, E:oracleoradatanbcdevcontrol02.ctl, E:oracleoradatanbcdevcontrol03.ctl
db_block_buffers = 19200
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 = TRUE
distributed_transactions = 500
instance_name = nbcdev
service_names = nbcdev
mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
open_links = 4
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = nbcdev
open_cursors = 300
os_authent_prefix =
job_queue_processes = 4
job_queue_interval = 10
parallel_max_servers = 5
background_dump_dest = E:oracleadminnbcdevbdump
user_dump_dest = E:oracleadminnbcdevudump
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
Tue Jul 09 09:36:25 2002
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Jul 09 09:36:26 2002
alter database mount exclusive
Tue Jul 09 09:36:33 2002
Successful mount of redo thread 1, with mount id 2138820129.
Tue Jul 09 09:36:33 2002
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Jul 09 09:36:33 2002
alter database open
Beginning crash recovery of 1 threads
Tue Jul 09 09:36:33 2002
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 2 Seq 80 Reading mem 0
Mem# 0 errs 0: E:ORACLEORADATANBCDEVREDO02.LOG
Tue Jul 09 09:36:34 2002
Thread recovery: finish rolling forward thread 1
Thread recovery: 21 data blocks read, 21 data blocks written, 48 redo blocks read
Crash recovery completed successfully
Tue Jul 09 09:36:34 2002
Thread 1 advanced to log sequence 81
Thread 1 opened at log sequence 81
Current log# 3 seq# 81 mem# 0: E:ORACLEORADATANBCDEVREDO01.LOG
Successful open of redo thread 1.
Tue Jul 09 09:36:34 2002
SMON: enabling cache recovery
SMON: enabling tx recovery
Tue Jul 09 09:36:46 2002
Completed: alter database open
-------------------------------------------------------
This is the control file...
-------------------------------------------------------
Dump file E:oracleadminnbcdevbdumpnbcdevCKPT.TRC
Tue Jun 25 22:40:40 2002
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Instance name: nbcdev
Redo thread mounted by this instance: 1
Oracle process number: 5
Windows thread id: 2172, image: ORACLE.EXE
*** 2002-06-25 22:40:40.562
*** SESSION ID:(4.1) 2002-06-25 22:40:40.562
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'E:ORACLEORADATANBCDEVCONTROL02.CTL'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.
error 221 detected in background process
Dump file E:oracleadminnbcdevbdumpnbcdevCKPT.TRC
Thu Jun 27 22:43:43 2002
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Instance name: nbcdev
Redo thread mounted by this instance: 1
Oracle process number: 5
Windows thread id: 1796, image: ORACLE.EXE
*** 2002-06-27 22:43:43.171
*** SESSION ID:(4.1) 2002-06-27 22:43:43.171
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'E:ORACLEORADATANBCDEVCONTROL01.CTL'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.
error 221 detected in background process
Dump file E:oracleadminnbcdevbdumpnbcdevCKPT.TRC
Mon Jul 01 22:59:11 2002
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Instance name: nbcdev
Redo thread mounted by this instance: 1
Oracle process number: 5
Windows thread id: 1800, image: ORACLE.EXE
*** 2002-07-01 22:59:11.546
*** SESSION ID:(4.1) 2002-07-01 22:59:11.546
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'E:ORACLEORADATANBCDEVCONTROL02.CTL'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.
error 221 detected in background process
Dump file E:oracleadminnbcdevbdumpnbcdevCKPT.TRC
Tue Jul 02 23:12:55 2002
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Instance name: nbcdev
Redo thread mounted by this instance: 1
Oracle process number: 5
Windows thread id: 1088, image: ORACLE.EXE
*** 2002-07-02 23:12:55.093
*** SESSION ID:(4.1) 2002-07-02 23:12:55.078
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'E:ORACLEORADATANBCDEVCONTROL01.CTL'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.
error 221 detected in background process
Dump file E:oracleadminnbcdevbdumpnbcdevCKPT.TRC
Sat Jul 06 09:45:41 2002
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Instance name: nbcdev
Redo thread mounted by this instance: 1
Oracle process number: 5
Windows thread id: 1804, image: ORACLE.EXE
*** 2002-07-06 09:45:41.468
*** SESSION ID:(4.1) 2002-07-06 09:45:41.468
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'E:ORACLEORADATANBCDEVCONTROL02.CTL'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.
error 221 detected in background process
Dump file E:oracleadminnbcdevbdumpnbcdevCKPT.TRC
Mon Jul 08 23:07:13 2002
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Instance name: nbcdev
Redo thread mounted by this instance: 1
Oracle process number: 5
Windows thread id: 1788, image: ORACLE.EXE
*** 2002-07-08 23:07:13.750
*** SESSION ID:(4.1) 2002-07-08 23:07:13.734
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'E:ORACLEORADATANBCDEVCONTROL01.CTL'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.
error 221 detected in background process
-------------------------------------------------------
need your help...!!!!!
|
|
|
|
Goto Forum:
Current Time: Thu Sep 19 18:16:24 CDT 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
