虚拟机Oracle_10g_RAC_安装

合集下载

linux下安装Oracle 10g RAC安装文档

linux下安装Oracle 10g RAC安装文档

Oracle 10g RAC安装文档1、建oracle用户和组:(两节点的用户ID和组ID一致)groupadd oinstallgroupadd dbauseradd -g oinstall -G dba oraclepasswd oracleid oracle2、准备文件目录:mkdir -p /opt/oraclechown oracle.dba /opt/oracle/chmod 775 /opt/oracle/mkdir -p /oracle01chown oracle.dba /oracle01chmod 775 /oracle01chown oracle.oinstall /oracle013、设置环境变量:vi /etc/hosts127.0.0.1 localhost.localdomain localhost# Public192.168.3.11 rac1192.168.3.12 rac2#Private192.168.4.11 rac1-priv192.168.4.12 rac2-priv#Virtual192.168.3.13 rac1-vip192.168.3.14 rac2-vipvi /etc/sysctl.confkernel.shmmax = 2147483648kernel.shmmni = 4096kernel.shmall = 2097152kernel.sem = 250 32000 100 128fs.file-max = 65536net.ipv4.ip_local_port_range = 1024 65000net.core.rmem_default=262144net.core.wmem_default=262144net.core.rmem_max=262144net.core.wmem_max=262144vi /etc/security/limits.conforacle soft nofile 65536oracle hard nofile 65536oracle soft nproc 16384oracle hard nproc 163844、配置 Hangcheck 计时器find /lib/modules -name "hangcheck-timer"echo "options hangcheck-timer hangcheck_tick=30 hangcheck_margin=180" >> /etc/modprobe.conf echo "/sbin/modprobe hangcheck-timer" >> /etc/rc.localmodprobe hangcheck-timergrep Hangcheck /var/log/messages | tail -25、设置oracle用户环境变量vi .bash_profileexport ORACLE_BASE=/opt/oracleexport ORACLE_HOME=$ORACLE_BASE/10g/dbexport ORA_CRS_HOME=$ORACLE_BASE/10g/crsexport ORACLE_SID=db1PATH=$ORACLE_HOME/bin:$ORA_CRS_HOME/bin:$PATH:$HOME/binexport PATH=$ORACLE_HOME/bin:/bin:/sbin:/usr/bin:/usr/ccs/bin:/usr/local/bin:/usr/ucb: $ORACLE_BASE/product/10.2.0/crs_1/bin:/etcexportLD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/network/lib:$ORACLE_HOME/oracm/lib:/usr/local/ lib:/usr/libexport ORACLE_TERM=xtermexportCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/rdbms/jlib :$ORACLE_HOME/network/jlibexport THREADS_FLAG=nativeexport TEMP=/tmpexport TMPDIR=/tmpexport LD_ASSUME_KERNEL=2.4.19unset USERNAME6、使用SSH为oracle用户配置等效性rac2上$ssh-keygen -t rsa$cat /home/oracle/.ssh/id_rsa.pub >> /home/oracle/.ssh/authorized_keysrac1上$ssh-keygen –t rsa$cat /home/oracle/.ssh/id_rsa.pub >> /home/oracle/.ssh/authorized_keys$ssh rac1 cat /home/oracle/.ssh/id_rsa.pub >> /home/oracle/.ssh/authorized_keys$ssh rac1-priv cat /home/oracle/.ssh/id_rsa.pub >> /home/oracle/.ssh/authorized_keys$ssh rac2 cat /home/oracle/.ssh/id_rsa.pub >> /home/oracle/.ssh/authorized_keys$ssh rac2-priv cat /home/oracle/.ssh/id_rsa.pub >> /home/oracle/.ssh/authorized_keys$scp /home/oracle/.ssh/authorized_keys rac2:/home/oracle/.ssh测试登录是否需要密码与时间同步 //rac1和rac2都要执行$ssh rac1 date;ssh rac2 date$ssh rac1-priv date;ssh rac2-priv date7、安装和配置ocfs安装 OCFS2把 OCFS2 文件安装到两台单处理器计算机中。

[誉天李老师上课文档]oracle 10g rac安装终手册

[誉天李老师上课文档]oracle 10g rac安装终手册

实验环境vmworkstation +redhat5.4搭建存储虚拟机2块网卡一块eth1 用于连接rac1 rac2 来连存储用192.168.2.10 hostonly一块eth0 用于作为rac1 rac2的公共网卡的网关10.85.10.254 vment2主机名storage添加一个100G硬盘作为存储01 配置共享存储一般的SAN存储服务器可以使用RAID+iSCSI进行架构。

我使用的是一个PC机器,主板不支持RAID,所以只将一块硬盘做成iSCSI服务器。

首先我们做一个服务器端:1、在RHEL5中安装如下的包:iscsi-initiator-utils-6.2.0.868-0.18.el5.i386.rpmperl-Config-General-2.40-1.el5.noarch.rpm(这个包在光盘的cluster storage目录下)scsi-target-utils-0.0-5.20080917snap.el5.i386.rpm (这个包在光盘的cluster storage目录下)2、通过linux中的命令生成IQN编号#iscsi-iname.redhat:e5ab84c569a83、编辑配置文件#vi /etc/tgt/targets.conf在文件中加入<target .redhat:e5ab84c569a8> backing-store /dev/sdb</target>4、启动服务servicetgtd startchkconfigtgtd on5、查看配置信息# tgtadm --lldiscsi --op show --mode targetTarget 1: .redhat:e5ab84c569a8 System information:Driver: iscsiState: readyI_T nexus information:LUN information:LUN: 0Type: controllerSCSI ID: deadbeaf1:0SCSI SN: beaf10Size: 0 MBOnline: YesRemovable media: NoBacking store: No backing storeLUN: 1Type: diskSCSI ID: deadbeaf1:1SCSI SN: beaf11Size: 1000205 MBOnline: YesRemovable media: NoBacking store: /dev/hdbLUN: 2Type: diskSCSI ID: deadbeaf1:2SCSI SN: beaf12Size: 1000205 MBOnline: YesRemovable media: NoBacking store: /dev/hdcAccount information:ACL information:ALL上面的内容就是iSCSI服务的配置,注意,iSCSI的链接端口是3260,保证防火墙访问正常通过。

oracle 10G rac安装亲测

oracle 10G rac安装亲测

