OracleGRAC及负载均衡搭建手册

1、Oracle11GR2RACgc装手册1. 基础知识RA淀什么RAC全称realapplicationclusters，译为“实时应用集群”，是Oracle新版数据库中采用的一项新技术，是高可用性的一种，也是Oracle数据库支持网格计算环境的核心技术。RAC勺优缺点优点OracleRAC支持Oracle9i、10g、11g版本，可以支持24x7有效的数据库应用系统，在低成本服务器上构建高可用性数据库系统，并且自由部署应用，无需修改代码。在OracleRAC环境下，Oracle集成提供了集群软件和存储管理软件，为用户降低了应用成本。当应用规模需要扩充时，用户可以按需扩展系统，以保证系统的性能。

2、(1) 多节点负载均衡；提供高可用：故障容错和无缝切换功能，将硬件和软件错误造成的影响最小化；(2) 通过并行执行技术提高事务响应时间-通常用于数据分析系通过横向扩展提高每秒交易数和连接数-通常对于联机事务系统；节约硬件成本，可以用多个廉价PC服务器代替昂贵的小型机或大型机，同时节约相应维护成本；(3) 可扩展性好，可以方便添加删除节点，扩展硬件资源。缺点(1) 相对单机，管理更复杂，要求更高；2. 可能会增加软件成本OracleRAC原理在一个应用环境当中，所有的服务器使用和管理同一个数据库，目的是为了分散每一台服务器的工作量，硬件上至少需要两台以上的服务器，而且还需要一个共享存储设备。同时

3、所有服务器上的OStK应该是同一类OS,根据负载均衡的配置策略，当一个客户端发送请求到某一台服务的listener后，这台服务器根据我们的负载均衡策略，会把请求发送给本机的RACS件处理也可能会发送给另外一台服务器的RAC组件处理，处理完请求后，RAg通过集群软件来访问共享存储设备.逻辑结构上看：每一个参加集群的节点有一个独立的instance,这些instance访问同一个数据库。每一个节点的linstance都有自己的SGA每一个节点的linstance都有自己的backgroundprocess每一个节点的linstance都有自己的redologs。每一个节点的instance都有自己

4、的und。表空间。所有节点都共享一份datafiles和controlfiles。三类Resource:VIP-虚拟IP地址(VirtualIP)OCR-OracleClusterRegistry(集群注册文件)，记录每个节点的相关信息VotingDisk,仲裁机制用于仲裁多个节点向共享节点同时写的行为，这样做是为了避免发生冲突。RACW境设计1.服务器配置操作系统主机名内存网卡RedhatEnterpriseLinux5.4rac12Geth0(Public)eth1(Prive)RedhatEnterpriseLinux5.4rac22Geth0(Public)eth1(Prive)2.用

5、户组规划GroupNameGroupID说明HOSTinstall501Oracle清单和软件所有者racl,rac2asmadmin504Oracle自动存储管理组racl,rac2asmdba506ASM敬据库管理员组racl,rac2asmopen507ASMS作员组racl,rac2dba502数据库管理员racl,rac23.用户规划UserIDUserNameGroup说明HOST口令501gridinstalldbaasmadminasmdbaasmoperOracleCluster用户raclrac2grid123502racleinstalldbaasmdbaOracle数据

6、库管理员raclrac2racle1234.IP规划主机名公用IP私有IP虚拟IPrac1rac2ScanIP5.存储规划存储组件BlockDeviceASMlibNameSizeOCR/dev/sdbOCR_VOL11G/dev/sdcOCR_VOL21G/dev/sddOCR_VOL31G数据文件/dev/sdeDATA_VOL110G文件备份/dev/sdfBACK_VOL15GOracleRAC搭建1. 配置共享存储(ASMR赖)方法一:vmwareworkstation9虚拟共享存储(1)在VM咬装目录VMwareWorkstation下执行命令:#vmware-vdiskmanag

7、er.exe-c-s1GB-alsilogic-t2D:racDiskdb01.vmdk#vmware-vdiskmanager.exe-c-s1GB-alsilogic-t2D:racDiskdb02.vmdk#vmware-vdiskmanager.exe-c-s1GB-alsilogic-t2D:racDiskdb03.vmdk#vmware-vdiskmanager.exe-c-s10GB-alsilogic-t2D:racDiskdb04.vmdk#vmware-vdiskmanager.exe-c-s5GB-alsilogic-t2D:racDiskdb05.vmdk修改rac1和

