RHEL54“加”Oracle10GRAC“加”裸设备安装

1、RHEL5.4+Oracle 10G RAC+裸设备目录 TOC o 1-6 h z u HYPERLINK l _Toc453075354 1 IP地址规划 PAGEREF _Toc453075354 h 3 HYPERLINK l _Toc453075355 2共享磁盘存储(裸设备)规划 PAGEREF _Toc453075355 h 3 HYPERLINK l _Toc453075356 3实施操作步骤 PAGEREF _Toc453075356 h 4 HYPERLINK l _Toc453075357 3.1环境准备及检查 PAGEREF _Toc453075357 h 4 HYPE

2、RLINK l _Toc453075358 1创建虚拟主机，规划IP PAGEREF _Toc453075358 h 4 HYPERLINK l _Toc453075359 2创建共享磁盘 PAGEREF _Toc453075359 h 4 HYPERLINK l _Toc453075360 3.2系统及内核参数配置 PAGEREF _Toc453075360 h 8 HYPERLINK l _Toc453075361 1各主机编辑文件 /etc/redhat-release(oracle不支持RHEL5版本) PAGEREF _Toc453075361 h 8 HYPERLINK l _To

3、c453075362 2各主机创建Oracle用户组oinstall、dba ；用户 oracle PAGEREF _Toc453075362 h 8 HYPERLINK l _Toc453075363 4各主机创建Oracle安装lv以及软件存放目录 PAGEREF _Toc453075363 h 8 HYPERLINK l _Toc453075364 3各主机创建Oracle安装目录 PAGEREF _Toc453075364 h 8 HYPERLINK l _Toc453075365 5各主机编辑文件 /home/oracle/.bash_profile PAGEREF _Toc4530

4、75365 h 9 HYPERLINK l _Toc453075366 6各主机编辑文件 /etc/sysctl.conf PAGEREF _Toc453075366 h 9 HYPERLINK l _Toc453075367 7 各主机编辑文件 /etc/hosts PAGEREF _Toc453075367 h 10 HYPERLINK l _Toc453075368 8各主机编辑文件 /etc/security/limits.conf PAGEREF _Toc453075368 h 10 HYPERLINK l _Toc453075369 9各主机编辑文件 /etc/pam.d/logi

5、n PAGEREF _Toc453075369 h 11 HYPERLINK l _Toc453075370 10各主机编辑文件 /etc/rc.local PAGEREF _Toc453075370 h 11 HYPERLINK l _Toc453075371 11各主机登录oracle用户，配置Oracle SSH互信： PAGEREF _Toc453075371 h 11 HYPERLINK l _Toc453075372 12配置NTP（可选） PAGEREF _Toc453075372 h 12 HYPERLINK l _Toc453075373 13安装、database需要的rp

6、m包 PAGEREF _Toc453075373 h 12 HYPERLINK l _Toc453075374 14创建LVM裸设备 PAGEREF _Toc453075374 h 14 HYPERLINK l _Toc453075375 15配置UDEV并且修改裸设备共享磁盘权限 PAGEREF _Toc453075375 h 15 HYPERLINK l _Toc453075376 16建立裸设备的软链接。 PAGEREF _Toc453075376 h 17 HYPERLINK l _Toc453075377 17创建裸设备映射文件 PAGEREF _Toc453075377 h 18

7、HYPERLINK l _Toc453075378 18禁止IPTABLES与SELINUX PAGEREF _Toc453075378 h 19 HYPERLINK l _Toc453075379 3.3安装Oracle10g_RAC PAGEREF _Toc453075379 h 19 HYPERLINK l _Toc453075380 1上传安装介质 PAGEREF _Toc453075380 h 19 HYPERLINK l _Toc453075381 2解压三个安装介质 PAGEREF _Toc453075381 h 20 HYPERLINK l _Toc453075382 3检查安

8、装环境 PAGEREF _Toc453075382 h 20 HYPERLINK l _Toc453075383 4安装clusterware PAGEREF _Toc453075383 h 21 HYPERLINK l _Toc453075384 5安装Oracle Database PAGEREF _Toc453075384 h 36 HYPERLINK l _Toc453075385 6升级clusterware PAGEREF _Toc453075385 h 42 HYPERLINK l _Toc453075386 7升级database PAGEREF _Toc453075386 h

