ORACLE11gR2RAC安裝文檔虛擬機(jī)(加入了DNS,及虛擬機(jī)配置部分)

1、-作者xxxx-日期xxxxORACLE11gR2RAC安裝文檔虛擬機(jī)(加入了DNS,及虛擬機(jī)配置部分)【精品文檔】 ORACLE11GR2 RAC服務(wù)器組建過程一 測試環(huán)境：虛擬機(jī)軟件：OS操作系統(tǒng): RedHat 5 update 4 (2臺)Oracle: oracle 11g r2主機(jī)名SIDETH0VIPPRIVtestdb1testdb1testdb2testdb212SCANNAME-testdb-SCAN二、虛擬機(jī)的文件設(shè)置：修改你的虛擬機(jī)配置文件（vmware configure file）.在這個(gè)文件的最后邊加上三個(gè)參數(shù) = FALSEscsi1.sharedBus = v

2、irtualscsi1:0.mode = persistent = 0 = 0 = 0 = 4096 = 0三、DNS 配置Oracle11gr2 RAC 是使用Single Client Access Name(SCAN),所以要DNS服務(wù)器來對SCANIP進(jìn)行解析。以上是對DNS服務(wù)器的相關(guān)配置。這里是把DNS服務(wù)器放在節(jié)點(diǎn)一中來進(jìn)行解析。1. DNS服務(wù)器所需要的RPM包：2. 對DNS主配置文件由于是用chroot來對DNS服務(wù)器的配置。所以直接去/var/named/chroot/etc/在 添加以下內(nèi)容options listen-on port 53 11;

3、 directory /var/named; dump-file /var/named/; statistics-file /var/named/data/named_stats.txt; memstatistics-file /var/named/data/named_mem_stats.txt; allow-query /24; ;include /etc/;zone type master; file /var/named/; ;zone 2.168.192. type master; file /var/named/192.168.2.re

4、v; ;zone 1.1.10. type master; file /var/named/10.1.1.rev; ;3. 編輯正向，反向解析配置文件DNS服務(wù)器需要對服務(wù)器的名字進(jìn)行正向，反向的解釋。Named 的默認(rèn)目錄是/var/named/chroot里面.以下是正向解釋Cd /var/named/chroot/var/namedVi $ttl 86400 IN .( 1282236195 10800 3600 604800 38400 ) IN NS . IN. IN. IN. IN. IN還要反向?qū)ublic,以及private進(jìn)行解釋Public的反向解

5、釋：Vi$ttl 86400 IN SOA . . ( 1282236195 10800 3600 604800 38400 ) IN NS .. IN .. IN .. IN PTR . IN PTR . IN PTR . IN PTR . IN PTR testdb-.Private 的反向解釋：Vi$ttl 86400 IN SOA . ( 1282248

6、634 10800 3600 604800 38400) IN NS . IN PTR IN PTR testdb2-.然后啟動(dòng)DNS服務(wù)：Service named restart配置連接的DNS連接Vi /etc/searchnameserver4. 對DNS進(jìn)行正向，反向驗(yàn)證正向驗(yàn)證roottestdb1 named# nslookup Address: 11#53反向驗(yàn)證roottestdb1 named# domain name pointer testdb-

7、.三、主機(jī)名設(shè)置：分別在兩臺節(jié)點(diǎn)做以下設(shè)定計(jì)算機(jī)名Hostname rac1 (一機(jī))Hostname rac2 （二機(jī)）Vi /etc/hosts localhost:1localhost6.localdomain6 localhost600 rac101 rac202 rac1-vip03 rac2-vip rac1-priv rac2-priv04 rac-scan05 rac-scan06

