tnsping 报TNS-12535: TNS:operation timed out

qq7343696

      大家好：
         
                    两个数据库环境都是db:11.2.0.3 rac环境

                  新安装的数据库在rhel 5.8下面 ，配置tnsnames.ora后，tnsping报下面的错误

[oracle@CSBDB01 admin]$ tnsping paramb

TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 30-MAY-2013 10:57:01

Copyright (c) 1997, 2011, Oracle.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 133.37.116.101)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 133.37.116.100)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = paramb) (FAILOVER_MODE = (TYPE = select) (METHOD = basic) (RETRIES = 180) (DELAY = 5))))
TNS-12535: TNS:operation timed out

tnsnames.ora文件中的内容跟其它的主机一样，在其它的主机上面tnsping正常。
tnsnames.ora的配置内容如下：
PARAMB=
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 133.37.116.101)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 133.37.116.100)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = paramb)
      (FAILOVER_MODE =
       (TYPE = select)
       (METHOD = basic)
       (RETRIES = 180)
       (DELAY = 5)
      )
    )
   )

去掉了failover_mode，也去掉了其中一个IP地址测试，仍然报错，并且只在新安装的这台主机上面报错，其它主机正常，param数据库上面没有配置sqlnet.ora文件，
在主机上面telnet 133.37.116.101 1521正常，说明不是防火墙的问题。
源主机上面的服务名paramb是正常运行的
param02$[/oracle]srvctl status service -d param
Service parama is running on instance(s) PARAM1
Service paramb is running on instance(s) PARAM2
param02$[/oracle]
下面是WIN平台一台主机测试正常
E:\wendang\SkyDrive\rs2\sql>tnsping paramb -n 100

TNS Ping Utility for 64-bit Windows: Version 11.2.0.3.0 - Production on 30-MAY-2013 10:57:35

Copyright (c) 1997, 2011, Oracle.  All rights reserved.

Used parameter files:
E:\app\luoping\product\11.2.0\dbhome_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 133.37.116.101)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 133.37.116.100)(PORT = 1521))) (CONNECT_DA
TA = (SERVER = DEDICATED) (SERVICE_NAME = paramb) (FAILOVER_MODE = (TYPE = select) (METHOD = basic) (RETRIES = 180) (DELAY = 5))))
OK (10 msec)

qq7343696

下面是client端的tnsping的trace文件
[oracle@CSBDB01 tmp]$ cat tnsping.trc

TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 30-MAY-2013 11:26:19

Copyright (c) 1997, 2011, Oracle.  All rights reserved.

--- TRACE CONFIGURATION INFORMATION FOLLOWS ---
New trace stream is /tmp/tnsping.trc
New trace level is 6
--- TRACE CONFIGURATION INFORMATION ENDS ---
--- PARAMETER SOURCE INFORMATION FOLLOWS ---
Attempted load of system pfile source /oracle/app/oracle/product/11.2/network/admin/sqlnet.ora
Parameter source loaded successfully

-> PARAMETER TABLE LOAD RESULTS FOLLOW <-
Successful parameter table load
-> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
  log_directory_client = /tmp
  trace_filelen_client = 100
  trace_level_client = 16
  tnsping.trace_level = admin
  trace_fileno_client = 2
  tnsping.trace_directory = /tmp
  trace_directory_client = /tmp
  log_file_client = cli
  trace_timestamp_client = on
  trace_file_client = cli
  trace_unique_client = on
--- PARAMETER SOURCE INFORMATION ENDS ---
--- LOG CONFIGURATION INFORMATION FOLLOWS ---
Log stream will be "standard output"
Log stream validation not requested
--- LOG CONFIGURATION INFORMATION ENDS ---