9、 44 HYPERLINK l _Toc453075387 8 NETCA创建监听 PAGEREF _Toc453075387 h 46 HYPERLINK l _Toc453075388 9 DBCA建库 PAGEREF _Toc453075388 h 53 HYPERLINK l _Toc453075389 10使用裸设备创建Database PAGEREF _Toc453075389 h 57 HYPERLINK l _Toc453075390 11导出dmp数据库文件 PAGEREF _Toc453075390 h 73 HYPERLINK l _Toc453075391 12导入dm

10、p数据库文件 PAGEREF _Toc453075391 h 73 HYPERLINK l _Toc453075392 13开启数据库归档模式 PAGEREF _Toc453075392 h 741 IP地址规划IP规划示例：主机名（不能大写）rac1rac2公共IP（eth0）1112私有IP（eth1）1112虚拟IP（eth0）1314ORACLE_SIDorcl1orcl2全局数据库名orcl2共享磁盘存储(裸设备)规划存储磁盘规划示例：(测试用)用途lv名裸设备名字大小存放集群注册表ocr/dev/vgdata/orcl_ocr/dev/raw/raw1512M表决磁盘voting

11、disk/dev/vgdata/orcl_vdisk/dev/raw/raw2512Mspfile信息存放/dev/vgdata/rorcl_spfile/dev/raw/raw3128M控制文件/dev/vgdata/rorcl_ctl1/dev/raw/raw4128M控制文件/dev/vgdata/rorcl_ctl2/dev/raw/raw5128M控制文件/dev/vgdata/rorcl_ctl3/dev/raw/raw6128MSysaux表空间/dev/vgdata/rorcl_sysaux/dev/raw/raw71024MSystem表空间/dev/vgdata/rorcl

12、_system/dev/raw/raw81024M系统临时表空间/dev/vgdata/rorcl_temp1/dev/raw/raw9128M撤销表空间/dev/vgdata/rorcl_undo1/dev/raw/raw10512M撤销表空间/dev/vgdata/rorcl_undo2/dev/raw/raw11512MUser表空间/dev/vgdata/rorcl_users/dev/raw/raw12128M重做日志文件/dev/vgdata/rorcl_redolog1/dev/raw/raw13512M重做日志文件/dev/vgdata/rorcl_redolog2/dev/r

13、aw/raw14512M重做日志文件/dev/vgdata/rorcl_redolog3/dev/raw/raw15512M重做日志文件/dev/vgdata/rorcl_redolog4/dev/raw/raw16512M用户数据表空间/dev/vgdata/rorcl_data1/dev/raw/raw17128M用户数据表空间/dev/vgdata/rorcl_data2/dev/raw/raw18128M用户数据表空间/dev/vgdata/rorcl_data3/dev/raw/raw19128M用户数据表空间/dev/vgdata/rorcl_data4/dev/raw/raw20

14、128M3实施操作步骤3.1环境准备及检查1创建虚拟主机，规划IP请见IP规划示例。要设定为静态IP。主机名由字母加数字组成，不得有大写或其他特殊符号。2创建共享磁盘见存储磁盘规划示例。另外由于两台虚拟机如果不属于同一台物理服务器，共享磁盘要设置为物理，见下图；共享磁盘模式应为厚置备置零。磁盘总线应该另外再用一条总线，如果原来用了SCSI0：X，则现在需要用SCSI1：1、SCSI1：2、SCSI1：3。共享磁盘只需在主机1建立，主机2在建磁盘时直接指向主机1的磁盘位置即可。主机1创建磁盘步骤如下主机2创建磁盘步骤如下3.2系统及内核参数配置1各主机编辑文件 /etc/redhat-relea

15、se(oracle不支持RHEL5版本)修改为：Red Hat Enterprise Linux Server release 4 (Tikanga)2各主机创建Oracle用户组oinstall、dba ；用户 oraclegroupadd oinstall groupadd dbauseradd -g oinstall -G dba oracle passwd oracle /密码设为 oracle4各主机创建Oracle安装lv以及软件存放目录lvcreate -L 15G -n lvoracle /dev/vgrootmkfs.ext3 /dev/vgroot/lvoraclemkdi

