Oracle 12c: TNS-12535: TNS:操作超时

Question

抱歉，如果这是一个重复的帖子，但我找不到问题所在。我们有一个新的数据库生产服务器，它将取代旧的。它安装在RHEL 7和Oracle 12c操作系统上。旧的数据库服务器是RHEL4和Oracle10g。为了进行概念验证，我使用了与测试服务器相同的配置和设置来配置新服务器。我需要使用12c客户端将数据从新的prod服务器转储到旧的prod服务器，因此我配置了tnsname。然而，在测试tnsping时，我得到了TNS-12535: TNS:operation超时。我仔细检查了所有的东西，所有的参数看起来都没问题。我尝试检查旧的服务器防火墙，它被禁用了，并且没有任何限制。我尝试将数据库实例连接到旧的登台和开发服务器，在不到10毫秒的时间内就得到了响应。下面是我们的旧产品的tnsnames条目

RPROD_1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.102.139)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = RPROD.GET2HAWAII.COM)
    )
  )

下面是tnsping的跟踪文件：

[09-JAN-2018 20:26:50:179] nlstdipi: entry
[09-JAN-2018 20:26:50:179] nlstdipi: exit
[09-JAN-2018 20:26:50:179] nnfun2awanm: entry
[09-JAN-2018 20:26:50:179] nnfgiinit: entry
[09-JAN-2018 20:26:50:179] nncpcin_maybe_init: default name server domain is [root]
[09-JAN-2018 20:26:50:179] nnfgiinit: Installing read path
[09-JAN-2018 20:26:50:179] nnfgsrsp: entry
[09-JAN-2018 20:26:50:179] nnfgsrsp: Obtaining path parameter from names.directory_path or native_names.directory_path
[09-JAN-2018 20:26:50:179] nnfgsrdp: entry
[09-JAN-2018 20:26:50:179] nnfgsrdp: Setting path:
[09-JAN-2018 20:26:50:179] nnfgsrdp: checking element TNSNAMES
[09-JAN-2018 20:26:50:179] nnfgsrdp: checking element EZCONNECT
[09-JAN-2018 20:26:50:179] nnfgsrdp: Path set
[09-JAN-2018 20:26:50:179] nnfun2a: entry
[09-JAN-2018 20:26:50:179] nlolgobj: entry
[09-JAN-2018 20:26:50:179] nnfgrne: entry
[09-JAN-2018 20:26:50:179] nnfgrne: Going though read path adapters
[09-JAN-2018 20:26:50:179] nnfgrne: Switching to TNSNAMES adapter
[09-JAN-2018 20:26:50:179] nnftboot: entry
[09-JAN-2018 20:26:50:179] nlpaxini: entry
[09-JAN-2018 20:26:50:179] nlpaxini: exit
[09-JAN-2018 20:26:50:179] nnftmlf_make_local_addrfile: entry
[09-JAN-2018 20:26:50:179] nnftmlf_make_local_addrfile: construction of local names file failed
[09-JAN-2018 20:26:50:179] nnftmlf_make_local_addrfile: exit
[09-JAN-2018 20:26:50:179] nlpaxini: entry
[09-JAN-2018 20:26:50:179] nlpaxini: exit
[09-JAN-2018 20:26:50:179] nnftmlf_make_system_addrfile: entry
[09-JAN-2018 20:26:50:179] nnftmlf_make_system_addrfile: system names file is /u01/app/oracle/product/12.2.0.1/db_1/network/admin/tnsnames.ora
[09-JAN-2018 20:26:50:179] nnftmlf_make_system_addrfile: exit
[09-JAN-2018 20:26:50:179] nnftboot: exit
[09-JAN-2018 20:26:50:179] nnftrne: entry
[09-JAN-2018 20:26:50:179] nnftrne: Original name: rprod_1
[09-JAN-2018 20:26:50:179] nnfttran: entry
[09-JAN-2018 20:26:50:179] nnfttran: exit
[09-JAN-2018 20:26:50:179] nnftrne: Using tnsnames.ora address (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.102.139)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = RPROD.GET2HAWAII.COM))) for name rprod_1
[09-JAN-2018 20:26:50:179] nnftrne: exit
[09-JAN-2018 20:26:50:179] nnfgrne: exit
[09-JAN-2018 20:26:50:179] nlolgserv: entry
[09-JAN-2018 20:26:50:179] nnfggav: entry
[09-JAN-2018 20:26:50:179] nnftgav: entry
[09-JAN-2018 20:26:50:179] nnftgav: exit
[09-JAN-2018 20:26:50:179] nnftfrm: exit
[09-JAN-2018 20:26:50:179] nnfgfrm: exit
[09-JAN-2018 20:26:50:179] nlolgserv: exit
[09-JAN-2018 20:26:50:179] nlolgobj: exit
[09-JAN-2018 20:26:50:179] nlolfmem: entry
[09-JAN-2018 20:26:50:179] nlolfmem: exit
[09-JAN-2018 20:26:50:179] nnfun2awanm: Getting the path of sqlnet.ora
[09-JAN-2018 20:26:50:179] nnfun2awanm: Getting the adapter name
[09-JAN-2018 20:26:50:179] nnfun2awanm: exit
[09-JAN-2018 20:26:50:179] snsgblini: exit
[09-JAN-2018 20:26:50:180] nsmal: 288 bytes at 0x1afe400
[09-JAN-2018 20:26:50:180] nscall: connecting...
[09-JAN-2018 20:26:50:180] snlinGetAddrInfo: entry
[09-JAN-2018 20:26:50:180] snlinGetAddrInfo: exit
[09-JAN-2018 20:26:50:180] snlinFreeAddrInfo: entry
[09-JAN-2018 20:26:50:180] snlinFreeAddrInfo: exit
[09-JAN-2018 20:26:50:180] nlad_pr: entry
[09-JAN-2018 20:26:50:180] nlad_pr: entry
[09-JAN-2018 20:26:50:180] snlinGetAddrInfo: entry
[09-JAN-2018 20:26:50:180] snlinGetAddrInfo: exit
[09-JAN-2018 20:26:50:180] snlinFreeAddrInfo: entry
[09-JAN-2018 20:26:50:180] snlinFreeAddrInfo: exit
[09-JAN-2018 20:26:50:180] nlad_pr: entry
[09-JAN-2018 20:26:50:180] nlad_aand: entry
[09-JAN-2018 20:26:50:180] nlad_ind: entry
[09-JAN-2018 20:26:50:180] snlinGetAddrInfo: entry
[09-JAN-2018 20:26:50:180] snlinGetAddrInfo: exit
[09-JAN-2018 20:26:50:180] snlinFreeAddrInfo: entry
[09-JAN-2018 20:26:50:180] snlinFreeAddrInfo: exit
[09-JAN-2018 20:26:50:180] nlad_ind: exit
[09-JAN-2018 20:26:50:180] nlad_aand: entry
[09-JAN-2018 20:26:50:180] nladini: entry
[09-JAN-2018 20:26:50:180] nladini: exit
[09-JAN-2018 20:26:50:180] nladget: entry
[09-JAN-2018 20:26:50:180] nladget: exit
[09-JAN-2018 20:26:50:180] nsmal: 122 bytes at 0x1b00090
[09-JAN-2018 20:26:50:180] nsc2addr: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.102.139)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=RPROD.GET2HAWAII.COM)))
[09-JAN-2018 20:26:50:180] nttbnd2addr: entry
[09-JAN-2018 20:26:50:180] snlinGetAddrInfo: entry
[09-JAN-2018 20:26:50:180] snlinGetAddrInfo: exit
[09-JAN-2018 20:26:50:180] nttbnd2addr: using host IP address: 192.168.102.139
[09-JAN-2018 20:26:50:180] snlinFreeAddrInfo: entry
[09-JAN-2018 20:26:50:180] snlinFreeAddrInfo: exit
[09-JAN-2018 20:26:50:180] nttbnd2addr: exit
[09-JAN-2018 20:26:50:180] nsmal: 1912 bytes at 0x1b00120
[09-JAN-2018 20:26:50:180] nsmal: 3352 bytes at 0x1b008a0
[09-JAN-2018 20:26:50:180] nsmal: 168 bytes at 0x1b017d0
[09-JAN-2018 20:26:50:180] nsopen: opening transport...
[09-JAN-2018 20:26:50:180] nttcon: entry
[09-JAN-2018 20:26:50:180] nttcon: toc = 1
[09-JAN-2018 20:26:50:180] nttcnp: entry
[09-JAN-2018 20:26:50:180] nttcnp: exit
[09-JAN-2018 20:26:50:180] nttcni: entry
[09-JAN-2018 20:26:50:180] nttcni: Tcp conn timeout = 60000 (ms)
[09-JAN-2018 20:26:50:180] nttctl: entry
[09-JAN-2018 20:26:50:180] nttctl: Setting connection into non-blocking mode
[09-JAN-2018 20:26:50:180] nttcni: trying to connect to socket 5.
[09-JAN-2018 20:26:50:180] ntt2err: entry
[09-JAN-2018 20:26:50:180] ntt2err: exit
[09-JAN-2018 20:26:50:180] ntctst: size of NTTEST list is 1 - not calling poll
[09-JAN-2018 20:27:50:240] sntpoltst: exit
[09-JAN-2018 20:27:50:240] nttcni: TImeout or Error on this socket
[09-JAN-2018 20:27:50:241] nttcni: exit
[09-JAN-2018 20:27:50:241] nttcon: exit
[09-JAN-2018 20:27:50:241] nserror: nsres: id=0, op=65, ns=12535, ns2=12560; nt[0]=505, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[09-JAN-2018 20:27:50:241] nsopen: unable to open transport
[09-JAN-2018 20:27:50:241] nsvntx_dei: entry
[09-JAN-2018 20:27:50:241] nsvntx_dei: exit
[09-JAN-2018 20:27:50:241] nsmfr: 3352 bytes at 0x1b008a0
[09-JAN-2018 20:27:50:241] nsmfr: 1912 bytes at 0x1b00120
[09-JAN-2018 20:27:50:241] nldntUpdateNodeTable: entry
[09-JAN-2018 20:27:50:241] snlinGetAddrInfo: entry
[09-JAN-2018 20:27:50:241] snlinGetAddrInfo: exit
[09-JAN-2018 20:27:50:241] snlinFreeAddrInfo: entry
[09-JAN-2018 20:27:50:241] snlinFreeAddrInfo: exit
[09-JAN-2018 20:27:50:241] nsmfr: 122 bytes at 0x1b00090
[09-JAN-2018 20:27:50:241] nscall: connecting...
[09-JAN-2018 20:27:50:241] nladget: entry
[09-JAN-2018 20:27:50:241] nladget: exit
[09-JAN-2018 20:27:50:241] nsmfr: 288 bytes at 0x1afe400
[09-JAN-2018 20:27:50:241] nladtrm: entry
[09-JAN-2018 20:27:50:241] nladtrm: exit
[09-JAN-2018 20:27:50:241] nlse_term_audit: entry
[09-JAN-2018 20:27:50:241] nlse_term_audit: exit

Answer 1

这确实是一个网络问题，涉及两台服务器的网络掩码，其中另一台服务器的网络掩码不正确。