nlstdipi: entry
nlstdipi: exit
nnfun2awanm: entry
nnfgiinit: entry
nncpcin_maybe_init: default name server domain is [root]
nnfgiinit: Installing read path
nnfgsrsp: entry
nnfgsrsp: Obtaining path parameter from names.directory_path or native_names.directory_path
nnfgsrsp: Parmeter names.directory_path not found, setting path to compiled in default
nnfgspd: entry
nnfgspd:     setting element TNSNAMES
nnfgspd:     setting element HOSTNAME
nnfgspd:     setting element EZCONNECT
nnfgspd:     setting element LDAP
nnfgspd: Path set
nnfgspd: exit
nnfun2a: entry
nlolgobj: entry
nnfgrne: entry
nnfgrne: Going though read path adapters
nnfgrne: Switching to TNSNAMES adapter
nnftboot: entry
nlpaxini: entry
nlpaxini: exit
nnftmlf_make_local_addrfile: entry
nnftmlf_make_local_addrfile: construction of local names file failed
nnftmlf_make_local_addrfile: exit
nlpaxini: entry
nlpaxini: exit
nnftmlf_make_system_addrfile: entry
nnftmlf_make_system_addrfile: system names file is /oracle/app/oracle/product/11.2/network/admin/tnsnames.ora
nnftmlf_make_system_addrfile: exit
nnftboot: exit
nnftrne: entry
nnftrne: Original name: paramb
nnfttran: entry
nnfttran: exit
nnftrne: Using tnsnames.ora address (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 133.37.116.101)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 133.37.116.100)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = paramb) (FAILOVER_MODE = (TYPE = select) (METHOD = basic) (RETRIES = 180) (DELAY = 5)))) for name paramb
nnftrne: exit
nnfgrne: exit
nlolgserv: entry
nnfggav: entry
nnftgav: entry
nnftgav: exit
nnfgfrm: entry
nnftfrm: entry
nnftfrm: exit
nnfgfrm: exit
nlolgserv: exit
nlolgobj: exit
nlolfmem: entry
nlolfmem: exit
nnfun2awanm: Getting the path of sqlnet.ora
nnfun2awanm: Getting the adapter name
nnfun2awanm: exit
snsgblini: exit
nsmal: 272 bytes at 0x1c552670
nscall: connecting...
snlinGetAddrInfo: entry
snlinGetAddrInfo: exit
snlinFreeAddrInfo: entry
snlinFreeAddrInfo: exit
snlinGetAddrInfo: entry
snlinGetAddrInfo: exit
snlinFreeAddrInfo: entry
snlinFreeAddrInfo: exit
nladini: entry
nladini: exit
nladget: entry
nladget: exit
nsmal: 190 bytes at 0x1c553ed0
nsc2addr: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=133.37.116.101)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=paramb)(FAILOVER_MODE=(TYPE=select)(METHOD=basic)(RETRIES=180)(DELAY=5))))
nttbnd2addr: entry
snlinGetAddrInfo: entry
snlinGetAddrInfo: exit
nttbnd2addr: using host IP address: 133.37.116.101
snlinFreeAddrInfo: entry
snlinFreeAddrInfo: exit
nttbnd2addr: exit
nsmal: 1528 bytes at 0x1c553fa0
nsmal: 2760 bytes at 0x1c5545a0
nsmal: 168 bytes at 0x1c555270
nsopen: opening transport...
nttcon: entry
nttcon: toc = 1
nttcnp: entry
nttcnp: exit
nttcni: entry
nttcni: Tcp conn timeout = 60000 (ms)
nttctl: entry
nttctl: Setting connection into non-blocking mode
nttcni: trying to connect to socket 5.
ntt2err: entry
ntt2err: exit
ntctst: size of NTTEST list is 1 - not calling poll
sntpoltst: exit
nttcni: TImeout or Error on this socket
nttcni: exit
nttcon: exit
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
nsopen: unable to open transport
nsvntx_dei: entry
nsvntx_dei: exit
nsmfr: 2760 bytes at 0x1c5545a0
nsmfr: 1528 bytes at 0x1c553fa0
nsmfr: 190 bytes at 0x1c553ed0
nscall: connecting...
nladget: entry
nladget: exit
nsmal: 190 bytes at 0x1c554b60
nsc2addr: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=133.37.116.100)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=paramb)(FAILOVER_MODE=(TYPE=select)(METHOD=basic)(RETRIES=180)(DELAY=5))))
nttbnd2addr: entry
snlinGetAddrInfo: entry
snlinGetAddrInfo: exit
nttbnd2addr: using host IP address: 133.37.116.100
snlinFreeAddrInfo: entry
snlinFreeAddrInfo: exit
nttbnd2addr: exit
nsmal: 1528 bytes at 0x1c554c30
nsmal: 2760 bytes at 0x1c557340
nsopen: opening transport...
nttcon: entry
nttcon: toc = 1
nttcnp: entry
nttcnp: exit
nttcni: entry
nttcni: Tcp conn timeout = 60000 (ms)
nttctl: entry
nttctl: Setting connection into non-blocking mode
nttcni: trying to connect to socket 5.
ntt2err: entry
ntt2err: exit
ntctst: size of NTTEST list is 1 - not calling poll
sntpoltst: exit
nttcni: TImeout or Error on this socket
nttcni: exit
nttcon: exit
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
nsopen: unable to open transport
nsvntx_dei: entry
nsvntx_dei: exit
nsmfr: 2760 bytes at 0x1c557340
nsmfr: 1528 bytes at 0x1c554c30
nsmfr: 190 bytes at 0x1c554b60
nscall: connecting...
nladget: entry
nladget: exit
nsmfr: 272 bytes at 0x1c552670
nladtrm: entry
nladtrm: exit
nlse_term_audit: entry
nlse_term_audit: exit

qq7343696

执行tnsping这个主机上面的防火墙已经关闭

Maclean Liu(刘相兵

tnsping   133.37.116.101:1521/paramb
试下

qq7343696

[oracle@CSBDB01 admin]$ tnsping 133.37.116.101:1521/paramb

TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 30-MAY-2013 20:33:52

Copyright (c) 1997, 2011, Oracle.  All rights reserved.

Used parameter files:

Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=paramb))(ADDRESS=(PROTOCOL=TCP)(HOST=133.37.116.101)(PORT=1521)))
TNS-12535: TNS:operation timed out
[oracle@CSBDB01 admin]$ tnsping 133.37.116.100:1521/paramb

TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 30-MAY-2013 20:35:00

Copyright (c) 1997, 2011, Oracle.  All rights reserved.

Used parameter files:

Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=paramb))(ADDRESS=(PROTOCOL=TCP)(HOST=133.37.116.100)(PORT=1521)))
TNS-12535: TNS:operation timed out
[oracle@CSBDB01 admin]$ telnet 133.37.116.101 1521
Trying 133.37.116.101...

32154358

可否贴一下你的
/etc/hosts
/etc/selinux/config

qq7343696

直接用的IP地址，所以跟/etc/hosts文件问题没有关系。另外selinux为disable

32154358

selinux为disable,应该可以排除。
不过还是贴一下/etc/hosts看看，因为遇到过这种问题。

qq7343696

这个是tnsping端的hosts文件
我把主机名与IP地址改 一下：
[oracle@Cabcd1 htz]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1               localhost.localdomain localhost
::1             localhost6.localdomain6 localhost6
123.123.123.86   Cabcd1
123.123.123.87   Cabcd2
123.123.123.88   Cabcd1-vip
123.123.123.89   Cabcd2-vip
123.123.123.85   csb-scan
1.1.1.133       Cabcd1-priv
1.1.1.134       Cabcd2-priv

133.37.93.165           dc3

qq7343696

感觉是网络问题，已经叫他们分析网络。

32154358

等待网络分析后再看。