-
应用数据库集群搭建
主机资源
设备用途
10.140.16.142
10.140.16.143
主机名
心跳
IP
192.168.1.60
需求
用途
专项应用库
搭建
oracle
rac
;
(征信、自助
取数等)
192.168.1.60/30
第二组
rac
(配置一)
BQJ-219-B11-IBMX480-Node2
192.168.1.61
BQJ-219-B12-IBMX480-Node2
192.168.1.62
1
、
创建用户和组
groupadd
-g 1000 oinstall
groupadd -g 1200
asmadmin
groupadd -g 1201 asmdba
groupadd -g 1202 asmoper
useradd -m -u 1100 -g oinstall -G
asmadmin,asmdba,asmoper -d /home/grid -s /bin/bash
-c
echo
groupadd
-g 1300 dba
groupadd -g 1301 oper
useradd -m -u 1101 -g oinstall -G
dba,oper,asmdba -d /home/oracle -s /bin/bash -c
echo
2
、
共享存储分区
查看共享磁盘多路径编号是否对等
/sbin/scsi_id --whitelisted --replace-
whitespace --device=/dev/sddlmaa
[root@BQJ-219-C16-IBM-X3850-018 home]#
fdisk -cu /dev/sddlmaa
Command (m for
help): p
Disk /dev/sddlmaa: 1008.7 GB,
1 bytes
255 heads, 63 sectors/track,
122632 cylinders, total 1970087936 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512
bytes / 512 bytes
I/O size
(minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x7411111e
Device Boot
Start
End
Blocks
Id
System
/dev/sddlmaa1
2048
41945087
20971520
83
Linux
/dev/sddlmaa2
41945088
1970087935
964071424
83
Linux
[root@BQJ-219-C16-IBM-X3850-018 home]#
fdisk -cu /dev/sddlmab
Command (m for
help): p
Disk /dev/sddlmab: 1008.7 GB,
1 bytes
255 heads, 63 sectors/track,
122632 cylinders, total 1970087936 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size
(logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes /
512 bytes
Disk identifier: 0x7411111e
Device Boot
Start
End
Blocks
Id
System
/dev/sddlmab1
2048
41945087
20971520
83
Linux
/dev/sddlmab2
41945088
1970087935
964071424
83
Linux
[root@BQJ-219-C16-IBM-X3850-018 home]#
fdisk -cu /dev/sddlmac
Command (m for
help): p
Disk /dev/sddlmac: 1008.7 GB,
1 bytes
255 heads, 63 sectors/track,
122632 cylinders, total 1970087936 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512
bytes / 512 bytes
I/O size
(minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x7411111e
Device Boot
Start
End
Blocks
Id
System
/dev/sddlmac1
2048
41945087
20971520
83
Linux
/dev/sddlmac2
41945088
1970087935
964071424
83
Linux
3
、
做裸设备映射
# vi
/etc/udev/rules.d/
ACTION==
A
CTION==
ACTION==
ACTION==
ACTION==
ACTION==
ACTION
==
ACTION==
ACTION==
ACTION==
ACTION==
ACTION==
ACTION==
ACTION==
ACTI
ON==
ACTION==
[root@BQJ-219-C1
7-IBM-X3850-024 home]# start_udev
正在启动
udev:
[
确定
]
Vi
/etc/
raw /dev/raw/raw1
/dev/sddlmaa1
raw /dev/raw/raw2
/dev/sddlmab1
raw /dev/raw/raw3
/dev/sddlmac1
raw /dev/raw/raw4
/dev/sddlmaa2
raw /dev/raw/raw5
/dev/sddlmab2
raw /dev/raw/raw6
/dev/sddlmac2
raw /dev/raw/raw7
/dev/sddlmad
raw /dev/raw/raw8
/dev/sddlmae
[root@BQJ-219-C17-IBM-X3850-024 home]#
raw -qa
/dev/raw/raw1:
bound
to major 251, minor 1
/dev/raw/raw2:
bound to major 251, minor 17
/dev/raw/raw3:
bound to
major 251, minor 33
/dev/raw/raw4:
bound to major 251, minor 2
/dev/raw/raw5:
bound to
major 251, minor 18
/dev/raw/raw6:
bound to major 251, minor 34
/dev/raw/raw7:
bound to
major 251, minor 48
/dev/raw/raw8:
bound to major 251, minor 64
4
、
建安装目录
mkdir -p
/home/app/app/grid
mkdir -p
/home/app/app/11.2.0/grid
chown -R
grid:oinstall /home/app
mkdir -p
/home/app/app/oracle
chown
oracle:oinstall /home/app/app/oracle
chmod -R 775 /home/app
5
、
用户环境变量设置
Oracle
环境变量
export TMP=/tmp
export
TMPDIR=$$TMP
export ORACLE_SID=pc0app1
export ORACLE_BASE=/home/app/app/oracle
export
ORACLE_HOME=$$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_UNQNAME=pc0app
export
TNS_ADMIN=$$ORACLE_HOME/network/admin
export ORACLE_TERM=xterm
export PATH=/usr/sbin:$$PATH
export PATH=$$ORACLE_HOME/bin:$$PATH
export
LD_LIBRARY_PATH=$$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$$ORACLE_HOME/JRE:$$ORAC
LE_HOME/jlib:$$ORACLE_HOME/rdbms/jlib
export EDITOR=vi
export
LANG=en_US
#export
NLS_LANG=american_32UTF8
export
NLS_DATE_FORMAT='yyyy/mm/dd hh24:mi:ss'
umask 022
alias
sql='rlwrap sqlplus'
alias
sqlplus='rlwrap sqlplus'
alias
lsnrctl='rlwrap lsnrctl'
alias
rman='rlwrap rman'
Grid
环境变量
export PATH
export TMP=/tmp
export TMPDIR=$$TMP
export
ORACLE_SID=+ASM1
export
ORACLE_BASE=/home/app/app/grid
export
ORACLE_HOME=/home/app/app/11.2.0/grid
export ORACLE_TERM=xterm
export NLS_DATE_FORMAT='yyyy/mm/dd
hh24:mi:ss'
export
TNS_ADMIN=$$ORACLE_HOME/network/admin
export PATH=/usr/sbin:$$PATH
export PATH=$$ORACLE_HOME/bin:$$PATH
export
LD_LIBRARY_PATH=$$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$$ORACLE_HOME/JRE:$$ORAC
LE_HOME/jlib:$$ORACLE_HOME/rdbms/jlib
export EDITOR=vi
export
LANG=en_US
#export
NLS_LANG=american_32UTF8
umask 022
alias
sql='rlwrap sqlplus'
alias
sqlplus='rlwrap sqlplus'
alias
lsnrctl='rlwrap lsnrctl'
alias
rman='rlwrap rman'
6
< br>、配置
/etc/hosts
文件
#public ip address
10.140.16.142 BQJ-219-B11-IBMX480-Node2
10.140.16.143 BQJ-219-B12-IBMX480-Node2
#private ip address
192.168.1.61
BQJ-219-B11-IBMX480-Node2-priv
192.168.1.62
BQJ-219-B12-IBMX480-Node2-priv
#virtual ip address
10.140.16.144
BQJ-219-B11-IBMX480-Node2-vip
10.140.16.145
BQJ-219-B12-IBMX480-Node2-vip
#scanip address
10.140.16.146
scanip
7
、配置内核参数
#vi /etc/security/
oracle
soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
grid soft nproc 2047
grid
hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
#vi
/etc/
= 85899345920
= 4096
= 250 32000 100 128
-max =
6815744
_local_port_range = 9000 65500
_default = 262144
_default =
262144
_max = 4194304
_max =
1048576
-max-nr = 1048576
#sysctl
–
p
#mv /etc/
/etc/
8
、安装插件包
#rpm -ih
#rpm -ih 6.x86_
# yum -y install compat-lib*
## yum -y install libaio-devel
#rpm -ih
cd
/home/app/grid/rpm
#
切换到
g
rid
解压目录下的
rpm
下
在使用
vmware
虚拟机(
7.0
)
RedHat Li
nux6.1
环境下使用
ASM
配置<
/p>
Oracle Database 11g release
2
(11.2.0.2 64-bit) RAC
rpm -ih
9
、解压软件
授权
oracle
可以解压软件,把软件解压到某个目录下如
:
/home/media/
unzip
p13390677_112040_Linux-x86-64_
unzip
p13390677_112040_Linux-x86-64_
unzip
p13390677_112040_Linux-x86-64_
10
、安装
grid
#cd/home/media/grid
#./runInstaller
Swap size
问题解决如下:根据实际情况使交换分区容量达到期望值以上
#dd if=/dev/zero of=/home/.swapfile
bs=1024M count=16
# mkswap /home/.swapfile
#/sbin/swapon /home/.swapfile
cvuqdisk-1.0.9-1
问题解决
#cd grid/rpm
# rpm -ih
Device Checks for
ASM
问题可以忽略
Task
Integrity
问题可以忽略
11
、新建
ASM
磁盘组
#su
–
grid
#asmca