[8i] Arrêt soudain de mon instance

**mamiberkof** · 19/07/2012, 13h21

Bonjour,

Il y a deux jours, l'instance sur une base oracle 8i s’arrête de façon inattendu, je n'ai pas modifier aucun parametre sur la base.

voici mon alert.log

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
 
Thu Jul 19 09:18:16 2012
Thread 1 advanced to log sequence 45480
  Current log# 3 seq# 45480 mem# 0: C:\ORACLE\ORADATA\BDOUJDA\REDO01.LOG
Thu Jul 19 09:21:20 2012
Thread 1 advanced to log sequence 45481
  Current log# 1 seq# 45481 mem# 0: C:\ORACLE\ORADATA\BDOUJDA\REDO03.LOG
Thu Jul 19 09:21:31 2012
Errors in file C:\oracle\admin\BDOUJDA\udump\bdoujdaP001.TRC:
ORA-00600: code erreur interne, arguments : [xtycsr3], [], [], [], [], [], [], []
 
Thu Jul 19 09:21:47 2012
Errors in file C:\oracle\admin\BDOUJDA\udump\bdoujdaP000.TRC:
ORA-00600: code erreur interne, arguments : [xtycsr3], [], [], [], [], [], [], []
 
Thu Jul 19 09:23:02 2012
Thread 1 advanced to log sequence 45482
  Current log# 2 seq# 45482 mem# 0: C:\ORACLE\ORADATA\BDOUJDA\REDO02.LOG
Thu Jul 19 09:23:21 2012
Errors in file C:\oracle\admin\BDOUJDA\udump\bdoujdaP001.TRC:
ORA-00600: code erreur interne, arguments : [xtycsr3], [], [], [], [], [], [], []
 
Thu Jul 19 09:23:23 2012
Errors in file C:\oracle\admin\BDOUJDA\udump\bdoujdaP000.TRC:
ORA-00600: code erreur interne, arguments : [xtycsr3], [], [], [], [], [], [], []
 
Thu Jul 19 09:25:02 2012
Thread 1 advanced to log sequence 45483
  Current log# 3 seq# 45483 mem# 0: C:\ORACLE\ORADATA\BDOUJDA\REDO01.LOG
Thu Jul 19 09:25:13 2012
Errors in file C:\oracle\admin\BDOUJDA\udump\bdoujdaP001.TRC:
ORA-00600: code erreur interne, arguments : [xtycsr3], [], [], [], [], [], [], []
 
Thu Jul 19 09:26:09 2012
Errors in file C:\oracle\admin\BDOUJDA\udump\bdoujdaP000.TRC:
ORA-00600: code erreur interne, arguments : [xtycsr3], [], [], [], [], [], [], []
 
Thu Jul 19 09:41:16 2012
Thread 1 advanced to log sequence 45484
  Current log# 1 seq# 45484 mem# 0: C:\ORACLE\ORADATA\BDOUJDA\REDO03.LOG
Thu Jul 19 10:20:56 2012
Thread 1 advanced to log sequence 45485
  Current log# 2 seq# 45485 mem# 0: C:\ORACLE\ORADATA\BDOUJDA\REDO02.LOG
Thu Jul 19 10:21:08 2012
Errors in file C:\oracle\admin\BDOUJDA\udump\bdoujdaP001.TRC:
ORA-00600: code erreur interne, arguments : [xtycsr3], [], [], [], [], [], [], []
 
Thu Jul 19 10:21:21 2012
Errors in file C:\oracle\admin\BDOUJDA\udump\bdoujdaP000.TRC:
ORA-00600: code erreur interne, arguments : [xtycsr3], [], [], [], [], [], [], []
 
Dump file C:\oracle\admin\BDOUJDA\bdump\bdoujdaALRT.LOG
Thu Jul 19 10:39:17 2012
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         = 52428800
  large_pool_size          = 614400
  java_pool_size           = 20971520
  control_files            = C:\oracle\oradata\BDOUJDA\control01.ctl, C:\oracle\oradata\BDOUJDA\control02.ctl, C:\oracle\oradata\BDOUJDA\control03.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             = FALSE
  distributed_transactions = 500
  instance_name            = BDOUJDA
  service_names            = BDOUJDA
  mts_dispatchers          = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
  open_links               = 4
  sort_area_size           = 65536
  sort_area_retained_size  = 65536
  db_name                  = BDOUJDA
  open_cursors             = 300
  os_authent_prefix        = 
  utl_file_dir             = c:\migr
  job_queue_processes      = 4
  job_queue_interval       = 10
  parallel_max_servers     = 5
  background_dump_dest     = C:\oracle\admin\BDOUJDA\bdump
  user_dump_dest           = C:\oracle\admin\BDOUJDA\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
