《[计算机软件及应用]ORACLE 11g R2 for suse11集群双机部署》由会员分享，可在线阅读，更多相关《[计算机软件及应用]ORACLE 11g R2 for suse11集群双机部署（44页珍藏版）》请在金锄头文库上搜索。
1、ORACLE 11g R2.03 rac安装 for SUSE Linux 11一， 主机环境准备：rac1：Hostname：rac1IP：/24rac1-priv: /24ntp: rac2:Hostname：rac2IP：/24rac1-priv: /24ntp: 共享存储：/dev/sdb 1G (锁盘，争议盘)/dev/sdc 16G (共享数据盘)/etc/hosts: rac1 rac1 rac1-priv rac1-priv rac2 rac2.3 rac2-priv rac2-priv rac1-vip rac1-vip rac2-vip rac2-viprac-scan r
2、ac-scan下面的PACKAGE应该包含在Default-RPMs，需要确认 (x86_64) (x86_64) glibc-32bit-2.9-13.2 (x86_64) (x86_64) (x86_64) libaio-32bit-0.3.104-140.22 (x86_64) libstdc+33-3.3.3-11.9 (x86_64) libstdc+33-32bit-3.3.3-11.9 (x86_64) libstdc+43-4.3.3_20081022-11.18 (x86_64) libstdc+43-32bit-4.3.3_20081022-11.18 (x86_64) (
3、x86_64) (x86_64)下面的PACKAGE需要另外安装noarch/linux-kernel-headers-2.6.27-2.22.noarch.rpm glibc-devel-32bitlibstdc libgomp43-32bit-4.3.3_20081022-11.18.x86_64.rpm gcc43-32bit-4.3.3_20081022-11.18.x86_64.rpm gcc43-c+-4.3.3_20081022-11.18.x86_64.rpm libaio-devel-32bit-0.3.104-140.22.x86_64.rpm 上述所有的PACKAGE，都
4、可以在SLES 11 64-bit (x86_64) distribution media 中找到。rpm -ivh （下载）rpm -ivh (光盘)rpm -ivh (光盘)rpm -ivh （下载）vi /etc/# Disable response to broadcasts.# You dont want yourself becoming a Smurf .ipv4.icmp_echo_ignore_broadcasts = 1# enable route verification on all interfacesnet.ipv4.conf.all.rp_filter = 1#
5、enable ipV6 forwarding#net.ipv6.conf.all.forwarding = 1# increase the number of possible inotify(7) watches = 65536-max = 6815744 = 2007748608 = 4096 kernel.sem = 250 32000 100 128 = 1000# avoid deleting secondary IPs on deleting the primary IPnet.ipv4.conf.default.promote_secondaries = 1net.ipv4.co
6、nf.all.promote_secondaries = 1=262144=4194304=262144=1048576net.ipv4.ip_local_port_range = 9000 65500sysctl p虚机vmx设置：需编辑加入：=FALSE = 0 = 0 = 0 = 4096 = 0scsi1.present = TRUEscsi1.sharedBus = physicalscsi1.virtualDev = lsilogicvmci0.unrestricted = TRUEscsi1:1.SharedBus=Virtualscsi1:1.shared=TRUEscsi1:
7、1.mode = independent-persistentscsi1:1.present = TRUEscsi1:1.fileName = rac1_2.vmdkscsi1:1.deviceType = scsi-hardDiskscsi1:2.SharedBus=Virtualscsi1:2.shared=TRUEscsi1:2.mode = independent-persistentscsi1:2.present = TRUEscsi1:2.fileName = rac1_3.vmdkscsi1:2.deviceType = scsi-hardDiskOracle安装用户和组设置创建
8、用户和组建立Oracle安装目录组:/usr/sbin/groupadd g 1000 oinstall建立Oracle ASMDBA组：/usr/sbin/groupadd -g 1002 asmadmin/usr/sbin/groupadd -g 1003 asmdba/usr/sbin/groupadd -g 1004 asmoper/usr/sbin/groupadd -g 1001 dba建立Grid安装用户grid：#mkdir /home/grid#/usr/sbin/useradd -u 1001 -g oinstall -G asmadmin,asmdba,asmoper,d
9、ba -d /home/grid/ grid建立Oracle安装用户oracle：/usr/sbin/useradd -u 1000 -g oinstall -G dba,asmdba -d /home/oracle/ oracle用户shell limit设置1 、修改/etc/security/limits.confOracle:oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 oracle soft stack 10240Grid:grid sof
10、t nproc 2047 grid hard nproc 16384 grid soft nofile 1024 grid hard nofile 65536 grid soft stack 102402、修改/etc/login,如果不存在，则创建该文件session3、修改default shell startup file For ksh bsh,/etc/profile:if $USER = oracle | $USER = grid ; thenif $SHELL = /bin/ksh ; thenulimit -p 16384ulimit -n 65536elseulimit -u
11、 16384 -n 65536fiumask 022fiFor CSH,/etc/:if ( $USER = oracle | $USER = grid ) thenlimit maxproc 16384limit descriptors 65536endif数据库安装用户grid.profile.profile文件内容如下：PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:. :$PATHexport PATHexport ORACLE_BASE=/oracle/app/gridbaseexport ORAC
12、LE_HOME=/oracle/app/gridexport PATH=$PATH:$ORACLE_HOME/binset -o viif -s $MAIL # This is at Shell startup. In normalthen echo $MAILMSG # operation, the Shell checksfi # periodically.umask 022GI_OUI=/home/oracle/softexport GI_OUI数据库安装用户oracle.profile.profile文件内容如下：PATH=/usr/bin:/etc:/usr/sbin:/usr/uc
13、b:$HOME/bin:/usr/bin/X11:/sbin:.:$PATHexport PATHexport ORACLE_BASE=/oracle/app/oracleexport ORACLE_HOME=/oracle/app/oracle/dbhomeexport PATH=$PATH:$ORACLE_HOME/binset -o viif -s $MAIL # This is at Shell startup. In normalthen echo $MAILMSG # operation, the Shell checksfi # periodically.umask 022OUI
14、_HOME=/home/oracle/softexport OUI_HOMEOracle inventory 目录mkdir -p /oracle/app/oraInventorychown -R grid:oinstall /oracle/app/oraInventorychmod -R 775 /oracle/app/oraInventoryGrid Infrastructure BASE 目录mkdir p /oracle/app/gridchown grid:oinstall /oracle/app/gridchmod -R 775 /oracle/app/gridGrid Infrastructure Home 目录mkdirchown -R grid:oinstallchmodOracle Base 目录mkdir -p /oracle/app/oraclemkdir /oracle/app/oracle/cfgtoollogs -needed to en