8、rac-scan注意SCAN的計(jì)算機(jī)名二 安裝ORACLE所需要的RPM包：compat-libstdccompat-libstdcgcc-clibstdclibstdclibstdc四、設(shè)置系統(tǒng)的核心參數(shù)：Vi /etc/kernel.shmmax = 1024000000kernel.shmall = 2097152kernel.shmmni = 4096kernel.sem = 250 32000 100 128 = 6815744 (512 x processes for example 6815744 for 13312 processes) = 1048576net.ipv4.ip

9、_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 4194304net.ipv4.tcp_wmem = 262144 262144 262144net.ipv4.tcp_rmem = 4194304 4194304 4194304保存后退出然后執(zhí)行 sysctl pVisession保存后退出vigrid soft nproc 2047grid hard nproc 163

10、84grid soft nofile 1024grid hard nofile 65536oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536保存退出Vi /etc/profileif $USER = oracle | $USER = grid ; then if $SHELL = /bin/ksh ; thenulimit -p 16384ulimit -n 65536elseulimit -u 16384 -n 65536fiumask 022fi保存退出注意

11、：以上幾點(diǎn)兩臺節(jié)點(diǎn)都需設(shè)置。五、建立用戶和組建立組：Groupadd g 500 oinstall;Groupadd g 501 dbaGroupadd g 502 asmdbaGroupadd g 503 asmadminGroupadd g 504 asmoperGroupadd g 505 oper建立用戶Useradd u 600 -g oinstall G dba,asmdba,oper oracleUseradd u 601 g asmadmin,asmdba,asmoper,dba gridPasswd oraclePasswd grid六、設(shè)置用戶環(huán)境參數(shù)：vi /home/g

12、rid/.bash_profileexport PATHexport ORACLE_SID=+ASM1export ORACLE_BASE=/u01/app/grid/crsexport ORACLE_HOME=/export JAVA_HOME=$ORACLE_HOME/jdkexport ORACLE_PATH=$ORACLE_BASE/common/oracle/sqlexport ORACLE_TERM=xtermexport NLS_DATE_FORMAT=YYYY-MM-DD HH24:MI:SSexport TNS_ADMIN=$ORACLE_HOME/network/admin

13、export ORA_NLS11=$ORACLE_HOME/nls/dataexport PATH=.:$JAVA_HOME/bin:$PATH:$HOME/bin:$ORACLE_HOME/binexport PATH=$PATH:/usr/bin:/bin:/usr/bin/X11:/usr/local/binexport PATH=$PATH:$ORACLE_BASE/common/oracle/binexport LD_LIBRARY_PATH=$ORACLE_HOME/libexport LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/or

14、acm/libexport LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/lib:/usr/lib:/usr/local/libexport CLASSPATH=$ORACLE_HOME/JREexport CLASSPATH=$CLASSPATH:$ORACLE_HOME/jlibexport CLASSPATH=$CLASSPATH:$ORACLE_HOME/rdbms/jlibexport CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlibexport THREADS_FLAG=nativeexport TEMP=/tmpe

15、xport TMPDIR=/tmpumask 022vi /home/oracle/.bash_profileexport ORACLE_SID=rac1export ORACLE_UNQNAME=racexport ORACLE_BASE=/opt/app/oracleexportexport JAVA_HOME=$ORACLE_HOME/jdkexport ORACLE_PATH=$ORACLE_BASE/common/oracle/sqlexport ORACLE_TERM=xtermexport NLS_DATE_FORMAT=YYYY-MM-DD HH24:MI:SSexport T

16、NS_ADMIN=$ORACLE_HOME/network/adminexport ORA_NLS11=$ORACLE_HOME/nls/dataexport PATH=.:$JAVA_HOME/bin:$PATH:$HOME/bin:$ORACLE_HOME/binexport PATH=$PATH:/usr/bin:/bin:/usr/bin/X11:/usr/local/binexport PATH=$PATH:$ORACLE_BASE/common/oracle/binexport LD_LIBRARY_PATH=$ORACLE_HOME/libexport LD_LIBRARY_PA

