预授权变更及操作手册oracle安装手册10gr2rac install on rhel

1、ORACLE ADVANCED PRODUCT SERVI青岛海尔数据库系统项目Oracle RAC安装配置文档生成日期:2012-12-06现场支持总时间(小时):HP工程师：文档控制此文档惠普公司相关技术支持服务部审阅。不得向与此无关的个人或机构传阅或。修改审阅分发审阅人职位审阅人职位日期作者版本修改2012-12-061.0创建初始版本概述本文档的了Oracle RAC数据库搭建步骤和安装需求，为今后数据库的运维，提供文字依据。客户名称海尔合同号联系人系统硬件/配置备注硬件配置机器类型ProLiant DL580 G7CPU(core)el(R) Xeon(R) CPU E7- 8837

2、 2.67GHz* 4内存16GB不低于 4 GB本地磁盘(类型, 容量)140G磁盘阵列(类型, 容量)1T本次实施因设备限制，RAID模式采用RAID 5CD-ROM 是/否是配置Linux服务器名dzyxdb01 /dzyxdb01Oracle OS 用户名/临时口令(Unix)Oracle/oracle默认为:oracle/dbaOracle装载点/oracle默认为:/oracleSWAP空间32GB默认为: 内存 * 2数据库配置MEM_12GBSES500初步设置为500PROSES600初步设置为 600数据库字符集16GBK网络配置管理IP(分配两个)10.135.13.69

3、/10.135.13.70该IP地址用于服务器、数据库的管理登陆(连号)服务IP(分配两个)10.135.13.85/10.135.13.86该IP地址用于前台应用程序、中间件、客户端对数据库的连接 (连号)心跳IP(分配两个)192.168.1.69 /192.168.1.70该IP地址用于两台服务器之间的心跳连接，不能被公共网络所，请在交换上接口上设置vlan(类似于 192.168.10.1/2)安装需求列表需求请提前在中划出操作系统安装（略过）Disk大小用途RAID结构DISK41TOracle数据盘RAID 5应用系统名称产品名称版本备注数据库Oracle Clusterware

4、Oracle Database10.2.0.5.0请提供两个版本的64位安装包操作系统Redhinux Entrise 5.4请提供Linux 64位安装光盘或安装包操作系统配置1. 网络配置更改每台机器的/etc/hostsdzyxdb01dzyxdb02dzyxdb01-vipdzyxdb02-vipdzyxdb01-pridzyxdb02-pri2.必须得 rpm 包（因操作系统原因，建议等 oracle 检查出来以后再去找相应的包）binutils-2.17.50(x86_64) compat-db-4.2.52(x86_64)comp comp compibstdc+-296(i38

5、6) ibstdc+-33-3.2.3(x86_64) ibstdc+-33-3.2.3(i386)control-center-2.16.0(x86_64) gcc-4.1.1(x86_64)gcc-c+-4.1.1(x86_64)glibc-2.5-12(x86_64) glibc-2.5-12(i686)mon-2.5-12(x86_64)glibc-devel-2.5-12(x86_64) glibc-devel-2.5-12(i386)glibc-headers-2.5-12(x86_64) ksh-20060214-1.4(x86_64)libaio-0.3.96(x86_64)

6、libgcc-4.1.1(i386) libgcc-4.1.1(x86_64)libgnome-2.16.0(x86_64) libgnomeui-2.16.0(x86_64) libgomp-4.1.1(x86_64) libstdc+-4.1.1(x86_64) libstdc+-devel-4.1.1(x86_64) libXp-1.0.0-8(i386)make-3.81(x86_64) syss-7.0.0(x86_64)yum install compat*3 创建 oracle 用户（1） 创建 dba 组groupadd g 700dba10guseradd u 701 g d

7、baora10g(2)配置 oracle 用户的环境变量export ORACLE_BASE=/oracleexportORACLE_TERM=xtermexportNLS_LANG=AMERICAN_AMERICA.ZHS16GBKexportCRS_HOME=/oracle/product/crsexportORACLE_HOME=/oracle/product/databaseexportORA_NLS33=$mon/nls/admin/dataexportPATH=$ CRS_HOME/bin:$ORACLE_HOME/bin:$PATHexportORACLE_SID=dzyxdb1

