OracleRestart[11204]“加”ASM“加”RHEL5安装手册

OracleRestart+ASM+RHEL5安装手册Oraclerestart数据库是在原来单实例数据库的基础上，利用了Clusterware增强了单实例数据库的可用性.可以使用srvctl,crsctl命令管理单实例数据库，当服务器重起或进程异常终止时，能够自动启动数据库.一OS环境配置1创建用户groupadd–g600dbauseradd–u600–gdba–Gdbaoracleuseradd–u601–gdba–Gdbagridchown–Roracle:dba/oraclechown–Rgrid:dba/gridchmod–R775/oraclechmod–R775/grid2版本及kernelRHEL55.2以上,kernel2.6.18以后RHEL66.0以后kernel2.6.32-71.el6.x86_64以后3安装rpm包查询rpm包是否安装rpm-q--qf'%{NAME}-%{VERSION}-%{RELEASE}(%{ARCH})\n'binutils\compat-libstdc++-33\elfutils-libelf\elfutils-libelf-devel\gcc\gcc-c++\glibc\glibc-common\glibc-devel\glibc-headers\ksh\libaio\libaio-devel\libgcc\libstdc++\libstdc++-devel\make\sysstat\unixODBC\unixODBC-develRHEL5binutils-2.17.50.0.6compat-libstdc++-33-3.2.3compat-libstdc++-33-3.2.3(32bit)elfutils-libelf-0.125elfutils-libelf-devel-0.125gcc-4.1.2gcc-c++-4.1.2glibc-2.5-24glibc-2.5-24(32bit)glibc-common-2.5glibc-devel-2.5glibc-devel-2.5(32bit)glibc-headers-2.5ksh-20060214libaio-0.3.106libaio-0.3.106(32bit)libaio-devel-0.3.106libaio-devel-0.3.106(32bit)libgcc-4.1.2libgcc-4.1.2(32bit)libstdc++-4.1.2libstdc++-4.1.2(32bit)libstdc++-devel4.1.2make-3.81sysstat-7.0.2unixODBC-2.2.11unixODBC-2.2.11(32bit)unixODBC-devel-2.2.11unixODBC-devel-2.2.11(32bit)REHL6binutils-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.i686orlater4kernel参数编译/etc/sysctl.conf,增加以下内容kernel.msgmnb=65536kernel.msgmax=65536kernel.msgmni=2878kernel.sem=250320000100128kernel.shmmni=4096kernel.shmmax=42949672960kernel.shmall=2097152net.core.rmem_default=262144net.core.rmem_max=4194304net.core.wmem_default=262144net.core.wmem_max=1048576fs.aio-max-nr=1048576fs.file-max=6815744net.ipv4.ip_local_port_range=9000655005用户限制编译/etc/security/limits.conforaclehardnofile65536oraclesoftnofile65536oraclesoftstack10240oraclehardnproc16384oraclesoftnproc16384gridhardnofile65536gridsoftnofile65536gridsoftstack10240gridhardnproc16384gridsoftnproc163846环境变量Oracle用户#FOroracleenvexportORACLE_SID=NGDWATESTexportORACLE_BASE=/oracleexportORACLE_HOME=$ORACLE_BASE/dbexportLD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:/usr/lib:/libexportPATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch#Forcommandaliasaliasss=sqlplus'/assysdba'aliasls=ls-lFaliasbdump='cd/oracle/diag/rdbms/dwatest/DWATEST/trace'sttyerase^HexportTMOUT=0grid用户#ForgridenvexportORACLE_SID=+ASMexportORACLE_BASE=/oracleexportORACLE_HOME=/grid#foramshomeexportGRID_HOME=/grid#forgridhomeexportLD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:/usr/lib:/libexportPATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$GRID_HOME/bin:$PATH#Forcommandaliasaliasss=sqlplus'/assysasm'aliasls=ls-lFaliasbdump='cd/oracle/diag/asm/+asm/+ASM/trace'sttyerase^HexportTMOUT=0二安装GridInfrastructure1安装gridGrid用户执行runInstaller[grid@HA2-BI-CS01gird]$./runInstaller选择skipsoftwareupdates注:此处可选择installoraclegridinfrastructuresoftwareonly或configureoraclegridinfrastructureastandaloneserver，时选择后者时ocr必须放在ASM上。选择osgroupdba指定oracle_base,grid_home路径指定oraInventory路径检查包,参数配置等注:oraclerestart不需要要使用dns,无需配置resove.conf可忽略Root用户执行orainstRoot.sh,root.sh脚本说明:orainstRoot.sh脚本是为了设置清单目录的权限Root.sh调用了一些其它脚本,主要包括clusterware和系统配置工作.[root@HA2-BI-CS01~]#/oracle/oraInventory/orainstRoot.shChangingpermissionsof/oracle/oraInventory.Addingread,writepermissionsforgroup.Removingread,write,executepermissionsforworld.Changinggroupnameof/oracle/oraInventorytodba.Theexecutionofthescriptiscomplete.[root@HA2-BI-CS01~]#/grid/root.shPerformingrootuseroperationforOracle11gThefollowingenvironmentvariablesaresetas:ORACLE_OWNER=gridORACLE_HOME=/gridEnterthefullpathnameofthelocalbindirectory:[/usr/local/bin]:Copyingdbhometo/usr/local/bin...Copyingoraenvto/usr/local/bin...Copyingcoraenvto/usr/local/bin...Creating/etc/oratabfile...Entrieswillbeaddedtothe/etc/oratabfileasneededbyDatabaseConfigurationAssistantwhenadatabaseiscreatedFinishedrunninggenericpartofrootscript.Nowproduct-specificrootactionswillbeperformed.ToconfigureGridInfrastructureforaStand-AloneServerrunthefollowingcommandastherootuser:/grid/perl/bin/perl-I/grid/perl/lib-I/grid/crs/install/grid/crs/install/roothas.plToconfigureGridInfrastructureforaClusterexecutethefollowingcommand:/grid/crs/config/config.shThiscommandlaunchestheGridInfrastructureConfigurationWizard.Thewizardalsosupportssilentoperation,andtheparameterscanbepassedthroughtheresponsefilethatisavailableintheins