11gR2 集群(CRS/GRID)新功能SCAN(Single Client Access Name
本文参考链接:https://blogs.oracle.com/ 回顾 ------------------- 本文简单的介绍一下11gR2集群(CRS/GRID)新功能SCAN(Single Client Access Name),希望对于刚刚接触11gR2的朋友有一些帮助。 在介绍SCAN之前,先简单的回顾一下oracle关于IP地址的使用,在9
回顾
-------------------
SCAN简介
-------------------
客户端如何通过SCAN访问数据库
-------------------------------------------
客户端tnsnames.ora的配置
-------------------------------------------
RAC =
(DESCRIPTION =
客户端的连接方式
-------------------------------------------
$ sqlplsu /@RAC
EZconnet的连接仍然适用于SCAN
$ sqlplus /@rac-cluster-scan:1521/rac
常用命令
-----------------------
1. 查看SCAN配置信息
$ srvctl config scan
SCAN name: rac-cluster-scan, Network: 1/192.168.1.0/255.255.255.0/
SCAN VIP name: scan1, IP: /rac-cluster-scan/192.168.1.12
SCAN VIP name: scan2, IP: /rac-cluster-scan/192.168.1.13
SCAN VIP name: scan3, IP: /rac-cluster-scan/192.168.1.14
2. 查看SCAN Listener配置信息
$ srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521
SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1521
SCAN Listener LISTENER_SCAN3 exists. Port: TCP:1521
3. 查看SCAN的状态
$ srvctl status scan
4. 查看SCAN listener的状态
$ srvctl status scan_listener
常用文档
------------------
SCAN介绍
www.oracle.com/technetwork/testcontent/scan-098460.html
ORACLE SUPPORT网站上查看下面2篇文章,都是关于SCAN的介绍,希望能够帮助您理解关于SCAN的问题:
11gR2 Grid Infrastructure Single Client Access Name (SCAN) Explained (Doc ID 887522.1)
How to Setup SCAN Listener and Client for TAF and Load Balancing [Video] (Doc ID 1188736.1)
集群(GRID/CRS)的安装和管理文档:
http://docs.oracle.com/cd/E11882_01/install.112/e22489/toc.htm
http://docs.oracle.com/cd/E11882_01/rac.112/e16794/toc.htm
RAC的安装和管理文档:
http://docs.oracle.com/cd/E11882_01/install.112/e24660/toc.htm
http://docs.oracle.com/cd/E11882_01/rac.112/e16795/toc.htm
上一篇: Mysql 主从同步简单配置_MySQL