oracle的监听日志报错
现在是这样一种情况:os:win 2003
oracle:11.2.0.2
问题描述:现在每天早上用户连接数据库都提示监控有问题,用户就重启机器,重启机器之后数据库连接正常,但查看oracle的监听日志,在日志中报如下错误:
<msg time='2014-08-19T09:08:13.406+08:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='IMAN-TESTSVR-DB'
host_addr='192.168.7.10' version='1'>
<txt>TNS-12528: TNS: 监听程序: 所有适用实例都无法建立新连接
</txt>
</msg>
<msg time='2014-08-19T09:08:13.421+08:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='IMAN-TESTSVR-DB'
host_addr='192.168.7.10'>
<txt>19-8月 -2014 09:08:13 * (CONNECT_DATA=(SID=nrmsdb)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.7.25)(PORT=3747)) * establish * nrmsdb * 12528
</txt>
</msg>
<msg time='2014-08-19T09:08:13.421+08:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='IMAN-TESTSVR-DB'
host_addr='192.168.7.10'>
<txt>TNS-12528: TNS: 监听程序: 所有适用实例都无法建立新连接
</txt>
</msg>
<msg time='2014-08-19T09:08:13.437+08:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='IMAN-TESTSVR-DB'
host_addr='192.168.7.10'>
<txt>19-8月 -2014 09:08:13 * (CONNECT_DATA=(SID=nrmsdb)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.7.25)(PORT=3748)) * establish * nrmsdb * 12528
</txt>
但有时连接正常,有时不正常,请各位帮忙看看,这是什么原因导致的,详细的监听信息请查看附件。
页:
[1]