ORACLE 11g R2 for SUSE 11集群双机部署

- 日理万妓 2022-06-16 06:25 105阅读 0赞

ORACLE 11g R2.03 rac 安装 for SUSE Linux 11

主机环境准备：

rac1：

Hostname：rac1

IP：192.168.1.1/24

rac1-priv: 192.168.2.1/24

ntp: 192.168.3.3

rac2:

Hostname：rac2

IP：192.168.1.3/24

rac1-priv: 192.168.2.2/24

ntp: 192.168.3.3

共享存储：

/dev/sdb 1G  (锁盘，争议盘)

/dev/sdc 16G  (共享数据盘)

/etc/hosts:

192.168.1.1  rac1 rac1

192.168.2.1   rac1-priv rac1-priv

192.168.1.3  rac2 rac2

192.168.2.3   rac2-priv rac2-priv

192.168.1.2 rac1-vip  rac1-vip

192.168.1.4  rac2-vip  rac2-vip

rac-scan  rac-scan

下面的PACKAGE应该包含在Default-RPMs，需要确认

binutils-2.19-11.28 (x86\_64)

glibc-2.9-13.2 (x86\_64)

glibc-32bit-2.9-13.2 (x86\_64)

ksh-93t-9.4 (x86\_64)

libaio-0.3.104-140.22 (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)

libgcc43-4.3.3\_20081022-11.18 (x86\_64)

make-3.81-128.20 (x86\_64)

下面的PACKAGE需要另外安装

noarch/linux-kernel-headers-2.6.27-2.22.noarch.rpm

gcc43-4.3.3\_20081022-11.18.x86\_64.rpm

glibc-devel-32bit-2.9-13.2.x86\_64.rpm

libstdc++43-devel-4.3.3\_20081022-11.18.x86\_64.rpm

gcc43-4.3.3\_20081022-11.18.x86\_64.rpm

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-0.3.104-140.22.x86\_64.rpm

libaio-devel-32bit-0.3.104-140.22.x86\_64.rpm

sysstat-8.1.5-7.8.x86\_64.rpm

glibc-devel-2.9-13.2.x86\_64.rpm

上述所有的PACKAGE，都可以在SLES 11 64-bit (x86\_64) distribution media 中找到。

rpm -ivh oracleasm-support-2.1.7-1.SLE11.x86\_64.rpm  （下载）

rpm -ivh oracleasm-kmp-default-2.0.5\_2.6.27.19\_5-7.6.x86\_64.rpm   (光盘)

rpm -ivh oracleasm-2.0.5-7.6.x86\_64.rpm   (光盘)

rpm -ivh oracleasmlib-2.0.4-1.sle11.x86\_64.rpm  （下载）

vi /etc/sysctl.conf

\# Disable response to broadcasts.

\# You don't want yourself becoming a Smurf amplifier.

net.ipv4.icmp\_echo\_ignore\_broadcasts = 1

\# enable route verification on all interfaces

net.ipv4.conf.all.rp\_filter = 1

\# enable ipV6 forwarding

\#net.ipv6.conf.all.forwarding = 1

\# increase the number of possible inotify(7) watches

fs.inotify.max\_user\_watches = 65536

fs.file-max = 6815744

kernel.shmall = 2007748608

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

vm.hugetlb\_shm\_group = 1000

\# avoid deleting secondary IPs on deleting the primary IP

net.ipv4.conf.default.promote\_secondaries = 1

net.ipv4.conf.all.promote\_secondaries = 1

net.core.rmem\_default=262144

net.core.rmem\_max=4194304

net.core.wmem\_default=262144

net.core.wmem\_max=1048576

net.ipv4.ip\_local\_port\_range = 9000 65500

sysctl –p

虚机vmx设置：需编辑加入：

disk.locking="FALSE"

diskLib.dataCacheMaxSize = "0"

diskLib.dataCacheMaxReadAheadSize = "0"

diskLib.DataCacheMinReadAheadSize = "0"

diskLib.dataCachePageSize = "4096"

diskLib.maxUnsyncedWrites = "0"

scsi1.present = "TRUE"

scsi1.sharedBus = "physical"

scsi1.virtualDev = "lsilogic"

vmci0.unrestricted = "TRUE"

scsi1:1.SharedBus="Virtual"

scsi1:1.shared="TRUE"

scsi1:1.mode = "independent-persistent"

scsi1:1.present = "TRUE"

scsi1:1.fileName = "rac1\_2.vmdk"

scsi1:1.deviceType = "scsi-hardDisk"

scsi1:2.SharedBus="Virtual"

scsi1:2.shared="TRUE"

scsi1:2.mode = "independent-persistent"

scsi1:2.present = "TRUE"

scsi1:2.fileName = "rac1\_3.vmdk"

scsi1:2.deviceType = "scsi-hardDisk"

Oracle安装用户和组设置

创建用户和组

建立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,dba -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.conf

Oracle:

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

oracle soft stack 10240

Grid:

grid soft nproc 2047

grid hard nproc 16384

grid soft nofile 1024

grid hard nofile 65536

grid soft stack 10240

2、修改/etc/pam.d/login,如果不存在，则创建该文件

session required pam\_limits.so

3、修改default shell startup file

![Image 1][]

For ksh bsh,/etc/profile:   
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   
For CSH,/etc/csh.login:   
if ( $USER = "oracle" | |  $USER = "grid" ) then   
limit maxproc 16384   
limit descriptors 65536   
endif

数据库安装用户grid.profile

![Image 1][].profile文件内容如下：

PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:. :$PATH   
export PATH   
export ORACLE\_BASE=/oracle/app/gridbase   
export ORACLE\_HOME=/oracle/app/grid   
export PATH=$PATH:$ORACLE\_HOME/bin   
set -o vi   
if \[ -s "$MAIL" \]           \# This is at Shell startup.  In normal   
then echo "$MAILMSG"        \# operation, the Shell checks   
fi                          \# periodically.   
umask 022   
GI\_OUI=/home/oracle/soft   
export GI\_OUI

数据库安装用户oracle.profile

![Image 1][]

PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.:$PATH   
export PATH   
export ORACLE\_BASE=/oracle/app/oracle   
export ORACLE\_HOME=/oracle/app/oracle/dbhome   
export PATH=$PATH:$ORACLE\_HOME/bin   
set -o vi   
if \[ -s "$MAIL" \]           \# This is at Shell startup.  In normal   
then echo "$MAILMSG"        \# operation, the Shell checks   
fi                          \# periodically.   
umask 022   
OUI\_HOME=/home/oracle/soft   
export OUI\_HOME

Oracle inventory 目录

![Image 1][]

Grid Infrastructure BASE 目录

![Image 1][]

Grid Infrastructure Home 目录

![Image 1][]

Oracle Base 目录

![Image 1][]

Oracle Rdbms Home 目录

![Image 1][]

ASM配置：

![Image 1][]