01,问题描述
心血来潮想看一下启动数据库的alert log.然后把数据库给关闭了,同时也在监听日志文件
下面可谓是详细的描述了整个关机过程,也看到了无数的error
1 [root@node1 ~]# tail -F /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/alert_oracle1.log
2 Wed Mar 27 02:00:00 2019
3 Closing scheduler window
4 Closing Resource Manager plan via scheduler window
5 Clearing Resource Manager plan via parameter
6 Wed Mar 27 10:05:35 2019
7 OS Pid: 2355 executed alter system set events 'trace[GCS_BSCN] disk=low'
8 Wed Mar 27 11:26:07 2019
9 ALTER SYSTEM SET _gc_policy_minimum=100 SCOPE=BOTH;
10 Wed Mar 27 11:26:41 2019
11 ALTER SYSTEM SET _gc_policy_time=4 SCOPE=SPFILE;
12 Wed Mar 27 13:43:19 2019
13 Shutting down instance (immediate)
14 Stopping background process SMCO
15 Shutting down instance: further logons disabled
16 Stopping background process QMNC
17 Wed Mar 27 13:43:19 2019
18 Stopping background process CJQ0
19 Stopping background process MMNL
20 Stopping background process MMON
21 License high water mark = 10
22 All dispatchers and shared servers shutdown
23 ALTER DATABASE CLOSE NORMAL
24 Wed Mar 27 13:43:24 2019
25 SMON: disabling tx recovery
26 Stopping background process RCBG
27 SMON: disabling cache recovery
28 Wed Mar 27 13:43:28 2019
29 NOTE: Deferred communication with ASM instance
30 NOTE: deferred map free for map id 15
31
32
33 ***********************************************************************
34
35 Fatal NI connect error 12547, connecting to:
36 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_lgwr_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle@node1)(HOST=node1)(USER=oracle))))
37
38 VERSION INFORMATION:
39 TNS for Linux: Version 11.2.0.4.0 - Production
40 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
41 Time: 27-MAR-2019 13:43:28
42 Tracing not turned on.
43 Tns error struct:
44 ns main err code: 12547
45
46 TNS-12547: TNS:lost contact
47 ns secondary err code: 12560
48 nt main err code: 517
49
50 TNS-00517: Lost contact
51 nt secondary err code: 32
52 nt OS err code: 0
53 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_lgwr_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
54 WARNING: ASM communication error: op 0 state 0x0 (15055)
55 ERROR: direct connection failure with ASM
56 NOTE: Deferred communication with ASM instance
57 Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_lgwr_4291.trc:
58 ORA-15055: unable to connect to ASM instance
59 ORA-12547: TNS:lost contact
60 NOTE: deferred map free for map id 16
61
62
63 ***********************************************************************
64
65 Fatal NI connect error 12547, connecting to:
66 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_lgwr_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle))))
67
68 VERSION INFORMATION:
69 TNS for Linux: Version 11.2.0.4.0 - Production
70 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
71 Time: 27-MAR-2019 13:43:28
72 Tracing not turned on.
73 Tns error struct:
74 ns main err code: 12547
75
76 TNS-12547: TNS:lost contact
77 ns secondary err code: 12560
78 nt main err code: 517
79
80 TNS-00517: Lost contact
81 nt secondary err code: 32
82 nt OS err code: 0
83 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_lgwr_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
84 WARNING: ASM communication error: op 0 state 0x0 (15055)
85 ERROR: direct connection failure with ASM
86 NOTE: Deferred communication with ASM instance
87 Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_lgwr_4291.trc:
88 ORA-15055: unable to connect to ASM instance
89 ORA-12547: TNS:lost contact
90 NOTE: deferred map free for map id 17
91
92
93 ***********************************************************************
94
95 Fatal NI connect error 12547, connecting to:
96 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_lgwr_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle))))
97
98 VERSION INFORMATION:
99 TNS for Linux: Version 11.2.0.4.0 - Production
100 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
101 Time: 27-MAR-2019 13:43:28
102 Tracing not turned on.
103 Tns error struct:
104 ns main err code: 12547
105
106 TNS-12547: TNS:lost contact
107 ns secondary err code: 12560
108 nt main err code: 517
109
110 TNS-00517: Lost contact
111 nt secondary err code: 32
112 nt OS err code: 0
113 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_lgwr_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
114 WARNING: ASM communication error: op 0 state 0x0 (15055)
115 ERROR: direct connection failure with ASM
116 NOTE: Deferred communication with ASM instance
117 Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_lgwr_4291.trc:
118 ORA-15055: unable to connect to ASM instance
119 ORA-12547: TNS:lost contact
120 NOTE: deferred map free for map id 18
121 Shutting down archive processes
122 Archiving is disabled
123 Archive process shutdown avoided: 0 active
124 Thread 1 closed at log sequence 69
125 Successful close of redo thread 1
126 Wed Mar 27 13:43:28 2019
127 NOTE: Deferred communication with ASM instance
128 NOTE: deferred map free for map id 4
129
130
131 ***********************************************************************
132
133 Fatal NI connect error 12547, connecting to:
134 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_dbw0_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle@node1)(HOST=node1)(USER=oracle))))
135
136 VERSION INFORMATION:
137 TNS for Linux: Version 11.2.0.4.0 - Production
138 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
139 Time: 27-MAR-2019 13:43:28
140 Tracing not turned on.
141 Tns error struct:
142 ns main err code: 12547
143
144 TNS-12547: TNS:lost contact
145 ns secondary err code: 12560
146 nt main err code: 517
147
148 TNS-00517: Lost contact
149 nt secondary err code: 32
150 nt OS err code: 0
151 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_dbw0_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
152 WARNING: ASM communication error: op 0 state 0x0 (15055)
153 ERROR: direct connection failure with ASM
154 NOTE: Deferred communication with ASM instance
155 Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_dbw0_4289.trc:
156 ORA-15055: unable to connect to ASM instance
157 ORA-12547: TNS:lost contact
158 NOTE: deferred map free for map id 5
159
160
161 ***********************************************************************
162
163 Fatal NI connect error 12547, connecting to:
164 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_dbw0_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle))))
165
166 VERSION INFORMATION:
167 TNS for Linux: Version 11.2.0.4.0 - Production
168 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
169 Time: 27-MAR-2019 13:43:28
170 Tracing not turned on.
171 Tns error struct:
172 ns main err code: 12547
173
174 TNS-12547: TNS:lost contact
175 ns secondary err code: 12560
176 nt main err code: 517
177
178 TNS-00517: Lost contact
179 nt secondary err code: 32
180 nt OS err code: 0
181 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_dbw0_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
182 WARNING: ASM communication error: op 0 state 0x0 (15055)
183 ERROR: direct connection failure with ASM
184 NOTE: Deferred communication with ASM instance
185 Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_dbw0_4289.trc:
186 ORA-15055: unable to connect to ASM instance
187 ORA-12547: TNS:lost contact
188 NOTE: deferred map free for map id 6
189
190
191 ***********************************************************************
192
193 Fatal NI connect error 12547, connecting to:
194 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_dbw0_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle))))
195
196 VERSION INFORMATION:
197 TNS for Linux: Version 11.2.0.4.0 - Production
198 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
199 Time: 27-MAR-2019 13:43:28
200 Tracing not turned on.
201 Tns error struct:
202 ns main err code: 12547
203
204 TNS-12547: TNS:lost contact
205 ns secondary err code: 12560
206 nt main err code: 517
207
208 TNS-00517: Lost contact
209 nt secondary err code: 32
210 nt OS err code: 0
211 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_dbw0_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
212 WARNING: ASM communication error: op 0 state 0x0 (15055)
213 ERROR: direct connection failure with ASM
214 NOTE: Deferred communication with ASM instance
215 Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_dbw0_4289.trc:
216 ORA-15055: unable to connect to ASM instance
217 ORA-12547: TNS:lost contact
218 NOTE: deferred map free for map id 7
219
220
221 ***********************************************************************
222
223 Fatal NI connect error 12547, connecting to:
224 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_dbw0_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle))))
225
226 VERSION INFORMATION:
227 TNS for Linux: Version 11.2.0.4.0 - Production
228 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
229 Time: 27-MAR-2019 13:43:29
230 Tracing not turned on.
231 Tns error struct:
232 ns main err code: 12547
233
234 TNS-12547: TNS:lost contact
235 ns secondary err code: 12560
236 nt main err code: 517
237
238 TNS-00517: Lost contact
239 nt secondary err code: 32
240 nt OS err code: 0
241 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_dbw0_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
242 WARNING: ASM communication error: op 0 state 0x0 (15055)
243 ERROR: direct connection failure with ASM
244 NOTE: Deferred communication with ASM instance
245 Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_dbw0_4289.trc:
246 ORA-15055: unable to connect to ASM instance
247 ORA-12547: TNS:lost contact
248 NOTE: deferred map free for map id 8
249 Wed Mar 27 13:43:29 2019
250 Completed: ALTER DATABASE CLOSE NORMAL
251 ALTER DATABASE DISMOUNT
252 Shutting down archive processes
253 Archiving is disabled
254 Wed Mar 27 13:43:29 2019
255 NOTE: Deferred communication with ASM instance
256 NOTE: deferred map free for map id 2
257
258
259 ***********************************************************************
260
261 Fatal NI connect error 12547, connecting to:
262 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_ckpt_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle@node1)(HOST=node1)(USER=oracle))))
263
264 VERSION INFORMATION:
265 TNS for Linux: Version 11.2.0.4.0 - Production
266 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
267 Time: 27-MAR-2019 13:43:29
268 Tracing not turned on.
269 Tns error struct:
270 ns main err code: 12547
271
272 TNS-12547: TNS:lost contact
273 ns secondary err code: 12560
274 nt main err code: 517
275
276 TNS-00517: Lost contact
277 nt secondary err code: 32
278 nt OS err code: 0
279 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_ckpt_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
280 WARNING: ASM communication error: op 0 state 0x0 (15055)
281 ERROR: direct connection failure with ASM
282 NOTE: Deferred communication with ASM instance
283 Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_ckpt_4293.trc:
284 ORA-15055: unable to connect to ASM instance
285 ORA-12547: TNS:lost contact
286 NOTE: deferred map free for map id 3
287 Completed: ALTER DATABASE DISMOUNT
288 Wed Mar 27 13:43:29 2019
289 NOTE: Deferred communication with ASM instance
290
291
292 ***********************************************************************
293
294 Fatal NI connect error 12547, connecting to:
295 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle@node1)(HOST=node1)(USER=oracle))))
296
297 VERSION INFORMATION:
298 TNS for Linux: Version 11.2.0.4.0 - Production
299 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
300 TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
301 Time: 27-MAR-2019 13:43:30
302 Tracing not turned on.
303 Tns error struct:
304 ns main err code: 12547
305
306 TNS-12547: TNS:lost contact
307 ns secondary err code: 12560
308 nt main err code: 517
309
310 TNS-00517: Lost contact
311 nt secondary err code: 32
312 nt OS err code: 0
313 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
314 WARNING: ASM communication error: op 0 state 0x0 (15055)
315 ERROR: direct connection failure with ASM
316 NOTE: Deferred communication with ASM instance
317 Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
318 ORA-15055: unable to connect to ASM instance
319 ORA-12547: TNS:lost contact
320
321
322 ***********************************************************************
323
324 Fatal NI connect error 12547, connecting to:
325 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle))))
326
327 VERSION INFORMATION:
328 TNS for Linux: Version 11.2.0.4.0 - Production
329 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
330 TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
331 Time: 27-MAR-2019 13:43:30
332 Tracing not turned on.
333 Tns error struct:
334 ns main err code: 12547
335
336 TNS-12547: TNS:lost contact
337 ns secondary err code: 12560
338 nt main err code: 517
339
340 TNS-00517: Lost contact
341 nt secondary err code: 32
342 nt OS err code: 0
343 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
344 WARNING: ASM communication error: op 0 state 0x0 (15055)
345 ERROR: direct connection failure with ASM
346 NOTE: Deferred communication with ASM instance
347 Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
348 ORA-15055: unable to connect to ASM instance
349 ORA-12547: TNS:lost contact
350
351
352 ***********************************************************************
353
354 Fatal NI connect error 12547, connecting to:
355 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle))))
356
357 VERSION INFORMATION:
358 TNS for Linux: Version 11.2.0.4.0 - Production
359 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
360 TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
361 Time: 27-MAR-2019 13:43:30
362 Tracing not turned on.
363 Tns error struct:
364 ns main err code: 12547
365
366 TNS-12547: TNS:lost contact
367 ns secondary err code: 12560
368 nt main err code: 517
369
370 TNS-00517: Lost contact
371 nt secondary err code: 32
372 nt OS err code: 0
373 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
374 WARNING: ASM communication error: op 0 state 0x0 (15055)
375 ERROR: direct connection failure with ASM
376 NOTE: Deferred communication with ASM instance
377 Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
378 ORA-15055: unable to connect to ASM instance
379 ORA-12547: TNS:lost contact
380
381
382 ***********************************************************************
383
384 Fatal NI connect error 12547, connecting to:
385 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle))))
386
387 VERSION INFORMATION:
388 TNS for Linux: Version 11.2.0.4.0 - Production
389 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
390 TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
391 Time: 27-MAR-2019 13:43:30
392 Tracing not turned on.
393 Tns error struct:
394 ns main err code: 12547
395
396 TNS-12547: TNS:lost contact
397 ns secondary err code: 12560
398 nt main err code: 517
399
400 TNS-00517: Lost contact
401 nt secondary err code: 32
402 nt OS err code: 0
403 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
404 WARNING: ASM communication error: op 0 state 0x0 (15055)
405 ERROR: direct connection failure with ASM
406 NOTE: Deferred communication with ASM instance
407 Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
408 ORA-15055: unable to connect to ASM instance
409 ORA-12547: TNS:lost contact
410
411
412 ***********************************************************************
413
414 Fatal NI connect error 12547, connecting to:
415 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle))))
416
417 VERSION INFORMATION:
418 TNS for Linux: Version 11.2.0.4.0 - Production
419 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
420 TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
421 Time: 27-MAR-2019 13:43:30
422 Tracing not turned on.
423 Tns error struct:
424 ns main err code: 12547
425
426 TNS-12547: TNS:lost contact
427 ns secondary err code: 12560
428 nt main err code: 517
429
430 TNS-00517: Lost contact
431 nt secondary err code: 32
432 nt OS err code: 0
433 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
434 WARNING: ASM communication error: op 0 state 0x0 (15055)
435 ERROR: direct connection failure with ASM
436 NOTE: Deferred communication with ASM instance
437 Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
438 ORA-15055: unable to connect to ASM instance
439 ORA-12547: TNS:lost contact
440
441
442 ***********************************************************************
443
444 Fatal NI connect error 12547, connecting to:
445 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle))))
446
447 VERSION INFORMATION:
448 TNS for Linux: Version 11.2.0.4.0 - Production
449 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
450 TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
451 Time: 27-MAR-2019 13:43:30
452 Tracing not turned on.
453 Tns error struct:
454 ns main err code: 12547
455
456 TNS-12547: TNS:lost contact
457 ns secondary err code: 12560
458 nt main err code: 517
459
460 TNS-00517: Lost contact
461 nt secondary err code: 32
462 nt OS err code: 0
463 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
464 WARNING: ASM communication error: op 0 state 0x0 (15055)
465 ERROR: direct connection failure with ASM
466 NOTE: Deferred communication with ASM instance
467 Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
468 ORA-15055: unable to connect to ASM instance
469 ORA-12547: TNS:lost contact
470
471
472 ***********************************************************************
473
474 Fatal NI connect error 12547, connecting to:
475 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle))))
476
477 VERSION INFORMATION:
478 TNS for Linux: Version 11.2.0.4.0 - Production
479 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
480 TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
481 Time: 27-MAR-2019 13:43:30
482 Tracing not turned on.
483 Tns error struct:
484 ns main err code: 12547
485
486 TNS-12547: TNS:lost contact
487 ns secondary err code: 12560
488 nt main err code: 517
489
490 TNS-00517: Lost contact
491 nt secondary err code: 32
492 nt OS err code: 0
493 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
494 WARNING: ASM communication error: op 0 state 0x0 (15055)
495 ERROR: direct connection failure with ASM
496 NOTE: Deferred communication with ASM instance
497 Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
498 ORA-15055: unable to connect to ASM instance
499 ORA-12547: TNS:lost contact
500
501
502 ***********************************************************************
503
504 Fatal NI connect error 12547, connecting to:
505 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle))))
506
507 VERSION INFORMATION:
508 TNS for Linux: Version 11.2.0.4.0 - Production
509 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
510 TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
511 Time: 27-MAR-2019 13:43:30
512 Tracing not turned on.
513 Tns error struct:
514 ns main err code: 12547
515
516 TNS-12547: TNS:lost contact
517 ns secondary err code: 12560
518 nt main err code: 517
519
520 TNS-00517: Lost contact
521 nt secondary err code: 32
522 nt OS err code: 0
523 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
524 WARNING: ASM communication error: op 0 state 0x0 (15055)
525 ERROR: direct connection failure with ASM
526 NOTE: Deferred communication with ASM instance
527 Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
528 ORA-15055: unable to connect to ASM instance
529 ORA-12547: TNS:lost contact
530
531
532 ***********************************************************************
533
534 Fatal NI connect error 12547, connecting to:
535 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle))))
536
537 VERSION INFORMATION:
538 TNS for Linux: Version 11.2.0.4.0 - Production
539 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
540 TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
541 Time: 27-MAR-2019 13:43:31
542 Tracing not turned on.
543 Tns error struct:
544 ns main err code: 12547
545
546 TNS-12547: TNS:lost contact
547 ns secondary err code: 12560
548 nt main err code: 517
549
550 TNS-00517: Lost contact
551 nt secondary err code: 32
552 nt OS err code: 0
553 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
554 WARNING: ASM communication error: op 0 state 0x0 (15055)
555 ERROR: direct connection failure with ASM
556 NOTE: Deferred communication with ASM instance
557 Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
558 ORA-15055: unable to connect to ASM instance
559 ORA-12547: TNS:lost contact
560
561
562 ***********************************************************************
563
564 Fatal NI connect error 12547, connecting to:
565 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle))))
566
567 VERSION INFORMATION:
568 TNS for Linux: Version 11.2.0.4.0 - Production
569 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
570 TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
571 Time: 27-MAR-2019 13:43:31
572 Tracing not turned on.
573 Tns error struct:
574 ns main err code: 12547
575
576 TNS-12547: TNS:lost contact
577 ns secondary err code: 12560
578 nt main err code: 517
579
580 TNS-00517: Lost contact
581 nt secondary err code: 32
582 nt OS err code: 0
583 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
584 WARNING: ASM communication error: op 0 state 0x0 (15055)
585 ERROR: direct connection failure with ASM
586 NOTE: Deferred communication with ASM instance
587 Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
588 ORA-15055: unable to connect to ASM instance
589 ORA-12547: TNS:lost contact
590
591
592 ***********************************************************************
593
594 Fatal NI connect error 12547, connecting to:
595 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle))))
596
597 VERSION INFORMATION:
598 TNS for Linux: Version 11.2.0.4.0 - Production
599 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
600 TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
601 Time: 27-MAR-2019 13:43:34
602 Tracing not turned on.
603 Tns error struct:
604 ns main err code: 12547
605
606 TNS-12547: TNS:lost contact
607 ns secondary err code: 12560
608 nt main err code: 517
609
610 TNS-00517: Lost contact
611 nt secondary err code: 32
612 nt OS err code: 0
613 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
614 WARNING: ASM communication error: op 0 state 0x0 (15055)
615 ERROR: direct connection failure with ASM
616 NOTE: Deferred communication with ASM instance
617 Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
618 ORA-15055: unable to connect to ASM instance
619 ORA-12547: TNS:lost contact
620
621
622 ***********************************************************************
623
624 Fatal NI connect error 12547, connecting to:
625 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle))))
626
627 VERSION INFORMATION:
628 TNS for Linux: Version 11.2.0.4.0 - Production
629 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
630 TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
631 Time: 27-MAR-2019 13:43:34
632 Tracing not turned on.
633 Tns error struct:
634 ns main err code: 12547
635
636 TNS-12547: TNS:lost contact
637 ns secondary err code: 12560
638 nt main err code: 517
639
640 TNS-00517: Lost contact
641 nt secondary err code: 32
642 nt OS err code: 0
643 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
644 WARNING: ASM communication error: op 0 state 0x0 (15055)
645 ERROR: direct connection failure with ASM
646 NOTE: Deferred communication with ASM instance
647 Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
648 ORA-15055: unable to connect to ASM instance
649 ORA-12547: TNS:lost contact
650
651
652 ***********************************************************************
653
654 Fatal NI connect error 12547, connecting to:
655 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle))))
656
657 VERSION INFORMATION:
658 TNS for Linux: Version 11.2.0.4.0 - Production
659 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
660 TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
661 Time: 27-MAR-2019 13:43:34
662 Tracing not turned on.
663 Tns error struct:
664 ns main err code: 12547
665
666 TNS-12547: TNS:lost contact
667 ns secondary err code: 12560
668 nt main err code: 517
669
670 TNS-00517: Lost contact
671 nt secondary err code: 32
672 nt OS err code: 0
673 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
674 WARNING: ASM communication error: op 0 state 0x0 (15055)
675 ERROR: direct connection failure with ASM
676 NOTE: Deferred communication with ASM instance
677 Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
678 ORA-15055: unable to connect to ASM instance
679 ORA-12547: TNS:lost contact
680
681
682 ***********************************************************************
683
684 Fatal NI connect error 12547, connecting to:
685 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle))))
686
687 VERSION INFORMATION:
688 TNS for Linux: Version 11.2.0.4.0 - Production
689 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
690 TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
691 Time: 27-MAR-2019 13:43:34
692 Tracing not turned on.
693 Tns error struct:
694 ns main err code: 12547
695
696 TNS-12547: TNS:lost contact
697 ns secondary err code: 12560
698 nt main err code: 517
699
700 TNS-00517: Lost contact
701 nt secondary err code: 32
702 nt OS err code: 0
703 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
704 WARNING: ASM communication error: op 0 state 0x0 (15055)
705 ERROR: direct connection failure with ASM
706 NOTE: Deferred communication with ASM instance
707 Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
708 ORA-15055: unable to connect to ASM instance
709 ORA-12547: TNS:lost contact
710
711
712 ***********************************************************************
713
714 Fatal NI connect error 12547, connecting to:
715 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle))))
716
717 VERSION INFORMATION:
718 TNS for Linux: Version 11.2.0.4.0 - Production
719 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
720 TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
721 Time: 27-MAR-2019 13:43:34
722 Tracing not turned on.
723 Tns error struct:
724 ns main err code: 12547
725
726 TNS-12547: TNS:lost contact
727 ns secondary err code: 12560
728 nt main err code: 517
729
730 TNS-00517: Lost contact
731 nt secondary err code: 32
732 nt OS err code: 0
733 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
734 WARNING: ASM communication error: op 0 state 0x0 (15055)
735 ERROR: direct connection failure with ASM
736 NOTE: Deferred communication with ASM instance
737 Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
738 ORA-15055: unable to connect to ASM instance
739 ORA-12547: TNS:lost contact
740
741
742 ***********************************************************************
743
744 Fatal NI connect error 12547, connecting to:
745 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle))))
746
747 VERSION INFORMATION:
748 TNS for Linux: Version 11.2.0.4.0 - Production
749 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
750 TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
751 Time: 27-MAR-2019 13:43:35
752 Tracing not turned on.
753 Tns error struct:
754 ns main err code: 12547
755
756 TNS-12547: TNS:lost contact
757 ns secondary err code: 12560
758 nt main err code: 517
759
760 TNS-00517: Lost contact
761 nt secondary err code: 32
762 nt OS err code: 0
763 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
764 WARNING: ASM communication error: op 0 state 0x0 (15055)
765 ERROR: direct connection failure with ASM
766 NOTE: Deferred communication with ASM instance
767 Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
768 ORA-15055: unable to connect to ASM instance
769 ORA-12547: TNS:lost contact
770
771
772 ***********************************************************************
773
774 Fatal NI connect error 12547, connecting to:
775 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle))))
776
777 VERSION INFORMATION:
778 TNS for Linux: Version 11.2.0.4.0 - Production
779 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
780 TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
781 Time: 27-MAR-2019 13:43:35
782 Tracing not turned on.
783 Tns error struct:
784 ns main err code: 12547
785
786 TNS-12547: TNS:lost contact
787 ns secondary err code: 12560
788 nt main err code: 517
789
790 TNS-00517: Lost contact
791 nt secondary err code: 32
792 nt OS err code: 0
793 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
794 WARNING: ASM communication error: op 0 state 0x0 (15055)
795 ERROR: direct connection failure with ASM
796 NOTE: Deferred communication with ASM instance
797 Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
798 ORA-15055: unable to connect to ASM instance
799 ORA-12547: TNS:lost contact
800
801
802 ***********************************************************************
803
804 Fatal NI connect error 12547, connecting to:
805 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle))))
806
807 VERSION INFORMATION:
808 TNS for Linux: Version 11.2.0.4.0 - Production
809 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
810 TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
811 Time: 27-MAR-2019 13:43:35
812 Tracing not turned on.
813 Tns error struct:
814 ns main err code: 12547
815
816 TNS-12547: TNS:lost contact
817 ns secondary err code: 12560
818 nt main err code: 517
819
820 TNS-00517: Lost contact
821 nt secondary err code: 32
822 nt OS err code: 0
823 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
824 WARNING: ASM communication error: op 0 state 0x0 (15055)
825 ERROR: direct connection failure with ASM
826 NOTE: Deferred communication with ASM instance
827 Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
828 ORA-15055: unable to connect to ASM instance
829 ORA-12547: TNS:lost contact
830
831
832 ***********************************************************************
833
834 Fatal NI connect error 12547, connecting to:
835 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle))))
836
837 VERSION INFORMATION:
838 TNS for Linux: Version 11.2.0.4.0 - Production
839 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
840 TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
841 Time: 27-MAR-2019 13:43:35
842 Tracing not turned on.
843 Tns error struct:
844 ns main err code: 12547
845
846 TNS-12547: TNS:lost contact
847 ns secondary err code: 12560
848 nt main err code: 517
849
850 TNS-00517: Lost contact
851 nt secondary err code: 32
852 nt OS err code: 0
853 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
854 WARNING: ASM communication error: op 0 state 0x0 (15055)
855 ERROR: direct connection failure with ASM
856 NOTE: Deferred communication with ASM instance
857 Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
858 ORA-15055: unable to connect to ASM instance
859 ORA-12547: TNS:lost contact
860
861
862 ***********************************************************************
863
864 Fatal NI connect error 12547, connecting to:
865 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle))))
866
867 VERSION INFORMATION:
868 TNS for Linux: Version 11.2.0.4.0 - Production
869 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
870 TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
871 Time: 27-MAR-2019 13:43:35
872 Tracing not turned on.
873 Tns error struct:
874 ns main err code: 12547
875
876 TNS-12547: TNS:lost contact
877 ns secondary err code: 12560
878 nt main err code: 517
879
880 TNS-00517: Lost contact
881 nt secondary err code: 32
882 nt OS err code: 0
883 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
884 WARNING: ASM communication error: op 0 state 0x0 (15055)
885 ERROR: direct connection failure with ASM
886 NOTE: Deferred communication with ASM instance
887 Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
888 ORA-15055: unable to connect to ASM instance
889 ORA-12547: TNS:lost contact
890
891
892 ***********************************************************************
893
894 Fatal NI connect error 12547, connecting to:
895 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle))))
896
897 VERSION INFORMATION:
898 TNS for Linux: Version 11.2.0.4.0 - Production
899 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
900 TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
901 Time: 27-MAR-2019 13:43:35
902 Tracing not turned on.
903 Tns error struct:
904 ns main err code: 12547
905
906 TNS-12547: TNS:lost contact
907 ns secondary err code: 12560
908 nt main err code: 517
909
910 TNS-00517: Lost contact
911 nt secondary err code: 32
912 nt OS err code: 0
913 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
914 WARNING: ASM communication error: op 0 state 0x0 (15055)
915 ERROR: direct connection failure with ASM
916 NOTE: Deferred communication with ASM instance
917 Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
918 ORA-15055: unable to connect to ASM instance
919 ORA-12547: TNS:lost contact
920 ARCH: Archival disabled due to shutdown: 1089
921 Shutting down archive processes
922 Archiving is disabled
923 NOTE: force a map free for map id 3
924 NOTE: force a map free for map id 2
925 NOTE: force a map free for map id 8
926 NOTE: force a map free for map id 7
927 NOTE: force a map free for map id 6
928 NOTE: force a map free for map id 5
929 NOTE: force a map free for map id 4
930 NOTE: force a map free for map id 18
931 NOTE: force a map free for map id 17
932 NOTE: force a map free for map id 16
933 NOTE: force a map free for map id 15
934 Wed Mar 27 13:43:36 2019
935 Stopping background process VKTM
936 ARCH: Archival disabled due to shutdown: 1089
937 Shutting down archive processes
938 Archiving is disabled
939 Wed Mar 27 13:43:36 2019
940 NOTE: Shutting down MARK background process
941
942
943 ***********************************************************************
944
945 Fatal NI connect error 12547, connecting to:
946 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_user2355_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle))))
947
948 VERSION INFORMATION:
949 TNS for Linux: Version 11.2.0.4.0 - Production
950 Unix Domain Socket IPC NT Protocol Adaptor for Linux: Version 11.2.0.4.0 - Production
951 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
952 TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
953 Time: 27-MAR-2019 13:43:38
954 Tracing not turned on.
955 Tns error struct:
956 ns main err code: 12547
957
958 TNS-12547: TNS:lost contact
959 ns secondary err code: 12560
960 nt main err code: 517
961
962 TNS-00517: Lost contact
963 nt secondary err code: 32
964 nt OS err code: 0
965 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_user2355_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
966 WARNING: ASM communication error: op 0 state 0x0 (15055)
967 ERROR: direct connection failure with ASM
968
969
970 ***********************************************************************
971
972 Fatal NI connect error 12547, connecting to:
973 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_user2355_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle))))
974
975 VERSION INFORMATION:
976 TNS for Linux: Version 11.2.0.4.0 - Production
977 Unix Domain Socket IPC NT Protocol Adaptor for Linux: Version 11.2.0.4.0 - Production
978 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
979 TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
980 Time: 27-MAR-2019 13:43:39
981 Tracing not turned on.
982 Tns error struct:
983 ns main err code: 12547
984
985 TNS-12547: TNS:lost contact
986 ns secondary err code: 12560
987 nt main err code: 517
988
989 TNS-00517: Lost contact
990 nt secondary err code: 32
991 nt OS err code: 0
992 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_user2355_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
993 WARNING: ASM communication error: op 0 state 0x0 (15055)
994 ERROR: direct connection failure with ASM
995 Wed Mar 27 13:43:40 2019
996
997
998 ***********************************************************************
999
1000 Fatal NI connect error 12547, connecting to:
1001 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_user2355_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle))))
1002
1003 VERSION INFORMATION:
1004 TNS for Linux: Version 11.2.0.4.0 - Production
1005 Unix Domain Socket IPC NT Protocol Adaptor for Linux: Version 11.2.0.4.0 - Production
1006 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
1007 TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
1008 Time: 27-MAR-2019 13:43:40
1009 Tracing not turned on.
1010 Tns error struct:
1011 ns main err code: 12547
1012
1013 TNS-12547: TNS:lost contact
1014 ns secondary err code: 12560
1015 nt main err code: 517
1016
1017 TNS-00517: Lost contact
1018 nt secondary err code: 32
1019 nt OS err code: 0
1020 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_user2355_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
1021 WARNING: ASM communication error: op 0 state 0x0 (15055)
1022 ERROR: direct connection failure with ASM
1023
1024
1025 ***********************************************************************
1026
1027 Fatal NI connect error 12547, connecting to:
1028 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_user2355_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle))))
1029
1030 VERSION INFORMATION:
1031 TNS for Linux: Version 11.2.0.4.0 - Production
1032 Unix Domain Socket IPC NT Protocol Adaptor for Linux: Version 11.2.0.4.0 - Production
1033 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
1034 TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
1035 Time: 27-MAR-2019 13:43:42
1036 Tracing not turned on.
1037 Tns error struct:
1038 ns main err code: 12547
1039
1040 TNS-12547: TNS:lost contact
1041 ns secondary err code: 12560
1042 nt main err code: 517
1043
1044 TNS-00517: Lost contact
1045 nt secondary err code: 32
1046 nt OS err code: 0
1047 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_user2355_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
1048 WARNING: ASM communication error: op 0 state 0x0 (15055)
1049 ERROR: direct connection failure with ASM
1050 Wed Mar 27 13:43:43 2019
1051 freeing rdom 0
1052 Wed Mar 27 13:43:49 2019
1053 Instance shutdown complete
View Code
这个节点是RAC集群,但是两台主机,就一台主机存活
启动时候错误:
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+ORADATA01/oracle/spfileoracle.ora'
ORA-17503: ksfdopn:2 Failed to open file +ORADATA01/oracle/spfileoracle.ora
ORA-12547: TNS:lost contact
文件时放在ASM磁盘里面的
02,问题探测
报错意思看看--
处理系统参数错误,识别文件错误,打开错误,TNS,失去联系?
这都是啥问题哦.
我看看文件在不在把.
[grid@node1 ~]$ asmcmd
ASMCMD> ls
OCR_VOTE/
ORADATA01/
ORADATA02/
ASMCMD> cd ORADATA01
ASMCMD> ls
ORACLE/
arch1/
arch2/
ASMCMD> ls ORACLE/
ARCHIVELOG/
CONTROLFILE/
DATAFILE/
ONLINELOG/
PARAMETERFILE/
TEMPFILE/
spfileoracle.ora
似乎没什么毛病啊
查看集群状态
crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE OFFLINE node1
ora.OCR_VOTE.dg
ONLINE ONLINE node1
ora.ORADATA01.dg
ONLINE ONLINE node1
ora.ORADATA02.dg
ONLINE ONLINE node1
ora.asm
ONLINE ONLINE node1 Started
ora.gsd
OFFLINE OFFLINE node1
ora.net1.network
ONLINE ONLINE node1
ora.ons
ONLINE ONLINE node1
ora.registry.acfs
ONLINE ONLINE node1
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE node1
ora.cvu
1 OFFLINE OFFLINE
ora.oc4j
1 ONLINE ONLINE node1
ora.oracle.db
1 ONLINE OFFLINE Instance Shutdown
ora.scan1.vip
1 ONLINE ONLINE node1
----
01078---问题主要就是应为$ORACLE_HOME/bin/oracle 权限导致的,默认需要的权限为6751
----
[grid@node1 ~]$ cd /oracle/11.2.0/grid/crs/bin/
[grid@node1 bin]$ ls -l oracle
-rwxr-x--x 1 grid oinstall 209914479 Mar 5 15:17 oracle
权限不对..我也没改这个权限呀,为什么会出现这个问题呢?
03, 问题解决
[grid@node1 bin]$ chmod 6751 oracle
[grid@node1 bin]$ ls -l oracle
-rwsr-s--x 1 grid oinstall 209914479 Mar 5 15:17 oracle
[grid@node1 bin]$ su - oracle
Password:
[oracle@node1 ~]$ cd $ORACLE_HOME
[oracle@node1 db_1]$ cd bin/
[oracle@node1 bin]$ ls -l oracle
-rwsr-s--x 1 oracle asmadmin 239626641 Mar 5 16:25 oracle
启动数据库
1 Wed Mar 27 14:00:29 2019
2
3
4 ***********************************************************************
5
6 Fatal NI connect error 12547, connecting to:
7 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_user_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle@node1)(HOST=node1)(USER=oracle))))
8
9 VERSION INFORMATION:
10 TNS for Linux: Version 11.2.0.4.0 - Production
11 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
12 Time: 27-MAR-2019 13:44:19
13 Tracing not turned on.
14 Tns error struct:
15 ns main err code: 12547
16
17 TNS-12547: TNS:lost contact
18 ns secondary err code: 12560
19 nt main err code: 517
20
21 TNS-00517: Lost contact
22 nt secondary err code: 32
23 nt OS err code: 0
24 NOTE: failed to open SPFILE +ORADATA01/oracle/spfileoracle.ora
25
26
27 ***********************************************************************
28
29 Fatal NI connect error 12547, connecting to:
30 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_user_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle@node1)(HOST=node1)(USER=oracle))))
31
32 VERSION INFORMATION:
33 TNS for Linux: Version 11.2.0.4.0 - Production
34 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
35 Time: 27-MAR-2019 13:44:52
36 Tracing not turned on.
37 Tns error struct:
38 ns main err code: 12547
39
40 TNS-12547: TNS:lost contact
41 ns secondary err code: 12560
42 nt main err code: 517
43
44 TNS-00517: Lost contact
45 nt secondary err code: 32
46 nt OS err code: 0
47 NOTE: failed to open SPFILE +ORADATA01/oracle/spfileoracle.ora
48
49
50 ***********************************************************************
51
52 Fatal NI connect error 12547, connecting to:
53 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_user_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle))))
54
55 VERSION INFORMATION:
56 TNS for Linux: Version 11.2.0.4.0 - Production
57 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
58 Time: 27-MAR-2019 13:45:15
59 Tracing not turned on.
60 Tns error struct:
61 ns main err code: 12547
62
63 TNS-12547: TNS:lost contact
64 ns secondary err code: 12560
65 nt main err code: 517
66
67 TNS-00517: Lost contact
68 nt secondary err code: 32
69 nt OS err code: 0
70 NOTE: failed to open SPFILE +ORADATA01/oracle/spfileoracle.ora
71 Starting ORACLE instance (normal)
72 ************************ Large Pages Information *******************
73 Per process system memlock (soft) limit = 64 KB
74
75 Total Shared Global Region in Large Pages = 0 KB (0%)
76
77 Large Pages used by this instance: 0 (0 KB)
78 Large Pages unused system wide = 0 (0 KB)
79 Large Pages configured system wide = 0 (0 KB)
80 Large Page size = 2048 KB
81
82 RECOMMENDATION:
83 Total System Global Area size is 2402 MB. For optimal performance,
84 prior to the next instance restart:
85 1. Increase the number of unused large pages by
86 at least 1201 (page size 2048 KB, total size 2402 MB) system wide to
87 get 100% of the System Global Area allocated with large pages
88 2. Large pages are automatically locked into physical memory.
89 Increase the per process memlock (soft) limit to at least 2410 MB to lock
90 100% System Global Area's large pages into physical memory
91 ********************************************************************
92 LICENSE_MAX_SESSION = 0
93 LICENSE_SESSIONS_WARNING = 0
94 Initial number of CPU is 1
95 Number of processor cores in the system is 1
96 Number of processor sockets in the system is 1
97 Private Interface 'eth1:1' configured from GPnP for use as a private interconnect.
98 [name='eth1:1', type=1, ip=169.254.73.23, mac=00-50-56-a4-35-75, net=169.254.0.0/16, mask=255.255.0.0, use=haip:cluster_interconnect/62]
99 Public Interface 'eth0' configured from GPnP for use as a public interface.
100 [name='eth0', type=1, ip=192.168.0.193, mac=00-50-56-a4-00-02, net=192.168.0.0/24, mask=255.255.255.0, use=public/1]
101 Public Interface 'eth0:1' configured from GPnP for use as a public interface.
102 [name='eth0:1', type=1, ip=192.168.0.176, mac=00-50-56-a4-00-02, net=192.168.0.0/24, mask=255.255.255.0, use=public/1]
103 CELL communication is configured to use 0 interface(s):
104 CELL IP affinity details:
105 NUMA status: non-NUMA system
106 cellaffinity.ora status: N/A
107 CELL communication will use 1 IP group(s):
108 Grp 0:
109 Picked latch-free SCN scheme 3
110 Using LOG_ARCHIVE_DEST_1 parameter default value as /oracle/app/oracle/product/11.2.0/db_1/dbs/arch
111 Autotune of undo retention is turned on.
112 LICENSE_MAX_USERS = 0
113 SYS auditing is disabled
114 Starting up:
115 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
116 With the Partitioning, Real Application Clusters, OLAP, Data Mining
117 and Real Application Testing options.
118 ORACLE_HOME = /oracle/app/oracle/product/11.2.0/db_1
119 System name: Linux
120 Node name: node1
121 Release: 2.6.32-754.11.1.el6.x86_64
122 Version: #1 SMP Tue Feb 26 15:38:56 UTC 2019
123 Machine: x86_64
124 VM name: VMWare Version: 6
125 Using parameter settings in server-side pfile /oracle/app/oracle/product/11.2.0/db_1/dbs/initoracle1.ora
126 System parameters with non-default values:
127 processes = 300
128 sessions = 472
129 spfile = "+ORADATA01/oracle/spfileoracle.ora"
130 sga_target = 2400M
131 control_files = "+ORADATA01/oracle/controlfile/current.267.1002895765"
132 control_files = "+ORADATA02/oracle/controlfile/current.256.1002895765"
133 db_block_size = 8192
134 compatible = "11.2.0.4.0"
135 cluster_database = TRUE
136 db_create_file_dest = "+ORADATA01"
137 db_create_online_log_dest_1= "+ORADATA01"
138 db_create_online_log_dest_2= "+ORADATA02"
139 _gc_policy_time = 4
140 _gc_policy_minimum = 100
141 thread = 1
142 undo_tablespace = "UNDOTBS1"
143 instance_number = 1
144 remote_login_passwordfile= "EXCLUSIVE"
145 db_domain = ""
146 dispatchers = "(PROTOCOL=TCP) (SERVICE=oracleXDB)"
147 remote_listener = "dbscan:1521"
148 audit_file_dest = "/oracle/app/oracle/admin/oracle/adump"
149 audit_trail = "DB"
150 db_name = "oracle"
151 open_cursors = 300
152 pga_aggregate_target = 800M
153 diagnostic_dest = "/oracle/app/oracle"
154 Cluster communication is configured to use the following interface(s) for this instance
155 169.254.73.23
156 cluster interconnect IPC version:Oracle UDP/IP (generic)
157 IPC Vendor 1 proto 2
158 Wed Mar 27 14:00:36 2019
159 PMON started with pid=2, OS id=444
160 Wed Mar 27 14:00:36 2019
161 PSP0 started with pid=3, OS id=446
162 Wed Mar 27 14:00:37 2019
163 VKTM started with pid=4, OS id=448 at elevated priority
164 VKTM running at (1)millisec precision with DBRM quantum (100)ms
165 Wed Mar 27 14:00:37 2019
166 GEN0 started with pid=5, OS id=452
167 Wed Mar 27 14:00:37 2019
168 DIAG started with pid=6, OS id=454
169 Wed Mar 27 14:00:37 2019
170 DBRM started with pid=7, OS id=456
171 Wed Mar 27 14:00:37 2019
172 PING started with pid=8, OS id=458
173 Wed Mar 27 14:00:37 2019
174 ACMS started with pid=9, OS id=460
175 Wed Mar 27 14:00:37 2019
176 DIA0 started with pid=10, OS id=462
177 Wed Mar 27 14:00:37 2019
178 LMON started with pid=11, OS id=464
179 Wed Mar 27 14:00:37 2019
180 LMD0 started with pid=12, OS id=466
181 * Load Monitor used for high load check
182 * New Low - High Load Threshold Range = [960 - 1280]
183 Wed Mar 27 14:00:37 2019
184 LMS0 started with pid=13, OS id=468 at elevated priority
185 Wed Mar 27 14:00:38 2019
186 RMS0 started with pid=14, OS id=472
187 Wed Mar 27 14:00:38 2019
188 LMHB started with pid=15, OS id=474
189 Wed Mar 27 14:00:38 2019
190 MMAN started with pid=16, OS id=476
191 Wed Mar 27 14:00:38 2019
192 DBW0 started with pid=17, OS id=478
193 Wed Mar 27 14:00:38 2019
194 LGWR started with pid=18, OS id=480
195 Wed Mar 27 14:00:38 2019
196 CKPT started with pid=19, OS id=482
197 Wed Mar 27 14:00:38 2019
198 SMON started with pid=20, OS id=484
199 Wed Mar 27 14:00:38 2019
200 RECO started with pid=21, OS id=486
201 Wed Mar 27 14:00:38 2019
202 RBAL started with pid=22, OS id=488
203 Wed Mar 27 14:00:38 2019
204 ASMB started with pid=23, OS id=490
205 Wed Mar 27 14:00:38 2019
206 MMON started with pid=24, OS id=492
207 NOTE: initiating MARK startup
208 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
209 Starting background process MARK
210 Wed Mar 27 14:00:38 2019
211 MMNL started with pid=25, OS id=496
212 Wed Mar 27 14:00:38 2019
213 MARK started with pid=26, OS id=498
214 NOTE: MARK has subscribed
215 starting up 1 shared server(s) ...
216 lmon registered with NM - instance number 1 (internal mem no 0)
217 Reconfiguration started (old inc 0, new inc 2)
218 List of instances:
219 1 (myinst: 1)
220 Global Resource Directory frozen
221 * allocate domain 0, invalid = TRUE
222 Communication channels reestablished
223 Master broadcasted resource hash value bitmaps
224 Non-local Process blocks cleaned out
225 LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
226 Set master node info
227 Submitted all remote-enqueue requests
228 Dwn-cvts replayed, VALBLKs dubious
229 All grantable enqueues granted
230 Post SMON to start 1st pass IR
231 Submitted all GCS remote-cache requests
232 Post SMON to start 1st pass IR
233 Fix write in gcs resources
234 Reconfiguration complete
235 Wed Mar 27 14:00:39 2019
236 LCK0 started with pid=30, OS id=508
237 Starting background process RSMN
238 Wed Mar 27 14:00:39 2019
239 RSMN started with pid=31, OS id=510
240 Wed Mar 27 14:00:39 2019
241 ORACLE_BASE from environment = /oracle/app/oracle
242 NOTE: Loaded library: System
243 SUCCESS: diskgroup ORADATA01 was mounted
244 NOTE: dependency between database oracle and diskgroup resource ora.ORADATA01.dg is established
245 Wed Mar 27 14:00:41 2019
246 ALTER DATABASE MOUNT
247 This instance was first to mount
248 SUCCESS: diskgroup ORADATA02 was mounted
249 NOTE: dependency between database oracle and diskgroup resource ora.ORADATA02.dg is established
250 Successful mount of redo thread 1, with mount id 1877148105
251 Database mounted in Shared Mode (CLUSTER_DATABASE=TRUE)
252 Lost write protection disabled
253 Completed: ALTER DATABASE MOUNT
254 Wed Mar 27 14:00:46 2019
255 ALTER DATABASE OPEN
256 This instance was first to open
257 Picked broadcast on commit scheme to generate SCNs
258 Thread 1 opened at log sequence 69
259 Current log# 1 seq# 69 mem# 0: +ORADATA01/oracle/onlinelog/group_1.256.1002895765
260 Current log# 1 seq# 69 mem# 1: +ORADATA02/oracle/onlinelog/group_1.266.1002895767
261 Successful open of redo thread 1
262 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
263 SMON: enabling cache recovery
264 Instance recovery: looking for dead threads
265 Instance recovery: lock domain invalid but no dead threads
266 minact-scn: Inst 1 is now the master inc#:2 mmon proc-id:492 status:0x7
267 minact-scn status: grec-scn:0x0000.00000000 gmin-scn:0x0000.00000000 gcalc-scn:0x0000.00000000
268 [608] Successfully onlined Undo Tablespace 2.
269 Undo initialization finished serial:0 start:1090369464 end:1090370324 diff:860 (8 seconds)
270 Verifying file header compatibility for 11g tablespace encryption..
271 Verifying 11g file header compatibility for tablespace encryption completed
272 SMON: enabling tx recovery
273 Database Characterset is ZHS16GBK
274 No Resource Manager plan active
275 Starting background process GTX0
276 Wed Mar 27 14:00:49 2019
277 GTX0 started with pid=36, OS id=646
278 Starting background process RCBG
279 Wed Mar 27 14:00:50 2019
280 RCBG started with pid=37, OS id=648
281 replication_dependency_tracking turned off (no async multimaster replication found)
282 Starting background process QMNC
283 Wed Mar 27 14:00:52 2019
284 QMNC started with pid=38, OS id=650
285 Completed: ALTER DATABASE OPEN
286 Wed Mar 27 14:00:56 2019
287 Starting background process CJQ0
288 Wed Mar 27 14:00:56 2019
289 CJQ0 started with pid=44, OS id=760
290 Wed Mar 27 14:01:39 2019
291 Decreasing number of real time LMS from 1 to 0
292 Wed Mar 27 14:05:52 2019
293 Starting background process SMCO
294 Wed Mar 27 14:05:52 2019
295 SMCO started with pid=28, OS id=1972
View Code
如愿以偿的看到了启动过程
问题探测
[Wèntí tàncè]
Problem detection
