tnsping时vip能通,public ip报错无监听
出问题的是节点一,节点二的vip和public ip都能tnsping通,麻烦有时间帮忙看看,非常感谢!系统版本:
$ uname -a
AIX GDGZ-PS-ESB-DB01-P780 1 6 00F7341E4C00
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
监听状态:
$ ps -ef |grep lsnr
grid 12320894 1 0 Nov 16 - 65:55 /oracle/app/crs/bin/tnslsnr LISTENER -inherit
grid 13041848 1 0 Nov 26 -4:06 /oracle/app/crs/bin/tnslsnr LISTENER_SCAN1 -inherit
grid 27656270 25559294 0 14:24:43pts/00:00 grep lsnr
$ lsnrctl status LISTENER
LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production on 16-MAR-2014 14:22:22
Copyright (c) 1991, 2010, Oracle.All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production
Start Date 16-NOV-2013 09:08:47
Uptime 120 days 5 hr. 13 min. 35 sec
Trace Level off
Security ON: Password or Local OS Authentication
SNMP ON
Listener Parameter File /oracle/app/crs/network/admin/listener.ora
Listener Log File /oracle/app/grid/diag/tnslsnr/GDGZ-PS-ESB-DB01-P780/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.5.15)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "oltp" has 1 instance(s).
Instance "oltp1", status READY, has 1 handler(s) for this service...
Service "oltpXDB" has 1 instance(s).
Instance "oltp1", status READY, has 1 handler(s) for this service...
The command completed successfully
$ lsnrctl status LISTENER_SCAN1
LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production on 16-MAR-2014 14:22:27
Copyright (c) 1991, 2010, Oracle.All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
STATUS of the LISTENER
------------------------
Alias LISTENER_SCAN1
Version TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production
Start Date 26-NOV-2013 15:48:02
Uptime 109 days 22 hr. 34 min. 25 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /oracle/app/crs/network/admin/listener.ora
Listener Log File /oracle/app/crs/log/diag/tnslsnr/GDGZ-PS-ESB-DB01-P780/listener_scan1/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.5.17)(PORT=1521)))
Services Summary...
Service "oltp" has 2 instance(s).
Instance "oltp1", status READY, has 1 handler(s) for this service...
Instance "oltp2", status READY, has 1 handler(s) for this service...
Service "oltpXDB" has 2 instance(s).
Instance "oltp1", status READY, has 1 handler(s) for this service...
Instance "oltp2", status READY, has 1 handler(s) for this service...
The command completed successfully
$ cat /oracle/app/crs/network/admin/listener.ora
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
TNSNAMES配置及测试结果:
OLTP1_public_test =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.5.13)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oltp)
)
)
OLTP1_vip_test =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.5.15)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oltp)
)
)
OLTP1_scan_test =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.5.17)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oltp)
)
)
$ tnsping OLTP1_public_test
TNS Ping Utility for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production on 16-MAR-2014 14:17:58
Copyright (c) 1997, 2010, Oracle.All rights reserved.
Used parameter files:
/oracle/app/products/11.2/db/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.5.13)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oltp)))
TNS-12541: TNS:no listener
$ tnsping OLTP1_vip_test
TNS Ping Utility for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production on 16-MAR-2014 14:18:03
Copyright (c) 1997, 2010, Oracle.All rights reserved.
Used parameter files:
/oracle/app/products/11.2/db/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.5.15)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oltp)))
OK (0 msec)
$ tnsping OLTP1_scan_test
TNS Ping Utility for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production on 16-MAR-2014 14:19:19
Copyright (c) 1997, 2010, Oracle.All rights reserved.
Used parameter files:
/oracle/app/products/11.2/db/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.5.17)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oltp)))
OK (0 msec)
网卡信息:
$ ifconfig -a
en0: flags=1e080863,480<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),CHAIN>
inet 192.168.5.13 netmask 0xffffff00 broadcast 192.168.5.255
inet 192.168.5.17 netmask 0xffffff00 broadcast 192.168.5.255
inet 192.168.5.15 netmask 0xffffff00 broadcast 192.168.5.255
tcp_sendspace 262144 tcp_recvspace 262144 rfc1323 1
en2: flags=1e080863,480<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),CHAIN>
inet 192.168.65.8 netmask 0xffffff00 broadcast 192.168.65.255
inet 169.254.101.30 netmask 0xffff0000 broadcast 169.254.255.255
tcp_sendspace 262144 tcp_recvspace 262144 rfc1323 1
lo0: flags=e08084b,c0<UP,BROADCAST,LOOPBACK,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,LARGESEND,CHAIN>
inet 127.0.0.1 netmask 0xff000000 broadcast 127.255.255.255
inet6 ::1%1/0
tcp_sendspace 131072 tcp_recvspace 131072 rfc1323 1
SQLNET配置
$ cat /oracle/app/products/11.2/db/network/admin/sqlnet.ora
SQLNET.EXPIRE_TIME=1440
$ cat /oracle/app/crs/network/admin/sqlnet.ora
# sqlnet.ora.gdgz-ps-esb-db01-p780 Network Configuration File: /oracle/app/crs/network/admin/sqlnet.ora.gdgz-ps-esb-db01-p780
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
ADR_BASE = /oracle/app/grid
肯定报无监听啊 !你看下监听listener的配置
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.5.15)(PORT=1521)))
这里明明只监听了192.168.5.15 这个IP啊
把这个文件/oracle/app/crs/network/admin/listener.ora 贴出来
这个贴出来了
$ cat /oracle/app/crs/network/admin/listener.ora
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent Public IP Endpoint is not registered for Listener in 11.2 RAC (Doc ID 1597716.1)
看下这个文章 1. 提供你的hosts文件
more /etc/hosts
2. ping hostname
ping ·hostname· $ cat /etc/hosts
# @(#)47 1.2src/bos/usr/sbin/netstart/hosts, cmdnet, bos61D, d2007_49A2 10/1/07 13:57:52
# IBM_PROLOG_BEGIN_TAG
# This is an automatically generated prolog.
#
# bos61D src/bos/usr/sbin/netstart/hosts 1.2
#
# Licensed Materials - Property of IBM
#
# COPYRIGHT International Business Machines Corp. 1985,1989
# All Rights Reserved
#
# US Government Users Restricted Rights - Use, duplication or
# disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
#
# IBM_PROLOG_END_TAG
#
# COMPONENT_NAME: TCPIP hosts
#
# FUNCTIONS: loopback
#
# ORIGINS: 2627
#
# (C) COPYRIGHT International Business Machines Corp. 1985, 1989
# All Rights Reserved
# Licensed Materials - Property of IBM
#
# US Government Users Restricted Rights - Use, duplication or
# disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
#
#/etc/hosts
#
# This file contains the hostnames and their address for hosts in the
# network.This file is used to resolve a hostname into an Internet
# address.
#
# At minimum, this file must contain the name and address for each
# device defined for TCP in your /etc/net file.It may also contain
# entries for well-known (reserved) names such as timeserver
# and printserver as well as any other host name and address.
#
# The format of this file is:
# Internet Address Hostname # Comments
# Internet Address can be either IPv4 or IPv6 address.
# Items are separated by any number of blanks and/or tabs.A '#'
# indicates the beginning of a comment; characters up to the end of the
# line are not interpreted by routines which search this file.Blank
# lines are allowed.
# Internet Address Hostname # Comments
# 192.9.200.1 net0sample # ethernet name/address
# 128.100.0.1 token0sample # token ring name/address
# 10.2.0.2 x25sample # x.25 name/address
# 2000:1:1:1:209:6bff:feee:2b7f ipv6sample # ipv6 name/address
127.0.0.1 loopback localhost # loopback (lo0) name/address
192.168.1.82 c2
192.168.1.99 Nimserver
192.168.1.201 c2
192.168.5.131 c2
192.168.5.15 c2
#192.168.65.8 c2
#10.201.39.112c2
192.168.5.13 GDGZ-PS-ESB-DB01-P780 GDGZ-PS-ESB-DB01-P780_beifen
192.168.5.15 GDGZ-PS-ESB-DB01-P780-VIP
192.168.65.8 GDGZ-PS-ESB-DB01-P780-PRIV
192.168.5.14 GDGZ-PS-ESB-DB02-P780 GDGZ-PS-ESB-DB02-P780_beifen
192.168.5.16 GDGZ-PS-ESB-DB02-P780-VIP
192.168.65.9 GDGZ-PS-ESB-DB02-P780-PRIV
192.168.5.17 GDGZ-PS-ESB-DB-780-SCAN
192.168.37.4 nmgc.gmcc.net
10.201.39.134 unmp.gmcc.net
192.168.82.7 uspms-mge03
###nbu master###
10.201.29.228 gdgz-ps-nbus-app01
$ ping GDGZ-PS-ESB-DB01-P780
PING GDGZ-PS-ESB-DB01-P780 (192.168.5.13): 56 data bytes
64 bytes from 192.168.5.13: icmp_seq=0 ttl=255 time=0 ms
64 bytes from 192.168.5.13: icmp_seq=1 ttl=255 time=0 ms
64 bytes from 192.168.5.13: icmp_seq=2 ttl=255 time=0 ms
64 bytes from 192.168.5.13: icmp_seq=3 ttl=255 time=0 ms
64 bytes from 192.168.5.13: icmp_seq=4 ttl=255 time=0 ms
64 bytes from 192.168.5.13: icmp_seq=5 ttl=255 time=0 ms
1.ls -l /etc/hosts 看看权限是否正确
2. oraagent_grid.log日志上传 看下 $ ls -lrt /etc/hosts
-rw-rw-r-- 1 root system 2529 Jun 17 2013/etc/hosts oraagent_grid.log $ crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGETSTATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRSDG.dg
ONLINEONLINE gdgz-ps-esb-db01-p780
ONLINEONLINE gdgz-ps-esb-db02-p780
ora.DATA.dg
ONLINEONLINE gdgz-ps-esb-db01-p780
ONLINEONLINE gdgz-ps-esb-db02-p780
ora.LISTENER.lsnr
ONLINEONLINE gdgz-ps-esb-db01-p780
ONLINEONLINE gdgz-ps-esb-db02-p780
ora.asm
ONLINEINTERMEDIATE gdgz-ps-esb-db01-p780 CHECK TIMED OUT
ONLINEONLINE gdgz-ps-esb-db02-p780 Started
ora.gsd
OFFLINE OFFLINE gdgz-ps-esb-db01-p780
OFFLINE OFFLINE gdgz-ps-esb-db02-p780
ora.net1.network
ONLINEONLINE gdgz-ps-esb-db01-p780
ONLINEONLINE gdgz-ps-esb-db02-p780
ora.ons
ONLINEONLINE gdgz-ps-esb-db01-p780
ONLINEONLINE gdgz-ps-esb-db02-p780
ora.registry.acfs
ONLINEONLINE gdgz-ps-esb-db01-p780
ONLINEONLINE gdgz-ps-esb-db02-p780
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINEINTERMEDIATE gdgz-ps-esb-db01-p780
ora.cvu
1 ONLINEONLINE gdgz-ps-esb-db01-p780
ora.gdgz-ps-esb-db01-p780.vip
1 ONLINEUNKNOWN gdgz-ps-esb-db01-p780
ora.gdgz-ps-esb-db02-p780.vip
1 ONLINEONLINE gdgz-ps-esb-db02-p780
ora.oc4j
1 ONLINEONLINE gdgz-ps-esb-db01-p780
ora.oltp.db
1 ONLINEONLINE gdgz-ps-esb-db01-p780 Open
2 ONLINEONLINE gdgz-ps-esb-db02-p780 Open
ora.scan1.vip
1 ONLINEUNKNOWN gdgz-ps-esb-db01-p780
$ ps -ef |grep d.bin
root5046436 1 1 Nov 16 - 2448:39 /oracle/app/crs/bin/crsd.bin reboot
grid7864494 1 1 Nov 16 - 2074:25 /oracle/app/crs/bin/evmd.bin
root8060938 1 0 Nov 16 - 2335:51 /oracle/app/crs/bin/ohasd.bin reboot
grid8781840 1 0 Nov 16 -8:48 /oracle/app/crs/bin/mdnsd.bin
grid8912924 1 0 Nov 16 - 217:53 /oracle/app/crs/bin/gpnpd.bin
grid9175068 1 1 Nov 16 - 2191:38 /oracle/app/crs/bin/gipcd.bin
root9568340 1 0 Nov 16 - 2128:48 /oracle/app/crs/bin/octssd.bin reboot
grid96338349502754 2 Nov 16 - 3998:45 /oracle/app/crs/bin/ocssd.bin
grid 25624580 49873114 0 15:44:58pts/00:00 grep d.bin
root 46727224 1 0 Mar 14 -0:00 /oracle/app/crs/bin/crsd.bin reboot
页:
[1]
2