Thu Jul 19 10:39:20 2012
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Jul 19 10:39:20 2012
alter database mount exclusive 
Thu Jul 19 10:39:27 2012
Successful mount of redo thread 1, with mount id 243426207.
Thu Jul 19 10:39:27 2012
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Thu Jul 19 10:39:27 2012
alter database open
Beginning crash recovery of 1 threads
Thu Jul 19 10:39:28 2012
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 1 Seq 45484 Reading mem 0
  Mem# 0 errs 0: C:\ORACLE\ORADATA\BDOUJDA\REDO03.LOG
Recovery of Online Redo Log: Thread 1 Group 2 Seq 45485 Reading mem 0
  Mem# 0 errs 0: C:\ORACLE\ORADATA\BDOUJDA\REDO02.LOG
Thu Jul 19 10:39:28 2012
Thread recovery: finish rolling forward thread 1
Thread recovery: 219 data blocks read, 205 data blocks written, 1843 redo blocks read
Crash recovery completed successfully
Thu Jul 19 10:39:29 2012
Thread 1 advanced to log sequence 45486
Thread 1 opened at log sequence 45486
  Current log# 3 seq# 45486 mem# 0: C:\ORACLE\ORADATA\BDOUJDA\REDO01.LOG
Successful open of redo thread 1.
Thu Jul 19 10:39:30 2012
SMON: enabling cache recovery
SMON: enabling tx recovery
Thu Jul 19 10:39:38 2012
Completed: alter database open
Thu Jul 19 11:03:26 2012
Thread 1 advanced to log sequence 45487
  Current log# 1 seq# 45487 mem# 0: C:\ORACLE\ORADATA\BDOUJDA\REDO03.LOG
Thu Jul 19 11:03:39 2012
Errors in file C:\oracle\admin\BDOUJDA\udump\bdoujdaP001.TRC:
ORA-00600: code erreur interne, arguments : [xtycsr3], [], [], [], [], [], [], []
 
Thu Jul 19 11:04:22 2012
Errors in file C:\oracle\admin\BDOUJDA\udump\bdoujdaP000.TRC:
ORA-00600: code erreur interne, arguments : [xtycsr3], [], [], [], [], [], [], []
 
Dump file C:\oracle\admin\BDOUJDA\bdump\bdoujdaALRT.LOG
Thu Jul 19 11:15:25 2012
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         = 52428800
  large_pool_size          = 614400
  java_pool_size           = 20971520
  control_files            = C:\oracle\oradata\BDOUJDA\control01.ctl, C:\oracle\oradata\BDOUJDA\control02.ctl, C:\oracle\oradata\BDOUJDA\control03.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             = FALSE
  distributed_transactions = 500
  instance_name            = BDOUJDA
  service_names            = BDOUJDA
  mts_dispatchers          = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
  open_links               = 4
  sort_area_size           = 65536
  sort_area_retained_size  = 65536
  db_name                  = BDOUJDA
  open_cursors             = 300
  os_authent_prefix        = 
  utl_file_dir             = c:\migr
  job_queue_processes      = 4
  job_queue_interval       = 10
  parallel_max_servers     = 5
  background_dump_dest     = C:\oracle\admin\BDOUJDA\bdump
  user_dump_dest           = C:\oracle\admin\BDOUJDA\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
Thu Jul 19 11:15:28 2012
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Jul 19 11:15:29 2012
alter database mount exclusive 
Thu Jul 19 11:15:35 2012
Successful mount of redo thread 1, with mount id 243443735.
Thu Jul 19 11:15:35 2012
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Thu Jul 19 11:15:35 2012
alter database open
Beginning crash recovery of 1 threads
Thu Jul 19 11:15:36 2012
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 3 Seq 45486 Reading mem 0
  Mem# 0 errs 0: C:\ORACLE\ORADATA\BDOUJDA\REDO01.LOG
Recovery of Online Redo Log: Thread 1 Group 1 Seq 45487 Reading mem 0
  Mem# 0 errs 0: C:\ORACLE\ORADATA\BDOUJDA\REDO03.LOG
Thu Jul 19 11:15:37 2012
Thread recovery: finish rolling forward thread 1
Thread recovery: 249 data blocks read, 229 data blocks written, 1841 redo blocks read
Crash recovery completed successfully
Thu Jul 19 11:15:37 2012
Thread 1 advanced to log sequence 45488
Thread 1 opened at log sequence 45488
  Current log# 2 seq# 45488 mem# 0: C:\ORACLE\ORADATA\BDOUJDA\REDO02.LOG
