powered by simpleCommunicator - 2.0.61     © 2026 Programmizd 02
Целевая тема:
Создать новую тему:
Автор:
Закрыть
Цитировать
Форумы / Oracle [игнор отключен] [закрыт для гостей] / Crush базы после запуска вот логи...
10 сообщений из 10, страница 1 из 1
Crush базы после запуска вот логи...
    #39505152
Nesquick1212
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
Помогите плиз, происходит краш базы сразу после запуска .
Код: plsql
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.
15:55:31 2017
Errors in file /u01/app/oracle/diag/rdbms/hpsm/hpsm/trace/hpsm_smon_4438.trc  (incident=109786):
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Block recovery from logseq 177443, block 282 to scn 3211656211
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.287.16, scn 0.3211656215
Block recovery from logseq 177443, block 282 to scn 3211656282
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.340.16, scn 0.3211656283
Non-fatal internal error happenned while SMON was doing flushing of monitored table stats.
SMON encountered 53 out of maximum 100 non-fatal internal errors.
Mon Aug 14 15:55:41 2017
Errors in file /u01/app/oracle/diag/rdbms/hpsm/hpsm/trace/hpsm_smon_4438.trc  (incident=109787):
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Block recovery from logseq 177443, block 269 to scn 3211656191
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.271.16, scn 0.3211656195
Block recovery from logseq 177443, block 269 to scn 3211656285
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.342.16, scn 0.3211656286
Non-fatal internal error happenned while SMON was doing flushing of monitored table stats.
SMON encountered 54 out of maximum 100 non-fatal internal errors.
Mon Aug 14 15:55:52 2017
Errors in file /u01/app/oracle/diag/rdbms/hpsm/hpsm/trace/hpsm_smon_4438.trc  (incident=109788):
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Block recovery from logseq 177443, block 287 to scn 3211656215
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.289.16, scn 0.3211656218
Block recovery from logseq 177443, block 287 to scn 3211656295
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.351.16, scn 0.3211656296
Non-fatal internal error happenned while SMON was doing flushing of monitored table stats.
SMON encountered 55 out of maximum 100 non-fatal internal errors.
Mon Aug 14 15:56:02 2017
Errors in file /u01/app/oracle/diag/rdbms/hpsm/hpsm/trace/hpsm_smon_4438.trc  (incident=109789):
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Block recovery from logseq 177443, block 265 to scn 3211656188
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.268.16, scn 0.3211656190
Block recovery from logseq 177443, block 265 to scn 3211656299
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.353.16, scn 0.3211656300
Non-fatal internal error happenned while SMON was doing flushing of monitored table stats.
SMON encountered 56 out of maximum 100 non-fatal internal errors.
Mon Aug 14 15:56:12 2017
Errors in file /u01/app/oracle/diag/rdbms/hpsm/hpsm/trace/hpsm_smon_4438.trc  (incident=109790):
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Block recovery from logseq 177443, block 269 to scn 3211656191
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.271.16, scn 0.3211656195
Block recovery from logseq 177443, block 269 to scn 3211656304
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.356.16, scn 0.3211656305
Non-fatal internal error happenned while SMON was doing flushing of monitored table stats.
SMON encountered 57 out of maximum 100 non-fatal internal errors.
Mon Aug 14 15:56:22 2017
Errors in file /u01/app/oracle/diag/rdbms/hpsm/hpsm/trace/hpsm_smon_4438.trc  (incident=109791):
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Block recovery from logseq 177443, block 287 to scn 3211656215
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.289.16, scn 0.3211656218
Block recovery from logseq 177443, block 287 to scn 3211656310
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.359.16, scn 0.3211656311
Non-fatal internal error happenned while SMON was doing flushing of monitored table stats.
SMON encountered 58 out of maximum 100 non-fatal internal errors.
Mon Aug 14 15:56:32 2017
Errors in file /u01/app/oracle/diag/rdbms/hpsm/hpsm/trace/hpsm_smon_4438.trc  (incident=109792):
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Block recovery from logseq 177443, block 282 to scn 3211656211
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.287.16, scn 0.3211656215
Block recovery from logseq 177443, block 282 to scn 3211656315
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.362.16, scn 0.3211656316
Non-fatal internal error happenned while SMON was doing flushing of monitored table stats.
SMON encountered 59 out of maximum 100 non-fatal internal errors.
Mon Aug 14 15:56:42 2017
Errors in file /u01/app/oracle/diag/rdbms/hpsm/hpsm/trace/hpsm_smon_4438.trc  (incident=109793):
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Block recovery from logseq 177443, block 276 to scn 3211656203
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.280.16, scn 0.3211656206
Block recovery from logseq 177443, block 276 to scn 3211656318
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.364.16, scn 0.3211656319
Non-fatal internal error happenned while SMON was doing flushing of monitored table stats.
SMON encountered 60 out of maximum 100 non-fatal internal errors.
Mon Aug 14 15:56:53 2017
Errors in file /u01/app/oracle/diag/rdbms/hpsm/hpsm/trace/hpsm_smon_4438.trc  (incident=109794):
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Block recovery from logseq 177443, block 287 to scn 3211656215
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.289.16, scn 0.3211656218
Block recovery from logseq 177443, block 287 to scn 3211656327
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.371.16, scn 0.3211656328
Non-fatal internal error happenned while SMON was doing flushing of monitored table stats.
SMON encountered 61 out of maximum 100 non-fatal internal errors.
Mon Aug 14 15:57:03 2017
Errors in file /u01/app/oracle/diag/rdbms/hpsm/hpsm/trace/hpsm_smon_4438.trc  (incident=109795):
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Block recovery from logseq 177443, block 265 to scn 3211656188
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.268.16, scn 0.3211656190
Block recovery from logseq 177443, block 265 to scn 3211656334
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.372.16, scn 0.3211656335
Non-fatal internal error happenned while SMON was doing flushing of monitored table stats.
SMON encountered 62 out of maximum 100 non-fatal internal errors.
Mon Aug 14 15:57:13 2017
Errors in file /u01/app/oracle/diag/rdbms/hpsm/hpsm/trace/hpsm_smon_4438.trc  (incident=109796):
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Block recovery from logseq 177443, block 282 to scn 3211656211
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.287.16, scn 0.3211656215
Block recovery from logseq 177443, block 282 to scn 3211656338
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.373.16, scn 0.3211656339
Non-fatal internal error happenned while SMON was doing flushing of monitored table stats.
SMON encountered 63 out of maximum 100 non-fatal internal errors.
Mon Aug 14 16:02:23 2017
Errors in file /u01/app/oracle/diag/rdbms/hpsm/hpsm/trace/hpsm_smon_4438.trc  (incident=109797):
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Block recovery from logseq 177443, block 392 to scn 3211656455
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.398.16, scn 0.3211656456
Block recovery from logseq 177443, block 392 to scn 3211656455
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.398.16, scn 0.3211656456
Non-fatal internal error happenned while SMON was doing logging scn->time mapping.
SMON encountered 64 out of maximum 100 non-fatal internal errors.
Mon Aug 14 16:07:24 2017
Errors in file /u01/app/oracle/diag/rdbms/hpsm/hpsm/trace/hpsm_smon_4438.trc  (incident=109798):
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Block recovery from logseq 177443, block 399 to scn 3211656564
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.403.16, scn 0.3211656565
Block recovery from logseq 177443, block 399 to scn 3211656564
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.403.16, scn 0.3211656565
Non-fatal internal error happenned while SMON was doing logging scn->time mapping.
SMON encountered 65 out of maximum 100 non-fatal internal errors.
Mon Aug 14 16:12:26 2017
Errors in file /u01/app/oracle/diag/rdbms/hpsm/hpsm/trace/hpsm_smon_4438.trc  (incident=109799):
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Block recovery from logseq 177443, block 404 to scn 3211656672
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.439.16, scn 0.3211656673
Block recovery from logseq 177443, block 404 to scn 3211656672
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.439.16, scn 0.3211656673
Non-fatal internal error happenned while SMON was doing flushing of monitored table stats.
SMON encountered 66 out of maximum 100 non-fatal internal errors.
Errors in file /u01/app/oracle/diag/rdbms/hpsm/hpsm/trace/hpsm_smon_4438.trc  (incident=109800):
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Block recovery from logseq 177443, block 439 to scn 3211656674
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.440.16, scn 0.3211656675
Block recovery from logseq 177443, block 439 to scn 3211656674
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.440.16, scn 0.3211656675
Non-fatal internal error happenned while SMON was doing flushing of monitored table stats.
SMON encountered 67 out of maximum 100 non-fatal internal errors.
Errors in file /u01/app/oracle/diag/rdbms/hpsm/hpsm/trace/hpsm_smon_4438.trc  (incident=109801):
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Block recovery from logseq 177443, block 399 to scn 3211656564
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.403.16, scn 0.3211656566
Block recovery from logseq 177443, block 399 to scn 3211656675
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.441.16, scn 0.3211656676
Non-fatal internal error happenned while SMON was doing flushing of monitored table stats.
SMON encountered 68 out of maximum 100 non-fatal internal errors.
Errors in file /u01/app/oracle/diag/rdbms/hpsm/hpsm/trace/hpsm_smon_4438.trc  (incident=109802):
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Block recovery from logseq 177443, block 441 to scn 3211656676
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.443.16, scn 0.3211656677
Block recovery from logseq 177443, block 441 to scn 3211656676
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.443.16, scn 0.3211656677
Non-fatal internal error happenned while SMON was doing flushing of monitored table stats.
SMON encountered 69 out of maximum 100 non-fatal internal errors.
Errors in file /u01/app/oracle/diag/rdbms/hpsm/hpsm/trace/hpsm_smon_4438.trc  (incident=109803):
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Block recovery from logseq 177443, block 404 to scn 3211656672
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.439.16, scn 0.3211656674
Block recovery from logseq 177443, block 404 to scn 3211656682
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.449.16, scn 0.3211656683
Non-fatal internal error happenned while SMON was doing flushing of monitored table stats.
SMON encountered 70 out of maximum 100 non-fatal internal errors.
Mon Aug 14 16:12:41 2017
Errors in file /u01/app/oracle/diag/rdbms/hpsm/hpsm/trace/hpsm_smon_4438.trc  (incident=109804):
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Block recovery from logseq 177443, block 439 to scn 3211656674
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.440.16, scn 0.3211656675
Block recovery from logseq 177443, block 439 to scn 3211656686
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.450.16, scn 0.3211656687
Non-fatal internal error happenned while SMON was doing flushing of monitored table stats.
SMON encountered 71 out of maximum 100 non-fatal internal errors.
Mon Aug 14 16:12:51 2017
Errors in file /u01/app/oracle/diag/rdbms/hpsm/hpsm/trace/hpsm_smon_4438.trc  (incident=109805):
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Block recovery from logseq 177443, block 453 to scn 3211656693
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.458.16, scn 0.3211656694
Block recovery from logseq 177443, block 453 to scn 3211656693
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.458.16, scn 0.3211656694
Non-fatal internal error happenned while SMON was doing flushing of monitored table stats.
SMON encountered 72 out of maximum 100 non-fatal internal errors.
Mon Aug 14 16:13:01 2017
Errors in file /u01/app/oracle/diag/rdbms/hpsm/hpsm/trace/hpsm_smon_4438.trc  (incident=109806):
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Block recovery from logseq 177443, block 441 to scn 3211656676
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.443.16, scn 0.3211656677
Block recovery from logseq 177443, block 441 to scn 3211656698
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.461.16, scn 0.3211656699
Non-fatal internal error happenned while SMON was doing flushing of monitored table stats.
SMON encountered 73 out of maximum 100 non-fatal internal errors.
Mon Aug 14 16:18:11 2017
Errors in file /u01/app/oracle/diag/rdbms/hpsm/hpsm/trace/hpsm_smon_4438.trc  (incident=109807):
ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Block recovery from logseq 177443, block 471 to scn 3211656802
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.475.16, scn 0.3211656803
Block recovery from logseq 177443, block 471 to scn 3211656802
Recovery of Online Redo Log: Thread 1 Group 3 Seq 177443 Reading mem 0
  Mem# 0: /oradata1/hpsm/redo03.log