16、r /oraclemount /dev/vgroot/lvoracle /oraclelvcreate -L 5G -n lvsoftware /dev/vgrootmkfs.ext3 /dev/vgroot/lvsoftwaremkdir /softwaremount /dev/vgroot/lvsoftware /softwarecat/etc/fstab/home/oracle/.bash_profile/home/oracle/.bash_profile/etc/sysctl.conf/etc/hosts/etc/security/limits.conf /etc/pam.d/logi

17、n /etc/rc.local /.ssh/authorized_keysssh rac1 cat /.ssh/id_dsa.pub /.ssh/authorized_keysssh rac2 cat /.ssh/id_rsa.pub /.ssh/authorized_keysssh rac2 cat /.ssh/id_dsa.pub /.ssh/authorized_keys节点2：ssh rac2 cat /.ssh/id_rsa.pub /.ssh/authorized_keysssh rac2 cat /.ssh/id_dsa.pub /.ssh/authorized_keysssh

18、rac1 cat /.ssh/id_rsa.pub /.ssh/authorized_keysssh rac1 cat /.ssh/id_dsa.pub /.ssh/authorized_keysPS：如果提示是否连接选择yes，密码输入oracle用户的密码exec /usr/bin/ssh-agent $SHELL测试互信是否成功节点1ssh rac1 datessh rac2 datessh rac1-priv date （会提示输入yes 或密码）ssh rac2-priv date （会提示输入yes 或密码）节点2ssh rac1 datessh rac2 datessh rac1

19、-priv date （会提示输入yes 或密码）ssh rac2-priv date （会提示输入yes 或密码）（若不需输入任何东西，时间又相差不大，则表示成功）SSH等价配置完成。12配置NTP（可选）rpm -qa |grep ntpchkconfig -level 2345 ntpd onservice ntpd startcat/etc/ntp.conf/etc/ntp/step-tickers/etc/yum.repos.d/rhel-debuginfo.repo/etc/udev/rules.d/60-raw.rules/etc/sysconfig/rawdevices/etc

20、/rc.d/rc.local orcl_raw.confEOFspfile=/dev/raw/raw3control1=/dev/raw/raw4control2=/dev/raw/raw5control3=/dev/raw/raw6sysaux=/dev/raw/raw7system=/dev/raw/raw8temp=/dev/raw/raw9undotbs1=/dev/raw/raw10undotbs2=/dev/raw/raw11users=/dev/raw/raw12redo1_1=/dev/raw/raw13redo1_2=/dev/raw/raw14redo2_1=/dev/ra

21、w/raw15redo2_2=/dev/raw/raw16EOF18禁止IPTABLES与SELINUXchkconfig iptables offchkconfig ip6tables offservice iptables stopservice ip6tables stop禁止SELINUXsetenforce 0sed -i s/SELINUX=.*/SELINUX=disabled/ /etc/selinux/config状态如下为关闭#getenforcePermissive#cat /etc/selinux/config|grep SELINUXSELINUX=disabledS

22、ELINUX=disabledSELINUXTYPE= can take one of these two values:SELINUXTYPE=targeted rootlabtest1 #关闭selinux后，最好重启主机。3.3安装Oracle10g_RAC1上传安装介质三个安装介质上传到主机1的/software/目录下10201_clusterware_linux_x86_64.cpio.gz / clusterware安装包10201_database_linux_x86_64.cpio.gz / database安装包p8202632_10205_Linux-x86-64.zip

23、 / 升级包并给oracle用户赋予/software目录权限：chown -R oracle:ointall /softwarechown -R oracle:ointall /software用oracle用户登录2解压三个安装介质#gunzip 10201_clusterware_linux_x86_64.cpio.gz#cpio -idmv 10201_clusterware_linux_x86_64.cpio /得到clusterware文件#gunzip 10201_database_linux_x86_64.cpio.gz#cpio -idmv 10201_database_li

24、nux_x86_64.cpio /得到database文件#unzip p8202632_10205_Linux-x86-64.zi /得到Disk1文件#chown -R oracle:oinstall /software#chmod -R 755 / software3检查安装环境 执行命令：$ /software/clusterware/cluvfy/runcluvfy.sh stage -pre crsinst -n rac1,rac2 -verboseoraclerac1 cluvfy$ ./runcluvfy.sh stage -pre crsinst -n rac1,rac2 -

25、verbosePerforming pre-checks for cluster services setup Checking node reachability.Check: Node reachability from node rac1 Destination Node Reachable? rac2 yes rac1 yes Result: Node reachability check passed from node rac1.Checking user equivalence.Check: User equivalence for user oracle Node Name C

