ORACLE11gR2RAC安装文档虚拟机(加入了DNS,及虚拟机配置部分)

1、 ORACLE11GR2 RAC服务器组建过程一 测试环境：虚拟机软件：VMWARE SERVER 2.0OS操作系统: RedHat 5 update 4 (2台)Oracle: oracle 11g r2主机名SIDETH0VIPPRIVtestdb1testdb1111311testdb2testdb2121412 SCANIP 15,16, 17SCANNAME-testdb-SCAN二、虚拟机的文件设

2、置：修改你的虚拟机配置文件（vmware configure file）.在这个文件的最后边加上三个参数disk.locking = FALSEscsi1.sharedBus = "virtual"scsi1:0.mode = "persistent"diskLib.dataCacheMaxSize = "0"diskLib.dataCacheMaxReadAheadSize = "0"diskLib.DataCacheMinReadAheadSize = "0"diskLib.dataCach

3、ePageSize = "4096"diskLib.maxUnsyncedWrites = "0"三、DNS 配置Oracle11gr2 RAC 是使用Single Client Access Name(SCAN),所以要DNS服务器来对SCANIP进行解析。以上是对DNS服务器的相关配置。这里是把DNS服务器放在节点一中来进行解析。1. DNS服务器所需要的RPM包：bind-9.3.6-4.P1.el5_4.2bind-libs-9.3.6-4.P1.el5_4.2bind-chroot-9.3.6-4.P1.el5_4.2bind-utils-9.

4、3.6-4.P1.el5_4.2bind-devel-9.3.6-4.P1.el5_4.2bind-sdb-9.3.6-4.P1.el5_4.2caching-nameserver-9.3.6-4.P1.el5_4.22. 对DNS主配置文件由于REDHAT5.0是用chroot来对DNS服务器的配置。所以直接去/var/named/chroot/etc/named.conf在named.conf 添加以下内容options listen-on port 53 11; directory "/var/named" dump-file "/va

5、r/named/cache_dump.db" statistics-file "/var/named/data/named_stats.txt" memstatistics-file "/var/named/data/named_mem_stats.txt" allow-query /24; ;include "/etc/rndc.key"zone "" type master; file "/var/named/.hosts" ;zone "2.168

6、.192." type master; file "/var/named/192.168.2.rev" ;zone "1.1.10." type master; file "/var/named/10.1.1.rev" ;3. 编辑正向，反向解析配置文件DNS服务器需要对服务器的名字进行正向，反向的解释。Named 的默认目录是/var/named/chroot里面.以下是正向解释Cd /var/named/chroot/var/namedVi .hosts$ttl 86400

7、 IN SOA . .( 1282236195 10800 3600 604800 38400 ) IN NS . IN A 11. IN A 12testdb-. IN A 15testdb1-. IN A 21testdb2-. IN A 22testdb1-. IN A 13testdb2-. IN A 14testdb-. IN A 16testdb-. IN A 17还要反向对public,以及pri

8、vate进行解释Public的反向解释：Vi 192.168.2.rev$ttl 86400 IN SOA . . ( 1282236195 10800 3600 604800 38400 ) IN NS .92.. IN PTR .92.. IN PTR .92.. IN PTR . IN PTR . IN PTR t

9、. IN PTR . IN PTR testdb-.Private 的反向解释：Vi 10.1.1.rev$ttl 86400 IN SOA . ( 1282248634 10800 3600 604800 38400) IN NS .0. IN PTR IN PTR testdb2-.然后启动DNS服务：Service named restart配置连接

10、的DNS连接Vi /etc/resolv.confsearch nameserver 114. 对DNS进行正向，反向验证正向验证roottestdb1 named# nslookup> testdb-Server: 11Address: 11#53Name: testdb-Address: 17Name: testdb-Address: 15Name: testdb-Address: 16反向验证roottestdb1 named# host 192.16

11、8.2.11592. domain name pointer testdb-.三、主机名设置：分别在两台节点做以下设定计算机名Hostname rac1 (一机)Hostname rac2 （二机）Vi /etc/hostslocalhost.localdomain localhost:1localhost6.localdomain6 localhost600 rac101 rac202 rac1-vip03 rac2-vip172.168.1