8、rac2下的.vmx文件，在最后一行添加如下内容:diskLib.dataCacheMaxSize=0diskLib.dataCacheMaxReadAheadSize=0diskLib.dataCacheMinReadAheadSize=0diskLib.dataCachePageSize=4096diskLib.maxUnsyncedWrites="0”disk.locking="FALSE"scsi1.sharedBus="virtual”scsi1.present="TRUE"scsi1.virtualDev="ls

9、ilogic"scsi1:0.mode="independent-persistent"scsi1:0.deviceType="disk”scsi1:0.present="TRUE"scsi1:0.fileName="D:racDiskdb01.vmdk”scsi1:1.mode="independent-persistent"scsi1:1.deviceType="disk”scsi1:1.present="TRUE"scsi1:1.fileName="D:rac

10、Diskdb02.vmdk"scsi1:2.mode="independent-persistent"scsi1:2.deviceType="disk”scsi1:2.present="TRUE"scsi1:2.fileName="D:racDiskdb03.vmdk”scsi1:3.mode="independent-persistent”scsi1:3.deviceType="disk"scsi1:3.present="TRUE"scsi1:3.fileName=&quo

11、t;D:racDiskdb04.vmdk”scsi1:4.mode="independent-persistent”scsi1:4.deviceType="disk"scsi1:4.present="TRUE"scsi1:4.fileName="D:racDiskdb05.vmdk”(3)重新打开虚拟机，并启动。磁盘分区，在rac1执行#fdisk/dev/sdbDevicecontainsneitheravalidDOSpartitiontable,norSun,SGIorOSFdisklabelBuildinganewDOSdis

12、klabel.Changeswillremaininmemoryonly,untilyoudecidetowritethem.Afterthat,ofcourse,thepreviouscontentwon'tberecoverable.Warning:invalidflag0x0000ofpartitiontable4willbecorrectedbyw(rite)Command(mforhelp):p64heads,32sectors/track,1000cylindersUnits=cylindersof2048*512=1048576bytesDeviceBootStartEn

13、dBlocksIdSystemCommand(mforhelp):nCommandactioneextendedpprimarypartition(1-4)pPartitionnumber(1-4):1Firstcylinder(1-1000,default1):Usingdefaultvalue1Lastcylinderor+sizeor+sizeMor+sizeK(1-1000,default1000):Usingdefaultvalue1000Command(mforhelp):wThepartitiontablehasbeenaltered!Callingioctl()tore-rea

14、dpartitiontable.Syncingdisks.#fdisk/dev/sdc重复上面操作#fdisk/dev/sdd重复上面操作#fdisk/dev/sde重复上面操作#fdisk/dev/sdf重复上面操作方法二：Linuxmount挂载(待解决)2. 安装依赖包#yuminstall-yexpect*iscsi*binutils*compat-libstdc+*expat*elfutils-libelf*gcc*glibc*ksh*libgcc*#yuminstall-ypdksh*libgomp*compat-db*libXp*libaio*cpp*setarch*syssta

15、t*libstdc+*make-3*#yuminstall-yunixODBC#yuminstall-yunixODBC-devel3. 查看依赖包安装状况#rpm-q-qf'%NAME-%VERSION-%RELEASE(%ARCH)n'binutilsunixODBC-devel执行结果elfutils-libelf-0.137-3.el5(x86_64)elfutils-libelf-0.137-3.el5(i386)elfutils-libelf-0.137-3.el5(x86_64)elfutils-libelf-0.137-3.el5(i386)glibc-2.5-

16、118.el5_10.2(i686)glibc-2.5-118.el5_10.2(x86_64)glibc-common-2.5-118.el5_10.2(x86_64)glibc-devel-2.5-118.el5_10.2(x86_64)glibc-devel-2.5-118.el5_10.2(i386)glibc-headers-2.5-118.el5_10.2(x86_64)make-3.81-3.el5(x86_64)4. 网络配置(1) 修改rac1和rac2的network#vi/etc/sysconfig/networkNETWORKING=yesNETWORKING_IPV6

