在vmwarevsphereesxi上安装oracleRAC

OracleDatabasesonVMwareRAC安装手册Contents1.Introduction52.InfrastructureEnvironment62.1Hardware62.2SoftwareEnvironment62.3VMwareVirtualMachines62.4VirtualDiskLayout72.5OracleRACDatabaseEnvironment72.6NetworkConfiguration72.7PhysicalArchitecture102.8LogicalArchitecture113.OverviewofDeploymentSteps124.ConfigureNTPClientonAllESXHosts135.PrepareaVirtualMachinefortheFirstRACNode155.1CreateaVirtualMachine155.2AddTwoNICs155.3AddCRSandVotingDisk165.4InstalltheGuestOperatingSystem195.5InstallVMwareTools215.6TimekeepingwiththeLinuxGuestOperatingSystem296.PrepareSubsequentVirtualMachines/RACNodes306.1ClonetheFirstVirtualMachine/RACNode306.2ConfigureCSRandVotingDisks326.3FormattheAddedDisksUsingfdisk347.InstallOracleGridInfrastructure358.VerifytheGridInfrastructureInstallation379.AddDATAandREDODiskstoVirtualMachineRACNodes3910.CreateDATAandREDOASMDiskGroupsasGridUser4311.InstallandCreatetheOracleDatabase11gR2RAC4412.References45介绍本文通过一个 案例 全员育人导师制案例信息技术应用案例心得信息技术教学案例综合实践活动案例我余额宝案例 简要介绍OracleRealApplicationClusters(RAC)在VMwarevSphere®平台上的安装过程,帮助Oracle数据库管理员在VMware平台上规划和实施OracleRAC环境.在VMware环境下,数据库管理员通常需要和VMware的管理员以及存储厂商的管理员合作,以顺利部署一个OracleRAC环境.在虚拟化平台上部署OracleRAC在许多方面与纯物理环境上的部署很类似,比如:在虚拟机创建完成之后,安装操作系统和OracleRAC软件的过程与物理环境下基本一致存储的规划,包括用于数据存放的LUN数量的规划和多路径的设计与物理环境也基本一致.差别在于我们可以充分依靠虚拟化软件,简化许多工作,从而加快安装进度,减少错误的发生,比如:利用事先准备好的模板,多次安装同版本的系统和数据库,同时加强 标准 excel标准偏差excel标准偏差函数exl标准差函数国标检验抽样标准表免费下载红头文件格式标准下载 化利用快照技术,很方便的进行测试和回退利用虚拟机复制技术,简化多个RAC节点的系统安装、打补丁、配置工作由于安装过程的细节与软件版本（尤其是Linux版本和Oracle版本）有较强的关联性，本文只能尽量把安装步骤描述清楚.读者在自己进行安装的时候，还需要参考相应版本的官方安装文档.先将本次安装中用到的主要软件和版本罗列如下：VMwareESXi™5.1VMwarevCenterServer™5.1vSphereClient5.1OracleDatabase11g11.2.0.3.OracleEnterpriseLinuxx86_646.3.软硬件环境硬件组件数量配置ESXiHosts2CiscoUCSB4404x10-coreCPUs,256GBRAM,and4NICsStorage1NetAppF3240双路控制器EthernetSwitches2CiscoFI6248FCSwitches1CiscoNexus7000HostBasedAdapters4每个刀片两个，与网卡共享流量软件环境组件版本作用vSphere5.1HypervisorhostingallvirtualmachinesVMwarevCenter™5.1管理vSphereOracleEnterpriseLinuxx86_646.3GuestoperatingsystemforvirtualmachinesrunningOracleDatabaseserverOracleDatabase11g(withOracleRACandOracleGridInfrastructure)EnterpriseEdition11.2.0.3MicrosoftWindowsServer2008R2用于vCenterServer虚拟机配置虚拟机用途数量配置OracleRACnodes220vCPU,120GBRAM,OracleEnterpriseLinuxx86_646.3vCenter12vCPUs,8GBRAM,WindowsServer2008R2共享存储配置DatastoreNameVirtualDiskonESXLinux路径虚拟路径驱动类型VMDKSize(GB)用途VMDATASTOREVMDK–Harddisk1/dev/sdaSCSI0:0LSILogic150OracleEnterpriseLinux5.5OSandOraclebinariesCRS1VMDK–Harddisk2Shareddisk/dev/sdb1SCSI1:0Paravirtual20CRSandvotingdiskREDO1VMDK–Harddisk3Shareddisk/dev/sdc1SCSI1:1Paravirtual900REDOandArchieveDATA01VMDK–Harddisk4Shareddisk/dev/sdd1SCSI2:0Paravirtual1000RACdatabaseDATADATA02VMDK–Harddisk5Shareddisk/dev/sde1SCSI2:1Paravirtual1000RACdatabaseDATADATA03VMDK–Harddisk6Shareddisk/dev/sdf1SCSI3:0Paravirtual1000RACdatabaseDATADATA04VMDK–Harddisk7Shareddisk/dev/sdg1SCSI3:1Paravirtual1000RACdatabaseDATAOracleRAC数据库环境NodeNameASMInstanceRACInstanceDatabaseASMStorageRAC1+ASM1RAC1RACASMfilesystemRAC2+ASM2RAC2RACASMfilesystem网络配置按照OracleRAC的实施惯例，每个RAC节点都提供一个Public网口用于承载业务，并在其上捆绑虚拟IP地址(VIP)用于HA切换..各RAC节点之间还需要一个私有网络进行节点之间的通信。在物理环境中，通常需要考虑链路的冗余以消除单点鼓掌。而在虚拟化环境中，冗余问 题 快递公司问题件快递公司问题件货款处理关于圆的周长面积重点题型关于解方程组的题及答案关于南海问题 由底层虚拟化软件处理，所以对于每个RAC节点，只是简单地需要两个网口就可以工作，大大简化了配置和安装工作.我们这次测试的网络配置如下三:UCS底层软件配置出三个物理网口（均为10Gb）–vmnic0和vmnic1用于OraclePublicandOraclePrivate网络,vmnic2用于vSphere®vMotion®工作.两个分布式虚拟交换机–OraclePublic(VMNet)andOraclePrivate(OracleHB).每个RAC节点配置3个IP地址–以节点1(RAC1)为例:OnepublicstaticIPaddress(eth0):162.16.3.101OneprivatestaticIPaddress(eth1):192.168.2.30OnevirtualstaticIPaddress(VIP):162.16.3.111（由CRS软件配置和管理）还有三个虚拟IP用于节点间负载均衡(SCAN):162.16.3.200,162.16.3.201,162.16.3.202（由CRS配置和管理）物理网口vmnic0连接到分布式交换机VMNet,vmnic1连接到分布式交换机OracleHB，vMotion使用标准交换机vSwitch3.这样区分概念上比较清晰，也可以只建一个分布式网络，用不同的端口组区分数据网络和心跳网。Figure1.NetworkConfiguration逻辑结构图Figure3.LogicalArchitectureofTwo-NodeOracleRAConvSphere部署 流程 快递问题件怎么处理流程河南自建厂房流程下载关于规范招聘需求审批流程制作流程表下载邮件下载流程设计 概览部署流程大体按照下面的流程图进行.Figure4.DeploymentStepsforFour-NodeOracleRAConvSpherewithVMFS为第一个RAC节点准备虚拟机环境本节安装步骤简介如下:使用vSphereClient创建第一个虚拟机。添加公网和心跳网卡，挑选适当的LUN创建仲裁盘CRS（VMDK模式）。安装RedhatLinux操作系统，安装VMwaretools，按照OracleRAC要求安装相应补丁.在Linux中配置NTP客户端.创建第一个虚拟机使用vSphereClient登录vCenter.选中一台主机,在GettingStarted页面单击Createanewvirtualmachine.IntheCreateNewVirtualMachinewizard,selectTypicalfortheConfiguration,andclickNext.OntheNameandLocationpage,enterRAC1fortheName,andclickNext.OntheDatastorepage,selectVMDATASTORE,andclickNext.OntheGuestOperatingSystempage,selectLinuxfromtheGuestOperatingSystemlist.FortheVersion,selectOracleLinux6(64-bit)fromthedrop-downmenu.ClickNext.OntheCreateaDiskpage,settheVirtualDiskSizeto20GB,andclickNext.OntheReadytoCompletepage,selectEditthevirtualmachinesettingsbeforecompletion.ClickContinue.OntheVirtualMachinePropertiespagefortheRAC1virtualmachine,select8CPUsand128GBMemory.ClickFinish.增加两个虚拟网卡现在需要增加两块网卡.一块用于公共数据网络,另一块用于心跳网络.添加这两块网卡的过程基本相同,差别仅在于添加公网网卡时选择标签:VMNet而添加心跳网卡时选择OracleHB.添加公网网卡的步骤：Selectavirtualmachine.ClickEditsettingstodisplaytheVirtualMachinePropertiespane.ClickAdd.SelectEthernetAdaptorandclickNexttodisplaytheAddHardwarewizard.OntheNetworkconnectionpage,selectVMXNET3fromtheAdapterTypedrop-downmenu.IntheNetworkConnectionsectionoftheNetworkconnectionpage,selectNamednetworkwithspecifiedlabel.IntheNamednetworkwithspecifiedlabeldrop-downmenu,selectVMNet.IntheDeviceStatussectionoftheNetworkconnectionpage,selectConnectatpoweron.OntheReadytoCompletepage,clickFinish,andthenclickOK.添加心跳网卡的步骤：Repeatsteps1through6fromtheprecedingprocedure.IntheNamednetworkwithspecifiedlabeldrop-downmenu,selectOracleHB.Continuewithsteps8and9fromtheprecedingprocedure.添加仲裁盘OracleRAC需要至少一个共享的仲裁盘存放clusterware信息和节点投票信息。存储管理员需要事先为仲裁盘分配好单独的LUN，然后我们需要创建单独的SCSI控制器并设为Paravirtual驱动.SCSI总线sharingpolicy设为none.下面描述创建共享存储的步骤.为虚拟机创建20GBdatastore：InvSphereClient,selectavirtualmachine.Right-clickthenameofthevirtualmachineandselectEditSettingstodisplaytheVirtualMachinePropertiespane.ClickAddtodisplaytheAddHardwarewizard.IntheAddHardwarewizardselectHardDiskfortheDeviceType,andclickNext.IntheDisksectionoftheSelectaDiskpage,selectCreateanewvirtualdisk.Setthedisksizeto20GB,selecttheSupportclusteringfeaturessuchasFaultTolerancecheckbox,andselectCRS1tospecifyadatastore.Also,forvSphere5,intheDiskProvisioningsectionselectThickProvisionEagerZeroed.ClickNext.OntheCompatibilityModepage,clickNext.OntheAdvancedOptionspage,intheVirtualDeviceNodesection,selectSCSI(1:0).IntheModesection,selectIndependent.ClickNext.OntheReadytoCompletepage,clickFinish.ClickOK.AddconfigurationparametersforeachOracleRACvirtualmachineasdescribedinDisablingsimultaneouswriteprotectionprovidedbyVMFSusingthemulti-writerflag(http://kb.vmware.com/kb/1034165).手工修改虚拟机参数InvSphereClient,selectavirtualmachine.Right-clickthenameofthevirtualmachineandselectEditSettingstodisplaytheVirtualMachinePropertiespane.ClicktheOptionstab,clickAdvanced,andclickGeneral.ClickConfigurationParameters.OntheConfigurationParameterspage,addrowsandentriesfortheshareddisksinthevirtualmachine'sconfigurationparametersasshowninthefollowingscreenshot.Repeatsteps1through5foreachoftheremainingvirtualmachines.YoucanviewthevirtualmachinepropertiesfortheRAC1virtualmachineinvCenterasinthefollowingscreenshot.webclient显示如下图：安装操作系统将OEL6.4安装介质ISO文件上传到datastore，然后进行安装。Note:ThisdocumentisspecifictoLinuxguestoperatingsystem.OracleRAC11.2.0.2andaboveversionscanbedeployedandsupportedonthelistofguestoperationsystemsusingVMwaremulti-writerflag(http://kb.vmware.com/kb/1008027).在虚拟机上安装Linux操作系统InvSphereClient,selectavirtualmachine.ClickEditsettings.IntheHardwaretaboftheVirtualMachinePropertiespane,selectCD/DVDDrive1.IntheDeviceStatussectionofthispane,selecttheConnectatpoweroncheckbox.IntheDeviceTypesectionofthispane,selectDatastoreISOFileandenterthepathtoyourLinuxISOimagefile.IntheVirtualDeviceNodesectionofthispane,selectCD/DVDDrive1fromthedrop-downmenu.ClickOK.Poweronthevirtualmachine.InstallLinuxwiththefollowingsettings.Custompartitioningscheme:/dev/sda1ext3150GBmountedon/Installedpackages–usethedefaultpackageselection,plusthefollowing:kernel-uek.x86_64kmod-oracleasmoracleasm-2.6.18-194.el5-2.0.5-1.el5.x86_64(downloadfromhttp://www.oracle.com/technetwork/topics/linux/asmlib/index-101839.html.)oracleasm-support-2.1.3-1.el5.x86_64systat-7.0.2-3.el5.x86_64Usebelowscripttoinstallremainingpackages:yuminstallbinutils\compat-libcap1\compat-libstdc++-33\compat-libstdc++-33.i686\gcc.x86_64\gcc-c++.x86_64\glibc.x86_64\glibc.i686\glibc-devel.x86_64\glibc-devel.i686\unixODBC.i686\unixODBC.x86_64\unixODBC-devel.x86_64\unixODBC-devel.i686\libgcc.x86_64\libgcc.i686\libstdc++.x86_64\libstdc++.i686\libstdc++-devel.x86_64\libstdc++-devel.i686\compat-libstdc++-33.x86_64\compat-libstdc++-33.i686\libaio.x86_64\libaio.i686\libaio-devel.x86_64\libaio-devel.i686\sysstat.x86_64\ksh\libXtst-devel.x86_64\libXtst.i686\compat-db.x86_64\xorg-x11-utils.x86_64\xorg-x11-xinit.x86_64\makeViewtheinstalledpackageswiththiscommand:runcommand“rpm–qConfirmthatthefollowingpackageshavebeeninstalled:binutils-2.20.51.0.2-5.11.el6(x86_64)compat-libcap1-1.10-1(x86_64)compat-libstdc++-33-3.2.3-69.el6(x86_64)compat-libstdc++-33-3.2.3-69.el6.i686gcc-4.4.4-13.el6(x86_64)gcc-c++-4.4.4-13.el6(x86_64)glibc-2.12-1.7.el6(i686)glibc-2.12-1.7.el6(x86_64)glibc-devel-2.12-1.7.el6(x86_64)glibc-devel-2.12-1.7.el6.i686kshlibgcc-4.4.4-13.el6(i686)libgcc-4.4.4-13.el6(x86_64)libstdc++-4.4.4-13.el6(x86_64)libstdc++-4.4.4-13.el6.i686libstdc++-devel-4.4.4-13.el6(x86_64)libstdc++-devel-4.4.4-13.el6.i686libaio-0.3.107-10.el6(x86_64)libaio-0.3.107-10.el6.i686libaio-devel-0.3.107-10.el6(x86_64)libaio-devel-0.3.107-10.el6.i686make-3.81-19.el6sysstat-9.0.4-11.el6(x86_64)unixODBC-2.2.14-11.el6(x86_64)orlaterunixODBC-2.2.14-11.el6.i686orlaterunixODBC-devel-2.2.14-11.el6(x86_64)orlaterunixODBC-devel-2.2.14-11.el6.i686orlater最后安装下面两个包:oracle-rdbms-server-11gR2-preinstall(从YUM安装，这个包会配置OracleRAC所需系统参数和环境变量)cvuqdisk(Oracle安装介质中提供这个包，用于安装前检查)检查配置文件/etc/sysctl.confkernel.shmmni=4096 kernel.sem=25032000100128 fs.file-max=6815744 (512xprocessesforexample6815744for13312processes)net.ipv4.ip_local_port_range=900065500 net.core.rmem_default=262144 net.core.rmem_max=4194304 net.core.wmem_default=262144 net.core.wmem_max=1048576 kernel.shmall=physicalRAMsize/pagesizeFormostsystems,thiswillbethevalue2097152.See Note:301830.1 formoreinformation. eg:kernel.shmall=4160749568(62GB)kernel.shnmax= 34359738368(32GB)kernel.shmmax=RAMtimes0.5(orhigheratcustomer'sdiscretion-seeNote:567506.1) /etc/profileulimit–u16384ulimit–n65535依照oracle传统，创建clusterware主用户“grid”:[root@racnode1~]#groupadd-g1000oinstall[root@racnode1~]#groupadd-g1200asmadmin[root@racnode1~]#groupadd-g1201asmdba[root@racnode1~]#groupadd-g1202asmoper[root@racnode1~]#useradd-m-u1100-goinstall-Gasmadmin,asmdba,asmoper-d/home/grid-s/bin/bash-c"GridInfrastructureOwner"grid[root@racnode1~]#idgriduid=1100(grid)gid=1000(oinstall)groups=1000(oinstall),1200(asmadmin),1201(asmdba),1202(asmoper)设置 grid 帐户的口令：[root@racnode1~]#passwdgridChangingpasswordforusergrid.NewUNIXpassword:xxxxxxxxxxxRetypenewUNIXpassword:xxxxxxxxxxxpasswd:allauthenticationtokensupdatedsuccessfully.为grid用户创建初始化脚本(/home/grid/.bash_profile):#---------------------------------------------------#.bash_profile#---------------------------------------------------#OSUser:grid#Application:OracleGridInfrastructure#Version:Oracle11grelease2#---------------------------------------------------#Getthealiasesandfunctionsif[-f~/.bashrc];then.~/.bashrcfialiasls="ls-FA"#---------------------------------------------------#ORACLE_SID#---------------------------------------------------#SpecifiestheOraclesystemidentifier(SID)#fortheAutomaticStorageManagement(ASM)instance#runningonthisnode.#EachRACnodemusthaveauniqueORACLE_SID.#(i.e.+ASM1,+ASM2,...)#---------------------------------------------------ORACLE_SID=+ASM1;exportORACLE_SID#---------------------------------------------------#JAVA_HOME#---------------------------------------------------#SpecifiesthedirectoryoftheJavaSDKandRuntime#Environment.#---------------------------------------------------JAVA_HOME=/usr/local/java;exportJAVA_HOME#---------------------------------------------------#ORACLE_BASE#---------------------------------------------------#SpecifiesthebaseoftheOracledirectorystructure#forOptimalFlexibleArchitecture(OFA)compliant#installations.TheOraclebasedirectoryforthe#gridinstallationowneristhelocationwhere#diagnosticandadministrativelogs,andotherlogs#associatedwithOracleASMandOracleClusterware#arestored.#---------------------------------------------------ORACLE_BASE=/u01/app/grid;exportORACLE_BASE#---------------------------------------------------#ORACLE_HOME#---------------------------------------------------#SpecifiesthedirectorycontainingtheOracle#GridInfrastructuresoftware.Forgrid#infrastructureforaclusterinstallations,theGrid#homemustnotbeplacedunderoneoftheOraclebase#directories,orunderOraclehomedirectoriesof#OracleDatabaseinstallationowners,orinthehome#directoryofaninstallationowner.During#installation,ownershipofthepathtotheGrid#homeischangedtoroot.Thischangecauses#permissionerrorsforotherinstallations.#---------------------------------------------------ORACLE_HOME=/u01/app/11.2.0/grid;exportORACLE_HOME#---------------------------------------------------#ORACLE_PATH#---------------------------------------------------#SpecifiesthesearchpathforfilesusedbyOracle#applicationssuchasSQL*Plus.Ifthefullpathto#thefileisnotspecified,orifthefileisnot#inthecurrentdirectory,theOracleapplication#usesORACLE_PATHtolocatethefile.#ThisvariableisusedbySQL*Plus,FormsandMenu.#---------------------------------------------------ORACLE_PATH=/u01/app/oracle/common/oracle/sql;exportORACLE_PATH#---------------------------------------------------#SQLPATH#---------------------------------------------------#Specifiesthedirectoryorlistofdirectoriesthat#SQL*Plussearchesforalogin.sqlfile.#---------------------------------------------------#SQLPATH=/u01/app/common/oracle/sql;exportSQLPATH#---------------------------------------------------#ORACLE_TERM#---------------------------------------------------#Definesaterminaldefinition.Ifnotset,it#defaultstothevalueofyourTERMenvironment#variable.Usedbyallcharactermodeproducts.#---------------------------------------------------ORACLE_TERM=xterm;exportORACLE_TERM#---------------------------------------------------#NLS_DATE_FORMAT#---------------------------------------------------#Specifiesthedefaultdateformattousewiththe#TO_CHARandTO_DATEfunctions.Thedefaultvalueof#thisparameterisdeterminedbyNLS_TERRITORY.The#valueofthisparametercanbeanyvaliddate#formatmask,andthevaluemustbesurroundedby#doublequotationmarks.Forexample:##NLS_DATE_FORMAT="MM/DD/YYYY"##---------------------------------------------------NLS_DATE_FORMAT="DD-MON-YYYYHH24:MI:SS";exportNLS_DATE_FORMAT#---------------------------------------------------#TNS_ADMIN#---------------------------------------------------#SpecifiesthedirectorycontainingtheOracleNet#Servicesconfigurationfileslikelistener.ora,#tnsnames.ora,andsqlnet.ora.#---------------------------------------------------TNS_ADMIN=$ORACLE_HOME/network/admin;exportTNS_ADMIN#---------------------------------------------------#ORA_NLS11#---------------------------------------------------#Specifiesthedirectorywherethelanguage,#territory,characterset,andlinguisticdefinition#filesarestored.#---------------------------------------------------ORA_NLS11=$ORACLE_HOME/nls/data;exportORA_NLS11#---------------------------------------------------#PATH#---------------------------------------------------#Usedbytheshelltolocateexecutableprograms;#mustincludethe$ORACLE_HOME/bindirectory.#---------------------------------------------------PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/binPATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/binPATH=${PATH}:/u01/app/common/oracle/binexportPATH#---------------------------------------------------#LD_LIBRARY_PATH#---------------------------------------------------#Specifiesthelistofdirectoriesthattheshared#libraryloadersearchestolocatesharedobject#librariesatruntime.#---------------------------------------------------LD_LIBRARY_PATH=$ORACLE_HOME/libLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/libLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/libexportLD_LIBRARY_PATH#---------------------------------------------------#CLASSPATH#---------------------------------------------------#Specifiesthedirectoryorlistofdirectoriesthat#containcompiledJavaclasses.#---------------------------------------------------CLASSPATH=$ORACLE_HOME/JRECLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlibCLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlibCLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlibexportCLASSPATH#---------------------------------------------------#THREADS_FLAG#---------------------------------------------------#AllthetoolsintheJDKusegreenthreadsasa#default.Tospecifythatnativethreadsshouldbe#used,settheTHREADS_FLAGenvironmentvariableto#"native".Youcanreverttotheuseofgreen#threadsbysettingTHREADS_FLAGtothevalue#"green".#---------------------------------------------------THREADS_FLAG=native;exportTHREADS_FLAG#---------------------------------------------------#TEMP,TMP,andTMPDIR#---------------------------------------------------#Specifythedefaultdirectoriesfortemporary#files;ifset,toolsthatcreatetemporaryfiles#createtheminoneofthesedirectories.#---------------------------------------------------exportTEMP=/tmpexportTMPDIR=/tmp#---------------------------------------------------#UMASK#---------------------------------------------------#Setthedefaultfilemodecreationmask#(umask)to022toensurethattheuserperforming#theOraclesoftwareinstallationcreatesfiles#with644permissions.#---------------------------------------------------umask022创建oracle账号“oracle”:[root@racnode1~]#groupadd-g1300dba[root@racnode1~]#groupadd-g1301oper[root@racnode1~]#useradd-m-u1101-goinstall-Gdba,oper,asmdba-d/home/oracle-s/bin/bash-c"OracleSoftwareOwner"oracle[root@racnode1~]#idoracleuid=1101(oracle)gid=1000(oinstall)groups=1000(oinstall),1201(asmdba),1300(dba),1301(oper)然后为oracle用户创建登录环境(/home/oracle/.bash_profile)#---------------------------------------------------#.bash_profile#---------------------------------------------------#OSUser:oracle#Application:OracleDatabaseSoftwareOwner#Version:Oracle11grelease2#---------------------------------------------------#Getthealiasesandfunctionsif[-f~/.bashrc];then.~/.bashrcfialiasls="ls-FA"#---------------------------------------------------#ORACLE_SID#---------------------------------------------------#SpecifiestheOraclesystemidentifier(SID)for#theOracleinstancerunningonthisnode.#EachRACnodemusthaveauniqueORACLE_SID.#(i.e.racdb1,racdb2,...)#---------------------------------------------------ORACLE_SID=racdb1;exportORACLE_SID#---------------------------------------------------#ORACLE_UNQNAME#---------------------------------------------------#InpreviousreleasesofOracleDatabase,youwere#requiredtosetenvironmentvariablesfor#ORACLE_HOMEandORACLE_SIDtostart,stop,and#checkthestatusofEnterpriseManager.With#OracleDatabase11grelease2(11.2)andlater,you#needtosettheenvironmentvariablesORACLE_HOME#andORACLE_UNQNAMEtouseEnterpriseManager.#SetORACLE_UNQNAMEequaltothedatabaseunique#name.#---------------------------------------------------ORACLE_UNQNAME=racdb;exportORACLE_UNQNAME#---------------------------------------------------#JAVA_HOME#---------------------------------------------------#SpecifiesthedirectoryoftheJavaSDKandRuntime#Environment.#---------------------------------------------------JAVA_HOME=/usr/local/java;exportJAVA_HOME#---------------------------------------------------#ORACLE_BASE#---------------------------------------------------#SpecifiesthebaseoftheOracledirectorystructure#forOptimalFlexibleArchitecture(OFA)compliant#databasesoftwareinstallations.#---------------------------------------------------ORACLE_BASE=/u01/app/oracle;exportORACLE_BASE#---------------------------------------------------#ORACLE_HOME#---------------------------------------------------#SpecifiesthedirectorycontainingtheOracle#Databasesoftware.#---------------------------------------------------ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1;exportORACLE_HOME#-------