12、.1 rac1-priv rac2-priv04 rac-scan05 rac-scan06 rac-scan注意SCAN的计算机名二 安装ORACLE所需要的RPM包：binutils-.6-14.el5.x86_64.rpmbinutils-devel-.6-14.el5.i386.rpmbinutils-devel-.6-14.el5.x86_64.rpmcompat-db-4.2.52-5.1.i386.rpmcompat-db-4.2.52-5

13、.1.x86_64.rpmcontrol-center-2.16.0-16.el5.i386.rpmcontrol-center-2.16.0-16.el5.x86_64.rpmcontrol-center-devel-2.16.0-16.el5.i386.rpmcontrol-center-devel-2.16.0-16.el5.x86_64.rpmcompat-libstdc+-33-3.2.3-61.i386.rpmcompat-libstdc+-33-3.2.3-61.x86_64.rpmelfutils-libelf-0.137-3.el5.i386.rpmelfutils-libe

14、lf-0.137-3.el5.x86_64.rpmelfutils-libelf-devel-0.137-3.el5.i386.rpmelfutils-libelf-devel-0.137-3.el5.x86_64.rpmelfutils-libelf-devel-static-0.137-3.el5.i386.rpmelfutils-libelf-devel-static-0.137-3.el5.x86_64.rpmexpat-1.95.8-8.3.el5_4.2.i386.rpmexpat-1.95.8-8.3.el5_4.2.x86_64.rpmexpat-devel-1.95.8-8.

15、3.el5_4.2.i386.rpmexpat-devel-1.95.8-8.3.el5_4.2.x86_64.rpmgcc-4.1.2-48.el5.x86_64.rpmgcc-c+-4.1.2-48.el5.x86_64.rpmglibc-2.5-49.i686.rpmglibc-2.5-49.x86_64.rpmglibc-common-2.5-49.x86_64.rpmglibc-devel-2.5-49.i386.rpmglibc-devel-2.5-49.x86_64.rpmglibc-headers-2.5-49.x86_64.rpmlibaio-0.3.106-5.i386.r

16、pmlibaio-devel-0.3.106-5.i386.rpmlibaio-0.3.106-5.i386.rpmlibaio-0.3.106-5.x86_64.rpmlibaio-devel-0.3.106-5.i386.rpmlibaio-devel-0.3.106-5.x86_64.rpmlibgcc-4.1.2-48.el5.i386.rpmlibgcc-4.1.2-48.el5.x86_64.rpmlibstdc+-4.1.2-48.el5.i386.rpmlibstdc+-4.1.2-48.el5.x86_64.rpmlibstdc+-devel-4.1.2-48.el5.i38

17、6.rpmlibstdc+-devel-4.1.2-48.el5.x86_64.rpmlibXp-1.0.0-8.1.el5.i386.rpmlibXp-1.0.0-8.1.el5.x86_64.rpmlibXp-devel-1.0.0-8.1.el5.i386libXp-devel-1.0.0-8.1.el5.x86_64.rpmmake-3.81-3.el5.x86_64.rpmopenmotif-2.3.1-2.el5_4.1.i386.rpmopenmotif-2.3.1-2.el5_4.1.x86_64.rpmopenmotif-devel-2.3.1-2.el5_4.1.i386.

18、rpmopenmotif-devel-2.3.1-2.el5_4.1.x86_64.rpmmake-3.81-3.el5.x86_64.rpmpdksh-5.2.14-36.el5.x86_64.rpmsysstat-7.0.2-3.el5.x86_64.rpmunixODBC-2.2.11-7.1.i386.rpmunixODBC-2.2.11-7.1.x86_64.rpmunixODBC-devel-2.2.11-7.1.i386.rpmunixODBC-devel-2.2.11-7.1.x86_64.rpm四、设置系统的核心参数：Vi /etc/sysctl.confkernel.shm

19、max = 1024000000kernel.shmall = 2097152kernel.shmmni = 4096kernel.sem = 250 32000 100 128fs.file-max = 6815744 (512 x processes for example 6815744 for 13312 processes)fs.aio-max-nr = 1048576net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wm