17、=noHOSTNAME=rac1#处为主机名#vi/etc/sysconfig/networkNETWORKING=yesNETWORKING_IPV6=noHOSTNAME=rac2(2) 修改rac1和rac2的hosts#vi/etc/hosts#eth0-PublicIP#eth1-PRIVATEIP#VIP#SCAN#重启rac1和rac2网络服务#servicenetworkrestart(4)配置虚拟IP#*注：虚拟IP在重启网络服务会被卸载，需要重新设置。5. 配置NTPD!务NTPCB务为Grid的检查项，提供时间同步服务。修改NTP学数文件(rac1,rac2)#vi/et

18、c/sysconfig/ntpdSYNC_HWCLOCK=yesOPTIONS="-x-untp:ntp-p/var/run/ntpd.pid”修改rac1的ntpd.conf文件，删除原有内容录入以下内容#vi/etc/ntp.confserverfudgedriftfile/var/lib/ntp/driftbroadcastdelay0.008authenticatenokeys/etc/ntp/keys(3) 清空rac1的ntpservers原有内容#cp/etc/ntp/ntpservers/etc/ntp/ntpservers.bak#vi/etc/ntp/ntpser

19、vers(4) 编辑racl的step-tickers,添加一行#cp/etc/ntp/step-tickers/etc/ntp/step-tickers.bak#vi/etc/ntp/step-tickers修改rac2的ntpd.conf文件，删除原有内容录入以下内容#vi/etc/ntp.confserverserverfudgedriftfile/var/lib/ntp/driftbroadcastdelay0.008authenticatenokeys/etc/ntp/keys(6) 清空rac2的ntpservers原有内容#cp/etc/ntp/ntpservers/etc/nt

20、p/ntpservers.bak#vi/etc/ntp/ntpservers编辑rac2的step-tickers,添加一行#cp/etc/ntp/step-tickers/etc/ntp/step-tickers.bak#vi/etc/ntp/step-tickers#rac1的ip地址(8)racl节点重启NTPD!务#servicentpdrestartrac2节点停止NTPC®务，racl重启NTPDW务后5、6分钟再执行#servicentpdstop#ntpdaterac1#servicentpdstart(10)NTP而用自动加载(racl,rac2)#chkconfi

21、gntpdon6. 关闭服务关闭racl和rac2无用的sendmail和cups服务，加快开机速度。#chkconfigsendmailoff#chkconfigcupsoff7. 用户、用户组(1) 创建用户和用户组#groupadd-g501oinstall#groupadd-g502dba#groupadd-g504asmadmin#groupadd-g506asmdba#groupadd-g507asmoper#useradd-u501-goinstall-Gdba,asmadmin,asmdba,asmopergrid#useradd-u502-goinstall-Gdba,asm

22、dbaoracle#idoracle#idgrid(2) 修改用户密码#passwdoracle#passwdgrid8. 文件夹及权限#mkdir-p/u01/app/grid/#mkdir-p/u01/app/oraInventory#chown-Rgrid:oinstall/u01/app#chown-Roracle:oinstall/u01/app/oracle#chmod-R775/u019. 修改系统参数修改rac1和rac2的limits.conf#vi/etc/security/limits.conf#ORACLESETTINGgridsoftnproc2047gridhard

23、nproc16384gridsoftnofile1024gridhardnofile65536oraclesoftnproc2047oraclehardnproc16384oraclesoftnofile1024oraclehardnofile65536(2) 修改rac1和rac2的/etc/pam.d/login#vi/etc/pam.d/login#ORACLESETTINGsessionrequiredpam_limits.so(3) 修改rac1和rac2的/etc/sysctl.conf#vi/etc/sysctl.conf#ORACLESETTINGfs.aio-max-nr=1

24、048576fs.file-max=6815744kernel.shmall=2097152kernel.shmmni=4096执行命令(rac1、rac2)#sysctl-p修改racl和rac2的profile,在末尾添加#vi/etc/profileif$USER="oracle"|$USER="grid"thenif$SHELL="/bin/ksh"thenulimit-p16384ulimit-n65536elseulimit-u16384-n65536fiumask022fi(6) 执行命令(rac1、rac2)#sour

25、ce/etc/profile(7) 修改rac1和rac2的/etc/csh.login#vi/etc/csh.loginif($USER="oracle"|$USER="grid")thenlimitmaxproc16384limitdescriptors65536endifEOFCSH修改grid用户的环境变量#su-grid$cd/home/grid/$vi.bash_profileTMP=/tmp;exportTMPTMPDIR=$TMP;exportTMPDIRORACLE_SID=+ASM1;exportORACLE_SIDORACLE_BA

