集群的告警日志显示Fatal NI connect error 12514，非数据库告警日志

2019-07-28

TNS-12564: TNS:connection refused

    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

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

Fatal NI connect error 12514, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.31.12.22)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=prod)(CID=(PROGRAM=ologgerd)(HOST=prod2)(USER=root))))

VERSION INFORMATION:
        TNS for Linux: Version 12.1.0.2.0 - Production
        TCP/IP NT Protocol Adapter for Linux: Version 12.1.0.2.0 - Production
Time: 28-JUL-2019 14:54:46
Tracing not turned on.
Tns error struct:
    ns main err code: 12564

TNS-12564: TNS:connection refused
    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

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

Fatal NI connect error 12514, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=166.254.38.93)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=prod)(CID=(PROGRAM=ologgerd)(HOST=prod2)(USER=root))))

VERSION INFORMATION:
        TNS for Linux: Version 12.1.0.2.0 - Production
        TCP/IP NT Protocol Adapter for Linux: Version 12.1.0.2.0 - Production
Time: 28-JUL-2019 14:54:51
Tracing not turned on.
Tns error struct:
    ns main err code: 12564

TNS-12564: TNS:connection refused
    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

5条回答

默认

最新

知识蛀虫

集群的告警日志显示如下信息，其中第一条为私网地址，为什么会有私网ip的tns

有用 0

知识蛀虫

只留了私网的解析，其它解析在下面显示中被我截取了

[root@prod2 admin]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6

#private ip
172.31.12.21 prod1-priv
172.31.12.22 prod2-priv