|
|
出问题的是节点一，节点二的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:43 pts/0 0: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
|
|
发表于 2014-3-16 14:29:35
发表于 2014-3-16 14:32:28
楼主