分区,安装系统系统好后安装第二个网卡安装vmtools下载linux vmtools 包[root@localhost /]#mount dev/cdrom /media/cdromcopy 此文件到临时文件夹cp media/cdrom/mVMwareTools-8.8.4-743747.tar.gz /tmp进入tmp 文件目录并解压此文件包cd /tmptar -zxf vmware-linux-tools.tar.gzls\more /etc/sysconfig/network 修改hostnameecho ‘127.0.0.1 localhost.localdomain localhost’ >/etc/hostsvi etc/hosts1、测试网络连通性[root@localhost ~]# ping -c 2 192.168.1.117PING 192.168.1.117 (192.168.1.117) 56(84) bytes of data.64 bytes from 192.168.1.117: icmp_seq=0 ttl=64 time=12.2 ms64 bytes from 192.168.1.117: icmp_seq=1 ttl=64 time=1.08 ms--- 192.168.1.117 ping statistics ---2 packets transmitted, 2 received, 0% packet loss, time 1002msrtt min/avg/max/mdev = 1.089/6.670/12.252/5.582 ms, pipe 2 [root@localhost ~]# ping -c 2 10.0.0.2PING 10.0.0.2 (10.0.0.2) 56(84) bytes of data.64 bytes from 10.0.0.2: icmp_seq=0 ttl=64 time=2.93 ms64 bytes from 10.0.0.2: icmp_seq=1 ttl=64 time=1.02 ms--- 10.0.0.2 ping statistics ---2 packets transmitted, 2 received, 0% packet loss, time 1002msrtt min/avg/max/mdev = 1.021/1.978/2.936/0.958 ms, pipe 2 [root@localhost ~]#2、配置host文件[root@localhost ~]# cat /etc/hosts# Do not remove the following line, or various programs# that require network functionality will fail.127.0.0.1 localhost.localdomain localhost192.168.1.116 myrac1192.168.1.117 myrac2192.168.1.118 myrac1-vip192.168.1.119 myrac2-vip10.0.0.1 myrac1-priv10.0.0.2 myrac2-priv3、安装系统所需rpm包rpm –ivh *.rpm查找rpm[root@myrac1 RPMS]# find compa*.rpmcompat-db-4.1.25-9.i386.rpmcompat-gcc-32-3.2.3-47.3.i386.rpmcompat-gcc-32-c++-3.2.3-47.3.i386.rpm挂光驱[root@myrac1 /]# mount /media/cdrommount: block device /dev/hdc is write-protected, mounting read-only [root@myrac1 /]# cd /media/cdrom/RedHat/RPMS[root@myrac1 RPMS]# pwd/media/cdrom/RedHat/RPMS[root@myrac1 RPMS]#安装的rpmrpm –ivh compat-libstdc++-33-3.2.3-47.3.i386.rpmrpm –ivh gcc-3.4.4-2.i386.rpmrpm –ivh gcc-c++-3.4.4-2.i386.rpmrpm –ivh glibc-devel-2.3.4-2.13.i386.rpmrpm –ivh glibc-headers-2.3.4-2.13.i386.rpmrpm –ivh glibc-kernheaders-2.4-9.1.98.EL.i386.rpmrpm –ivh libstdc++-devel-3.4.4-2.i386.rpmrpm –ivh sysstat-5.0.5-1.i386.rpm[root@myrac2 /]# mount /media/cdrommount: block device /dev/hdc is write-protected, mounting read-only[root@myrac2 /]# cd /media/cdrom/RedHat/RPMS[root@myrac2 RPMS]# rpm -ivh compat-libstdc++-33-3.2.3-47.3.i386.rpmwarning: compat-libstdc++-33-3.2.3-47.3.i386.rpm: V3 DSA signature: NOKEY, key ID db42a60e Preparing... ########################################### [100%] package compat-libstdc++-33-3.2.3-47.3 is already installed[root@myrac2 RPMS]# rpm -ivh gcc-3.4.4-2.i386.rpmwarning: gcc-3.4.4-2.i386.rpm: V3 DSA signature: NOKEY, key ID db42a60eerror: Failed dependencies:glibc-devel >= 2.2.90-12 is needed by gcc-3.4.4-2.i386Suggested resolutions:glibc-devel-2.3.4-2.13.i386.rpm[root@myrac2 RPMS]# rpm -ivh gcc-c++-3.4.4-2.i386.rpmwarning: gcc-c++-3.4.4-2.i386.rpm: V3 DSA signature: NOKEY, key ID db42a60eerror: Failed dependencies:gcc = 3.4.4-2 is needed by gcc-c++-3.4.4-2.i386libstdc++-devel = 3.4.4 is needed by gcc-c++-3.4.4-2.i386Suggested resolutions:gcc-3.4.4-2.i386.rpmlibstdc++-devel-3.4.4-2.i386.rpm[root@myrac2 RPMS]# rpm -ivh glibc-devel-2.3.4-2.13.i386.rpmwarning: glibc-devel-2.3.4-2.13.i386.rpm: V3 DSA signature: NOKEY, key ID db42a60eerror: Failed dependencies:glibc-headers is needed by glibc-devel-2.3.4-2.13.i386glibc-headers = 2.3.4-2.13 is needed by glibc-devel-2.3.4-2.13.i386Suggested resolutions:glibc-headers-2.3.4-2.13.i386.rpm[root@myrac2 RPMS]# rpm -ivh glibc-headers-2.3.4-2.13.i386.rpmwarning: glibc-headers-2.3.4-2.13.i386.rpm: V3 DSA signature: NOKEY, key ID db42a60e error: Failed dependencies:kernel-headers is needed by glibc-headers-2.3.4-2.13.i386kernel-headers >= 2.2.1 is needed by glibc-headers-2.3.4-2.13.i386 Suggested resolutions:glibc-kernheaders-2.4-9.1.98.EL.i386.rpm[root@myrac2 RPMS]# rpm -ivh glibc-kernheaders-2.4-9.1.98.EL.i386.rpmwarning: glibc-kernheaders-2.4-9.1.98.EL.i386.rpm: V3 DSA signature: NOKEY, key ID db42a60e Preparing... ########################################### [100%] 1:glibc-kernheaders ########################################### [100%] [root@myrac2 RPMS]# rpm -ivh libstdc++-devel-3.4.4-2.i386.rpmwarning: libstdc++-devel-3.4.4-2.i386.rpm: V3 DSA signature: NOKEY, key ID db42a60e Preparing... ########################################### [100%] 1:libstdc++-devel ########################################### [100%] [root@myrac2 RPMS]# rpm -ivh sysstat-5.0.5-1.i386.rpmwarning: sysstat-5.0.5-1.i386.rpm: V3 DSA signature: NOKEY, key ID db42a60e Preparing... ########################################### [100%] 1:sysstat ########################################### [100%] [root@myrac2 RPMS]#4、创建oracle账户及软件安装目录[root@myrac1 /]# groupadd -g 700 dba[root@myrac1 /]# useradd -u 500 -g dba oracle[root@myrac1 /]# passwd oracleChanging password for user oracle.New UNIX password:BAD PASSWORD: it is too simplistic/systematicRetype new UNIX password:passwd: all authentication tokens updated successfully.[root@myrac1 /]#[root@myrac1 /]# mkdir -p /oracle/product/database[root@myrac1 /]#mkdir -p /oracle/product/crs[root@myrac1 /]# chown -R oracle:dba /oracle/product/crs[root@myrac1 /]# chown -R oracle:dba /oracle/product/database[root@myrac1 /]# chmod 775 /oracle/product/database[root@myrac1 /]# chmod 775 /oracle/product/crs[root@myrac1 /]# chown -R oracle:dba /oracle[root@myrac1 /]# chmod 775 /oracle[root@myrac1 /]# ls -l /oracle/product5、配置环境变量及用户资源[root@myrac1 /]# su - oracle[oracle@myrac1 ~]$ ls[oracle@myrac1 ~]$ pwd/home/oracle[oracle@localhost ~]$ cat .bash_profile# .bash_profile# Get the aliases and functionsif [ -f ~/.bashrc ]; then. ~/.bashrcfi# User specific environment and startup programsPATH=$PATH:$HOME/binexport ORACLE_BASE=/oracleexport CRS_HOME=/oracle/product/crsexport ORACLE_HOME=/oracle/product/databaseexport PATH=$CRS_HOME/bin:$ORACLE_HOME/bin:$PATHexport ORACLE_SID=rac1unset USERNAME [oracle@localhost ~]$配置Limits.conf,限制oracle抢占资源[root@localhost security]# pwd/etc/security[root@localhost security]# cat limits.conf# /etc/security/limits.conf##Each line describes a limit for a user in the form:##<domain> <type> <item> <value>##Where:#<domain> can be:# - an user name# - a group name, with @group syntax# - the wildcard *, for default entry# - the wildcard %, can be also used with %group syntax, # for maxlogin limit##<type> can have the two values:# - "soft" for enforcing the soft limits# - "hard" for enforcing hard limits##<item> can be one of the following:# - core - limits the core file size (KB)# - data - max data size (KB)# - fsize - maximum filesize (KB)# - memlock - max locked-in-memory address space (KB) # - nofile - max number of open files# - rss - max resident set size (KB)# - stack - max stack size (KB)# - cpu - max CPU time (MIN)# - nproc - max number of processes# - as - address space limit# - maxlogins - max number of logins for this user# - priority - the priority to run user process with# - locks - max number of file locks the user can hold##<domain> <type> <item> <value>##* soft core 0#* hard rss 10000#@student hard nproc 20#@faculty soft nproc 20#@faculty hard nproc 50#ftp hard nproc 0#@student - maxlogins 1oracle soft memlock 5242880oracle hard memlock 5242880oracle soft nofile 65536oracle hard nofile 65536oracle soft nproc 2047oracle hard nproc 16384# End of file[root@localhost security]#6、编辑内核文件etc/sysctl.conf[root@localhost /]# cat /etc/sysctl.conf# Kernel sysctl configuration file for Red Hat Linux## For binary values, 0 is disabled, 1 is enabled. See sysctl(8) and# sysctl.conf(5) for more details.# Controls IP packet forwardingnet.ipv4.ip_forward = 0# Controls source route verificationnet.ipv4.conf.default.rp_filter = 1# Do not accept source routingnet.ipv4.conf.default.accept_source_route = 0# Controls the System Request debugging functionality of the kernel kernel.sysrq = 0# Controls whether core dumps will append the PID to the core filename. # Useful for debugging multi-threaded applications.kernel.core_uses_pid = 1kernel.shmmax=2147483648kernel.sem=250 32000 100 128fs.file-max=65536net.ipv4.ip_local_port_range=1024 65000net.core.rmem_default=262144net.core.wmem_default=262144net.core.rmem_max=262144net.core.wmem_max=262144[root@localhost /]#[root@myrac1 /]# sysctl -pnet.ipv4.ip_forward = 0net.ipv4.conf.default.rp_filter = 1net.ipv4.conf.default.accept_source_route = 0kernel.sysrq = 0kernel.core_uses_pid = 1kernel.shmmax = 2147483648kernel.sem = 250 32000 100 128fs.file-max = 65536net.ipv4.ip_local_port_range = 1024 65000net.core.rmem_default = 262144net.core.wmem_default = 262144net.core.rmem_max = 262144net.core.wmem_max = 262144[root@myrac1 /]#7、配置SSH用户信任关系[oracle@myrac2 ~]$ cd[oracle@myrac2 ~]$ pwd/home/oracle[oracle@myrac2 ~]$ mkdir .ssh[oracle@myrac2 ~]$ chmod 700 .ssh[oracle@myrac2 ~]$ cd .ssh[oracle@myrac2 .ssh]$ ssh-keygen -t rsaGenerating public/private rsa key pair.Enter file in which to save the key (/home/oracle/.ssh/id_rsa):Enter passphrase (empty for no passphrase):Enter same passphrase again:Your identification has been saved in /home/oracle/.ssh/id_rsa.Your public key has been saved in /home/oracle/.ssh/id_rsa.pub.The key fingerprint is:6d:03:9d:f7:73:b3:17:04:5e:68:88:3b:57:6c:54:c2 oracle@myrac2[oracle@myrac2 .ssh]$ ssh-keygen -t dsaGenerating public/private dsa key pair.Enter file in which to save the key (/home/oracle/.ssh/id_dsa):Enter passphrase (empty for no passphrase):Enter same passphrase again:Your identification has been saved in /home/oracle/.ssh/id_dsa.Your public key has been saved in /home/oracle/.ssh/id_dsa.pub.The key fingerprint is:4c:93:1c:c8:ab:85:a2:02:06:bf:38:e7:e2:9c:97:45 oracle@myrac2[oracle@myrac2 .ssh]$ cat *.pub>authorized_keys[oracle@myrac2 .ssh]$ scp authorized_keys myrac1:/home/oracle/.ssh/keys_myrac2 The authenticity of host 'myrac1 (192.168.1.116)' can't be established.RSA key fingerprint is 00:c6:a2:01:df:5b:5c:42:22:48:8d:4f:09:7d:bc:51.Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added 'myrac1,192.168.1.116' (RSA) to the list of known hosts. oracle@myrac1's password:authorized_keys 100% 826 0.8KB/s 00:00 [oracle@myrac2 .ssh]$[oracle@myrac1 .ssh]$ lsauthorized_keys id_dsa id_dsa.pub id_rsa id_rsa.pub keys_myrac2[oracle@myrac1 .ssh]$ cat keys_myrac2>>authorized_keys[oracle@myrac1 .ssh]$ lsauthorized_keys id_dsa id_dsa.pub id_rsa id_rsa.pub keys_myrac2[oracle@myrac1 .ssh]$ scp authorized_keys myrac2:/home/oracle/.ssh/The authenticity of host 'myrac2 (192.168.1.117)' can't be established.RSA key fingerprint is 00:c6:a2:01:df:5b:5c:42:22:48:8d:4f:09:7d:bc:51.Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added 'myrac2,192.168.1.117' (RSA) to the list of known hosts. oracle@myrac2's password:authorized_keys 100% 1652 1.6KB/s 00:00 [oracle@myrac1 .ssh]$8、配置时间同步[root@myrac1 ~]# vi /etc/ntp.confserver 127.127.1.0 # local clockdudge 127.127.1.0 stratum 11broadcastdelay 0.008[root@myrac2 /]# vi /etc/ntp.confserver 192.168.1.116 prefer # local clockdriftfile /var/lib/ntp/driftbroadcastdelay 0.008[root@myrac2 /]# service ntpd restart9、修改hangcheck-timer[root@myrac2 /]# cat /etc/rc.d/rc.local#!/bin/sh## This script will be executed *after* all the other init scripts.# You can put your own initialization stuff in here if you don't# want to do the full Sys V style init stuff.touch /var/lock/subsys/localmodprobe hangcheck-timer[root@myrac2 /]# vi /etc/modprobe.confalias scsi_hostadapter mptbasealias scsi_hostadapter1 mptscsialias scsi_hostadapter2 mptspialias scsi_hostadapter3 mptsasalias scsi_hostadapter4 mptscsihalias scsi_hostadapter5 ata_piixalias eth1 pcnet32alias eth0 pcnet32[root@myrac2 /]# sync,sync,rebootGrep hangcheck /var/log/messages |tail -l10、按照系统需求对磁盘分区(裸设备+asm磁盘)[root@myrac1 ~]# fdisk /dev/sdbDevice contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel Building a new DOS disklabel. Changes will remain in memory only,until you decide to write them. After that, of course, the previouscontent won't be recoverable.The number of cylinders for this disk is set to 1305.There is nothing wrong with that, but this is larger than 1024,and could in certain setups cause problems with:1) software that runs at boot time (e.g., old versions of LILO)2) booting and partitioning software from other OSs(e.g., DOS FDISK, OS/2 FDISK)Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite) Command (m for help): mCommand actiona toggle a bootable flagb edit bsd disklabelc toggle the dos compatibility flagd delete a partitionl list known partition typesm print this menun add a new partitiono create a new empty DOS partition tablep print the partition tableq quit without saving changess create a new empty Sun disklabelt change a partition's system idu change display/entry unitsv verify the partition tablew write table to disk and exitx extra functionality (experts only)Command (m for help):Command (m for help): nCommand actione extendedp primary partition (1-4)pPartition number (1-4): 1First cylinder (1-1305, default 1): 1Last cylinder or +size or +sizeM or +sizeK (1-1305, default 1305): 13 Command (m for help):Command (m for help): nCommand actione extendedp primary partition (1-4)pPartition number (1-4): 2First cylinder (14-1305, default 14): 14Last cylinder or +size or +sizeM or +sizeK (14-1305, default 1305): 26 Command (m for help):lBuilding a new DOS disklabel. Changes will remain in memory only,until you decide to write them. After that, of course, the previous content won't be recoverable.The number of cylinders for this disk is set to 1305.There is nothing wrong with that, but this is larger than 1024,and could in certain setups cause problems with:1) software that runs at boot time (e.g., old versions of LILO)2) booting and partitioning software from other OSs(e.g., DOS FDISK, OS/2 FDISK)Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite) Command (m for help): nCommand actione extendedp primary partition (1-4)pPartition number (1-4): 1First cylinder (1-1305, default 1): 1Last cylinder or +size or +sizeM or +sizeK (1-1305, default 1305): 13 Command (m for help): nCommand actione extendedp primary partition (1-4)pPartition number (1-4): 14Value out of range.Partition number (1-4): 2First cylinder (14-1305, default 14): 26Last cylinder or +size or +sizeM or +sizeK (26-1305, default 1305):[root@myrac1 ~]# fdisk /dev/sdbDevice contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel Building a new DOS disklabel. Changes will remain in memory only,until you decide to write them. After that, of course, the previouscontent won't be recoverable.The number of cylinders for this disk is set to 1305.There is nothing wrong with that, but this is larger than 1024,and could in certain setups cause problems with:1) software that runs at boot time (e.g., old versions of LILO)2) booting and partitioning software from other OSs(e.g., DOS FDISK, OS/2 FDISK)Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite) Command (m for help):[root@myrac1 ~]# fdisk /dev/sdbDevice contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel Building a new DOS disklabel. Changes will remain in memory only,until you decide to write them. After that, of course, the previouscontent won't be recoverable.The number of cylinders for this disk is set to 1305.There is nothing wrong with that, but this is larger than 1024,and could in certain setups cause problems with:1) software that runs at boot time (e.g., old versions of LILO)2) booting and partitioning software from other OSs(e.g., DOS FDISK, OS/2 FDISK)Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite) Command (m for help): nCommand actione extendedp primary partition (1-4)pPartition number (1-4): 1First cylinder (1-1305, default 1): 1Last cylinder or +size or +sizeM or +sizeK (1-1305, default 1305): 13 Command (m for help): nCommand actione extendedp primary partition (1-4)pPartition number (1-4): 2First cylinder (14-1305, default 14): 14Last cylinder or +size or +sizeM or +sizeK (14-1305, default 1305): 26 Command (m for help): nCommand actione extendedp primary partition (1-4)pPartition number (1-4): 3First cylinder (27-1305, default 27): 27Last cylinder or +size or +sizeM or +sizeK (27-1305, default 1305): 800 Command (m for help): nCommand actione extendedp primary partition (1-4)pSelected partition 4First cylinder (801-1305, default 801): 801Last cylinder or +size or +sizeM or +sizeK (801-1305, default 1305): 1035 Command (m for help): wThe partition table has been altered!Calling ioctl() to re-read partition table.Syncing disks.[root@myrac2 /]# fdisk -lDisk /dev/sda: 23.6 GB, 23622320128 bytes255 heads, 63 sectors/track, 2871 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytesDevice Boot Start End Blocks Id System/dev/sda1 * 1 13 104391 83 Linux/dev/sda2 14 1287 10233405 83 Linux/dev/sda3 1288 2561 10233405 83 Linux/dev/sda4 2562 2871 2490075 5 Extended /dev/sda5 2562 2688 1020096 82 Linux swap Disk /dev/sdb: 10.7 GB, 10737418240 bytes255 heads, 63 sectors/track, 1305 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytesDevice Boot Start End Blocks Id System/dev/sdb1 1 13 104391 83 Linux/dev/sdb2 14 26 104422+ 83 Linux/dev/sdb3 27 800 6217155 83 Linux/dev/sdb4 801 1305 4056412+ 83 Linux[root@myrac2 /]#11、配置裸设备(1、2都操作)[root@myrac1 /]# cat /etc/sysconfig/rawdevices# This file and interface are deprecated.# Applications needing raw device access should open regular# block devices with O_DIRECT.# raw device bindings# format: <rawdev> <major> <minor># <rawdev> <blockdev># example: /dev/raw/raw1 /dev/sda1# /dev/raw/raw2 8 5/dev/raw/raw1 /dev/sdb1/dev/raw/raw2 /dev/sdb2[root@myrac1 /]#[root@myrac1 /]# cd etc[root@myrac1 etc]# cd udev[root@myrac1 udev]# lsdevices permissions.d rules.d scripts udev.conf[root@myrac1 udev]# cd p*[root@myrac1 permissions.d]# ls50-udev.permissions[root@myrac1 permissions.d]# cat 50-udev.permissions[root@myrac1 permissions.d]# cat 50-udev.permissions# raw devicesram*:root:disk:0660raw/*:root:disk:0660raw*:oracle:dba:0660raw/*:oracle:dba:0660[root@myrac1 /]# service rawdevices restartAssigning devices:/dev/raw/raw1 --> /dev/sdb1/dev/raw/raw1: bound to major 8, minor 17/dev/raw/raw2 --> /dev/sdb2/dev/raw/raw2: bound to major 8, minor 1812、创建ASM逻辑磁盘[root@myrac1 /]# uname -aLinux myrac1 2.6.9-22.ELsmp #1 SMP Mon Sep 19 18:32:14 EDT 2005 i686 i686 i386 GNU/Linux [root@myrac1 /]# cd /media/cdrom[root@myrac1 cdrom]# lsoracleasm-2.6.9-22.ELsmp-2.0.3-1.i686.rpm oracleasm-support-2.0.3-1.i386.rpm oracleasmlib-2.0.2-1.i386.rpm[root@myrac1 cdrom]# rpm -ivh *.rpmPreparing... ########################################### [100%] 1:oracleasm-support ########################################### [ 33%] 2:oracleasm-2.6.9-22.ELsm########################################### [ 67%]3:oracleasmlib ########################################### [100%] [root@myrac1 cdrom]#[root@myrac1 ~]# /etc/init.d/oracleasm configureConfiguring 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 <ENTER> without typing ananswer will keep that current value. Ctrl-C will abort.Default user to own the driver interface []:Default group to own the driver interface []:Start Oracle ASM library driver on boot (y/n) [n]:Fix permissions of Oracle ASM disks on boot (y/n) [y]:Writing Oracle ASM library driver configuration: [ OK ]/etc/init.d/oracleasm configure[root@myrac1 init.d]# ./oracleasmUsage: ./oracleasm {start|stop|restart|enable|disable|configure|createdisk|deletedisk|querydisk|listdisks|scandisk s|status}[root@myrac1 init.d]# ./oracleasm start[root@myrac1 init.d]# ./oracleasm statusChecking if ASM is loaded: [FAILED][root@myrac1 init.d]# ./oracleasm enableWriting Oracle ASM library driver configuration: [ OK ]Loading module "oracleasm": [ OK ]Mounting ASMlib driver filesystem: [ OK ]Scanning system for ASM disks: [ OK ][root@myrac1 init.d]#[root@myrac1 init.d]# ./oracleasm createdisk vol1 /dev/sdb3Marking disk "/dev/sdb3" as an ASM disk: [root@myrac1 init.d]# cd /[root@myrac1 /]# /etc/init.d/oracleasm createdisk vol2 /dev/sdb4Marking disk "/dev/sdb4" as an ASM disk: [root@myrac1 /]#若还是创建不了votingdisk,可以采用如下解决方法:[root@myrac1 /]# cat /etc/selinux/configSELINUX=permissiveSELINUXTYPE=targeted[root@myrac1 /]# selinux代表安全增强linux,有三个值enforcing记录日志且阻止程序运行,permissive记录警告日志允许程序运行,disable关闭selinux策略。

