请选择 进入手机版 | 继续访问电脑版

ORACLE SOS

 找回密码
 立即注册

QQ登录

只需一步,快速开始

搜索
查看: 4034|回复: 2

11gr2 RAC SCAN添加IP失败【已解决】

[复制链接]

5

主题

16

帖子

74

积分

注册会员

Rank: 2

积分
74
发表于 2014-3-25 10:51:50 | 显示全部楼层 |阅读模式
本帖最后由 Fung920 于 2014-3-25 11:11 编辑

问题描述:
原来scan为hosts解析,改为DNS并且添加至三个SCAN VIPs,但是后面添加的IP无法添加进SCAN里面,步骤如下:
1.DNS正反向解析:
[grid@node1:/home/grid]$ host racdb-scan
racdb-scan.oraclema.com has address 192.168.56.112
racdb-scan.oraclema.com has address 192.168.56.110
racdb-scan.oraclema.com has address 192.168.56.111
[grid@node1:/home/grid]$ nslookup racdb-scan
Server:         192.168.56.101
Address:        192.168.56.101#53

Name:   racdb-scan.oraclema.com
Address: 192.168.56.111
Name:   racdb-scan.oraclema.com
Address: 192.168.56.112
Name:   racdb-scan.oraclema.com
Address: 192.168.56.110

[grid@node1:/home/grid]$ nslookup 192.168.56.112
Server:         192.168.56.101
Address:        192.168.56.101#53

112.56.168.192.in-addr.arpa     name = racdb-scan.oraclema.com.
112.56.168.192.in-addr.arpa     name = racdb-scan.


2.现有SCAN及SCAN监听配置:
[grid@node1:/home/grid]$ srvctl config scan
SCAN name: racdb-scan, Network: 1/192.168.56.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /racdb-scan/192.168.56.110
[grid@node1:/home/grid]$ srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521

3.根据MOS ID 952903.1修改SCAN信息:
[grid@node1:/home/grid]$ srvctl stop scan_listener
[grid@node1:/home/grid]$ srvctl stop scan
[grid@node1:/home/grid]$ which srvctl
/u01/app/11gr2/grid/bin/srvctl
[root@node1:/root]# /u01/app/11gr2/grid/bin/srvctl modify scan -n racdb-scan
[root@node1:/root]# /u01/app/11gr2/grid/bin/srvctl modify scan_listener -u

4.修改完后查看SCAN配置信息,发现仍然没有改变:
[grid@node1:/home/grid]$ srvctl config scan
SCAN name: racdb-scan, Network: 1/192.168.56.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /racdb-scan/192.168.56.110



[grid@node1:/home/grid]$ srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521

[grid@node1:/home/grid]$ srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node node1

依然是只有一个IP,只有一个SCAN监听,有解吗?

回复

使用道具 举报

4

主题

46

帖子

