wmware10+redhat65+oracle11204+RAC+asmlib方式安装配置.docx

1、wmware10+redhat65+oracle11204+RAC+asmlib方式安装配置1.Wmware上安装上创建共享磁盘：网络设置：使用NAT模式，配置子网为192.168.59.0，两个虚拟机的网络选择NAT方式，并且配置192.168.59网段的IP地址，在笔记本电脑上可以直接访问。创建一个虚拟机安装redhat6.5操作系统后，要禁用Firewall 和SElinux，调整参数：增加共享存储：A.创建共享磁盘在cmd中进入WMware Workstation 10.0 安装目录:1.创建存储Oracle Clusterware文件 (Oracle Cluster Registry

2、 and voting disk) 的磁盘：vmware-vdiskmanager.exe -c -s 1Gb -a lsilogic -t 2 D:vm-linux6.5-rac-storageShareDiskOCR.vmdk2.创建存储Oracle共享数据文件的磁盘：vmware-vdiskmanager.exe -c -s 10Gb -a lsilogic -t 2 D:vm-linux6.5-rac-storageShareDiskData01.vmdk编辑虚拟机配置文件B.关闭两台虚拟机，用记事本打开虚拟机名字.wmx，到虛拟机的目录比如 E:SoftwareInstallvmwa

3、relinuxrac1，直接编辑*.vmx 文件, 加上下面语句(所有虛拟机节点)：或者直接在两台VM上使用图形界面上直接添加磁盘选择已有的磁盘-选择上面创建的共享磁盘，然后点高级中选择scsi卡，最后确定。scsi1:1.deviceType = diskscsi1:1.present = TRUEscsi1:1.fileName = D:vm-linux6.5-rac-storageShareDiskOCR.vmdkscsi1:1.mode = independent-persistentscsi1:1.redo = scsi1:2.deviceType = diskscsi1:2.pre

4、sent = TRUEscsi1:2.fileName = D:vm-linux6.5-rac-storageShareDiskData01.vmdkscsi1:2.mode = independent-persistentscsi1:2.redo = scsi1:1.deviceType = disk 加入配置文件中。2. 采用UEK内核来创建共享ASMLIB存储：2.1.在redhat6.5操作系统上安装如下RPM包：kmod-oracleasm-2.0.6.rh1-3.el6.x86_64.rpmoracleasm-support-2.1.8-1.el6.x86_64.rpmoracle

5、asmlib-2.0.4-1.el6.x86_64.rpmkernel-uek-firmware-2.6.39-300.17.3.el6uek.noarch.rpmkernel-uek-2.6.39-300.17.3.el6uek.x86_64.rpm#rpm ihv *.rpm2.2创建ASM Disk Volumes对磁盘需要新进行fdisk分区，oracleasm configure -i之后两个节点需要重启！# oracleasm configure -i 两个节点上都要操作节点一上：rootoradb1 soft# oracleasm configure -iConfiguring

6、the Oracle ASM library driver.This 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 valueswill be shown in brackets (). Hitting without typing ananswer will

7、 keep that current value. Ctrl-C will abort.Default user to own the driver interface : gridDefault group to own the driver interface : asmadminStart 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配置后reboot重

8、启主机！节点二上：rootoradb2 disks# oracleasm configure -iConfiguring the Oracle ASM library driver.This 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 valueswill

9、be shown in brackets (). Hitting without typing ananswer will keep that current value. Ctrl-C will abort.Default user to own the driver interface grid: Default group to own the driver interface asmadm: asmadminStart Oracle ASM library driver on boot (y/n) y: Scan for Oracle ASM disks on boot (y/n) y

10、: Writing Oracle ASM library driver configuration: done配置后reboot重启主机！# oracleasm configure 查看配置rootoradb2 # oracleasm configureORACLEASM_ENABLED=trueORACLEASM_UID=gridORACLEASM_GID=asmadminORACLEASM_SCANBOOT=trueORACLEASM_SCANORDER=ORACLEASM_SCANEXCLUDE=ORACLEASM_USE_LOGICAL_BLOCK_SIZE=falserootorad

