預(yù)授權(quán)變更及操作手冊oracle安裝手冊10gr2rac install on rhel

1、ORACLE ADVANCED PRODUCT SERVI青島海爾數(shù)據(jù)庫系統(tǒng)項目Oracle RAC安裝配置文檔生成日期:2012-12-06現(xiàn)場支持總時間(小時):HP工程師：文檔控制此文檔惠普公司相關(guān)技術(shù)支持服務(wù)部審閱。不得向與此無關(guān)的個人或機構(gòu)傳閱或。修改審閱分發(fā)審閱人職位審閱人職位日期作者版本修改2012-12-061.0創(chuàng)建初始版本概述本文檔的了Oracle RAC數(shù)據(jù)庫搭建步驟和安裝需求，為今后數(shù)據(jù)庫的運維，提供文字依據(jù)?？蛻裘Q海爾合同號聯(lián)系人系統(tǒng)硬件/配置備注硬件配置機器類型ProLiant DL580 G7CPU(core)el(R) Xeon(R) CPU E7- 8837

2、 2.67GHz* 4內(nèi)存16GB不低于 4 GB本地磁盤(類型, 容量)140G磁盤陣列(類型, 容量)1T本次實施因設(shè)備限制，RAID模式采用RAID 5CD-ROM 是/否是配置Linux服務(wù)器名dzyxdb01 /dzyxdb01Oracle OS 用戶名/臨時口令(Unix)Oracle/oracle默認(rèn)為:oracle/dbaOracle裝載點/oracle默認(rèn)為:/oracleSWAP空間32GB默認(rèn)為: 內(nèi)存 * 2數(shù)據(jù)庫配置MEM_12GBSES500初步設(shè)置為500PROSES600初步設(shè)置為 600數(shù)據(jù)庫字符集16GBK網(wǎng)絡(luò)配置管理IP(分配兩個)10.135.13.69

3、/10.135.13.70該IP地址用于服務(wù)器、數(shù)據(jù)庫的管理登陸(連號)服務(wù)IP(分配兩個)10.135.13.85/10.135.13.86該IP地址用于前臺應(yīng)用程序、中間件、客戶端對數(shù)據(jù)庫的連接 (連號)心跳IP(分配兩個)192.168.1.69 /192.168.1.70該IP地址用于兩臺服務(wù)器之間的心跳連接，不能被公共網(wǎng)絡(luò)所，請在交換上接口上設(shè)置vlan(類似于 192.168.10.1/2)安裝需求列表需求請?zhí)崆霸谥袆澇霾僮飨到y(tǒng)安裝（略過）Disk大小用途RAID結(jié)構(gòu)DISK41TOracle數(shù)據(jù)盤RAID 5應(yīng)用系統(tǒng)名稱產(chǎn)品名稱版本備注數(shù)據(jù)庫Oracle Clusterware

4、Oracle Database10.2.0.5.0請?zhí)峁﹥蓚€版本的64位安裝包操作系統(tǒng)Redhinux Entrise 5.4請?zhí)峁㎜inux 64位安裝光盤或安裝包操作系統(tǒng)配置1. 網(wǎng)絡(luò)配置更改每臺機器的/etc/hostsdzyxdb01dzyxdb02dzyxdb01-vipdzyxdb02-vipdzyxdb01-pridzyxdb02-pri2.必須得 rpm 包（因操作系統(tǒng)原因，建議等 oracle 檢查出來以后再去找相應(yīng)的包）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 創(chuàng)建 oracle 用戶（1） 創(chuàng)建 dba 組groupadd g 700dba10guseradd u 701 g d

7、baora10g(2)配置 oracle 用戶的環(huán)境變量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)設(shè)置用戶資源限制vi /etc/security/limits.conforacle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 65536 oracle hard nofile 65536查看用戶資源限制Ulimit a(4)設(shè)置 SSH 用戶等價ssh dzyxdb02-pri date內(nèi)網(wǎng)也得配置RSH人品不好的也得配置(5)設(shè)置 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)設(shè)置時間同步vi /etc/ntp.conf Server 10.135.8.100修改/etc/sysconfig/ntpdOPTIONS=-x -u ntp:ntp -p /var/run/ntpd.# service ntpd restart(7)配置設(shè)備兩個節(jié)點都要執(zhí)行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節(jié)點二執(zhí)行/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 之