Oracle_RAC_10g安装文档

Oracle_RAC_10g安装文档

一、准备工作二、设置Vmware环境用Vmware主要是创建虚拟机,这个过程比较简单。

1、新建一个虚拟机:点击Virtual Machine Create Virtual Machine2、进入创建虚拟机向导窗口在Name后面输入,要创建的虚拟机名,如:RedHat_10gRAC_1,点击“Next”即可3、选择操作系统点击“Next”4、为虚拟机分配内存,并选择CPU的数量点击“Next”5、为虚拟机创建磁盘点击“Next”,为虚拟硬盘分配大小,并选择保存的位置点击“Next”5、为虚拟机创建网卡点击“Next”,选择“Bridged”点击“Next”6、为虚拟机创建光驱,选择“Use an ISO Image”点击“Next”,选择要安装的操作系统所在的位置点击“Next”7、不创建软驱选择“Don’t Add a Floppy Drive”,即可跳入下一个窗口8、不创建USB选择“Don’t Add a USB Controller”,即可进入下一个窗口9、初步完成虚拟机的配置点击“Finish”完成虚拟机的创建10、为虚拟机新增一块网卡点击上图中的“Add Hardware”,弹出新建设备向导选择“Network Adapter”点击“Next”11、首先添加几个硬盘,用来做共享存储由于我们准备采用asm+raw来创建RAC,将voting disk和ocr放在raw上,数据文件等放在asm上,因此我们至少需要4个虚拟的硬盘,其中voting disk至少需要20M的空间,ocr至少需要60M的空间,数据文件等至少需要1-2G的空间,如果你的磁盘剩余空间充足,建议留有足够的富裕。

