<msg time='2014-02-21T13:14:08.468+08:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='WIN-LO2BM3SDT1A'
host_addr='fe80::11c3:7366:5a5c:609a%11'>
<txt>
Fatal NI connect error 12570, connecting to:
(LOCAL=NO)
</txt>
</msg>
<msg time='2014-02-21T13:14:08.469+08:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='WIN-LO2BM3SDT1A'
host_addr='fe80::11c3:7366:5a5c:609a%11'>
<txt>
VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
</txt>
</msg>
<msg time='2014-02-21T13:14:08.470+08:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='WIN-LO2BM3SDT1A'
host_addr='fe80::11c3:7366:5a5c:609a%11'>
<txt> Time: 21-2月 -2014 13:14:08
</txt>
</msg>
<msg time='2014-02-21T13:14:08.471+08:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='WIN-LO2BM3SDT1A'
host_addr='fe80::11c3:7366:5a5c:609a%11'>
<txt> Tracing not turned on.
</txt>
</msg>
<msg time='2014-02-21T13:14:08.471+08:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='WIN-LO2BM3SDT1A'
host_addr='fe80::11c3:7366:5a5c:609a%11'>
<txt> Tns error struct:
</txt>
</msg>
<msg time='2014-02-21T13:14:08.472+08:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='WIN-LO2BM3SDT1A'
host_addr='fe80::11c3:7366:5a5c:609a%11'>
<txt> ns main err code: 12570
</txt>
</msg>
<msg time='2014-02-21T13:14:08.473+08:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='WIN-LO2BM3SDT1A'
host_addr='fe80::11c3:7366:5a5c:609a%11'>
<txt>
</txt>
</msg>
<msg time='2014-02-21T13:14:08.474+08:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='WIN-LO2BM3SDT1A'
host_addr='fe80::11c3:7366:5a5c:609a%11'>
<txt>TNS-12570: TNS: 包阅读程序失败
</txt>
</msg>
<msg time='2014-02-21T13:14:08.474+08:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='WIN-LO2BM3SDT1A'
host_addr='fe80::11c3:7366:5a5c:609a%11'>
<txt> ns secondary err code: 12560
</txt>
</msg>
<msg time='2014-02-21T13:14:08.475+08:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='WIN-LO2BM3SDT1A'
host_addr='fe80::11c3:7366:5a5c:609a%11'>
<txt> nt main err code: 0
</txt>
</msg>
<msg time='2014-02-21T13:14:08.476+08:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='WIN-LO2BM3SDT1A'
host_addr='fe80::11c3:7366:5a5c:609a%11'>
<txt> nt secondary err code: 0
</txt>
</msg>
<msg time='2014-02-21T13:14:08.476+08:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='WIN-LO2BM3SDT1A'
host_addr='fe80::11c3:7366:5a5c:609a%11'>
<txt> nt OS err code: 0
</txt>
</msg>
<msg time='2014-02-21T13:14:08.530+08:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='WIN-LO2BM3SDT1A'
host_addr='fe80::11c3:7366:5a5c:609a%11' pid='4748'>
<txt>opiodr aborting process unknown ospid (4748) as a result of ORA-609
</txt>
</msg>
查看上面的alter日志可以一个问题就是【TNS-12570: TNS: 包阅读程序失败】
找了好久都没有什么头绪,结果看到$ORACLE_HOME/diag\tnslsnr\WIN-LO2BM3SDT1A\listener\trace 目录下
有一个listener.log 日志文件大小到4G多,找了下windows 文件系统的配置如下,这个文件明显达到极限(客户服务器为NTFS 64位 txt文件可以支持到4G),
Windows下可以使用下面的命令来控制
lsnrctl set log_status off
rename listener.log listener.old
lsnrctl set log_status on
理论上硬盘还剩多少就可以保存多大的文件
NTFS(Windows):支持最大分区2TB,最大文件2TB
FAT16(Windows):支持最大分区2GB,最大文件2GB
FAT32(Windows):支持最大分区128GB,最大文件4GB
HPFS(OS/2):支持最大分区2TB,最大文件2GB
EXT2和EXT3(Linux):支持最大分区4TB,最大文件2GB
JFS(AIX):支持最大分区4P(block size=4k),最大文件4P
XFS(IRIX):这是个正经的64位的文件系统,可以支持9E(2的63次方)的分区