SCAN_IP是Oracle11g R2引入的单一客户端访问名称,通通过集群数据库配置简化客户端网络连接文件的管理。
前段时间因为修改了其中一个节点的IP,把这个IP作为scan_ip,具体的操作写下来记一下。
修改及增加scan_ip无需重启数据库及crs
主要是增加一个scan_ip。
1、修改hosts
原hosts(只有一个scan_ip)
192.168.1.10 rac-cluster-scan
修改后hosts(增加一个scan_ip)
192.168.1.10 rac-cluster-scan
192.168.1.20 rac-cluster-scan
全部节点都要修改
2、停止scan_listener及scan应用
为方便均使用root用户,记得$GRID_HOME/bin加入到root用户的PATH里面
srvctl stop scan_listener
srvctl stop scan
3、删除原有的scan_listener及scan
srvctl remove scan_listener
srvctl remove scan
4、添加新的scan及scan_listener
srvctl add scan
srvctl add scan_listener
5、启动scan及scan_listener
srvctl start scan
srvctl start scan_listener
6、检查scan及scan_listener
srvctl config scan
SCAN name: rac-cluster-scan, Network: 1/192.168.1.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /rac-cluster-scan/192.168.1.10
SCAN VIP name: scan2, IP: /rac-cluster-scan/192.168.1.20
crsctl stat res -t查看LISTENER
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.DG.dg
OFFLINE OFFLINE rac1
ONLINE OFFLINE rac2
ora.LISTENER.lsnr
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.MAGIC.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.OCR.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.asm
ONLINE ONLINE rac1 Started
ONLINE ONLINE rac2 Started
ora.gsd
OFFLINE OFFLINE rac1
OFFLINE OFFLINE rac2
ora.net1.network
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.ons
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.registry.acfs
ONLINE ONLINE rac1
ONLINE ONLINE rac2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac2
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE rac1
ora.cvu
1 ONLINE ONLINE rac1
ora.magic.db
1 ONLINE ONLINE rac1 Open
2 ONLINE ONLINE rac2 Open
ora.oc4j
1 ONLINE ONLINE rac1
ora.rac1.vip
1 ONLINE ONLINE rac1
ora.rac2.vip
1 ONLINE ONLINE rac2
ora.scan1.vip
1 ONLINE ONLINE rac2
ora.scan2.vip
1 ONLINE ONLINE rac1
节点1切换至grid用户:lsnrctl status LISTENER_SCAN1
节点2切换至grid用户:lsnrctl status LISTENER_SCAN2
查看实例是否已注册至scan_listener
8、如果把scan_ip对应的hostname也进行了改动,则需要进数据库重新声明参数remote_listener
REMOTE_LISTENER : 类似LOCAL_LISTENER参数,实例通过ROMOTE_LISTENER参数指明的hostname,动态向SCAN监听器注册。
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on 星期五 12月 19 11:22:59 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> show parameter remote_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_listener string rac-cluster-scan:1521
SQL> alter system set remote_listener='rac-cluster-scan:1521' scope=both;
和local_listener一样remote_listener也可以只在某一个节点起作用
例如: alter system set remote_listener=' rac-cluster-scan:1521' scope=both sid=rac1;
声明以后数据库实例会动态注册至scan_listener
前段时间因为修改了其中一个节点的IP,把这个IP作为scan_ip,具体的操作写下来记一下。
修改及增加scan_ip无需重启数据库及crs
主要是增加一个scan_ip。
1、修改hosts
原hosts(只有一个scan_ip)
192.168.1.10 rac-cluster-scan
修改后hosts(增加一个scan_ip)
192.168.1.10 rac-cluster-scan
192.168.1.20 rac-cluster-scan
全部节点都要修改
2、停止scan_listener及scan应用
为方便均使用root用户,记得$GRID_HOME/bin加入到root用户的PATH里面
srvctl stop scan_listener
srvctl stop scan
3、删除原有的scan_listener及scan
srvctl remove scan_listener
srvctl remove scan
4、添加新的scan及scan_listener
srvctl add scan
srvctl add scan_listener
5、启动scan及scan_listener
srvctl start scan
srvctl start scan_listener
6、检查scan及scan_listener
srvctl config scan
SCAN name: rac-cluster-scan, Network: 1/192.168.1.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /rac-cluster-scan/192.168.1.10
SCAN VIP name: scan2, IP: /rac-cluster-scan/192.168.1.20
crsctl stat res -t查看LISTENER
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.DG.dg
OFFLINE OFFLINE rac1
ONLINE OFFLINE rac2
ora.LISTENER.lsnr
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.MAGIC.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.OCR.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.asm
ONLINE ONLINE rac1 Started
ONLINE ONLINE rac2 Started
ora.gsd
OFFLINE OFFLINE rac1
OFFLINE OFFLINE rac2
ora.net1.network
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.ons
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.registry.acfs
ONLINE ONLINE rac1
ONLINE ONLINE rac2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac2
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE rac1
ora.cvu
1 ONLINE ONLINE rac1
ora.magic.db
1 ONLINE ONLINE rac1 Open
2 ONLINE ONLINE rac2 Open
ora.oc4j
1 ONLINE ONLINE rac1
ora.rac1.vip
1 ONLINE ONLINE rac1
ora.rac2.vip
1 ONLINE ONLINE rac2
ora.scan1.vip
1 ONLINE ONLINE rac2
ora.scan2.vip
1 ONLINE ONLINE rac1
节点1切换至grid用户:lsnrctl status LISTENER_SCAN1
节点2切换至grid用户:lsnrctl status LISTENER_SCAN2
查看实例是否已注册至scan_listener
8、如果把scan_ip对应的hostname也进行了改动,则需要进数据库重新声明参数remote_listener
REMOTE_LISTENER : 类似LOCAL_LISTENER参数,实例通过ROMOTE_LISTENER参数指明的hostname,动态向SCAN监听器注册。
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on 星期五 12月 19 11:22:59 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> show parameter remote_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_listener string rac-cluster-scan:1521
SQL> alter system set remote_listener='rac-cluster-scan:1521' scope=both;
和local_listener一样remote_listener也可以只在某一个节点起作用
例如: alter system set remote_listener=' rac-cluster-scan:1521' scope=both sid=rac1;
声明以后数据库实例会动态注册至scan_listener
至此scan_ip增加及修改完毕。
修改与增加类似,停止,删除,添加,启动,声明,最后实例动态注册至服务。 一般两个节点如果是两个scan_ip,那么oracle会在启动scan的时候在每一个节点虚拟一个scan_ip出来。 |