1. ホーム
  2. oracle

[解決済み] Oracle 12c: TNS-12535: TNS:操作がタイムアウトしました。

2022-02-08 19:50:51

質問

繰り返しの投稿になりますが、問題が見つかりませんでしたので、申し訳ありません。古いサーバーを置き換える新しいDBプロドサーバーがあります。OSはRHEL 7で、Oracle 12cを搭載しています。古いデータベースサーバーはRHEL4、Oracle10gです。新しいサーバーは、概念実証のためのテストサーバーに行ったのと同じ構成と設定で構成しました。12cクライアントを使用して、新しいProdサーバーから古いProdサーバーにデータをダンプする必要があるため、tnsnamesを設定しました。しかし、tnspingをテストしている間、TNS-12535: TNS:operation timed outが表示されました。すべてダブルチェックしましたが、すべてのパラメータは問題ないようです。古いサーバーのファイアウォールをチェックしてみましたが、無効になっており、何の制限もありませんでした。データベースインスタンスを古いステージングと開発サーバーにtnspingしてみましたが、10ms未満で応答が得られました。以下は、古いプロダクツ用の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

解決方法は?

これは確かにネットワークの問題で、両方のサーバーのネットマスクが関係しており、もう一方のサーバーのネットマスクが正しくないというものでした。