8、(3)设置用户资源限制vi /etc/security/limits.conforacle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 65536 oracle hard nofile 65536查看用户资源限制Ulimit a(4)设置 SSH 用户等价ssh dzyxdb02-pri date内网也得配置RSH人品不好的也得配置(5)设置 OS Kernelvi /etc/sysctl.conffs.file-max = 6815744kernel.sem = 250 32000 100 128net.ipv4.ip

9、_local_port_range = 1024 65500net.core.rmem_default = 4194304net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576(6)设置时间同步vi /etc/ntp.conf Server 10.135.8.100修改/etc/sysconfig/ntpdOPTIONS=-x -u ntp:ntp -p /var/run/ntpd.# service ntpd restart(7)配置设备两个节点都要执行vi /etc/sysco

10、nfig/rawdevi/dev/raw/raw1/dev/mapper/vote01/dev/raw/raw2/dev/mapper/vote02/dev/raw/raw3/dev/mapper/vote03/dev/raw/raw4/dev/mapper/ocr01/dev/raw/raw5/dev/mapper/ocr02Service rawdevirestart/dev/rawn ora10g:dba10g */dev/mappern ora10g:dba10g *加开机启动Vi /etc/rc.d/rc.local#n ora10g:dba10g /dev/mapper/ocr*

11、od 660 /dev/mapper/ocr*raw /dev/raw/raw4 /dev/mapper/ocr01 raw /dev/raw/raw5 /dev/mapper/ocr02 sleep 2n ora10g:dba10g /dev/raw/raw4 n ora10g:dba10g /dev/raw/raw5 od 660 /dev/raw/raw4od 660 /dev/raw/raw5# Oracle Cluster Voting disks #n ora10g:dba10g /dev/mapper/vote* od 660 /dev/mapper/vote*raw /dev/

12、raw/raw1 /dev/mapper/vote01 raw /dev/raw/raw2 /dev/mapper/vote02 raw /dev/raw/raw3 /dev/mapper/vote03 sleep 2n ora10g:dba10g /dev/raw/raw1 n ora10g:dba10g /dev/raw/raw2 n ora10g:dba10g /dev/raw/raw3 od 660 /dev/raw/raw1od 660 /dev/raw/raw2od 660 /dev/raw/raw3安装ASMhtt d64/technetwork/server-storage/l

13、inux/downloads/rhel5-084877.html#oracleasm_rhel5_am地址rootdzyxdb01 asmrpm# uname -aLinux dzyxdb01 2.6.18-274.el5 #1 SMP Fri Jul 8 17:36:59 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux rootdzyxdb01 asmrpm# rpm -ivh *warning: oracleasm-2.6.18-274.el5-2.0.5-1.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, k

14、ey ID 1e5e0159Preparing.1:oracleasm-support# 100%# 33%2:oracleasm-2.6.18-274.el# 67%3:oracleasmlib# 100%rootdzyxdb01 init.d# /etc/init.d/oracleasm configure Configuring the Oracle ASM library driver.This will configure the on-boot properties of the Oracle ASM library driver. The following questions

15、will determine whether the driver isloaded on boot and what permiss it will have. The current valueswill be shown in brackets (). Hitting without tyananswer will keept current value. Ctrl-C will abort.Default user to own the drivererface : ora10gDefault group to own the drivererface : dba10gStart Or

16、acle ASM library driver on boot (y/n) n: y Scan for Oracle ASM disks on boot (y/n) y: yWriting Oracle ASM library driver configuration: done Initializing the Oracle ASMLib driver: OK Scanning the system for Oracle ASMLib disks: OK /etc/init.d/oracleasm createdisk VOL1 /dev/mapper/data01/etc/init.d/o

17、racleasm createdisk VOL2 dev/mapper/data02/etc/init.d/oracleasm scandisks/etc/init.d/oracleasm listdisks节点二执行/etc/init.d/oracleasm configure即可/etc/init.d/oracleasm listdisks检查开始安装oracle cluster Mkdir /oraclen ora10g:dba10g /oraclerootdzyxdb01 app# cat /etc/redhat-releaseRed Hat Entrise Linux Server release 4 (Tikanga)多路径这个地方有个bug，需要替换补丁包。参考这个帖子vipca时候有个bug在安装 rac 时vipca也是类似错误/app/oracle/product/10.2.0/crs/bin/crsctl.bin: error while loading shared libraries: libpthread.so.0: cannot open shared object file:No such file or directory这个问题是新版的 glibc 和 10g 的 java 有不兼容的地方。按照文档要在运行 root.sh 之