26、SE=/u01/app/grid;exportORACLE_BASE1ATNLS_DATE_FORMAT="yyyy-mm-ddHH24:MI:SS"exportNLS_DATE_FORMTHREADS_FLAG=native;exportTHREADS_FLAGPATH=$ORACLE_HOME/bin:$PATH;exportPATHTHREADS_FLAG=native;exportTHREADS_FLAGPATH=$ORACLE_HOME/bin:$PATH;exportPATHif$USER="oracle"|$USER="grid&

27、quot;thenif$SHELL="/bin/ksh"thenulimit-p16384ulimit-n65536elseulimit-u16384-n65536fiumask022fi#su-grid$cd/home/grid/$vi.bash_profileTMP=/tmp;exportTMPTMPDIR=$TMP;exportTMPDIRORACLE_SID=+ASM2;exportORACLE_SID1ATORACLE_BASE=/u01/app/grid;exportORACLE_BASENLS_DATE_FORMAT="yyyy-mm-ddHH24:

28、MI:SS"exportNLS_DATE_FORMTHREADS_FLAG=native;exportTHREADS_FLAGPATH=$ORACLE_HOME/bin:$PATH;exportPATHTHREADS_FLAG=native;exportTHREADS_FLAGPATH=$ORACLE_HOME/bin:$PATH;exportPATHif$USER="oracle"|$USER="grid"thenif$SHELL="/bin/ksh"thenulimit-p16384ulimit-n65536elseul

29、imit-u16384-n65536fiumask022fi执行命令(racl、rac2)$source.bash_profile(10)修改oracle用户的环境变量#su-oracle$cd/home/oracle/$vi.bash_profile#OracleSettingsoracleTMP=/tmp;exportTMPTMPDIR=$TMP;exportTMPDIRORACLE_BASE=/u01/app/oracle;exportORACLE_BASEORACLE_SID=orcl1;exportORACLE_SIDORACLE_TERM=xterm;exportORACLE_TE

30、RMPATH=/usr/sbin:$PATH;exportPATHPATH=$ORACLE_HOME/bin:$PATH;exportPATHLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;exportLD_LIBRARY_PATHCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;exportCLASSPATHNLS_DATE_FORMAT="yyyy-mm-ddHH24:MI:SS"exportNLS_DATE_FORMATNLS_LANG

31、=AMERICAN_AMERICA.ZHS16GBK;exportNLS_LANGif$USER="oracle"|$USER="grid"thenif$SHELL="/bin/ksh"thenulimit-p16384ulimit-n65536elseulimit-u16384-n65536fiumask022fi#su-grid$cd/home/grid/$vi.bash_profile#OracleSettingsoracleTMP=/tmp;exportTMPTMPDIR=$TMP;exportTMPDIRORACLE_BAS

32、E=/u01/app/oracle;exportORACLE_BASEORACLE_SID=orcl2;exportORACLE_SIDORACLE_TERM=xterm;exportORACLE_TERMPATH=/usr/sbin:$PATH;exportPATHPATH=$ORACLE_HOME/bin:$PATH;exportPATHLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;exportLD_LIBRARY_PATHCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rd

33、bms/jlib;exportCLASSPATHNLS_DATE_FORMAT="yyyy-mm-ddHH24:MI:SS"exportNLS_DATE_FORMATNLS_LANG=AMERICAN_AMERICA.ZHS16GBK;exportNLS_LANGif$USER="oracle"|$USER="grid"thenif$SHELL='7bin/ksh"thenulimit-p16384ulimit-n65536elseulimit-u16384-n65536fiumask022fi(11)执行命令(ra

34、c1、rac2)$source.bash_profile配置用户等效性使用Oracle用户，在所有节点执行#su-oracle$ssh-keygen-trsaGeneratingpublic/privatersakeypair.Enterfileinwhichtosavethekey(/home/oracle/.ssh/id_rsa):Createddirectory'/home/oracle/.ssh'.Enterpassphrase(emptyfornopassphrase):Entersamepassphraseagain:Youridentificationhasbee