26、omment rac2 passed rac1 passed Result: User equivalence check passed for user oracle.Checking administrative privileges.Check: Existence of user oracle Node Name User Exists Comment rac2 yes passed rac1 yes passed Result: User existence check passed for oracle.Check: Existence of group oinstall Node

27、 Name Status Group ID rac2 exists 500 rac1 exists 500 Result: Group existence check passed for oinstall.Check: Membership of user oracle in group oinstall as Primary Node Name User Exists Group Exists User in Group Primary Comment rac2 yes yes yes yes passed rac1 yes yes yes yes passed Result: Membe

28、rship check for user oracle in group oinstall as Primary passed.Administrative privileges check passed.Checking node connectivity.Interface information for node rac2 Interface Name IP Address Subnet eth0 12 eth1 12 Interface information for node rac1 Interface Name IP Address Subnet eth0 11 eth1 11

29、Check: Node connectivity of subnet Source Destination Connected? rac2:eth0 rac1:eth0 yes Result: Node connectivity check passed for subnet with node(s) rac2,rac1.Check: Node connectivity of subnet Source Destination Connected? rac2:eth1 rac1:eth1 yes Result: Node connectivity check passed for subnet

30、 with node(s) rac2,rac1.Suitable interfaces for the private interconnect on subnet :rac2 eth0:12rac1 eth0:11Suitable interfaces for the private interconnect on subnet :rac2 eth1:12rac1 eth1:11ERROR: Could not find a suitable set of interfaces for VIPs.Result: Node connectivity check failed.Checking

31、system requirements for crs.No checks registered for this product.Pre-check for cluster services setup was unsuccessful on all the nodes.前面都是正确的话，就表示可以安装。VIP报错不用理会。4安装clusterware 打开自己电脑上的Xmanager xstart，远程连接到主机查出本机的IP ： 再在终端输入命令：(在/software/clusterware目录下)$export DISPLAY=:0.0 $export LANG=en_US$ ./r

32、unInstaller -ignoreSysPreReqs后，弹出安装界面：下一步：修改安装路径为crs ；下一步：环境检测，全部通过；下一步：Add添加主机2的信息：下一步：编辑eth0 为public，下一步：填入OCR的裸设备/dev/raw/raw1，下一步：（注意：这里不能填 /devvgdata/rorcl_ocr，不能填链接，只能填实际的裸设备，创建链接只是方便自己查看裸设备的对应关系）填入Voting的裸设备/dev/raw/raw2，下一步：点击install 进行安装：等待弹出：这一步关键，需要用root用户在两台主机执行命令/oracle/oraInventory/ora

33、instRoot.sh/oracle/product/10.2.0/crs/root.sh执行前先在各主机编辑文件：vi /oracle/product/10.2.0/crs/bin/vipca 添加 unset LD_ASSUME_KERNELvi /oracle/product/10.2.0/crs/bin/srvctl 添加添加 unset LD_ASSUME_KERNEL编辑好后，在主机1用root用户执行：#/oracle/oraInventory/orainstRoot.shrootrac1 lib# /oracle/oraInventory/orainstRoot.shChang

34、ing permissions of /oracle/oraInventory to 770.Changing groupname of /oracle/oraInventory to oinstall.The execution of the script is complete在主机2用root用户执行：#/oracle/oraInventory/orainstRoot.shrootrac2 Server# /oracle/oraInventory/orainstRoot.shChanging permissions of /oracle/oraInventory to 770.Chang

35、ing groupname of /oracle/oraInventory to oinstall.The execution of the script is complete在主机1用root用户执行：#/oracle/product/10.2.0/crs/root.shrootrac1 lib# /oracle/product/10.2.0/crs/root.shWARNING: directory /oracle/product/10.2.0 is not owned by rootWARNING: directory /oracle/product is not owned by r

36、ootWARNING: directory /oracle is not owned by rootChecking to see if Oracle CRS stack is already configured/etc/oracle does not exist. Creating it now.Setting the permissions on OCR backup directorySetting up NS directoriesOracle Cluster Registry configuration upgraded successfullyWARNING: directory

37、 /oracle/product/10.2.0 is not owned by rootWARNING: directory /oracle/product is not owned by rootWARNING: directory /oracle is not owned by rootSuccessfully accumulated necessary OCR keys.Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.node : node 1: rac1 rac1-priv rac1node 2: rac2 rac2