259

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
259
发表于 2014-3-25 11:07:16 | 显示全部楼层
你的host 文件没改吧 。把scan ip信息去掉



  1. 1、查看当前配置
  2.         [grid@rac1 ~]$ srvctl status scan
  3.         SCAN VIP scan1 is enabled
  4.         SCAN VIP scan1 is running on node rac2

  5.         [grid@rac1 ~]$ srvctl status scan_listener
  6.         SCAN Listener LISTENER_SCAN1 is enabled
  7.         SCAN listener LISTENER_SCAN1 is running on node rac2

  8.         [grid@rac1 ~]$ srvctl config scan
  9.         SCAN name: rac-scan, Network: 1/192.168.2.0/255.255.255.0/eth0
  10.         SCAN VIP name: scan1, IP: /rac-scan.localdomain/192.168.2.201

  11.         [grid@rac1 ~]$ srvctl config scan_listener
  12.         SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521

  13.         --host文件
  14.         [grid@rac1 ~]$ more /etc/hosts
  15.         # Public
  16.         192.168.2.101 rac1.localdomain rac1
  17.         192.168.2.102 rac2.localdomain rac2
  18.         # Private
  19.         192.168.0.101 rac1-priv.localdomain rac1-priv
  20.         192.168.0.102 rac2-priv.localdomain rac2-priv
  21.         # Virtual
  22.         192.168.2.111 rac1-vip.localdomain rac1-vip
  23.         192.168.2.112 rac2-vip.localdomain rac2-vip
  24.         # SCAN
  25.         192.168.2.201 rac-scan.localdomain rac-scan
  26.         [grid@rac1 ~]$


  27.         Validating SCAN on second Node


  28.         [grid@rac2 ~]$ srvctl status scan
  29.         SCAN VIP scan1 is enabled
  30.         SCAN VIP scan1 is running on node rac2

  31.         [grid@rac2 ~]$ srvctl status scan_listener
  32.         SCAN Listener LISTENER_SCAN1 is enabled
  33.         SCAN listener LISTENER_SCAN1 is running on node rac2

  34.         [grid@rac2 ~]$ srvctl config scan
  35.         SCAN name: rac-scan, Network: 1/192.168.2.0/255.255.255.0/eth0
  36.         SCAN VIP name: scan1, IP: /rac-scan.localdomain/192.168.2.201

  37.         [grid@rac2 ~]$ srvctl config scan_listener
  38.         SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521


  39. 2、停止scan


  40.         [grid@rac1 ~]$ srvctl stop scan_listener

  41.         [grid@rac1 ~]$ srvctl stop scan

  42.         [grid@rac1 ~]$ srvctl status scan
  43.         SCAN VIP scan1 is enabled
  44.         SCAN VIP scan1 is not running

  45.         [grid@rac1 ~]$ srvctl status scan_listener
  46.         SCAN Listener LISTENER_SCAN1 is enabled
  47.         SCAN listener LISTENER_SCAN1 is not running

  48.         [grid@rac1 ~]$ srvctl config scan
  49.         SCAN name: rac-scan, Network: 1/192.168.2.0/255.255.255.0/eth0
  50.         SCAN VIP name: scan1, IP: /rac-scan.localdomain/192.168.2.201

  51.         [grid@rac1 ~]$ srvctl config scan_listener
  52.         SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521

  53.         [grid@rac1 ~]$



  54. 3、修改host 文件和dns 解析

  55. 4、修改


  56.         [root@rac1 ~]# srvctl modify scan -n rac-scan

  57.         [root@rac1 ~]# srvctl config scan
  58.         SCAN name: rac-scan, Network: 1/192.168.2.0/255.255.255.0/eth0
  59.         SCAN VIP name: scan1, IP: /rac-scan.localdomain/192.168.2.121
  60.         SCAN VIP name: scan2, IP: /rac-scan.localdomain/192.168.2.122
  61.         SCAN VIP name: scan3, IP: /rac-scan.localdomain/192.168.2.123

  62.         [root@rac1 ~]# srvctl modify scan_listener –u

  63.         [root@rac1 ~]# srvctl config scan_listener
  64.         SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521
  65.         SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1521
  66.         SCAN Listener LISTENER_SCAN3 exists. Port: TCP:1521


  67. 5、启动
  68.         [root@rac1 ~]# srvctl start scan

  69.         [root@rac1 ~]# srvctl start scan_listener

  70. 6、检查

  71.         [root@rac1 ~]# srvctl status scan
  72.         SCAN VIP scan1 is enabled
  73.         SCAN VIP scan1 is running on node rac2
  74.         SCAN VIP scan2 is enabled
  75.         SCAN VIP scan2 is running on node rac1
  76.         SCAN VIP scan3 is enabled
  77.         SCAN VIP scan3 is running on node rac1

  78.         [root@rac1 ~]# srvctl status scan_listener
  79.         SCAN Listener LISTENER_SCAN1 is enabled
  80.         SCAN listener LISTENER_SCAN1 is running on node rac2
  81.         SCAN Listener LISTENER_SCAN2 is enabled
  82.         SCAN listener LISTENER_SCAN2 is running on node rac1
  83.         SCAN Listener LISTENER_SCAN3 is enabled
  84.         SCAN listener LISTENER_SCAN3 is running on node rac1
复制代码
-------------------------------------------
Travel
长路漫漫, 所思在远道
Email:travel.liu@outlook.com
www.traveldba.com
--------------------------------------------
回复 支持 1 反对 0

使用道具 举报

5

主题

16

帖子

74

积分

注册会员

Rank: 2

积分
74
 楼主| 发表于 2014-3-25 11:12:00 | 显示全部楼层
travel.liu 发表于 2014-3-25 11:07
你的host 文件没改吧 。把scan ip信息去掉

正是,忘记屏蔽掉原有信息了,
回复 支持 反对

使用道具 举报

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

本版积分规则

QQ|Archiver|手机版|ORACLE SOS 技术论坛

GMT+8, 2022-1-21 22:29 , Processed in 0.018106 second(s), 21 queries .

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表