11、b1 soft# oracleasm initLoading module oracleasm: oracleasmMounting ASMlib driver filesystem: /dev/oracleasmrootoradb1 soft# rootoradb2 soft# oracleasm initLoading module oracleasm: oracleasmMounting ASMlib driver filesystem: /dev/oracleasmrootoradb2 soft# 在节点一上创建即可，节点二上可以直接扫描出来：rootoradb1 soft# orac

12、leasm createdisk CRSVOL /dev/sdb1Writing disk header: doneInstantiating disk: donerootoradb1 soft# oracleasm createdisk DATAVOL /dev/sdc1Writing disk header: doneInstantiating disk: donerootoradb1 soft# rootoradb1 soft# oracleasm listdisksCRSVOLDATAVOLrootoradb1 soft# oracleasm-discover Using ASMLib

13、 from /opt/oracle/extapi/64/asm/orcl/1/libasm.soASM Library - Generic Linux, version 2.0.4 (KABI_V2)Discovered disk: ORCL:CRSVOL 2088387 blocks (1069254144 bytes), maxio 512Discovered disk: ORCL:DATAVOL 20964762 blocks (10733958144 bytes), maxio 512rootoradb1 soft# 在节点二上直接scandisks后就会出现已创建的asmdisk.r

14、ootoradb2 soft# oracleasm scandisksReloading disk partitions: doneCleaning any stale ASM disks.Scanning system for ASM disks.Instantiating disk CRSVOLInstantiating disk DATAVOLrootoradb2 soft# oracleasm listdisksCRSVOLDATAVOLrootoradb2 soft# gridoradb1 disks$ ls -atl /dev/oracleasm/disks 查看属性grid：as

15、madmintotal 0brw-rw- 1 grid asmadmin 8, 33 May 7 08:42 DATAVOLbrw-rw- 1 grid asmadmin 8, 17 May 7 08:42 CRSVOLdrwxr-xr-x 1 root root 0 May 7 08:37 .drwxr-xr-x 4 root root 0 May 7 08:37 .3. redhat6.5操作系统上配置3.1 主机IP配置：192.168.59.130 oradb1192.168.59.131 oradb2192.168.59.132 oradb1-vip192.168.59.133 or

16、adb2-vip192.168.59.134 scan-ip10.10.10.130 oradb1-priv10.10.10.131 oradb2-priv3.2创建组及用户：groupadd -g 1000 oinstall groupadd -g 1020 asmadmin groupadd -g 1021 asmdba groupadd -g 1022 asmoper groupadd -g 1031 dba groupadd -g 1032 oper useradd -u 1100 -g oinstall -G asmadmin,asmdba,asmoper,oper,dba grid

17、 useradd -u 1101 -g oinstall -G dba,asmdba,oper oracle mkdir -p /oracle/app/grid_basemkdir -p /oracle/app/grid_homemkdir -p /oracle/app/oracle/product/11.2.0/db_1chown -R grid:oinstall /oracle/chown -R oracle:oinstall /oracle/app/oraclechmod -R 775 /oracle/3.3 配置limits.confvi /etc/security/limits.co

18、nf grid soft nproc 2047 grid hard nproc 16384 grid soft nofile 1024 grid hard nofile 65536 oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 3.4配置内核参数# vi /etc/sysctl.conf fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmmni = 4096 kernel.sem = 25

19、0 32000 100 128 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048586 3.5检查需要的包:#rpm -q binutils compat-libstdc+-33 elfutils-libelf elfutils-libelf-devel gcc gcc-c+ glibc glibc-common glibc-deve

20、l glibc-headers kernel-headers ksh libaio libaio-devel libgcc libgomp libstdc+ libstdc+-devel make numactl-devel sysstat unixODBC unixODBC-devel 3.6设置用户环境变量节点一：#su - grid#cat .bash_profileTMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR ORACLE_SID=+ASM1; export ORACLE_SID ORACLE_BASE=/oracle/app/grid