点击“Add Hardware”,进入新建设备向导,选择“Hard Disk”进入磁盘创建向导点击“Next”;为磁盘分配大小;并选择存放位置;展开“File Options”,选中“Allocate all disk space now”;展开“Disk Mode”,选中“Independent”;展开“Vitual Device Node”,在”Adapter”后选中“SCSI 1”,“divice“后面选择“1”,点击“NEXT“完成创建注意:此处一定要选中“Allocate all disk space now”,即首先分配足额的磁盘空间,避免后期需要使用时在分配,可能会造成虚拟机崩溃;选中“Persistent”,即同步写入数据到磁盘;在Virtual device node中选择一个新的SCSI总线(比如虚拟机默认磁盘SCSI 0:x,则新添加的硬盘可以使用1:x)循环上述添加磁盘的步骤,按你的实际情况添加几个(注:最少要3个,一个做asm盘,一个用来存储votingdisk,一个用来存储OCR)最终配置时这样的:虚拟机配置完成三、安装linux系统四、配置Linux环境以下脚本操作较多,不再频繁截图,紧贴出操作脚本供参考。

Oracle10g RAC安装部署

Oracle10g RAC安装部署

数据库安装Oracle10.2.0.4数据库RAC安装报告目录1. 文档控制 (3)1.1 修改记录 (3)1.2 审阅 (3)1.3 分发 (3)2. 系统软硬件配置状况简介 (4)2.1 硬件配置信息 (4)2.2 软件配置信息 (4)2.3 网络规划 (4)2.4 系统安装规划 (4)3. Oracle 10g RAC安装过程 (6)3.1 系统环境检查 (6)3.2 安装准备工作 (7)3.3 初始Oracle配置 (10)3.4 格式化共享存储 (11)3.5 建立裸设备 (12)4. Oracle产品安装 (14)4.1 CRS安装 (14)4.2 安装数据库软件 (31)4.3 安装CRS补丁集 (37)4.4 安装数据库补丁集.......................................................................... 错误!未定义书签。

4.5 配置监听 (44)4.6 建立数据库 (49)4.6.1 配置ASM磁盘 (49)4.6.2 建立数据库 (55)Oracle10gR2 RAC 数据库安装实施报告1. 文档控制1.1 修改记录1.2 审阅1.3 分发2. 系统软硬件配置状况简介2.1 硬件配置信息2.2 软件配置信息2.3 网络规划2.4 系统安装规划Oracle10gR2 RAC 数据库安装实施报告3. Oracle 10g RAC安装过程3.1 系统环境检查(1) Linux版本# cat /etc/issueRed Hat Enterprise Linux Server release 5.5 (Tikanga)Kernel \r on an \m(2) 内存大小[root@localhost /]# grep MemTotal /proc/meminfoMemTotal: 32933832 kB(3) Swap分区[root@localhost /]# grep SwapTotal /proc/meminfoSwapTotal: 32764528 kB(4) TMP空间[root@localhost /]# df -kh /tmpFilesystem Size Used Avail Use% Mounted on /dev/sda2 48G 240M 45G 1% /tmp(5) 检查操作系统内核[root@localhost /]# getconf LONG_BIT64(6) 检查网络# hostname# ifconfig -a# ping(7) 检查节点时间#date(8) 检查是否有已存在oracle进程(9) 检查操作系统是否已安装所需补丁包Oracle10gR2 RAC 数据库安装实施报告rpm -qa | grep binutilsrpm -qa | grep compat-db (无)rpm -qa | grep compat-libstdc++-296rpm -qa | grep compat-libstdc++-33rpm -qa | grep control-centerrpm -qa | grep gccrpm -qa | grep gcc-c++rpm -qa | grep glibcrpm -qa | grep glibc-commonrpm -qa | grep glibc-develrpm -qa | grep glibc-headersrpm -qa | grep kshrpm -qa | grep libaiorpm -qa | grep libgccrpm -qa | grep libgnomerpm -qa | grep libgnomeuirpm -qa | grep libgomprpm -qa | grep libstdc++rpm -qa | grep libstdc++-develrpm -qa | grep libXp (无)rpm -qa | grep makerpm -qa | grep rshrpm -qa | grep sysstat (无)rpm -qa | grep util-linuxNOTES: 检查操作系统是否安装以上补丁,若无,则需要上传补丁并完成安装,这样才能确保后期的数据库安装能够顺利进行3.2 安装准备工作(1) 检查/etc/oraInst.loc文件(2) 在两边节点创建dba(500)用户组groupadd -g 500 dba(3) 在两边节点创建oracle(501)用户useradd -u 501 -g dba oraclepasswd oracleoracle为用户名,并设置用户密码(oracle)(4) 在两边节点上检查nobody用户是否存在id nobody(5) 两边节点设置内核参数(/etc/sysctl.conf)vi /etc/sysctl.conf,在文件中添加如下内容kernel.sem = 250 32000 100 128kernel.shmmni = 4096kernel.shmall = 8388608kernel.shmmax = 10737418240net.ipv4.ip_local_port_range = 1024 65000net.core.rmem_default = 1048576net.core.rmem_max = 1048576net.core.wmem_default = 262144net.core.wmem_max = 262144修改完成后使用sysctl -p命令使得修改生效(6) 两边节点设置系统限制参数vi /etc/security/limits.conf,在文件中添加如下内容oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536(8) 两边节点修改hostname参数节点一做如下操作:vi /etc/sysconfig/networkNETWORKING=yesOracle10gR2 RAC 数据库安装实施报告NETWORKING_IPV6=noHOSTNAME=node1节点二做如下操作:vi /etc/sysconfig/networkNETWORKING=yesNETWORKING_IPV6=noHOSTNAME=node2修改完成后两节点执行hostname命令,查看hostname参数是否修改成功(9) 两边节点设置/etc/hosts两节点执行vi /etc/hosts,添加如下内容10.0.2.13 node110.0.2.14 node210.0.2.11 node1-vip10.0.2.12 node2-vip192.168.2.1 node1-priv192.168.2.2 node2-priv配置完成后在各个节点上用ping的方式查看网络状况(10) 配置用户等效性使用ssh配置oracle用户的等效性,具体操作步骤如下:两节点首先分别执行如下操作:[oracle@node1 ~]$ mkdir ~/.ssh[oracle@node1 ~]$ chmod 700 ~/.ssh[oracle@node1 ~]$ ssh-keygen -t rsa[oracle@node1 ~]$ ssh-keygen -t dsa然后两节点再分别执行以下代码:节点1:[oracle@node1 ~]$ cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys[oracle@node1 ~]$ cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys[oracle@node1 ~]$ ssh node2 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys[oracle@node1 ~]$ ssh node2 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys [oracle@node1 ~]$ scp ~/.ssh/authorized_keys node2:~/.ssh/authorized_keys节点2:[oracle@node2 ~]$ cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys[oracle@node2 ~]$ cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys[oracle@node2 ~]$ ssh node1 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys[oracle@node2~]$ ssh node1 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys[oracle@node2 ~]$ scp ~/.ssh/authorized_keys node1:~/.ssh/authorized_keys最后在两个节点分别执行以下命令测试连接,第一次时应该要输入yes来确认连接,以后如果以后不要输入密码则表示配置成功。

Oracle数据库10g RAC Windows平台下安装指南

Oracle数据库10g RAC Windows平台下安装指南

Oracle 10G安装文档前言:Oracle 10g的RAC比Oracle 9i的RAC进步很多,同时Oracle开发了自己的HA软件CRS并且支持所有平台包括Microsoft Windows,Ibm Aix,Sun Solaris, HP-UX等等。

VIP网络资源的的使用对TAF的改善性能是非常明显。

Oracle 10g 的RAC基本安装步骤:一:了解系统的软硬件情况并且做相应安装前的准备操作系统:Microsoft Windows 2003简体中文企业版+sp1每台主机2块CPU,3.5G内存和两块网卡两台主机的主机名为:shciq-iqac-db1和shciq-iqac-db2二 :共享存储的设置10g支持:a.OCFSb.RAWc. ASMd.NFS(官方称需认证)本次安装使用OCFS三: CRS的安装(安装在D盘)Cluster Ready Service 类似简单的hacmp,sun cluster.四: Oracle 10g数据库系统软件安装(安装在D盘)五: VIP网络的配置CRS的补充,cluster网络资源的定义.六:Oracle 10g RAC数据库的建立(安装在OCFS文件系统中)使用dbca工具建立数据库。

详细步骤:一. 安装前准备1. 分别在两台主机的“网络连接“中,将第一块显示在网络适配器的网卡对应的网络名字改为public,作为公共网络访问使用和作为将来VIP地址的绑定网卡,第二块显示在网络适配器的网卡对应的名字改为private,作为私有网络访问使用(包括心跳)。

Oracle 10G RAC For Windows官方文档注明:第一块能够访问网络服务的网卡必须设置作为public公共网络访问。

