oracle 错误实例分析(ORA-01078)
01,问题描述
心血来潮想看一下启动数据库的alert log.然后把数据库给关闭了,同时也在监听日志文件
下面可谓是详细的描述了整个关机过程,也看到了无数的error
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
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
这个节点是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
启动数据库
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
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
如愿以偿的看到了启动过程
问题探测
[Wèntí tàncè]
Problem detection
人生就像一滴水,非要落下才后悔!
--kingle