oracle10g rac for soalris10文档

编写人：李真旭QQ264752493个人博客安装以及维护文档前言：本文将介绍在Oraclerac的安装以及crs日常维护的相关命令。以下是安装crs以及db的基本步骤：一、检查硬件环境/usr/sbin/prctconf|grep“Memorysize”/usr/sbin/swap–s查看交换分区的大小df–k/tmp查看临时目录的大小备注：当物理内存大于1G或小于2G时，swap=1.5物理内存当物理内存大于2G时，swap=物理内存临时目录至少大于等于400MDiskspacefororaclesoftware4G(建议8G以上)----以上为官方文档推荐值二、检查软件环境（安装oracle所需要的一些包）检查方法如下：#pkginfoSUNWarc,SUNWbtool,SUNWhea,SUNWlibm，,SUNWlibms,SUNWsprot,SUNWtoo,SUNWi1of,SUNWi1cs,SUNWi15cs,SUNWxwfntPatchesforSolaris10：118345-03SunOS5.10_x86:ld&libc.so.1Patch119961-02SunOS5.10_x86,x64,Patchforassembler117837-06C5.7_x86:PatchforSS10C_x86compiler117846-13SunCompilerCommon10_x86:Patchforstudio10backend118682-01PatchforSS10_x86debuginfohandling编写人：李真旭QQ264752493个人博客(forPro*FORTRAN)SunClusterPatchesforSolaris10:20498-02:SunCluster3.1_x86:OPSCorePatchforSolaris10_x86119964-05:SunOS5.10_x86:SharedlibrarypatchforC++_x86三、调整系统内核参数（/etc/system）noexec_user_stack1semsys:seminfo_semmns100semsys:seminfo_semmns1024semsys:seminfo_semmsl256semsys:seminfo_semvmx32767shmsys:shminfo_shmmax4294967295shmsys:shminfo_shmmin1shmsys:shminfo_shmmni100shmsys:shminfo_shmseg10四、查看网络并调整网络参数#ifconfig–a#netstat-nr#ndd-set/dev/udpudp_xmit_hiwat65536#ndd-set/dev/udpudp_recv_hiwat65536五、创建用户、用户组以及相关目录命令基本如下：#groupaddoinstall#groupadddba#useradd–goinstall–Gdbaoracle设置oracle用户的密码编写人：李真旭QQ264752493个人博客:oinstall/opt/oracle/product#chmod775/opt/oracle/product六、检查节点之间的时间是否同步#date(在每个节点执行，时间误差一般控制在20s以内)七、编辑/etc/hosts文件(每个节点都要添加哦)172.16.3.11rac1172.16.3.13rac1-vip10.10.10.30rac1-priv172.16.3.12rac2172.16.3.14rac2-vip10.10.10.32rac-priv注意：一定要添加127.0.0.1的哦八、配置集群节点之间用户的等效性（此处指oracle用户）备注：此处使用ssh（是用rsh也可）以oracle用户登录在1节点db1上执行如下操作：mkdir~/.sshchmod700~/.sshssh-keygen-trsassh-keygen-tdsa编写人：李真旭QQ264752493个人博客在2节点db2上执行如下操作：mkdir~/.sshchmod700~/.sshssh-keygen-trsassh-keygen-tdsatouchauthorized_keys在1节点db1上执行如下操作（在任意节点执行都可）：sshBSPTMS-DB-CLAcat/opt/oracle/.ssh/id_rsa.pub/opt/oracle/.ssh/authorized_keyssshBSPTMS-DB-CLAcat/opt/oracle/.ssh/id_dsa.pub/opt/oracle/.ssh/authorized_keyssshBSPTMS-DB-CLBcat/opt/oracle/.ssh/id_rsa.pub/opt/oracle/.ssh/authorized_keyssshBSPTMS-DB-CLBcat/opt/oracle/.ssh/id_dsa.pub/opt/oracle/.ssh/authorized_keysscp/opt/oracle/.ssh/authorized_keysBSPTMS-DB-CLB:/opt/oracle/.ssh/authorized_keyschmod-R600/opt/oracle/.ssh/authorized_keys在2节点db2执行如下操作：Chmod600/opt/oracle/.ssh/authorized_keys九、验证节点用户之间的等效性在每个节点执行如下操作：sshdb1datesshdba-privdatesshdb1-vipdatesshdb2datesshdb2-privdatesshdb2-vipdate(不提示密码即可，否则需要重新配置)编写人：李真旭QQ264752493个人博客十、配置每个节点的oracle用户环境变量以oracle用户登录，然后vi.profile键入下列值：TMP=/tmp;exportTMPTEMP=/tmp;exportTEMPORACLE_BASE=/opt/oracle/product;exportORACLE_BASEORACLE_HOME=$ORACLE_BASE/10.2/db;exportORACLE_HOMEORA_CRS_HOME=$ORACLE_BASE/10.2/crs;exportORA_CRS_HOMEORACLE_TERM=xterm;exportORACLE_TERMLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$ORACLE_HOME/rdbms/lib;exportLD_LIBRARY_PATHPATH=$PATH:$ORACLE_HOME/bin:$ORA_CRS_HOME/bin;exportPATHCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib;exportCLASSPATHNLS_LANG=AMERICAN_AMERICA.ZHS16GBK;exportNLS_LANGumask022十一、设置ocr和voting的属主以及权限，操作如下：修改属主（只列出了部分所需，其他方法雷同）chownoracle:oinstall/dev/rdsk/c6t6005076308FFC45E0000000000001207d0s3chownoracle:oinstall/dev/rdsk/c6t6005076308FFC45E0000000000001207d0s4chownoracle:oinstall/dev/rdsk/c6t6005076308FFC45E0000000000001207d0s5chownoracle:oinstall/dev/rdsk/c6t6005076308FFC45E0000000000001207d0s6chownoracle:oinstall/dev/rdsk/c6t6005076308FFC45E0000000000001207d0s7chownoracle:oinstall/dev/rdsk/c6t6005076308FFC45E0000000000001307d0s7编写人：李真旭QQ264752493个人博客修改权限chmod640/dev/rdsk/c6t6005076308FFC45E0000000000001207d0s3chmod640/dev/rdsk/c6t6005076308FFC45E0000000000001207d0s4chmod640/dev/rdsk/c6t6005076308FFC45E0000000000001207d0s5chmod640/dev/rdsk/c6t6005076308FFC45E0000000000001207d0s6chmod640/dev/rdsk/c6t6005076308FFC45E0000000000001207d0s7chmod640/dev/rdsk/c6t6005076308FFC45E0000000000001307d0s7为了方便，建立如下链接ln-s/dev/rdsk/c6t6005076308FFC45E0000000000001207d0s3/dev/rdsk/oracle/ocr01ln-s/dev/rdsk/c6t6005076308FFC45E0000000000001207d0s4/dev/rdsk/oracle/ocr02ln-s/dev/rdsk/c6t6005076308FFC45E0000000000001207d0s5/dev/rdsk/oracle/voting01ln-s/dev/rdsk/c6t6005076308FFC45E0000000000001207d0s6/dev/rdsk/oracle/voting02ln-s/dev/rdsk/c6t6005076308FFC45E0000000000001207d0s7/dev/rdsk/oracle/voting03十一、解压clusterware，db以及升级patchGunzip10gr2_db_sol.cpio.gzcpio-idmv10gr2_db_sol.cpiounzipcluster_inst_solaris.zipunzipp6810189_10204_Solaris-64.zip十二、验证是否具备安装crs的条件进入clusterware的解压目录，执行如下操作：#./runcluvfy.shstage-precrsinst-nBSPTMS-DB-CLA,BSPTMS-DB-CLB-verbose十三、安装oracleclusterware进入clusterware解压目录，运行如下命令：编写人：李真旭QQ264752493个人博客如下图：点击next，进入下一步编写人：李真旭QQ2