38、-priv rac2Creating OCR keys for user root, privgrp root.Operation successful.Now formatting voting device: /dev/raw/raw2Format of 1 voting devices complete.Startup will be queued to init within 90 seconds.Adding daemons to inittabExpecting the CRS daemons to be up within 600 seconds.CSS is active on

39、 these nodes. rac1CSS is inactive on these nodes. rac2Local node checking complete.Run root.sh on remaining nodes to start CRS daemons.表示成功；在主机2用root用户执行：#/oracle/product/10.2.0/crs/root.shrootrac2 Server# /oracle/product/10.2.0/crs/root.shWARNING: directory /oracle/product/10.2.0 is not owned by ro

40、otWARNING: directory /oracle/product is not owned by rootWARNING: directory /oracle is not owned by rootChecking to see if Oracle CRS stack is already configured/etc/oracle does not exist. Creating it now.Setting the permissions on OCR backup directorySetting up NS directoriesOracle Cluster Registry

41、 configuration upgraded successfullyWARNING: directory /oracle/product/10.2.0 is not owned by rootWARNING: directory /oracle/product is not owned by rootWARNING: directory /oracle is not owned by rootclscfg: EXISTING configuration version 3 detected.clscfg: version 3 is 10G Release 2.Successfully ac

42、cumulated necessary OCR keys.Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.node : node 1: rac1 rac1-priv rac1node 2: rac2 rac2-priv rac2clscfg: Arguments check out successfully.NO KEYS WERE WRITTEN. Supply -force parameter to override.-force is destructive and will destroy any previous

43、clusterconfiguration.Oracle Cluster Registry for cluster has already been initializedStartup will be queued to init within 90 seconds.Adding daemons to inittabExpecting the CRS daemons to be up within 600 seconds.CSS is active on these nodes. rac1 rac2CSS is active on all nodes.Waiting for the Oracl

44、e CRSD and EVMD to startWaiting for the Oracle CRSD and EVMD to startOracle CRS stack installed and running under init(1M)Running vipca(silent) for configuring nodeappsError 0(Native: listNetInterfaces:3) Error 0(Native: listNetInterfaces:3)如果只有主机2报错，则往下执行，跳到（到这一步报错误，针对这个错误，解决方案：手动配置vip）如果在两台主机执行都报错

45、，则运行以下命令行从新执行root.sh这个命令start_udevrm -rf ls /etc/oraclrm -rf /etc/oracle/scls_scr/rac1/oracle/cssfatalrm -rf /etc/oracle/scls_scr/rac2/oracle/cssfatal/oracle/product/10.2.0/crs/bin/clsfmt.bin ocr /dev/raw/raw1dd if=/dev/zero of=/dev/raw/raw1 bs=1M count=524dd if=/dev/zero of=/dev/raw/raw2 bs=1M coun

46、t=629到这一步报错误，针对这个错误，解决方案：手动配置vip在主机1到/oracle/product/10.2.0/crs/bin目录下，执行命令cd /oracle/product/10.2.0/crs/bin./oifcfg iflisteth0 28eth1 #./oifcfg setif -global eth0/:public#./oifcfg setif -global eth1/:cluster_interconnect#./oifcfg getifeth0 28 global publiceth1 global cluster_interconnect在主机2运行命令查看是

47、否有同样的输出结果#./oifcfg getifeth0 28 global publiceth1 global cluster_interconnect在主机1手动运行vipca#export DISPLAY=:0.0 #export LANG=en_US到/oracle/product/10.2.0/crs/bin目录下#./vipca 弹出窗口：下一步：下一步：只需填入：rac1-vip ；其他三个空自动填入；下一步：点击完成：结束后，回到此界面：点击OK后：检查安装看到这，已经成功安装好了clusterware！通过命令： crs_stat -t 查看，如下：oraclerac1 $

48、crs_stat -tName Type Target State Host ora.rac1.gsd application ONLINE ONLINE rac1 ora.rac1.ons application ONLINE ONLINE rac1 ora.rac1.vip application ONLINE ONLINE rac1 ora.rac2.gsd application ONLINE ONLINE rac2 ora.rac2.ons application ONLINE ONLINE rac2 ora.rac2.vip application ONLINE ONLINE ra

