1、查询告警日志发现有错误信息
[oracle@mwrac2 trace]$ cat /u01/app/oracle/diag/rdbms/easdb/easdb2/trace/alert_easdb2.log |grep err
DBMS_STATS: GATHER_STATS_JOB encountered errors. Check the trace file.
Fatal NI connect error 12170.
Tns error struct:
ns main err code: 12535
ns secondary err code: 12560
nt main err code: 505
nt secondary err code: 110
nt OS err code: 0
*********************************************************************** ns main err code: 12535
ns main err code: 12535
Tns error struct:
Tns error struct:
ns main err code: 12535
Fatal NI connect error 12170.
ns main err code: 12535
ns main err code: 12535
Fatal NI connect error 12170.
ns main err code: 12535
ns secondary err code: 12560
ns secondary err code: 12560
ns secondary err code: 12560
ns secondary err code: 12560
ns secondary err code: 12560
Tns error struct:
nt main err code: 505
ns secondary err code: 12560
nt main err code: 505
nt main err code: 505
nt main err code: 505
是那里设置有问题吗？
通过日志了解，一个节点大概是在收集表的统计信息，然后可能由于集群内部通信问题，某个表可能同步状态不正常，导致报出那些NI的错误。我也只是猜测，具体还要看下grid相关日志没有有什么报错。
评论
有用 0