17、TH=$LD_LIBRARY_PATH:$ORACLE_HOME/oracm/libexport LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/lib:/usr/lib:/usr/local/libexport CLASSPATH=$ORACLE_HOME/JREexport CLASSPATH=$CLASSPATH:$ORACLE_HOME/jlibexport CLASSPATH=$CLASSPATH:$ORACLE_HOME/rdbms/jlibexport CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlibexport T

18、HREADS_FLAG=nativeexport TEMP=/tmpexport TMPDIR=/tmpumask 022重點(diǎn)：注意第二個(gè)節(jié)點(diǎn)要改兩個(gè)用戶的相應(yīng)SID,GRID用戶ORACLE_HOME不能放在ORACLE_BASE里面七、建立用戶的目錄并對用戶的目錄屬主及權(quán)限進(jìn)行設(shè)置Mkdir p /u01/app/grid/crsMkdir p /Mkdir p /u01/app/oracleMkdir p /Chown /u01/app/grid/Chmod R 775 /u01/app/gridChown -R oracle.oinstall /u01/app/oracleChmod

19、-R 775 /u01/app/oracle八、對共享磁盤進(jìn)行分區(qū)：Fdisk -lDisk /dev/sda: 42.9 GB, 42949672960 bytes255 heads, 63 sectors/track, 5221 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System/dev/sda1 * 1 25 200781 83 Linux/dev/sda2 26 286 2096482+ 82 Linux swap / Solaris/dev/s

20、da3 287 5221 39640387+ 83 LinuxDisk /dev/sdb: 32.2 GB, 32212254720 bytes255 heads, 63 sectors/track, 3916 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System/dev/sdb1 1 3916 31455238+ 83 LinuxDisk /dev/sdc: 32.2 GB, 32212254720 bytes255 heads, 63 sectors/

21、track, 3916 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System/dev/sdc1 1 609 4891761 83 Linux/dev/sdc2 610 1826 9775552+ 83 Linux/dev/sdc3 1827 3043 9775552+ 83 Linux/dev/sdc4 3044 3916 7012372+ 83 Linux這里是以/DEV/SDC作為共享盤，在這里已經(jīng)進(jìn)行了分區(qū)。九、安裝ASM包，并對ASM進(jìn)行設(shè)置，以及

22、讀入ASM盤Uname a2.6.18-164.el5 DOWNLOAD SOFT FROM:service oracleasm restartservice oralceasm enableservice oracleasm configureThis will configure the on-boot properties of the Oracle ASM librarydriver. The following questions will determine whether the driver isloaded on boot and what permissions it wi

23、ll have. The current valueswill be shown in brackets (). Hitting without typing an answer will keep that current value. Ctrl-C will abort.Default user to own the driver interface : gridDefault group to own the driver iCRerface : asmdbaStart Oracle ASM library driver on boot (y/n) n: yScan for Oracle

24、 ASM disks on boot (y/n) y: yWriting Oracle ASM library driver configuration: done然后對共享盤進(jìn)行CREATEOracleasm createdisk ocr /dev/sdc1Oracleasm createdisk data /dev/sdc2Oracleasm createdisk archv /dev/sdc3Oracleasm createdisk fre /dev/sdc4然后在另外一個(gè)節(jié)點(diǎn)對ASM盤進(jìn)行SCAN:Oracleasm scandisksOracleasm listdisks十、把系統(tǒng)的NTP服務(wù)停止及修改Service ntpd stopChkconfig ntpd offMv /etc/ntp.conf /Vi /etc/sysconfigOPTIONS=-x -u ntp:ntp -p /var/run/ntpd.pid十一 建立SSH用戶等效性配置Su gridMkdir p /.sshChmod 700 /.ssh/usr/bin/ssh-keygen t rsa/usr/bin/ssh-keygen t dsaSsh rac1 cat /.ssh/id_rsa.pub /.ssh/authorized_keysSsh rac1 cat/.