15064 进而导致数据库实例意外中止(3)

在ASMB进程的的dump文件中,发现有2个4分4秒的等待,waited for 'ASM file metadata operation'和waited for 'latch: shared pool',而其他的相关操作都是只有几微秒,甚至0秒的

 

3.ASM实例的alert日志:

 

Mon Jan 05 01:40:56 2015

 

 

***********************************************************************

TNS-12537: TNS:connection closed

 

Fatal NI connect error 12537, connecting to:

 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

    ns secondary err code: 12560

 

  VERSION INFORMATION:

TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production

Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production

    nt main err code: 0

  Time: 05-JAN-2015 01:40:56

    nt secondary err code: 0

  Tracing not turned on.

    nt OS err code: 0

  Tns error struct:

    ns main err code: 12537

   

TNS-12537: TNS:connection closed

    ns secondary err code: 12560

    nt main err code: 0

    nt secondary err code: 0

    nt OS err code: 0

Mon Jan 05 04:42:23 2015

NOTE: ASMB process exiting due to lack of ASM file activity for 305 seconds

Mon Jan 05 08:46:53 2015

NOTE: client test5:test5 registered, osid 23593052, mbr 0x0

Mon Jan 05 08:47:24 2015

Starting background process ASMB

Mon Jan 05 08:47:24 2015

ASMB started with pid=26, OS id=20185292 

Mon Jan 05 08:47:25 2015

NOTE: client +ASM:+ASM registered, osid 16384406, mbr 0x1

 

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/88b38284c605879efcb0d6e3d3511c89.html