Block recovery completed at rba 177443.475.16, scn 0.3211656803
Non-fatal internal error happenned while SMON was doing logging scn->time mapping.
SMON encountered 74 out of maximum 100 non-fatal internal errors.
...
Рейтинг: 0 / 0
Crush базы после запуска вот логи...
    #39505161
Фотография env
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
Nesquick1212,

ORA-00600 - прямой путь в поддержку.

Errors in file /u01/app/oracle/diag/rdbms/hpsm/hpsm/trace/hpsm_smon_4438.trc
И что же в нём?
...
Рейтинг: 0 / 0
Crush базы после запуска вот логи...
    #39505315
flexgen
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
Nesquick1212,

Вот здесь описано что это и как попытаться решить проблему - Step by step to resolve ORA-600 4194 4193 4197 on database crash
...
Рейтинг: 0 / 0
Crush базы после запуска вот логи...
    #39505364
Nesquick1212
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
Спасибо, буду пробывать
...
Рейтинг: 0 / 0
Crush базы после запуска вот логи...
    #39505378
Фотография env
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
Nesquick1212,

Отпишитесь потом по факту, помогло ли это решить Ваш вопрос.
...
Рейтинг: 0 / 0
Crush базы после запуска вот логи...
    #39505396
SAS2014
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
у меня примерно так же было база не запускалась, пришлось пересоздать spfile
...
Рейтинг: 0 / 0
Crush базы после запуска вот логи...
    #39505397