Successful open of redo thread 1.
Thu Jul 19 11:15:38 2012
SMON: enabling cache recovery
SMON: enabling tx recovery
Thu Jul 19 11:15:45 2012
Completed: alter database open
Thu Jul 19 11:20:48 2012
Thread 1 advanced to log sequence 45489
  Current log# 3 seq# 45489 mem# 0: C:\ORACLE\ORADATA\BDOUJDA\REDO01.LOG
Thu Jul 19 11:20:54 2012
Errors in file C:\oracle\admin\BDOUJDA\udump\bdoujdaP001.TRC:
ORA-00600: code erreur interne, arguments : [xtycsr3], [], [], [], [], [], [], []
 
Thu Jul 19 11:21:07 2012
Errors in file C:\oracle\admin\BDOUJDA\udump\bdoujdaP000.TRC:
ORA-00600: code erreur interne, arguments : [xtycsr3], [], [], [], [], [], [], []
 
Dump file C:\oracle\admin\BDOUJDA\bdump\bdoujdaALRT.LOG
Thu Jul 19 11:22:38 2012
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         = 52428800
  large_pool_size          = 614400
  java_pool_size           = 20971520
  control_files            = C:\oracle\oradata\BDOUJDA\control01.ctl, C:\oracle\oradata\BDOUJDA\control02.ctl, C:\oracle\oradata\BDOUJDA\control03.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             = FALSE
  distributed_transactions = 500
  instance_name            = BDOUJDA
  service_names            = BDOUJDA
  mts_dispatchers          = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
  open_links               = 4
  sort_area_size           = 65536
  sort_area_retained_size  = 65536
  db_name                  = BDOUJDA
  open_cursors             = 300
  os_authent_prefix        = 
  utl_file_dir             = c:\migr
  job_queue_processes      = 4
  job_queue_interval       = 10
  parallel_max_servers     = 5
  background_dump_dest     = C:\oracle\admin\BDOUJDA\bdump
  user_dump_dest           = C:\oracle\admin\BDOUJDA\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
Thu Jul 19 11:22:41 2012
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Jul 19 11:22:42 2012
alter database mount exclusive 
Thu Jul 19 11:22:48 2012
Successful mount of redo thread 1, with mount id 243432392.
Thu Jul 19 11:22:48 2012
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Thu Jul 19 11:22:48 2012
alter database open
Beginning crash recovery of 1 threads
Thu Jul 19 11:22:49 2012
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 2 Seq 45488 Reading mem 0
  Mem# 0 errs 0: C:\ORACLE\ORADATA\BDOUJDA\REDO02.LOG
Recovery of Online Redo Log: Thread 1 Group 3 Seq 45489 Reading mem 0
  Mem# 0 errs 0: C:\ORACLE\ORADATA\BDOUJDA\REDO01.LOG
Thu Jul 19 11:22:49 2012
Thread recovery: finish rolling forward thread 1
Thread recovery: 228 data blocks read, 216 data blocks written, 1845 redo blocks read
Crash recovery completed successfully
Thu Jul 19 11:22:50 2012
Thread 1 advanced to log sequence 45490
Thread 1 opened at log sequence 45490
  Current log# 1 seq# 45490 mem# 0: C:\ORACLE\ORADATA\BDOUJDA\REDO03.LOG
Successful open of redo thread 1.
Thu Jul 19 11:22:50 2012
SMON: enabling cache recovery
SMON: enabling tx recovery
Thu Jul 19 11:22:58 2012
Completed: alter database open
Thu Jul 19 11:37:10 2012
Thread 1 advanced to log sequence 45491
  Current log# 2 seq# 45491 mem# 0: C:\ORACLE\ORADATA\BDOUJDA\REDO02.LOG
Thu Jul 19 11:40:19 2012
Thread 1 advanced to log sequence 45492
  Current log# 3 seq# 45492 mem# 0: C:\ORACLE\ORADATA\BDOUJDA\REDO01.LOG

**olivanto** · 20/07/2012, 11h47

pas beaucoup d'information en effet.

à part l'ORA-600 ....

**mamiberkof** · 20/07/2012, 12h07

J'ai ouvert le fichier bdoujdaP001.trc là ou mentionne l'erreur, à la fin de ce fichier , il est écrit
*****Trace File Full ****
*****Trace File Full ****
*****Trace File Full ****

est ce que l'arret de la base vient du faite que le fichier est pleine ?