20、em_default = 262144net.core.wmem_max = 4194304net.ipv4.tcp_wmem = 262144 262144 262144net.ipv4.tcp_rmem = 4194304 4194304 4194304保存后退出然后执行 sysctl pVi /etc/pam.d/loginsession required pam_limits.so保存后退出vi /etc/security/limits.confgrid soft nproc 2047grid hard nproc 16384grid soft nofile 1024grid hard

21、 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保存

22、退出注意：以上几点两台节点都需设置。五、建立用户和组建立组：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六、设置用户环境参数：vi /ho

23、me/grid/.bash_profileexport PATHexport ORACLE_SID=+ASM1export ORACLE_BASE=/u01/app/grid/crsexport ORACLE_HOME=/u01/app/11.2.0export JAVA_HOME=$ORACLE_HOME/jdkexport ORACLE_PATH=$ORACLE_BASE/common/oracle/sqlexport ORACLE_TERM=xtermexport NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"export TNS_AD

24、MIN=$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_PATH=$L

25、D_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 THREAD

26、S_FLAG=nativeexport TEMP=/tmpexport TMPDIR=/tmpumask 022vi /home/oracle/.bash_profileexport ORACLE_SID=rac1export ORACLE_UNQNAME=racexport ORACLE_BASE=/opt/app/oracleexport ORACLE_HOME=/opt/oracle/11.2.0/dbhome_1export JAVA_HOME=$ORACLE_HOME/jdkexport ORACLE_PATH=$ORACLE_BASE/common/oracle/sqlexport

27、 ORACLE_TERM=xtermexport NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"export TNS_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

28、_BASE/common/oracle/binexport LD_LIBRARY_PATH=$ORACLE_HOME/libexport LD_LIBRARY_PATH=$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:$O

29、RACLE_HOME/rdbms/jlibexport CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlibexport THREADS_FLAG=nativeexport TEMP=/tmpexport TMPDIR=/tmpumask 022重点：注意第二个节点要改两个用户的相应SID,GRID用户ORACLE_HOME不能放在ORACLE_BASE里面七、建立用户的目录并对用户的目录属主及权限进行设置Mkdir p /u01/app/grid/crsMkdir p /u01/app/grid/11.2.0Mkdir p /u01/app/oracl

30、eMkdir p /u01/app/oracle/11.2.0/db_1Chown R grid.oinstall /u01/app/grid/Chmod R 775 /u01/app/gridChown -R oracle.oinstall /u01/app/oracleChmod -R 775 /u01/app/oracle八、对共享磁盘进行分区：Fdisk -lDisk /dev/sda: 42.9 GB, 42949672960 bytes255 heads, 63 sectors/track, 5221 cylindersUnits = cylinders of 16065 * 51

31、2 = 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/sda3 287 5221 39640387+ 83 LinuxDisk /dev/sdb: 32.2 GB, 32212254720 bytes255 heads, 63 sectors/track, 3916 cylindersUnits = cylinders of 16065 * 512 = 8225280

32、 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/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 182

33、6 9775552+ 83 Linux/dev/sdc3 1827 3043 9775552+ 83 Linux/dev/sdc4 3044 3916 7012372+ 83 Linux这里是以/DEV/SDC作为共享盘，在这里已经进行了分区。九、安装ASM包，并对ASM进行设置，以及读入ASM盘Uname a2.6.18-164.el5 DOWNLOAD SOFT FROM:oracleasm-2.6.18-164.15.1.el5-2.0.5-1.el5.x86_64.rpmoracleasm-support-2.1.7-1.el5.x86_64.rpmoracleasmlib-2.0.4

34、-1.el5.x86_64.rpmservice 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 will have. The current valueswil

35、l be shown in brackets (''). Hitting <ENTER> 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 ASM disks on boot (y/n) y: yWriting Oracle ASM library driver configuration: done然后对共享盘进行CREATEOracleasm createdisk ocr /dev/sdc1Oracleasm createdisk data /dev/sdc2Oracleasm createdisk archv /dev/sdc3Oracleasm createdisk fre /dev/sdc4然后在另外一个节点对ASM盘进行SCAN:Oracleasm scandisksOracleasm listdisks十、把