关于SQLRecoverableException问题的排查和分析(r4笔记第13天)

上周在升级时候，客户反馈某个job报了下面的错误，想让我们查看一下是不是数据库这边有什么问题。Caused by: java.sql.SQLRecoverableException: No more data to read from socketOct 8 23:17 log.xmlDIAG_ADR_ENABLED=OFFListener Log File /opt/app/oracle/xxxxx/product/11.2.0/log/diag/tnslsnr/xxxxx/listener_cust01/alert/log.xml

<msg time='2015-01-07T02:00:13.352+07:00' org_id='oracle' comp_id='tnslsnr'

type='UNKNOWN' level='16' host_id='ccbdbpr3'

host_addr='127.0.0.1'>

<txt>TNS-12547: TNS:lost contact

TNS-12560: TNS:protocol adapter error

TNS-00517: Lost contact

Linux Error: 104: Connection reset by peer

</txt>

</msg>

有了这个日志，能够判断出了问题，但是还不能判断出来问题倒底是由什么原因导致的。

$ORACLE_BASE/diag/rdbms/cust01/CUST01/alert2015-01-07T02:00:02.186+07:00' org_id='oracle' comp_id='rdbms'

--

host_id='ccbdbpr3' host_addr='127.0.0.1' module='sqlplus@ccbdbpr3 (TNS V1-V3)'

pid='22321'>

<txt>Immediate Kill Session: sess: 0xa52fe0740 OS pid: 8314

</txt>

</msg>

<msg time='2015-01-07T02:00:02.253+07:00' org_id='oracle' comp_id='rdbms'

--

host_id='ccbdbpr3' host_addr='127.0.0.1' module='sqlplus@ccbdbpr3 (TNS V1-V3)'

pid='22321'>

<txt>Immediate Kill Session#: 239, Serial#: 63057

</txt>

</msg>

<msg time='2015-01-07T02:00:02.254+07:00' org_id='oracle' comp_id='rdbms'

--

host_id='ccbdbpr3' host_addr='127.0.0.1' module='sqlplus@ccbdbpr3 (TNS V1-V3)'

pid='22321'>

<txt>Immediate Kill Session: sess: 0xa512cff40 OS pid: 19222

</txt>

</msg>