急,求助scan ip为何无法连接?

[复制链接]
查看11 | 回复6 | 2011-11-1 16:20:28 | 显示全部楼层 |阅读模式
刚在redhat5.4上安装好oracle11.2 rac,但从客户端(服务器没问题)连接报没有监听,DNS已经配置好的,有二个问题请教一下:1、为什么只监听上只有一个实例?
2、就算一个实例,我直接配tns连接scan ip或二个主机的vip也是应该能连的吧?为什么一样报没有监听?
CEP_DB_01-> lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 27-MAR-2013 09:22:54
Copyright (c) 1991, 2009, Oracle.All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias
LISTENER
Version
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date
26-MAR-2013 17:40:41
Uptime
0 days 15 hr. 42 min. 13 sec
Trace Level
off
Security
ON: Local OS Authentication
SNMP
OFF
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/CEP_DB_01/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.212.51.29)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.212.51.51)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "streams" has 1 instance(s).
Instance "streams1", status READY, has 1 handler(s) for this service...
Service "streamsXDB" has 1 instance(s).
Instance "streams1", status READY, has 1 handler(s) for this service...
The command completed successfully
CEP_DB_01-> cat /u01/app/11.2.0/grid/network/admin/listener.ora
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))))
# line added by Agent
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))
# line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON
# line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON
# line added by Agent
CEP_DB_01->
SQL> show parameterremote_listener
NAME
TYPE
VALUE
------------------------------------ --------------------------------- ------------------------------
remote_listener
string
scan-cluster:1521
SQL>
CEP_DB_01-> srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node cep_db_01
CEP_DB_01-> srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node cep_db_01
CEP_DB_01->

TNS:
streams-scan =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.212.51.53)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = streams)
)
)

CEP_DB_01-> cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost
10.212.51.29CEP_DB_01 loghost
10.212.51.30CEP_DB_02
10.212.51.51CEP_DB_01-vip
10.212.51.52CEP_DB_02-vip
192.168.20.11 CEP_DB_01-priv
192.168.20.12 CEP_DB_02-priv
10.212.51.53scan-cluster
CEP_DB_01->

回复

使用道具 举报

千问 | 2011-11-1 16:20:28 | 显示全部楼层
我在服务器上CEP_DB_01-> tnsping streams-scan
...
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.212.51.53)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = streams)))
OK (0 msec)
在其他主机上/opt/oracle/db/network/admin> tnsping streams-scan
...
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.212.51.53)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = streams)))
TNS-12541: TNS:no listener
完全相同的配置
回复

使用道具 举报

千问 | 2011-11-1 16:20:28 | 显示全部楼层
直接 PING 能ping的通么?
回复

使用道具 举报

千问 | 2011-11-1 16:20:28 | 显示全部楼层
1.你的每台主机上都只有一个数据库实例。。。。两台主机上的监听分别监听的
2.第二台主机使用sid连接试试吧,参考一下这篇
http://www.itpub.net/thread-1702865-2-1.html
回复

使用道具 举报

千问 | 2011-11-1 16:20:28 | 显示全部楼层
这个测试不了,我们这边都是禁ping的
回复

使用道具 举报

千问 | 2011-11-1 16:20:28 | 显示全部楼层
xfind 发表于 2013-3-27 10:52
这个测试不了,我们这边都是禁ping的

telnet对scan:1521试试
回复

使用道具 举报

千问 | 2011-11-1 16:20:28 | 显示全部楼层
xfind 发表于 2013-3-27 10:05
我在服务器上CEP_DB_01-> tnsping streams-scan
...
Used TNSNAMES adapter to resolve the alias

1.用域名试试
2.连接VIP可以成功吗
3.看一下crs_stat 的状态
4.想办法确定网络是否有问题
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行