49、c2 5安装Oracle Database用oracle用户进入/software/ database；运行： ./ runInstaller ，弹出界面：下一步：默认，下一步：默认，下一步：勾上rac2，下一步：检查通过，下一步：选择第三项，不建数据库，下一步：点击安装：在主机1上执行：rootrac1 install# cd .rootrac1 Disk1# cd /oracle/product/10.2.0/db/rootrac1 db# ./root.shRunning Oracle10 root.sh script.The following environment variable

50、s are set as: ORACLE_OWNER= oracle ORACLE_HOME= /oracle/product/10.2.0/dbEnter the full pathname of the local bin directory: /usr/local/bin: Copying dbhome to /usr/local/bin . Copying oraenv to /usr/local/bin . Copying coraenv to /usr/local/bin .Creating /etc/oratab file.Entries will be added to the

51、 /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed.rootrac1 db#在主机2上执行：rootrac2 bin# /oracle/product/10.2.0/db/root.shRunning Oracle10 root.sh script.The followin

52、g environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /oracle/product/10.2.0/dbEnter the full pathname of the local bin directory: /usr/local/bin: Copying dbhome to /usr/local/bin . Copying oraenv to /usr/local/bin . Copying coraenv to /usr/local/bin .Creating /etc/oratab file.Entrie

53、s will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed.rootrac2 bin# rootrac2 bin#回到安装界面点击OK：点击结束；Database安装完毕！6升级clusterware在主机1用oracle用户执行命令：$

54、 crs_stop -all /停止集群进入/software/Disk1，运行：$ ./ runInstaller，需要注意的是clusterware和database的升级包都是这一个，升级clusterware和database都是运行这个runInstaller文件，不同的是在 Specify Home Details这一页面的时候需要选择Name 这一行的选框里面的内容来却分是升级clusterware还是database。需要先升级clusterware再升级database。选择crs的目录，下一步：下一步：检查通过，下一步：点击安装：用root用户在各主机执行a、b 命令：主机

55、1：#/oracle/product/10.2.0/crs/bin/crsctl stop crs/oracle/product/10.2.0/crs/install/root102.sh主机2：/oracle/product/10.2.0/crs/bin/crsctl stop crs/oracle/product/10.2.0/crs/install/root102.sh看到这，表示都很成功；接着回到升级界面，结束升级：用命令：$ crsctl query crs softwareversion 查看已经升级到.0；并查看集群状态，已经正常；升级没有问题。7升级database用oracl

56、e用户进入/software/Disk1，再次运行：$ ./ runInstaller点击name选项后面的下三角，选择OraDb10g_home1下一步：去掉勾，下一步：下一步：检测通过，下一步：点击安装：各主机用root用户执行命令：主机1：主机2：回到升级界面，点击OK，出现：点击结束，Database升级完毕！8 NETCA创建监听#su - oracleexport DISPLAY=:0.0export LANG=en_USnetca 核对两台主机的以下配置文件，（本次发行主机2 (ADDRESS = (PROTOCOL = TCP)(HOST = 12)(PORT = 1521)(

57、IP = FIRST)中HOST变成主机的物理IP，导致lsnrctl status查看监听不正确，后来根据主机1的配置改为后重启监听正常）listener.ora tnsnames.ora # listener.ora.rac1 Network Configuration File: /oracle/product/10.2.0/db/network/admin/listener.ora.rac1# Generated by Oracle configuration tools.LISTENER_RAC1 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRE

58、SS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521)(IP = FIRST) (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521)(IP = FIRST) ) )SID_LIST_LISTENER_RAC1 = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /oracle/product/10.2.0/db) (PROGRAM = extproc) ) )oraclerac1 admin$oraclerac2 admin

59、$ more listener.ora # listener.ora.rac2 Network Configuration File: /oracle/product/10.2.0/db/network/admin/listener.ora.rac2# Generated by Oracle configuration tools.LISTENER_RAC2 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521)(IP = FIRST) (ADDRESS = (

60、PROTOCOL = TCP)(HOST = )(PORT = 1521)(IP = FIRST) ) )SID_LIST_LISTENER_RAC2 = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /oracle/product/10.2.0/db) (PROGRAM = extproc) ) )oraclerac2 admin$oraclerac1 admin$ cat tnsnames.ora # tnsnames.ora Network Configuration File: /oracle/produc