问个RAC低级问题 [复制链接]

howard_zhang

注册会员

鸡肋

精华贴数: 0
技术积分: 14150
社区积分: 87
注册时间: 2006-9-15

论坛徽章:: 62

发表于 2007-6-8 11:41:15 |显示全部楼层

环境10G + AIX
$ crs_stat -t
Name          Type          Target State    Host
------------------------------------------------------------
ora.ossdb.db application ONLINE ONLINE ossdb2
ora....b1.inst application ONLINE ONLINE ossdb1
ora....b2.inst application ONLINE ONLINE ossdb2
ora....B1.lsnr application ONLINE OFFLINE
ora.ossdb1.gsd application ONLINE ONLINE ossdb1
ora.ossdb1.ons application ONLINE ONLINE ossdb1
ora.ossdb1.vip application ONLINE ONLINE ossdb1
ora....B2.lsnr application ONLINE OFFLINE
ora.ossdb2.gsd application ONLINE ONLINE ossdb2
ora.ossdb2.ons application ONLINE ONLINE ossdb2
ora.ossdb2.vip application ONLINE ONLINE ossdb2
CRS的LSNROFFIINE会对数据库有什么影响?
它与数据库的监听器有和关系?

使用道具举报

lzfzl

注册会员

老会员

精华贴数: 0
技术积分: 1132
社区积分: 31
注册时间: 2004-6-22

论坛徽章:: 3

发表于 2007-6-8 11:54:42 |显示全部楼层

监听器没有启动，数据库服务器以外的oracle客户端不能建立连接

使用道具举报

howard_zhang

注册会员

鸡肋

精华贴数: 0
技术积分: 14150
社区积分: 87
注册时间: 2006-9-15

论坛徽章:: 62

发表于 2007-6-8 12:06:27 |显示全部楼层

你的意思是RAC CRS的监听还是数据库的监听?
现在看数据库的监听器是很正常的

使用道具举报

howard_zhang

注册会员

鸡肋

精华贴数: 0
技术积分: 14150
社区积分: 87
注册时间: 2006-9-15

论坛徽章:: 62

发表于 2007-6-8 13:08:49 |显示全部楼层

Alias                   LISTENER
Version                TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production
Start Date             20-MAR-2007 16:55:16
Uptime                   79 days 20 hr. 8 min. 40 sec
Trace Level             off
Security                ON: Local OS Authentication
SNMP                   ON
Listener Parameter File /oracle/app/product/10gr2/network/admin/listener.ora
Listener Log File       /oracle/app/product/10gr2/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xx)(PORT=1521)))
Services Summary...
Service "ossdb" has 2 instance(s).
  Instance "ossdb1", status READY, has 2 handler(s) for this service...
  Instance "ossdb2", status READY, has 1 handler(s) for this service...
Service "ossdbXDB" has 2 instance(s).
  Instance "ossdb1", status READY, has 1 handler(s) for this service...
  Instance "ossdb2", status READY, has 1 handler(s) for this service...
Service "ossdb_XPT" has 2 instance(s).
  Instance "ossdb1", status READY, has 2 handler(s) for this service...
  Instance "ossdb2", status READY, has 1 handler(s) for this service...
The command completed successfully
$
这个是监听的状态

使用道具举报