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-lF"aliasbdump='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=$ORA...