否则Oracle的CRS安装过程的Cluster集群检查会报错(第一版有bug,同样做一遍可以pass Cluster检查,但是安装的时候第一个节点无法copy 到远程第二个节点上,log日志会一直报错。

Oracle10g RAC安装与管理文档

Oracle10g RAC安装与管理文档

集中交易系统Oracle10g RAC安装与管理文档(for Linux x86-64)恒生电子股份有限公司目录第一部分存储划分 (3)第二部分RedHat AS4 X86_64 系统安装 (3)2.1 本地磁盘做RAID (3)2.2 操作系统的安装 (3)2.3 安装HBA卡和驱动以及网卡绑定 (3)2.4 开起/关掉部分服务 (4)2.5 配置Xmanager (4)第三部分配置系统及建立Oracle User (5)3.1 系统内核及RPM包检查(两节点都执行) (5)3.2 物理内存及SW AP检查(两节点都执行) (6)3.3 系统参数设定(两节点都执行) (6)3.4 Oracle User和目录建立(两节点都执行) (6)3.5 配置网络设定(两节点都执行) (7)3.6 SSH配置(两节点都执行) (7)3.7 配置hangcheck-timer 内核模块(两节点都执行) (9)3.8 设定oracle用户登录配置(两节点都执行) (9)3.9 存储划分及配置RAW (10)第四部分Oracle 10g RAC Cluster 安装(只需在一个节点执行) (14)第五部分Oracle 10g RAC Database Software 安装(只需在一个节点执行) (23)第六部分升级Oracle10g RAC到10.2.0.4(只需在一个节点执行) (28)第七部分建立Listener(只需在一个节点执行) (34)第八部分Oracle 10g RAC Database 建立(只需在一个节点执行) (40)第九部分Oracle 10g RAC Database 管理 (50)9.1 查看所有数据文件对应的RAW (50)9.2 查所有实例和服务的状态 (50)9.3 停止、启动群集 (51)9.4 远程管理集群 (51)9.5 创建新ext3的文件系统 (52)9.6 归档管理 (52)9.7 flash recovery area管理 (52)9.8 Oracle10g Recyclebin管理 (53)第十部分oracle10g RAC性能检查 (53)10.1 GCS等待事件的分析 (53)10.2 一致性读(CR)效率分析 (53)10.3 当前块传输(Current Block Transfer)效率分析 (54)10.4 当前块服务(Current Block Service)效率分析 (54)10.5 全局缓冲转换和获取(Global Cache Convert and Get)效率分析 (54)附录: (56)附录一:fdisk_emcpowera.sh (56)第一部分存储划分存储划分方法参见《附件一:集中交易系统CX4 存储实施文档》存储规划见文档《附件二:集中交易系统-EMC120-240存储划分》第二部分RedHat AS4 X86_64 系统安装2.1本地磁盘做RAID主机启动后,放入做RAID的光盘,按提示一步步完成RAID的制作(本地磁盘可做成RAID5或RAID1+0)。

使用虚拟机在Linux环境下搭建Oracle_RAC_10g

使用虚拟机在Linux环境下搭建Oracle_RAC_10g

一、 Linux安装平台及Oracle软件:1、Linux平台:(1)centos5.4(2.6.18-164.e15)2、Oracle软件:(1) 10201_clusterware_linux_x86_64.cpio.gz(2) 10201_database_linux_x86_64.cpio.gz3、 ASM相关安装包oracleasm-2.6.18-164.el5-2.0.5-1.el5.x86_64.rpmoracleasm-support-2.1.3-1.el5.x86_64.rpmoracleasmlib-2.0.4-1.el5.x86_64.rpm4、Openfiler相关安装包iscsi-initiator-utils-6.2.0.871-0.10.el5.x86_64.rpm5、 OCFS相关安装包ocfs2-2.6.18-164.el5-1.4.2-1.el5.x86_64.rpmocfs2console-1.4.2-1.el5.x86_64.rpmocfs2-tools-1.4.2-1.el5.x86_64.rpm6、 Oracle集群件10201_clusterware_linux_x86_64.cpio.gzlibXp-1.0.0-8.1.el5.i386.rpm 补丁包libXp-1.0.0-8.1.el5.x86_64.rpm补丁包二、配置第一个虚拟机:要创建和配置第一个虚拟机,您需要添加虚拟硬件设备,如磁盘和处理器。

在继续执行安装之前,请创建以下windows 文件夹以存放虚拟机和共享存储。

F:\>OracleRac\oracledb1 虚拟机1F:\>OracleRac\oracledb2 虚拟机2F:\>OracleRac\sharedDisk 共享存储启动vmware应用程序1. 创建一个新的虚拟机。

2. 新建虚拟机向导:单击Next。

3. 选择适当的配置:a. 虚拟机配置:选择Custom。

ORACLE10gRAC(RAW)安装文档

ORACLE10gRAC(RAW)安装文档

ORACLE10gRAC(RAW)安装⽂档1.安装oracle10g RAC1.1. 安装需要的软件10201_clusterware_linux_x86_64.cpio.gz10201_database_linux_x86_64.cpio.gz1.2. 系统设置注意,以下所说步骤如果没有特别强调,则要求在每个节点上执⾏。

1.2.1.系统参数1.内核参数在/etc/sysctl.conf中添加如下项⽬:然后⽤执⾏/sbin/sysctl –p1.2.2.oracle⽤户和组# /usr/sbin/groupadd oinstall# /usr/sbin/groupadd dba# /usr/sbin/useradd -m -g oinstall -G dba oracle# id oracleuid=1000(oracle) gid=1000(oinstall) groups=1000(oinstall),6(disk),1001(dba) 设置oracle 帐户的⼝令:# passwd oracleChanging password for user oracle.New password:Retype new password:passwd:all authentication tokens updated successfully.设置oracle的shell限制:在/etc/security/limits.conf⽂件中加⼊1.2.3. ⽹络设置RAC要求机群内的每个节点⾄少有两块⽹卡,⼀个设置为公⽤(公⽹),对外提供服务;⼀个设置为私⽤(专⽤),提供节点内的告诉传输。

此外还需要为公⽤⽹卡配置⼀个虚拟地址,oracle需要借此为⽤户提供透明的⾼可⽤服务。

具体介绍如下:专⽤⽹络每个集群节点通过专⽤⾼速⽹络连接到所有其他节点,这种专⽤⾼速⽹络也称为集群互联或⾼速互联(HSI)。

Oracle 的Cache Fusion 技术使⽤这种⽹络将每个主机的物理内存(RAM)有效地组合成⼀个⾼速缓存。

Oracle10g RAC安装手册2

Oracle10g RAC安装手册2

Oracle10g RAC安装手册2第五部分安装配置Oracle RAC5.1 配置环境变量5.1.1 编辑.bashrc设置 ORACLE_BASE 和 ORACLE_HOME 等环境变量基本路径:ORACLE_BASE=/u01/app/oracleORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1ORA_CRS_HOME=/u01/crs/oracle/product/10.2.0/crs_1据oracle的安装文档要求,CRS的目录最好不是ORACLE_BASE的子目录,因为安装过程中会改变CRS的父目录的权限,这会影响ORACLE的安装。

在按以上要求生成对应目录之前,需检查所在磁盘的空间是否满足安装要求,确定之后生成目录,并将相关环境变量设置在oracle用户的profile中。

用oracle帐号编辑/home/oracle/.bashrcoracle用户的profile文件.bashrc内容:# .bashrc# User specific aliases and functions# Source global definitionsif [ -f /etc/bashrc ]; then. /etc/bashrcfiexport ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1export ORA_CRS_HOME=/u01/crs/oracle/product/10.2.0/crs_1export ORACLE_SID=dbrac1export ORACLE_TERM=xtermexport LD_ASSUME_KERNEL=2.4.1export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/dataexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin:$ORA_CRS_HOME/bin:/sbinexport PATH然后执行$ source .bash_profile使环境变量生效注意:ORACLE_SID每台机器不一样,如dbrac1的SID为dbrac1,dbrac2的SID 为dbrac2,以此类推。

Linux下oracle10g rac安装配置说明

Linux下oracle10g rac安装配置说明

集群中所有计算机上配置时间服务
时间服务器配置:
vi /etc/ntp.conf,时间服务器用uas两台机器,uas两台机器的ntp.conf中server配置:
server
server
server
rpm -ivh /mnt/cdrom3/RedHat/RPMS/zlib-devel-1.2.1.2-1.i386.rpm
rpm -ivh /mnt/cdrom3/RedHat/RPMS/freetype-devel-2.1.9-1.i386.rpm
rpm -ivh /mnt/cdrom3/RedHat/RPMS/fontconfig-devel-2.2.3-7.i386.rpm
# Each RAC node must have a unique ORACLE_SID.(i.e. orcl1, orcl2,...)
export ORACLE_SID=orcl1
export PATH=.:${PATH}:$HOME/bin:$ORACLE_HOME/bin
export PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
用户帐户名是‘oracle’,组是‘oinstall’和‘dba’。
仅在一个集群主机上以 root 用户身份执行以下命令:
1,创建user/group;
groupadd oinstall
groupadd dba
useradd -m -g oinstall -G dba oracle
--------------------------------------------------------------------------------

Oracle 10g RAC安装与配置(ppt 32页)

Oracle 10g RAC安装与配置(ppt 32页)

共享文件系统(NTFS、EXT3)
维护方便
大型数据库不推荐使用
ASM( Oracle 10g新技术)
维护方便,性能较可靠
13
二、CRS安装升级
CRS安装 1、root用户执行rootpre.sh脚本 2、CRS_HOME路径 3、规划VIP地址 4、root用户执行
/home/oracle/oraInventory/orainstRoot.sh和 $CRS_HOME/root.sh脚本 5、VIP配置BUG
Server Mode All Initialization Parameters:……
26
建库
5、Database Storage 控制文件 路径、冗余、参数 表空间 路径、大小、参数 数据文件 路径、大小、参数 Redo log Groups 路径、大小、组数、成员数
27
建库
7
系统环境
硬件环境 硬件服务器: CPU(32bit、64bit|Intel-Itanium、AMD) 内存(32bit system Oracle可寻址内存4G, SGA 1.7G) 其他:存储、网卡等 网络环境:双网卡、心跳线、网络带宽等
8
系统环境
软件环境 系统版本: 需要经过Oracle认证 系统包:
30
Q&A
谢谢!
31
Oracle 10g RAC安装配置注意事项
1) 系统时间同步 2) 主机名命名(长度、特殊符号等) 3) 共享磁盘(划分、共享方式等) 4) OCR DISK和VOTING DISK读写属性 5) Root用户执行root.sh脚本 6) VIP配置BUG 7) 操作系统补丁包(不要太低或太高,要合理) 8) 操作系统经过认证 9) CRS和数据库软件升级 10) Redo log groups

Oracle RAC 安装图解

Oracle RAC 安装图解

oracle 10g rac 安装图解规划:所用linux系统以虚拟化方式安装在esx上,配置有内网的yum源,各分配有16G存储,下面为简单拓扑图一,下载软件1,地址:/technology/software/products/database/oracle10g/htdocs/10201linx8 664soft.html10201_database_linux_x86_64.cpio.gz10201_clusterware_linux_x86_64.cpio.gz2,地址:/technology/software/tech/linux/asmlib/rhel5.html oracleasm-2.6.18-164.el5-2.0.5-1.el5.x86_64.rpmoracleasmlib-2.0.4-1.el5.x86_64.rpmoracleasm-support-2.1.3-1.el5.x86_64.rpm二,安装环境1,系统:centos 5.4 x86_642,外部存储:linux下的iscsi3, iscsi服务器配置#下载iSCSI Enterprise Targetwget/sourceforge/iscsitarget/iscsitarget-0.4.17.ta r.gz#解压缩tar-zxvf iscsitarget-0.4.17.tar.gzcd iscsitarget-0.4.17#编译、安装makemake install#配置服务chkconfig --level2345 iscsi-target onservice iscsi-target start#配置第一个iSCSI设备#在/opt/下生成64G大的空洞设备文件#请将opt修改为实际的目录,并根据实际情况设置设备文件大小#生成空洞文件速度很快的,且在真正使用之前不占用磁盘实际空间dd if=/dev/zero of=/opt/iscsi.[配置文件中Target的名称].img bs=1G count=64seek=64#cout是从什么开始,一般设置为0#生成256G的例子dd if=/dev/zeroof=/opt/iscsi/.haoyuan-inc:storage.disk.oracle.01.img bs=1G count=0seek=256vim/etc/ietd.conf#编辑Target名称,例如:.haoyuan-inc:storage.disk.share.01#编辑LUN段内容,例如:Lun 0Path=/opt/.haoyuan-inc:storage.disk.share.01.image,Type =fileio#不要设置XXXUser,允许任何人访问#重启iscsi-targetservice iscsi-target restart三,安装准备1,检查必须软件yum install jdk binutils elfutils-libelf elfutils-libelf-devel glibcglibc-common glibc-devel gcc gcc-c++ libaio libaio-devel libgcc libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel libXp libXp-devel#其中jdk是我在yum服务器中添加的2,修改内核参数编辑/etc/sysctl.confkernel.shmall = 2097152kernel.shmmax = 2147483648kernel.shmmni = 4096kernel.sem = 25032000100128fs.file-max = 65536net.ipv4.ip_local_port_range = 102465000net.core.rmem_default = 262144net.core.rmem_max = 262144net.core.wmem_default = 262144net.core.wmem_max = 262144#生效/sbin/sysctl -p3,修改系统shell限制vi/etc/security/limits.conforacle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 655364,配置Hangcheck 计时器所有RHEL 版本:cat >> /etc/rc.d/rc.local <<eof/sbin/insmod hangcheck-timer hangcheck_tick=30 hangcheck_margin=180EOF5,添加相应用户和组</eof/usr/sbin/groupadd oinstall/usr/sbin/groupadd dba/usr/sbin/useradd -m-g oinstall -G dba oraclepasswd oracle6,配置网络每个机器需要两块网卡,一个设置为公共IP,一个设置为私有IP,另外另需配置一虚拟IP,虚拟IP不用手工添加到系统,只需预先定义好,一般是和公共IP在同一子网。