21、_base; export ORACLE_BASE ORACLE_HOME=/oracle/app/grid_home; export ORACLE_HOME NLS_DATE_FORMAT=yyyy-mm-dd HH24:MI:SS; export NLS_DATE_FORMAT THREADS_FLAG=native; export THREADS_FLAG PATH=$ORACLE_HOME/bin:$PATH; export PATH THREADS_FLAG=native; export THREADS_FLAG PATH=$ORACLE_HOME/bin:$PATH; export

22、 PATH if $USER = oracle | $USER = grid ; then if $SHELL = /bin/ksh ; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi umask 022fi #su - oraclecat .bash_profileTMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR ORACLE_BASE=/oracle/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_B

23、ASE/product/11.2.0; export ORACLE_HOME ORACLE_SID=racdb1; export ORACLE_SID ORACLE_UNQNAME=racdb; export ORACLE_UNQNAMEORACLE_TERM=xterm; export ORACLE_TERM PATH=/usr/sbin:$PATH; export PATH PATH=$ORACLE_HOME/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PA

24、TH CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH NLS_DATE_FORMAT=yyyy-mm-dd HH24:MI:SS; export NLS_DATE_FORMAT NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;export NLS_LANG if $USER = oracle | $USER = grid ; then if $SHELL = /bin/ksh ; then ulimit -p 16384 ulimit -n 655

25、36 else ulimit -u 16384 -n 65536 fi umask 022 fi 节点二：#su - grid#cat .bash_profileTMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR ORACLE_SID=+ASM2; export ORACLE_SID ORACLE_BASE=/oracle/app/grid_base; export ORACLE_BASE ORACLE_HOME=/oracle/app/grid_home; export ORACLE_HOME NLS_DATE_FORMAT=yyyy-mm-dd

26、HH24:MI:SS; export NLS_DATE_FORMAT THREADS_FLAG=native; export THREADS_FLAG PATH=$ORACLE_HOME/bin:$PATH; export PATH THREADS_FLAG=native; export THREADS_FLAG PATH=$ORACLE_HOME/bin:$PATH; export PATH if $USER = oracle | $USER = grid ; then if $SHELL = /bin/ksh ; then ulimit -p 16384 ulimit -n 65536 e

27、lse ulimit -u 16384 -n 65536 fi umask 022fi #su - oraclecat .bash_profileTMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR ORACLE_BASE=/oracle/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/11.2.0; export ORACLE_HOME ORACLE_SID=racdb2; export ORACLE_SID ORACLE_UNQNAME=racdb; export OR

28、ACLE_UNQNAMEORACLE_TERM=xterm; export ORACLE_TERM PATH=/usr/sbin:$PATH; export PATH PATH=$ORACLE_HOME/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH NLS_DATE_FORMAT=y

29、yyy-mm-dd HH24:MI:SS; export NLS_DATE_FORMAT NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;export NLS_LANG if $USER = oracle | $USER = grid ; then if $SHELL = /bin/ksh ; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi umask 022 fi 3.7建立信任关系Grid用户：#su - gridoradb1主机上：$ ssh-keygen -t rsa $

30、ssh-keygen -t dsa oradb2主机上：$ ssh-keygen -t rsa $ ssh-keygen -t dsa $ cat /.ssh/id_rsa.pub ./.ssh/authorized_keys $ cat /.ssh/id_dsa.pub ./.ssh/authorized_keys $ ssh oradb2 cat /.ssh/id_rsa.pub /.ssh/authorized_keys $ ssh oradb2 cat /.ssh/id_dsa.pub /.ssh/authorized_keys $ scp /.ssh/authorized_keys oradb2:/.ssh/authorized_keys Oracle用户：#su - oracleoradb1主机上：$ ssh-keygen -t rsa $ ssh-keygen -t dsa oradb2主机上：$ ssh-keygen -t rsa $ ssh-keygen -t dsa