Gooora

0 积分	0 好友	8 主题

发消息

[Exadata常规管理] 客户端无法通过scan连上数据库

1^#

发表于 2013-5-15 16:03:26 | 查看: 3604| 回复: 4

环境：系统RHEL5u4 x86_64，GI和database版本：11gR2（11.2.0.1.0）两节点RAC，客户端11gR2(11.2.0.3.0)
服务器上的/etc/hosts文件
#Public
192.168.1.80  rac1.example.com  rac1
192.168.1.81  rac2.example.com  rac2
#Private
10.1.1.250    rac1-priv.example.com rac1-priv
10.1.1.251    rac2-priv.example.com rac2-priv
#Virtual
192.168.1.82  rac1-vip.example.com rac1-vip
192.168.1.83  rac2-vip.example.com rac2-vip
#scan-IP
192.168.1.84 orcl-scan.example.com  orcl-scan
#######################################
/g01/app/11.2.0/grid/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=ON             # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON             # line added by Agent
####################################################################
[grid@rac1 ~]$ lsnrctl stat LISTENER_SCAN1

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 15-MAY-2013 16:02:25

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
STATUS of the LISTENER
------------------------
Alias                   LISTENER_SCAN1
Version                TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date             15-MAY-2013 15:00:15
Uptime                   0 days 1 hr. 2 min. 9 sec
Trace Level             off
Security                ON: Local OS Authentication
SNMP                   OFF
Listener Parameter File /var/app/11.2.0/grid/network/admin/listener.ora
Listener Log File       /var/app/11.2.0/grid/log/diag/tnslsnr/rac1/listener_scan1/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.84)(PORT=1521)))
Services Summary...
Service "orcl" has 2 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
  Instance "orcl2", status READY, has 1 handler(s) for this service...
The command completed successfully
#######################################################################
客户端上的tnsname.ora
ORCL =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = orcl-scan)(PORT = 1521))
(CONNECT_DATA =
   (SERVER = DEDICATED)
   (SERVICE_NAME = orcl)
)
  )
客户端上ping orcl-scan没问题
tnsping orcl没问题
#####################################
通过vip可以访问
##################
在oracle服务器上，
sqlplus system@orcl 可以访问
##################
客户端访问报错
ERROR:
ORA-12545: 因目标主机或对象不存在, 连接失败

分享0