oracle10g _RAC安装说明

oracle10g _RAC安装说明

RADHATENTERPRISELinux5.5 Oracle10RAC群集安装---薛宋辉昵称:stromQQ号:2506149081. 硬件要求和概述2. 配置第一个虚拟机3. 在第一个虚拟机上配置Enterprise Linux4. 创建并配置第二个虚拟机5. 配置Oracle 自动存储管理(ASM)6. 配置Oracle 集群文件系统(OCFS2)7. 安装Oracle 集群件8. 安装Oracle 数据库10g第2 版9. 安装RAC 数据库环境存在的问题1. 硬件要求和概述在本指南中,您将安装64 位Linux 客户操作系统。

只有在主机上运行的以下64 位处理器支持64 位客户操作系统:∙AMD Athlon 64 修订版D 或更高版本∙AMD Opteron 修订版E 或更高版本∙AMD Turion 64 修订版E 或更高版本∙AMD Sempron 64-bit-capable 修订版D 或更新的Intel EM64T VT-capable 处理器∙如果您决定安装64 位客户操作系统,请确定上面列出了您的处理器。

您还需要确保在BIOS 中启用了虚拟技术(VT)。

一些主流制造商在默认情况下禁用了该技术。

此处提供了有关处理器兼容性的其他信息。

要验证您的处理器是否受支持,请从VMware 网站下载处理器兼容性检查工具。

∙为每个虚拟机至少分配1024MB 内存;为所有虚拟机预留至少30GB 磁盘空间。

主机操作系统环境概况:客户操作系统环境概况:虚拟磁盘布局概况:(要配置共享存储,客户OS 不能与共享存储共享同一个SCSI 总线。

指定客户OS 使用SCSI0,共享磁盘使用SCSI1。

)RAC 数据库环境概况:您将在每个节点上安装Oracle 主目录供冗余使用。

每个节点上的ASM 和Oracle RAC 实例共享同一个Oracle 主目录。

1.安装虚拟机这块不讲了2.在VMware配置共享磁盘和网卡设备Vmware版本为 7.0或更新的版本创建四个虚拟SCSI 硬盘— ocfs2disk.vmdk (512MB)、asmdisk1.vmdk (3GB)、asmdisk2.vmdk (3GB) 和asmdisk3.vmdk (2GB)。

oracle10g安装教程

oracle10g安装教程

oracle10g安装教程Oracle 10g 是一款强大的关系型数据库管理系统,下面是Oracle 10g 的安装教程:第一步:下载 Oracle 10g 安装包。

可以在 Oracle 官方网站上下载适用于您的操作系统的 Oracle 10g 安装包。

下载完成后,确保安装包与您的操作系统兼容。

第二步:解压安装包。

将下载的安装包解压到您想要安装 Oracle 10g 的目录中。

您可以使用压缩解压工具(如WinRAR)或自带的压缩工具进行解压。

第三步:运行安装程序。

在解压完成后,进入到解压目录,并找到名为“setup.exe” 或“install.exe” 的安装程序。

双击运行该程序以启动安装向导。

第四步:选择安装类型。

安装向导会提示您选择“创建和配置数据库”或“仅安装软件”。

如果您想在本地计算机上创建和配置 Oracle 数据库,选择第一个选项。

如果只是想安装 Oracle 10g 的软件,选择第二个选项。

第五步:配置数据库实例和监听器。

如果选择了“创建和配置数据库”选项,安装向导会要求您提供一些配置信息,如数据库名称、端口号和管理员密码等。

根据您的需求,填写相应的信息,并点击“下一步”继续。

第六步:选择安装位置。

安装向导会要求您选择 Oracle 10g 的安装位置。

您可以选择默认路径或自定义路径。

点击“下一步”继续。

第七步:进行安装。

在确认了安装选项和安装位置后,点击“下一步”开始安装。

安装过程可能需要一些时间,请耐心等待。

第八步:完成安装。

安装完成后,安装向导会弹出安装完成的提示窗口。

点击“完成”退出向导。

至此,您已经成功安装了 Oracle 10g 数据库。

完成安装后,您可以通过启动菜单或桌面上的 Oracle 10g 快捷方式来启动Oracle 10g 数据库,并开始使用它来创建和管理数据库。

总结:安装 Oracle 10g 数据库需要先下载安装包,然后解压安装包,并运行安装程序。

在安装向导中,需要选择安装类型、配置数据库实例和监听器、选择安装位置,最后进行安装。

oracle10gRAC安装

oracle10gRAC安装

一、配置LINUX创建 Oracle 组和用户帐户接下来我们将创建用于安装和维护 Oracle 10g 软件的 Linux 组和用户帐户。

用户帐户名是‘oracle’,组是‘oinstall’和‘dba’。

仅在一个集群主机上以 root 用户身份执行以下命令:/usr/sbin/groupadd dba/usr/sbin/groupadd oinstall/usr/sbin/useradd -m -g oinstall -G dba oracleid oracle例如:# /usr/sbin/groupadd dba# /usr/sbin/groupadd oinstall# /usr/sbin/useradd -m -g oinstall -G dba oracle# id oracleuid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba)设置 oracle 帐户的口令:# passwd oracleChanging password for user oracle.New password:Retype new password:passwd:all authentication tokens updated successfully.创建挂载点现在创建存储 Oracle 10g 软件的挂载点。

本指南在创建目录结构时所用的命名惯例将遵循最佳灵活体系结构 (OFA)。

有关 OFA 标准的更多信息,请参见Oracle 数据库 10g 安装指南的附录 D。

以 root 用户身份执行以下命令:mkdir -p /u01/app/oracle /ocfschown -R oracle:oinstall /u01/app/oracle /ocfschmod 775 /u01/app/oracle /ocfs配置内核参数cat >> /etc/sysctl.conf <<EOFkernel.shmall = 2097152kernel.shmmax = 2147483648kernel.shmmni = 4096kernel.sem = 250 32000 100 128fs.file-max = 65536net.ipv4.ip_local_port_range = 1024 65000net.core.rmem_default = 1048576net.core.rmem_max = 1048576net.core.wmem_default = 262144net.core.wmem_max = 262144EOF为 oracle 用户设置 Shell 限制Oracle 建议对每个 Linux 帐户可以使用的进程数量和打开文件的数量设置限制。

最终版oracle_10g_rac_for_linux86_64安装.doc

最终版oracle_10g_rac_for_linux86_64安装.doc

Oracle 10g RAC For RHEL5 Linux86_64 (裸设备)安装手册目录第一章安装准备 (3)1.1系统补丁包安装 (3)1.2若连接存储为IP-SAN则需安装ISCSI包,并开启ISCSI服务 (3)1.3关闭SENDMAIL (3)1.4规划RAC网络及存储 (3)1.5修改操作系统文件 (9)1.5.1 配置主机名 (9)1.5.2 配置网卡 (10)1.5.3 /etc/hosts (10)1.5.4 /etc/sysctl.conf (10)1.5.5 /etc/security/limits.conf (11)1.5.6 /etc/pam.d/login (11)1.5.7 /etc/profile (11)1.5.8 /etc/modprobe.conf (11)1.5.9 /etc/rc.d/rc.local (12)1.5.10 加载hangcheck模块 (12)1.5.11 修改系统版本号 (12)[oracle@sohdb1 ~]# vi /etc/redhat-release (12)[oracle@sohdb2 ~]# vi /etc/redhat-release (12)1.5.12 创建oracle安装用户 (12)1.5.13 创建oracle软件的相关目录 (12)1.5.14 修改oracle用户的环境变量 (13)1.5.15 修改root用户环境变量 (13)1.5.16 创建目录 ........................................................................................................... 错误!未定义书签。

1.5.17 时间同步 (13)1.5.18 配置ssh (13)1.5.19 绑定裸设备 (15)第二章安装ORACLECRS软件 (16)2.1安装的准备工作 (16)2.2图形下安装 (16)2.2.1 CRS安装环境检查 (16)2.3 ROOT执行VIPCA (28)第三章安装ORACLE数据库软件 (32)第四章安装ORACLE10.2.0.4补丁 (39)4.1安装ORACLE CRS补丁 (39)4.2安装O RACLE数据库补丁 (44)第五章创建数据库 (49)5.1D BCA创建数据库 (49)本文中黄色字体是用户手工输入的内容第一章安装准备1.1系统补丁包安装正式环境系统必须为linux64位系统,建议采用系统版本为5,由于64位需要打得包较多,故建议在系统安装时使用全安装。

  1. 1、下载文档前请自行甄别文档内容的完整性,平台不提供额外的编辑、内容补充、找答案等附加服务。
  2. 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
  3. 3、如文档侵犯您的权益,请联系客服反馈,我们会尽快为您处理(人工客服工作时间:9:00-18:30)。