35、nsavedin/home/oracle/.ssh/id_rsa.Yourpublickeyhasbeensavedin/home/oracle/.ssh/id_rsa.pub.Thekeyfingerprintis:be:8b:34:fd:c9:34:a7:2f:d2:f7:d9:30:1f:2e:48:d6oraclerac1$ssh-keygen-tdsaGeneratingpublic/privatedsakeypair.Enterfileinwhichtosavethekey(/home/oracle/.ssh/id_dsa):Enterpassphrase(emptyfornopa

36、ssphrase):Entersamepassphraseagain:Youridentificationhasbeensavedin/home/oracle/.ssh/id_dsa.Yourpublickeyhasbeensavedin/home/oracle/.ssh/id_dsa.pub.Thekeyfingerprintis:4f:bc:4b:9a:a6:cd:1c:15:e7:67:92:94:a2:cd:50:14oraclerac1使用Oracle用户，在节点rac1执行$cat/home/oracle/.ssh/*.pub>>/home/oracle/.ssh/au

37、thorized_keys$sshrac2cat/home/oracle/.ssh/*.pub>>/home/oracle/.ssh/authorized_keys$scp/home/oracle/.ssh/authorized_keysrac2:/home/oracle/.ssh/authorized_keys(3)验证Oracle用户等效性，在所有节点执行$sshrac2date$sshrac1date$sshrac2-vipdate$sshrac1-vipdate$sshrac2-privdate$sshrac1-privdates使用grid用户，在所有节点执行#su-gr

38、id$ssh-keygen-trsaGeneratingpublic/privatersakeypair.Enterfileinwhichtosavethekey(/home/grid/.ssh/id_rsa):Createddirectory'/home/grid/.ssh'.Enterpassphrase(emptyfornopassphrase):Entersamepassphraseagain:Youridentificationhasbeensavedin/home/grid/.ssh/id_rsa.Yourpublickeyhasbeensavedin/home/g

39、rid/.ssh/id_rsa.pub.Thekeyfingerprintis:39:1c:f5:9b:76:e1:de:20:40:e0:e8:20:77:fa:cd:97gridrac1$ssh-keygen-tdsaGeneratingpublic/privatedsakeypair.Enterfileinwhichtosavethekey(/home/grid/.ssh/id_dsa):Enterpassphrase(emptyfornopassphrase):Entersamepassphraseagain:Youridentificationhasbeensavedin/home/

40、grid/.ssh/id_dsa.Yourpublickeyhasbeensavedin/home/grid/.ssh/id_dsa.pub.Thekeyfingerprintis:08:a4:1b:87:89:fb:cd:93:3f:5d:f8:7b:f6:67:dd:4cgridrac1使用grid用户，在节点rac1执行$cat/home/grid/.ssh/*.pub>>/home/grid/.ssh/authorized_keys$sshrac2cat/home/grid/.ssh/*.pub>>/home/grid/.ssh/authorized_keys$

41、scp/home/grid/.ssh/authorized_keysrac2:/home/grid/.ssh/authorized_keys(6)验证grid用户等效性，在所有节点执行$sshrac2date$sshrac1date$sshrac2-vipdate$sshrac1-vipdate$sshrac2-privdate$sshrac1-privdates重启racl、rac2#reboot安装ASM检查系统及内核版本#unamaLinuxrac2#1SMPTueAug1815:51:48EDT2009x86_64x86_64x86_64GNU/Linux#lsb_release-aL

42、SBVersion:core-3.1-amd64:core-3.1-ia32:core-3.1-noarch:graphics-3.1-amd64:graphics-3.1-ia32:graphics-3.1-noarchDistributorID:RedHatEnterpriseServerDescription:RedHatEnterpriseLinuxServerrelease5.4(Tikanga)Release:5.4Codename:Tikanga下载与系统及内核版本对应的ASM下载地址：当前版本：安装asm包，按顺序安装#rpm-ivh-nodepsorac#初始化asmlib,

43、在所有节点执行#/usr/sbin/oracleasmconfigure-iConfiguringtheOracleASMlibrarydriver.Thiswillconfiguretheon-bootpropertiesoftheOracleASMlibrarydriver.Thefollowingquestionswilldeterminewhetherthedriverisloadedonbootandwhatpermissionsitwillhave.Thecurrentvalueswillbeshowninbrackets('').Hitting<ENTER&

44、gt;withouttypingananswerwillkeepthatcurrentvalue.Ctrl-Cwillabort.Defaultusertoownthedriverinterface:gridDefaultgrouptoownthedriverinterface:asmadminStartOracleASMlibrarydriveronboot(y/n)n:yScanforOracleASMdisksonboot(y/n)y:yWritingOracleASMlibrarydriverconfiguration:doneASMlib加载到内核，在所有节点执行#/usr/sbin

45、/oracleasminit创建asm磁盘，在节点racl执行#/usr/sbin/oracleasmcreatediskOCR_VOL1/dev/sdb1#/usr/sbin/oracleasmcreatediskOCR_VOL2/dev/sdc1#/usr/sbin/oracleasmcreatediskOCR_VOL3/dev/sdd1#/usr/sbin/oracleasmcreatediskDATA_VOL1/dev/sde1#/usr/sbin/oracleasmcreatediskBACK_VOL1/dev/sdf1rac2节点执行#/usr/sbin/oracleasmscan

46、disks#/usr/sbin/oracleasmlistdisks安装OracleGrid安装cvuqdisk(rac1,rac2)#exportCVUQDISK_GRP=oinstall#使用grid用户，进行oraclegrid安装前检查#su-grid$cd/Grid安装目录$./runcluvfy.shstage-precrsinst-nrac1,rac2-fixup-verbose.检查内容略Pre-checkforclusterservicessetupwassuccessful.更改DISPLAY设置#su-root#xhost+#DISPLAY=:0.0;exportDISP

47、LAY#su-grid$xhost+更改SELinxu设置#system-config-securitylevel执行安装Grid#su-grid$./runInstaller安装方式安装类型产品语言集群信息节点信息指定网络接口用法存储选项信息创建ASM®盘组指定ASMI口令，使用统一口令：Nortek123故障隔离支持角色分配指定安装路径创建产品清单安装检测安装概要正在安装以root用户在racl和rac2运行脚本#OracleClusterVerificationUtility失败可以忽略OracleGrid安装完成16. 确认安装成功$crs_stat-t-v配置ASMB盘组启

48、动ASMB盘组创建向导，点击新建；#su-grid$asmca创建DATA1盘组创建BAC飕盘组创建完成安装OraclellG启动oracle安装程序#su-oracle$cd/oracle11G安装目录$./runInstaller&仅安装数据库软件选择两个节点添加简体中文选择企业版默认安装目录默认用户分配安装前检查安装概要执行安装用户root在rac1和rac2执行脚本Oracle软件安装成功创建数据库启动数据库创建向导#su-oracle$dbca创建数据库安装一般用途数据库填写数据库名称，选择两个节点使用默认选项使用统一口令(orcl)选择数据文件存储路径选择+DATA输入AS

49、M口令(Nortek123)选择归档模式，添加归档参数添加参数“+BACK/'使用默认设置设置数据库参数SGA(注：SG虾可大于/dev/shm)选择数据库字符集(utf8，根据需求)安装概述点击Finish设置完毕点击OK开始安装正在安装数据库创建成功创建表空间#su-oracle$sqlplussys/orclorclassysdbaSQL>createtablespaceimatrixdatafile'+DATA/orcl/imatrix.dbf'size100Mautoextendonnext10Msegmentspacemanagementautoext

50、entmanagementlocal;创建用户并指定默认表空间SQL>createuserjwjidentifiedbyjwjdefaulttablespaceimatrix;用户分权SQL>grantdba,connect,resource,createtable,createsessiontojwj;日常维护RAC勺启停关闭crsctlstopcluster停止本节点集群服务crsctlstopclusterall停止所有节点服务启动crsctlstartcluster停止本节点集群服务crsctlstartcluster-all停止所有节点服务RAC佥查运行状态crsctlc

51、heckclusterDATABASE查实例状态srvctlstatusdatabase-dorcl检查节点应用状态及配置srvctlstatusnodeappssrvctlconfignodeapps-a-g-s-l查看数据配置srvctlconfigdatabase-dorcl-a检查ASM犬态及配置srvctlstatusasmsrvctlconfigasm-a检查TNS的状态及配置srvctlstatuslistenersrvcticonfiglistener-a检查SCAN犬态及配置srvctlstatusscansrvctlconfigscan检查VIP状态及配置srvctlstatusvip-nraclsrvctlstatusvip-nrac2srvctlconfigvip-nrac1srvctlconfigvip-nrac2四、RAC负载均衡配置1. RAC负载均衡概述RAC勺负载均衡主要是指新会话连接到RACB据库时，如