RAC的搭建
2022-02-26
来源：独旅网
Bluefox 夏开怀 2012.12 Oracle 10g RAC安装 一、RAC环境信息 1、实验平台 操作系统：RHEL 5.4 数据库软件：Oracle 10g 集群软件：oracle 10g R2 clusterware 虚拟机：VMware-server-installer-1.0.9 二、双节点RAC图 本例使用VM虚拟机模拟共享存储。 邮箱：lpf_315@163.com Bluefox 三、双节点信息 服务器主机名 Public IP(eth0) Virtual IP(eth0) Private IP(eth1) Oracle RAC SID 集群实例名称 OCR（oracle集群注册表） 夏开怀 node1 172.25.3.21 172.25.3.31 162.25.3.21 rac1 rac 2012.12 node2 172.25.3.22 172.25.3.32 162.25.3.22 rac2 /dev/raw/raw1 /dev/sdb1 200M /dev/raw/raw2 /dev/sdb2 200M /dev/raw/raw3 /dev/sdc1 200M /dev/raw/raw4 /dev/sdc2 200M /dev/raw/raw5 /dev/sdc3 200M /dev/sdd1 10G VOL1 for Oracle Data /dev/sdd1 5G VOL2 for Flash_recovery_area 表决磁盘（voting disk） ASM 四、安装流程 >安装虚拟机（vmware server 1.0.9） >安装操作系统(RHEL 5.4) >配置操作系统 >复制虚拟机 >配置双机信任关系 >安装clusterware软件 >安装database软件 >配置监听listener >建立数据库实例 >客户端TAF(transparent application failover)配置（透明切换） 五、安装过程 1、安装VMware-server-installer-1.0.9软件，新建一个虚拟机，命名为rac1，并添加4块磁盘与一块网卡。 磁盘属性改为 Votingdisk.vmdk(0.1G)(scsi1:1)(Independent) OCRdisk.vmdk(0.1G)(scsi1:2)(Independent) ASMdisk1(2G)(scsi1:3)(Independent) ASMdisk2(1G)(scsi1:4)(Independent) 网卡选桥接 2、安装RHEL 5.4操作系统，不详述 3、按oracle安装要求配置好Linux系统，/etc/hosts文件中加入6个IP [root@node1 ~]# tail -7 /etc/hosts 127.0.0.1 localhost.localdomain localhost 172.25.3.21 node1 172.25.3.22 node2 172.25.3.31 node1-vip 172.25.3.32 node2-vip 162.25.3.21 node1-priv 162.25.3.22 node2-priv 邮箱：lpf_315@163.com Bluefox 夏开怀 2012.12 [root@node1 ~]# fdisk -l Disk /dev/sda: 10.7 GB, 10737418240 bytes 255 heads, 63 sectors/track, 1305 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/sda1 * 1 1241 9968301 83 Linux /dev/sda2 1242 1305 514080 82 Linux swap / Solaris Disk /dev/sdb: 107 MB, 107374080 bytes 64 heads, 32 sectors/track, 102 cylinders Units = cylinders of 2048 * 512 = 1048576 bytes Device Boot Start End Blocks Id System /dev/sdb1 1 102 104432 83 Linux Disk /dev/sdc: 107 MB, 107374080 bytes 64 heads, 32 sectors/track, 102 cylinders Units = cylinders of 2048 * 512 = 1048576 bytes Device Boot Start End Blocks Id System /dev/sdc1 1 102 104432 83 Linux Disk /dev/sdd: 2147 MB, 2147483648 bytes 255 heads, 63 sectors/track, 261 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/sdd1 1 261 2096451 83 Linux Disk /dev/sde: 1073 MB, 1073741824 bytes 255 heads, 63 sectors/track, 130 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/sde1 1 130 1044193+ 83 Linux 4、安装ASM所需软件包 [root@node1 32bit]# rpm -ivh oracleasm-support-2.1.3-1.el5.i386.rpm warning: oracleasm-support-2.1.3-1.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159 Preparing... ########################################### [100%] 1:oracleasm-support ########################################### [100%] [root@node1 32bit]# rpm -ivh oracleasm-2.6.18-92.el5-2.0.5-1.el5.i686.rpm warning: oracleasm-2.6.18-92.el5-2.0.5-1.el5.i686.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159 Preparing... ########################################### [100%] 1:oracleasm-2.6.18-92.el5########################################### [100%] [root@node1 32bit]# rpm -ivh oracleasmlib-2.0.4-1.el5.i386.rpm warning: oracleasmlib-2.0.4-1.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159 Preparing... ########################################### [100%] 1:oracleasmlib ########################################### [100%] 5、配置ASM，启动OCR并添加ASM磁盘 邮箱：lpf_315@163.com Bluefox 夏开怀 2012.12 [root@node1 32bit]# /etc/init.d/oracleasm configure Configuring the Oracle ASM library driver. This will configure the on-boot properties of the Oracle ASM library driver. The following questions will determine whether the driver is loaded on boot and what permissions it will have. The current values will be shown in brackets ('[]'). Hitting
without typing an answer will keep that current value. Ctrl-C will abort. Default user to own the driver interface []: oracle Default group to own the driver interface []: dba Start Oracle ASM library driver on boot (y/n) [n]: y Scan for Oracle ASM disks on boot (y/n) [y]: y Writing Oracle ASM library driver configuration: done Initializing the Oracle ASMLib driver: [ OK ] Scanning the system for Oracle ASMLib disks: [ OK ] [root@kk 32bit]# /etc/init.d/oracleasm enable Writing Oracle ASM library driver configuration: done Initializing the Oracle ASMLib driver: [ OK ] Scanning the system for Oracle ASMLib disks: [ OK ] [root@kk bin]# ./localconfig add /etc/oracle does not exist. Creating it now. Successfully accumulated necessary OCR keys. Creating OCR keys for user 'root', privgrp 'root'.. Operation successful. Configuration for local CSS has been initialized Adding to inittab Startup will be queued to init within 90 seconds. Checking the status of new Oracle init process... Expecting the CRS daemons to be up within 600 seconds. CSS is active on these nodes. node1 CSS is active on all nodes. Oracle CSS service is installed and running under init(1M) [root@node1 ~]#/etc/init.d/oracleasm createdisk VOL1 /dev/sdd1 [root@node1 ~]#/etc/init.d/oracleasm createdisk VOL2 /dev/sde1 6、配置裸设备 [root@node1 ~]# tail -5 /etc/udev/rules.d/60-raw.rules ACTION==\"add\ACTION==\"add\ENV{MAJOR}==\"8\ENV{MINOR}==\"17\RUN+=\"/bin/raw /dev/raw/raw1 %M %m\" ACTION==\"add\ACTION==\"add\ENV{MAJOR}==\"8\ENV{MINOR}==\"33\RUN+=\"/bin/raw /dev/raw/raw2 %M %m\" KERNEL==\"raw[1-2]\[root@node1 ~]#start_udev 邮箱：lpf_315@163.com Bluefox 夏开怀 2012.12 7、安装clusterware所需的软件包 [root@node1 ~]#rpm -ivh /oradisk/compat-gcc-7.3-2.96.128.i386.rpm [root@node1 ~]#rpm -ivh /oradisk/compat-libstdc++-7.3-2.96.128.i386.rpm —force [root@node1~]#rpm -ivh /oradisk/compat-libstdc++-devel-7.3-2.96.128.i386.rpm [root@node1 ~]#rpm -ivh /oradisk/compat-gcc-c++-7.3-2.96.128.i386.rpm 8、复制出第二个节点，修改信息 将rac1.vmx改名为rac2.vmx。并修改磁盘文件加入共享属性 打开rac2，在提示框中选择复制，打开后修改如下信息 [root@node1 ~]#hostname node2 [root@node2 ~]#cat /etc/sysconf/network [root@node2 ~]#cd /etc/sysconfig/network-scripts/ [root@node2 network-scripts]#mv ifcfg-eth0.bak ifcfg-eth0 [root@node2 network-scripts]#mv ifcfg-eth1.bak ifcfg-eth1 [root@node2 network-scripts]#ifconfig eth0 | grep Hwaddr [root@node2 network-scripts]#ifconfig eth1 | grep Hwaddr [root@node2 network-scripts]#vim ifconfig eth0(改硬件地址) [root@node2 network-scripts]#vim ifconfig eth1(改硬件地址) [root@node2 network-scripts]#service network restart [root@node2 network-scripts]#vim /home/oracle/.bash_profile(改ORACLE_SID为RACDB2) [root@node2 ~]#ping node1 [root@node2 ~]#ping node2 [root@node2 ~]#ping node1-priv [root@node2 ~]#ping node1-priv [root@node2 ~]#/etc/init.d/oracleasm scandisks [root@node2 ~]#/etc/init.d/oracleasm listdisks [root@node2 ~]#service xinetd start [root@node2 ~]#chkconfig time-stream on [root@node2 ~]#exit [root@node2 ~]#crontab -e * * * * rdate -s 142.105.100.112 下面是配置双机信任关系 [root@node1 ~]#su - oracle [oracle@node1 ~]#mkdir .ssh [oracle@node1 ~]#chmod 700 .ssh [oracle@node1 ~]#ssh-keygen -t rsa [oracle@node1 ~]#ssh-keygen -t dsa [root@node2 ~]#su - oracle [oracle@node2 ~]#mkdir .ssh [oracle@node2 ~]#chmod 700 .ssh [oracle@node2 ~]#ssh-keygen -t rsa [oracle@node2 ~]#ssh-keygen -t dsa [oracle@node1~]#cat/home/oracle/.ssh/id_rsa.pub >>/home/oracle/.ssh/authori邮箱：lpf_315@163.com Bluefox 夏开怀 2012.12 zed_keys [oracle@node1~]#cat/home/oracle/.ssh/id_dsa.pub >>/home/oracle/.ssh/authori zed_keys [oracle@node1 ~]#ssh node2 cat /home/oracle/.ssh/id_rsa.pub >> /home/oracle/.ssh/authorized_keys [oracle@node1 ~]#ssh node2 cat /home/oracle/.ssh/id_dsa.pub >> /home/oracle/.ssh/authorized_keys [oracle@node1 ~]#scp /home/oracle/.ssh/authorized_keys node2:/home/oracle/.ssh/authorized_keys 下面几步很重要，一定要全部完成，不然在集群检测时会报等同用户不存在的错误 [oracle@node1 ~]#ssh node1 date [oracle@node1 ~]#ssh node2 date [oracle@node1 ~]#ssh node1-priv date [oracle@node1 ~]#ssh node1-priv date [oracle@node1 ~]#ssh node2 [oracle@node2 ~]#ssh node1 date [oracle@node2 ~]#ssh node2 date [oracle@node2 ~]#ssh node1-priv date [oracle@node2 ~]#ssh node2-priv date 9、安装oracle 10g R2 clusterware软件 [oracle@node1 ~]#cd /oradisk [oracle@node1 ~]#unzip Oracle10201_clusterware_linux32.zip [oracle@node1 ~]#chown -R oracle:oinstall /oradisk [oracle@node1 ~]#chmod -R 775 /oradisk [oracle@node1 ~]#cd /oradisk/clusterware [oracle@node1 clusterware]#/oradisk/clusterware/cluvfy/runcluvfy.sh stage -pre crsinst -n node1,node2 –verbose 这里是集群安装前的检测，很重要，除了内存和交换空间的错误可以忽略，其余都不能忽略，要排除错误再进行下面的步骤 [oracle@node1 ~]#su - root [root@node1 ~]#cd /oradisk/clusterware/rootpre [root@node1 ~]#exit [oracle@node1 ~]#cd /oradisk/clusterware [oracle@node1 clusterware]#export LANG=en_US.UTF-8 [oracle@node1 clusterware]#./runInstaller –ignoreSysPreReqs 关键点： 1)在specify cluster configuration中加node2 node2-priv node2-vip 2)自specify network interface usage中验证interdace Type选项是否是eth0 private;eth1 public 3)在specify oracle cluster registry(OCR) location中选择Extermal redundancyn并加/dev/raw/raw2 4)在specify Voting Disk location中选择Extermal redundancyn并加/dev/raw/raw1 5)运行完显示完成并出现选项OK和2个脚本(不是第一次装，也可能只有1个脚本)，先别点，接着作下面的： [oracle@node1 ~]#/u01/app/oracle/oraInventory/orainstRoot.sh 邮箱：lpf_315@163.com Bluefox 夏开怀 2012.12 [oracle@node1 ~]#ssh node2 [oracle@node2 ~]#/u01/app/oracle/oraInventory/orainstRoot.sh [oracle@node1 ~]#cd /u01/app/oracle/product/10.2.0/crs_1/bin [oracle@node1 ~]#vim vipca #Remove this workaround when the bug 3937317 is fixed arch=`uname -m` if [ \"$arch\" = \"i686\" -o \"$arch\" = \"ia64\" ] then LD_ASSUME_KERNEL=2.4.19（改为当前系统内核版本（如：2.6.18）） export LD_ASSUME_KERNEL fi unset LD_ASSUME_KERNEL（加上这行） #End workaround [oracle@node1 ~]#vim srvctl #Remove this workaround when the bug 3937317 is fixed LD_ASSUME_KERNEL=2.4.19（改为当前系统内核版本（如：2.6.18）） export LD_ASSUME_KERNEL unset LD_ASSUME_KERNEL（加上这行） # Run ops control utility [oracle@node1 ~]#vim racgvip set it to 0 for checkIf() to return success if default gateway is not found, # otherwise set it to 1 FAIL_WHEN_DEFAULTGW_NOT_FOUND=0(将1改为0) # hard code default gateway here if needed DEFAULTGW=142.105.100.1（加上网关） # renice the process [oracle@node1 ~]#vim vipca [oracle@node1 ~]#vim srvctl 同样改node2 [oracle@node1 ~]#vim racgvip [root@node1 ~]#/u01/app/oracle/product/10.2.0/crs_1/root.sh [root@node2 ~]#/u01/app/oracle/product/10.2.0/crs_1/root.sh [root@node2 ~]#cd /u01/app/oracle/product/10.2.0/crs_1/bin [root@node2 bin]#export LANG=en_US.UTF-8 [root@node2 bin]#./vipca [root@node2 bin]#./oifcfg iflist [root@node2 bin]#./oifcfg setif -global eth0/142.105.100.0:public [root@node2 bin]#./oifcfg setif -global eth1/192.168.100.0: cluster_interconnect [root@node2 bin]#./oifcfg getif [root@node2 bin]#./vipca 关键点： IP Alias Name中加：node1-vip和node2-vip 完成后（Exit） 点击 OK 邮箱：lpf_315@163.com Bluefox 夏开怀 2012.12 6)[root@node1 ~]#cd /u01/app/oracle/product/10.2.0/crs_1/bin [root@node1 ~]#./crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora.node1.gsd application ONLINE ONLINE node1 ora.node1.ons application ONLINE ONLINE node1 ora.node1.vip application ONLINE ONLINE node1 ora.node2.gsd application ONLINE ONLINE node2 ora.node2.ons application ONLINE ONLINE node2 ora.node2.vip application ONLINE ONLINE node2 [root@node1 ~]#tail -3 /etc/inittab (显示启集群软件3行命令) [root@node2 ~]#cd /u01/app/oracle/product/10.2.0/crs_1/bin [root@node2 ~]#./crs_stat -t [root@node1 ~]#./crs_stop ora.node1.vip [root@node1 ~]#./crs_stat ora.node1.vip 10、安装oracle 10gR2 database软件，安装很简单，关键是要选择集群安装，选上两个节点。不详述 11、配置netca [oracle@node2 ~]#netca 关键点： 1)选cluster configuration 2)node1,node2全选 3)选listener configuration 4)add 5)选TCP [oracle@node1 ~]#/u01/app/oracle/product/10.2.0/crs_1/bin/crs_stat -t [oracle@node2 ~]#/u01/app/oracle/product/10.2.0/crs_1/bin/crs_stat –t 12、dbca创建数据库 [oracle@node1 bin]#dbca 关键点： 1)create a Datebase 2)node1,node2全选 3)custon Database 4)RACDB 5)configure the Database with EnterPrise Manager;use Database control for Database Management 6)选ASM 7)create initialization parameter file:{ORACLE_BASE} /admin/+ASM/prfile/init.ora 8)create new:(RAC_VOLGRP1,Extemal,show candidates,VOL1) (FLASH_RECOVERY_AREA,Extemal,show candidates,VOL2) 9)use oracle-managed files:+RAC_VOLGRP1 10)Specify Flash recover Area:+FLASH_RECOVERY_AREA 1000 11)create Database 邮箱：lpf_315@163.com Bluefox 夏开怀 2012.12 [oracle@node1 bin]#./crs_stat -t [oracle@node2 bin]#./crs_stat -t [oracle@node1 bin]#export ORACLE_SID=+ASM1 [oracle@node1 bin]#sqlplus / as sysdba SQL>select instance_name from v$instance; INSTANCE_NAME +ASM1 [oracle@node1 bin]#export ORACLE_SID=RACDB1 [oracle@node1 bin]#sqlplus / as sysdba SQL>select instance_name from v$instance; INSTANCE_NAME RACDB1 [oracle@node2 bin]#export ORACLE_SID=+ASM2 [oracle@node2 bin]#sqlplus / as sysdba SQL>select instance_name from v$instance; INSTANCE_NAME +ASM2 [oracle@node2 bin]#export ORACLE_SID=RACDB2 [oracle@node2 bin]#sqlplus / as sysdba SQL>select instance_name from v$instance; INSTANCE_NAME +RACDB2 13、检查RAC状态 [oracle@node2 bin]#./crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora....B1.inst application ONLINE OFFLINE ora....B2.inst application ONLINE OFFLINE ora.RACDB.db application ONLINE UNKNOWN node2 ora....SM1.asm application ONLINE UNKNOWN node1 ora....E1.lsnr application ONLINE UNKNOWN node1 ora.node1.gsd application ONLINE UNKNOWN node1 ora.node1.ons application ONLINE UNKNOWN node1 ora.node1.vip application ONLINE ONLINE node1 ora....SM2.asm application ONLINE UNKNOWN node2 ora....E2.lsnr application ONLINE UNKNOWN node2 ora.node2.gsd application ONLINE UNKNOWN node2 ora.node2.ons application ONLINE UNKNOWN node2 ora.node2.vip application ONLINE ONLINE node2 UNKNOWN状态的可以重启指导ONLINE [root@node1 bin]#./crs_stop -f ora.RACDB.db [root@node1 bin]#./crs_stop -f ora.node1.ASM1.asm [root@node1 bin]#./crs_stop -f ora.node2.ASM2.asm [root@node1 bin]#./crs_stop -f ora.node1.LISTENER_NODE1.lsnr 邮箱：lpf_315@163.com Bluefox 夏开怀 2012.12 [root@node1 bin]#./crs_stop -f ora.node2.LISTENER_NODE2.lsnr [root@node1 bin]#./crs_stop -f ora.node1.gsd [root@node1 bin]#./crs_stop -f ora.node1.ons [root@node1 bin]#./crs_stop -f ora.node2.gsd [root@node1 bin]#./crs_stop -f ora.node2.ons [root@node1 bin]#./crs_stop -f ora.node1.vip [root@node1 bin]#./crs_stop -f ora.node2.vip [root@node1 bin]#./crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora....B1.inst application ONLINE OFFLINE ora....B2.inst application ONLINE OFFLINE ora.RACDB.db application ONLINE OFFLINE ora....SM1.asm application ONLINE OFFLINE ora....E1.lsnr application ONLINE OFFLINE ora.node1.gsd application ONLINE OFFLINE ora.node1.ons application ONLINE OFFLINE ora.node1.vip application ONLINE OFFLINE ora....SM2.asm application ONLINE OFFLINE ora....E2.lsnr application ONLINE OFFLINE ora.node2.gsd application ONLINE OFFLINE ora.node2.ons application ONLINE OFFLINE ora.node2.vip application ONLINE OFFLINE [oracle@node1 bin]#./crs_start -all [oracle@node1 bin]#./crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora....B1.inst application ONLINE ONLINE node1 ora....B2.inst application ONLINE ONLINE node2 ora.RACDB.db application ONLINE ONLINE node1 ora....SM1.asm application ONLINE ONLINE node1 ora....E1.lsnr application ONLINE ONLINE node1 ora.node1.gsd application ONLINE ONLINE node1 ora.node1.ons application ONLINE ONLINE node1 ora.node1.vip application ONLINE ONLINE node1 ora....SM2.asm application ONLINE ONLINE node2 ora....E2.lsnr application ONLINE ONLINE node2 ora.node2.gsd application ONLINE ONLINE node2 ora.node2.ons application ONLINE ONLINE node2 ora.node2.vip application ONLINE ONLINE node2 14、客户端TAF（Transparent applacation failover）配置 a. 服务器确认listener.ora node1$ cat listener.ora SID_LIST_LISTENER_NODE1 = 邮箱：lpf_315@163.com Bluefox 夏开怀 2012.12 (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1) (PROGRAM = extproc) ) ) LISTENER_NODE1 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS=(PROTOCOL = TCP)(HOST = NODE1-VIP)(PORT=1521)(IP=FIRST)) (ADDRESS=(PROTOCOL = TCP)(HOST =142.105.100.111) (PORT=1521)(IP=FIRST)) ) ) node1$ lsnctl status LISTENER_NODE1 node2$ cat listener.ora SID_LIST_LISTENER_NODE2 = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1) (PROGRAM = extproc) ) ) LISTENER_NODE2 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS=(PROTOCOL = TCP)(HOST = NODE1-VIP)(PORT=1521)(IP=FIRST)) (ADDRESS=(PROTOCOL = TCP)(HOST =142.105.100.112) (PORT=1521)(IP=FIRST)) ) ) node1$ lsnctl status LISTENER_NODE2 FOR RAC BUG ORA-12545 IN ORACLE 10.2(SEE NORE:364855.1):(连不上node1转而连node2) node1$ sqlplus / as sysdba SQL>show parameter instance_name; RACDB1 SQL>alter system set local_listener='LISTENERS_RACDB' sid='*'; (node1/2都行) 邮箱：lpf_315@163.com Bluefox 夏开怀 2012.12 node2$ sqlplus / as sysdba SQL>show parameter instance_name; RACDB2 SQL>alter system set local_listener='LISTENERS_RACDB' sid='*'; $cat tnsnames.ora …… LISTENERS_RACDB = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip)(PORT = 1521)) ) b. 客户端确认tnsnames.ora RACDB = (DESCRIPTION = (DESCRIPTION = (ADDRESS=(PROTOCOL = TCP)(HOST =142.105.100.211)(PORT=1521)) (ADDRESS=(PROTOCOL = TCP)(HOST =142.105.100.212)(PORT=1521))(连接不上就连node2) ) (CONNECT_DATE = (SERVICE_NAME = RACDB(此名用于连接数据库)) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) ) ) ) Type有两个选项 SELECT(2个vip选1个，连上1个就不连另一个)有问题临时连 PRECONNECT（连1同时连2）有问题时不需要临时连 Method有两个选项 BASIC(查询到一半中断时自动连另一个继续查询(接着的)) SESSION(查询到一半中断时自动连另一个重新查询(重新开始)) 15、客户端负载均衡配置 RACDB = (DESCRIPTION = (DESCRIPTION = (ADDRESS=(PROTOCOL = TCP)(HOST =142.105.100.211)(PORT=1521)) (ADDRESS=(PROTOCOL = TCP)(HOST =142.105.100.212)(PORT=1521)) (LOAD_BALANCE = YES)(负载均衡，2个vip随机连) ) (CONNECT_DATE = (SERVICE_NAME = RACDB) 邮箱：lpf_315@163.com Bluefox (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) ) ) ) 夏开怀 2012.12 邮箱：lpf_315@163.com