Ads by Google Oracle VMware Linux VMware Console VMware3 VMwareThis SiteHomeDBA ScriptsOracle 8i Articles Oracle 9i Articles Oracle 10g Articles Miscellaneous Articles Linux ArticlesOracle Certification ForumsORACLE-BASE Blog Blog Aggregator Industry News Book StoreTSHSQL Download Firefox Search Plugins Site Info LinksPrinter FriendlyOracle SitesOracle Corporation Technology Network Oracle Metalink Oracle Certification Oracle Magazine Ask TomOracle 8i R3 Docs Oracle 9i R1 Docs Oracle 9i R2 Docs Oracle 10g R1 Docs Oracle 10g R2 Docs Oracle 9iAS DocsOracle AS10g R1 Docs Oracle AS10g R2 Docs Oracle AS10g R3 DocsError MessagesORA-Go 8i R39i R19i R210g R110g R2Search Oracle DocsGo Metalink 8i R39i R19i R210g R110g R2SiteWebGo Oracle 10g RAC On Windows 2003 Using VMware ServerThis article describes the installation of Oracle 10g release 2 (10.2.0.1) RAC on Windows 2003 Server Standard Edition using VMware Server with no additional shared disk devices.z Introduction z Download Software z VMware Server Installationz Virtual Machine Setupz Guest Operating System Installation z Oracle Installation Prerequisites z Install VMware Client Tools z Create Shared Disksz Clone the Virtual Machinez Install the Clusterware Softwarez Install the Database Software and Create an ASM Instance z Create a Database using the DBCA z TNS ConfigurationzCheck the Status of the RACIntroductionOne of the biggest obstacles preventing people from setting up test RAC environments is the requirement for shared storage. In a production environment, shared storage is often provided by a SAN or high-end NAS device, but both of these options are very expensive when all you want to do is get some experience installing and using RAC. A cheaper alternative is to use a FireWire disk enclosure to allow two machines to access the same disk(s), but that still costs money and requires two servers. A third option is to use VMware Server to fake the shared storage.Using VMware Server you can run multiple Virtual Machines (VMs) on a single server, allowing you to run both RAC nodes on a single machine. In additon, it allows you to set up shared virtual disks, overcoming the obstacle of expensive shared storage.Before you launch into this installation, here are a few things to consider.zThe finished system includes the host operating system, two guest operating systems, two sets of Oracle Clusterware, two ASM instances and two Database instances all on a single server. As you can imagine, this requires a significant amount of disk space, CPU and memory. To complete this installation I used a dual 3.0G Xeon server with 4G of memory.zThis procedure provides a bare bones installation to get the RAC working. There is no redundancy in the Clusterware installation or the ASM installation. To add this, simply create double the amount of shared disks and select the "Normal" redundancy option when it is offered. Of course, this will take more disk space.z During the virtual disk creation, I always choose not to preallocate the disk space. This makes virtual disk access slower during the installation, but saves on wasted disk space.z This is not, and should not be considered, a production-ready system. It's simply to allow you to get used to installing and using RAC.Download SoftwareDownload the following software.z VMware ServerzOracle 10g (10.2.0.1) CRS and DB softwareVMware Server InstallationFor this article, I used CentOS 4.3 as the host operating systems. To use Windows as the host operating system, simply run the executable installation file and ignore the following VMware Server installation information.First, install the VMware Server software. On Linux you do this with the following command as the root user.# rpm -Uvh VMware-server-*.rpmPreparing... ########################################### [100%] 1:VMware-server ########################################### [100%]Virtual Disaster RecoveryFree White Paper: Building disaster recovery solutions with VMware.Rac Antibodies Santa Cruz Biotechnology, Inc. Source of over26,000 antibodies. /table-rac.html#Then finish the configuration by running the vmware-config.pl script as the root user. Most of the questions can be answered with the default response by pressing the return key. The output below shows my responses to the questions.# vmware-config.plMaking sure services for VMware Server are stopped.Stopping VMware services:Virtual machine monitor [ OK ]You must read and accept the End User License Agreement to continue.Press enter to display it.VMWARE, INC.SOFTWARE BETA TEST AGREEMENT*** Editied out license agreement ***Do you accept? (yes/no) yesThank you.Configuring fallback GTK+ 2.4 libraries.In which directory do you want to install the mime type icons?[/usr/share/icons]What directory contains your desktop menu entry files? These files have a.desktop file extension. [/usr/share/applications]In which directory do you want to install the application's icon?[/usr/share/pixmaps]Trying to find a suitable vmmon module for your running kernel.The module bld-2.6.9-5.EL-i686smp-RHEL4 loads perfectly in the running kernel.Do you want networking for your virtual machines? (yes/no/help) [yes]Configuring a bridged network for vmnet0.The following bridged networks have been defined:. vmnet0 is bridged to eth0All your ethernet interfaces are already bridged.Do you want to be able to use NAT networking in your virtual machines? (yes/no)[yes]Configuring a NAT network for vmnet8.Do you want this program to probe for an unused private subnet? (yes/no/help)[yes]Probing for an unused private subnet (this can take some time)...The subnet 172.16.210.0/255.255.255.0 appears to be unused.The following NAT networks have been defined:. vmnet8 is a NAT network on private subnet 172.16.210.0.Do you wish to configure another NAT network? (yes/no) [no]Do you want to be able to use host-only networking in your virtual machines?[yes] noTrying to find a suitable vmnet module for your running kernel.The module bld-2.6.9-5.EL-i686smp-RHEL4 loads perfectly in the running kernel.Please specify a port for remote console connections to use [902]Stopping xinetd: [ OK ]Starting xinetd: [ OK ]Configuring the VMware VmPerl Scripting API.Building the VMware VmPerl Scripting API.Using compiler "/usr/bin/gcc". Use environment variable CC to override.The installation of the VMware VmPerl Scripting API succeeded.Do you want this program to set up permissions for your registered virtualmachines? This will be done by setting new permissions on all files found inthe "/etc/vmware/vm-list" file. [no] yesGenerating SSL Server CertificateIn which directory do you want to keep your virtual machine files?[/var/lib/vmware/Virtual Machines] /u01/VMDo you want to enter a serial number now? (yes/no/help) [no] yesPlease enter your 20-character serial number.Type XXXXX-XXXXX-XXXXX-XXXXX or 'Enter' to cancel: ENTER-YOUR-SERIAL-NUMBERStarting VMware services:Virtual machine monitor [ OK ]Virtual ethernet [ OK ]Bridged networking on /dev/vmnet0 [ OK ]Host-only networking on /dev/vmnet8 (background) [ OK ]NAT service on /dev/vmnet8 [ OK ]Starting VMware virtual machines... [ OK ]The configuration of VMware Server e.x.p build-22874 for Linux for this runningkernel completed successfully.#The VMware Server Console is started by issuing the command "vmware" at the command prompt, or by selecting it from the "System Tools" menu.On the "Connect to Host" dialog, accept the "Local host" option by clicking the "Connect" button.You are then presented with the main VMware Server Console screen.The VMware Server is now installed and ready to use.Virtual Machine SetupNow we must define the two virtual RAC nodes. We can save time by defining one VM, then cloning it when it is installed. In this article I use Linux as my host operating system, so all the file paths are UNIX style paths. If you are using a Windows host operating system you would expect to use Windows style paths to the various VMware files, so adjust the paths as necessary.Click the "Create a new virtual machine" button to start the "New Virtual Machine Wizard". Click the "Next" button onthe welcome page.Select the "Custom" virtual machine configuration and click the "Next" button.Select the "Windows" guest operating system option, and set the version to "Windows Server 2003 Standard Edition", then click the "Next" button.Enter the name "RAC1" and the location should default to "/u01/VM/RAC1", then click the "Next" button.Select the required number of processors and click the "Next" button.Uncheck the "Make this virtual machine private" checkbox and click the "Next" button.Select the amount of memory to associate with the virtual machine. Remember, you are going to need two instances, so don't associate too much, but you are going to need approximately 1 Gig (1024 Meg) to compete the installation successfully.Accept the "Use bridged networking" option by clicking the "Next" button.Accept the "LSI Logic" option by clicking the "Next" button.Select the "Create a new virtual disk" option and click the "Next" button.Accept the "SCSI" option by clicking the "Next" button. It's a virtual disk, so you can still use this option even if your physical disk is IDE or SATA.Set the disk size to "10.0" GB and uncheck the "Allocate all disk space now" option. The latter will make disk access slower, but will save you wasting disk space.Accept "RAC1.vmdk" as the disk file name and complete the VM creation by clicking the "Finish" button.On the "VMware Server Console" screen, click the "Edit virtual machine settings" button.On the "Virtual Machine Settings" screen, highlight the "Floppy 1" drive and click the "- Remove" button.Click the "+ Add" button and select a hardware type of "Ethernet Adapter", then click the "Next" button.Accept the "Bridged" option by clicking the "Finish" button.Click on the "Options" tab, highlight the "Startup/Shutdown" setting and select the "Don't power on virtual machine" in the "On host startup" option. Finish by clicking the "OK" button.The virtual machine is not configured so we can start the guest operating system installation.Guest Operating System InstallationPlace the first Windows 2003 SE disk in the CD drive and start the virtual machine by clicking the "Power on this virtual machine" button. The right pane of the VMware Server Console should display a boot loader, then the Windows installation screen.Continue through the Windows installation as you would for a normal server. To be consistent with the rest of the article, the following information should be set during the installation:z hostname: RAC1z IP Address eth0: 192.168.2.101 (public address)z IP Address eth1: 192.168.0.101 (private address)You are free to change the IP addresses to suit your network, but remember to stay consistent with those adjustments throughout the rest of the article.Oracle Installation PrerequisitesPerform the following steps whilst logged into the RAC1 virtual machine.Amend the C:\windows\system32\drivers\etc\hosts file to contain the following information.127.0.0.1 localhost.localdomain localhost# Public192.168.2.101 rac1.localdomain rac1192.168.2.102 rac2.localdomain rac2#Private192.168.0.101 rac1-priv.localdomain rac1-priv192.168.0.102 rac2-priv.localdomain rac2-priv#Virtual192.168.2.111 rac1-vip.localdomain rac1-vip192.168.2.112 rac2-vip.localdomain rac2-vipVMware sometimes creates additional network adapters, which will prevent the clusterware from loading. Delete any additional adapters as follows. Open a command prompt on RAC1 and issue the following commands.set devmgr_show_nonpresent_devices=1devmgmt.mscOn the resulting "Device Manager" screen, pick the "View > Show hidden devices" menu option.Now check for extra network adapters. You would expect two, but if there are more than this, uninstall the greyed out adapters.Open the "Network Connections" screen (Start > All Programs > Accessories > Communications > Network Connections). Rename the two connections to "public" and "private" respectively, making sure you apply the names to the appropriate connections.Check that the network settings are correct for both connections.The Clusterware installation is very sensitive, so make sure you read the Checking Network Requirements section of the documentation, and make any necessary changes.In addition to the configuration mentioned above, the documentation suggests two more configuration changes that I did not find necessary on VMware Server. Even so, it is advisable to make the changes.First, ensure the public interface is first in the bind order:z Open the "Network Connections" dialog by right-clicking on the "My Network Places" icon and selecting the "Properties" menu option.z Select the "Advanced > Advanced Settings..." menu option.z On the "Adapters and Bindings" tab, make sure the public interface is the first interface listed.z Accept any modifications by clicking on the "OK" button and exiting the "Network Connections" dialog. Second, disable Windows Media Sensing for TCP/IP:z Backup the Windows registry.z Run the Registry Editor (Regedt32.exe) and find the following key:HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\Tcpip\Parameters z Add the following registry value:Value Name: DisableDHCPMediaSenseData Type: REG_DWORD -BooleanValue: 1z This change will not take effect until the computer is restarted.Next, install the VMware client tools.Install VMware Client ToolsLogin on the RAC1 virtual machine, then select the "VM > Install VMware Tools..." option from the main VMware Server Console menu.Click the "Install" button on the subsequent screen.Click the "Next" button to continue.Accept the "Typical" option by clicking the "Next" button.Click the "Install" button to continue.Set the hardware acceleration when prompted by clicking the "Yes" button and following the instructions on the subsequent screens.Once the installatin is complete, click the "Finish" button.The VMware client tools are now installed.Create Shared DisksShut down the RAC1 virtual machine and create a directory on the host system to hold the shared virtual disks.# mkdir -p /u01/VM/sharedOn the VMware Server Console, click the "Edit virtual machine settings" button. On the "Virtual Machine Settings" screen, click the "+ Add" button.Select the hardware type of "Hard Disk" and click the "Next" button.Accept the "Create a new virtual disk" option by clicking the "Next" button.Accept the "SCSI" option by clicking the "Next" button.Set the disk size to "10.0" GB and uncheck the "Allocate all disk space now" option, then click the "Next" button.Set the disk name to "/u01/VM/shared/ocr.vmdk" and click the "Advanced" button.Set the virtual device node to "SCSI 1:1" and the mode to "Independent" and "Persistent", then click the "Finish" button.Repeat the previous hard disk creation steps 4 more times, using the following values:z File Name: /u01/VM/shared/votingdisk.vmdkVirtual Device Node: SCSI 1:2Mode: Independent and Persistentz File Name: /u01/VM/shared/asm1.vmdkVirtual Device Node: SCSI 1:3Mode: Independent and Persistentz File Name: /u01/VM/shared/asm2.vmdkVirtual Device Node: SCSI 1:4Mode: Independent and Persistentz File Name: /u01/VM/shared/asm3.vmdkVirtual Device Node: SCSI 1:5Mode: Independent and PersistentAt the end of this process, the virtual machine should look something like the picture below.Edit the contents of the "/u01/VM/RAC1/RAC1.vmx" file using a text editor, making sure the following entries are present. Some of the tries will already be present, some will not.disk.locking = "FALSE"diskLib.dataCacheMaxSize = "0"diskLib.dataCacheMaxReadAheadSize = "0"diskLib.dataCacheMinReadAheadSize = "0"diskLib.dataCachePageSize = "4096"diskLib.maxUnsyncedWrites = "0"scsi1.present = "TRUE"scsi1.virtualDev = "lsilogic"scsi1.sharedBus = "VIRTUAL"scsi1:1.present = "TRUE"scsi1:1.mode = "independent-persistent"scsi1:1.fileName = "/u01/VM/shared/ocr.vmdk"scsi1:1.deviceType = "plainDisk"scsi1:1.redo = ""scsi1:2.present = "TRUE"scsi1:2.mode = "independent-persistent"scsi1:2.fileName = "/u01/VM/shared/votingdisk.vmdk"scsi1:2.deviceType = "plainDisk"scsi1:2.redo = ""scsi1:3.present = "TRUE"scsi1:3.mode = "independent-persistent"scsi1:3.fileName = "/u01/VM/shared/asm1.vmdk"scsi1:3.deviceType = "plainDisk"scsi1:3.redo = ""scsi1:4.present = "TRUE"scsi1:4.mode = "independent-persistent"scsi1:4.fileName = "/u01/VM/shared/asm2.vmdk"scsi1:4.deviceType = "plainDisk"scsi1:4.redo = ""scsi1:5.present = "TRUE"scsi1:5.mode = "independent-persistent"scsi1:5.fileName = "/u01/VM/shared/asm3.vmdk"scsi1:5.deviceType = "plainDisk"scsi1:5.redo = ""Start the RAC1 virtual machine by clicking the "Power on this virtual machine" button on the VMware Server Console. When the server has started, log in so you can partition the disks.Prior to partitioning the disks on Windows Server 2003, you must enable disk automounting. I didn't need to do this, but I guess it makes sense to do as you're told. To enable automounting do the following command at the command prompt, then restart the server.C:\> diskpartDISKPART> automount enableDISKPART> exitC:\>When the server restarts, open the "Computer Management" dialog (Start > All Programs > Administrative Tools > Computer Management) and click on the Disk Management tree node. This action should initiate the "Initialize and Convert Disk Wizard". Click the "Next" button to continue.Initialize all 5 disks by clicking the "Next" button.Don't convert any of the disks. Make sure all 5 disks are unchecked, then "Next" button.Complete the process by clicking the "Finish" button.Right-click on "Disk 1" and select the "New Partition..." option to start the "New Partition Wizard".Click the "Next" button to continue.Select the "Extended partition" option, then click the "Next" button.Accept the default partition size by clicking the "Next" button.Complete the partition by clicking the "Finish" button.The partition will now be displayed with a green bar. Right-click on the partition and select the "New Logical Drive" option to restart the "New Partition Wizard".Click the "Next" button to continue.Accept the "Logical drive" option by clicking the "Next" button.Accept the default partition size by clicking the "Next" button.Select the "Do not assign a drive letter or drive path" option, then click the "Next" button.Select the "Do not format this partition" option, then click the "Next" button.Complete the logical drive by clicking the "Finish" button.The drive should now be displayed as a healthy drive with a blue bar.Repeat the previous partitioning steps for the remaining 4 disks.The shared disks are now configured.Clone the Virtual MachineThe current version of VMware Server does not include an option to clone a virtual machine, but the following steps illustrate how this can be achieved manually.Shut down the RAC1 virtual machine and copy the RAC1 virtual machine using the following command.# cp -R /u01/VM/RAC1 /u01/VM/RAC2Edit the contents of the "/u01/VM/RAC2/RAC1.vmx" file, making the following change.displayName = "RAC2"Ignore discrepancies with the file names in the "/u01/VM/RAC2" directory. This does not affect the action of the virtual machine.In the VMware Server Console, select the File > Open menu options and browse for the"/u01/VM/RAC2/RAC1.vmx" file. Once opened, the RAC2 virtual machine is visible on the console. Start the RAC2 virtual machine by clicking the "Power on this virtual machine" button and click the "Always Create" button on the subsequent "Question" screen.Open the "Network Connections" screen (Start > All Programs > Accessories > Communications > Network Connections). Amend the IP Addresses of both connections to the correct values for the RAC2 node.The cloning process sometimes alters the network connection setup, so repeat the steps mentioned previously for removing extra network adapters and renaming the connections.Open the "System Properties" dialog (Start > Control Panel > System), click on the "Computer Name" tab and click the "Change" button. Enter the name "rac2" then click the "OK" button.Click all subsequent "OK" buttons to exit the "System Properties" dialog and restart the server when prompted. Once the RAC2 virtual machine has restarted, start the RAC1 virtual machine. When both nodes have started, check they can both ping all the public and private IP addresses using the following commands.ping -c 3 rac1ping -c 3 rac1-privping -c 3 rac2ping -c 3 rac2-privAt this point the virtual IP addresses defined in the hosts file will not work, so don't bother testing them.It's a good idea to take a snapshot of the virtual machines, so you can repeat the following stages if you run into any problems. To do this, shutdown both virtual machines and issue the following commands.# cd /u01/VM# tar -cvf RAC-PreClusterware.tar RAC1 RAC2 shared# gzip RAC-PreClusterware.tarThe virtual machine setup is now complete.Install the Clusterware SoftwareStart the RAC1 and RAC2 virtual machines. The Oracle Clusterware for Windows is very sensitive, so before you start, check the network connection setup on each machine again. Remove and extra network adapters, rename the connections appropriately and check the nodes ping correctly. Make sure your network configuration matches the Checking Network Requirements section of the documentation.Start the Oracle installer on RAC1.On the "Welcome" screen, click the "Next" button.Accept the default inventory location by clicking the "Next" button.Enter the appropriate name and path for the Oracle Home and click the "Next" button.Wait while the prerequisite checks are done. If you have any failures correct them and retry the tests before clicking the "Next" button.The "Specify Cluster Configuration" screen shows only the RAC1 node in the cluster. Click the "Add" button to continue.Enter the details for the RAC2 node and click the "OK" button.Click the "Next" button to continue.The "Specific Network Interface Usage" screen defines how each network interface will be used. Highlight the "public" interface and click the "Edit" button.Set the "public" interface type to "Public" and click the "OK" button.Leave the "private" interface as private and click the "Next" button.On the "Cluster Configuration Storage" screen, highlight disk 1 and click the "Edit" button.Select the "Place OCR(Primary) on this Partition" option and click the "OK" button.Highlight disk 2 and click the "Edit" button. Select the "Place Voting Disk on this Partition" option and click the "OK" button.On the "Cluster Configuration Storage" screen, click the "Next" button and ignore the redundancy warnings by clicking the "OK" button.On the "Summary" screen, click the "Install" button to continue.Wait while the installation takes place.Wait while the configuration assistants run.The VIPCA will fail, so click the "OK" button on the resulting error screen.Click the "Next" button and accept the subsequent warning, then click the "Exit" button to leave the installer.On the RAC1 virtual machine, run the VIPCA manually by issuing the following commands in a command prompt.cd c:\oracle\product\10.2.0\crs\binvipca.batClick the "Next" button on the VIPCA welcome screen.Highlight the "public" interface and click the "Next" button.Enter the vitual IP alias and address for each node. Once you enter the first alias, the remaining values should default automatically. Click the "Next" button to continue.Accept the summary information by clicking the "Finish" button.Wait until the configuration is complete, then click the "OK" button.Accept the VIPCA results by clicking the "Exit" button.The status of the finished cluster can be checked by running the cluvfy.bat script as shown below.C:\oracle\product\10.2.0\crs\BIN>cluvfy.bat stage -post crsinst -n rac1,rac2Performing post-checks for cluster services setupChecking node reachability...Node reachability check passed from node "rac1".Checking user equivalence...User equivalence check passed for user "Administrator".Checking Cluster manager integrity...Checking CSS daemon...Daemon status check passed for "CSS daemon".Cluster manager integrity check passed.Checking cluster integrity...Cluster integrity check passedChecking OCR integrity...Checking the absence of a non-clustered configuration...All nodes free of non-clustered, local-only configurations.Uniqueness check for OCR device passed.Checking the version of OCR...OCR of correct Version "2" exists.Checking data integrity of OCR...Data integrity check for OCR passed.OCR integrity check passed.。

相关文档
最新文档