SAS2014
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
там я с параметрами намудрил (память, SGA, PGA)
...
Рейтинг: 0 / 0
Crush базы после запуска вот логи...
    #39506344
Фотография Aliona
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
Nesquick1212Спасибо, буду пробывать

если удасться запустить БД с параметром
event='10513 trace name context forever, level 2'

То лучше сделать её дамп экспортом или expdp и пересоздать базу (создать новую пустую БД и залить в неё дамп)
Это будет надёжнее.
...
Рейтинг: 0 / 0
Crush базы после запуска вот логи...
    #39506612
SAS2014
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
ага если в базе не крутится ни каких джобов, процедур и прочее в схемах system, sys, а то после пересоздания баз их придется создавать заново

тогда лучше сделать их бэкап т.е. код сохранить в файле
...
Рейтинг: 0 / 0
Crush базы после запуска вот логи...
    #39506614
SAS2014
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
да и настройки, параметры тоже желательно сохранить (размер выделенной памяти и прочее)
...
Рейтинг: 0 / 0
10 сообщений из 10, страница 1 из 1
Форумы / Oracle [игнор отключен] [закрыт для гостей] / Crush базы после запуска вот логи...
Найденые пользователи ...
Разблокировать пользователей ...
Читали форум (0):
Пользователи онлайн (0):
x
x
Закрыть


Просмотр
0 / 0
Close
Debug Console [Select Text]