Oracle Exadata Virtual Machine 11.2.3.3.1

Cell Node

软件包下载

可到 Oracle Software Delivery Cloud 下载 V46145-01.zip，V27570-01.zip。
V46145-01.zip 为 Exadata Cell 11.2.3.2 介质。
V27570-01.zip 为 OracleLinux-R5-U7-Server-x86_64-dvd.iso。
Oracle 安装包：p10404530_112030_Linux-x86-64_1of7.zip; p10404530_112030_Linux-x86-64_2of7.zip。
Grid 安装包：p10404530_112030_Linux-x86-64_3of7.zip。

配置 hosts，修改启动内核

echo "192.168.184.160 oradb01" >>/etc/hosts
echo "192.168.184.170 oracell01" >>/etc/hosts

sed -i 's/^default=.*/default=1/' /etc/grub.conf
reboot

修改资源限制

echo "fs.file-max = 65536" >>/etc/sysctl.conf
sysctl -p

cat >>/etc/security/limits.conf <<EOF
* soft nofile 65536
* hard nofile 65536
EOF

安装 oracle-vaildated
yum install -y oracle-validated

创建日志文件夹

mkdir -p /var/log/oracle
chmod -R 775 /var/log/oracle

安装 Cell 软件

unzip V46145-01.zip
tar -xvf cellImageMaker_11.2.3.3.1_LINUX.X64_140708-1.x86_64.tar
cd dl180/boot/cellbits

tar -xvf cellrpms.tbz jdk-1.7.0_55-fcs.x86_64.rpm
rpm -ivh jdk-1.7.0_55-fcs.x86_64.rpm

unzip cell.bin
rpm -ivh cell-11.2.3.3.1_LINUX.X64_140708-1.x86_64.rpm

创建虚拟磁盘

mkdir -p /opt/oracle/cell/disks/raw
cat >/tmp/disk.sh <<EOF
dd if=/dev/zero of=/opt/oracle/cell/disks/raw/disk01 bs=1M count=5120
dd if=/dev/zero of=/opt/oracle/cell/disks/raw/disk02 bs=1M count=5120
dd if=/dev/zero of=/opt/oracle/cell/disks/raw/disk03 bs=1M count=5120
dd if=/dev/zero of=/opt/oracle/cell/disks/raw/disk04 bs=1M count=5120
dd if=/dev/zero of=/opt/oracle/cell/disks/raw/disk05 bs=1M count=5120
dd if=/dev/zero of=/opt/oracle/cell/disks/raw/disk06 bs=1M count=5120
dd if=/dev/zero of=/opt/oracle/cell/disks/raw/disk07 bs=1M count=5120
dd if=/dev/zero of=/opt/oracle/cell/disks/raw/disk08 bs=1M count=5120
dd if=/dev/zero of=/opt/oracle/cell/disks/raw/disk09 bs=1M count=5120
dd if=/dev/zero of=/opt/oracle/cell/disks/raw/disk10 bs=1M count=5120
dd if=/dev/zero of=/opt/oracle/cell/disks/raw/disk11 bs=1M count=5120
dd if=/dev/zero of=/opt/oracle/cell/disks/raw/disk12 bs=1M count=5120
dd if=/dev/zero of=/opt/oracle/cell/disks/raw/FLASH01 bs=1M count=1024
dd if=/dev/zero of=/opt/oracle/cell/disks/raw/FLASH02 bs=1M count=1024
dd if=/dev/zero of=/opt/oracle/cell/disks/raw/FLASH03 bs=1M count=1024
dd if=/dev/zero of=/opt/oracle/cell/disks/raw/FLASH04 bs=1M count=1024
EOF

sh /tmp/disk.sh
chmod 660 /opt/oracle/cell/disks/raw/*

启动 cell 服务

su - celladmin
cellcli -e create cell cell01 interconnect1=eth0
cellcli -e alter cell restart services all

创建磁盘

cellcli -e create celldisk all
cellcli -e create flashcache all size=2G
cellcli -e create flashlog all
cellcli -e create griddisk all harddisk prefix=data,size=4G
cellcli -e create griddisk all harddisk prefix=reco
cellcli -e list griddisk

DB Node

创建 Exadata 配置文件

mkdir -p /etc/oracle/cell/network-config
echo "ipaddress1=192.168.184.160/24" >/etc/oracle/cell/network-config/cellinit.ora
echo "cell=\"192.168.184.170\"" >/etc/oracle/cell/network-config/cellip.ora
chown -R grid:oinstall /etc/oracle/cell/network-config
chmod -R 775 /etc/oracle/cell/network-config

安装完 Grid 后，创建磁盘组

alter system set asm_diskstring='o/192.168.184.*/*' scope=both sid='*';

CREATE DISKGROUP DATA NORMAL REDUNDANCY
FAILGROUP CELL01_DATA_F1 DISK
'o/192.168.184.170/data_CD_disk01_cell01',
'o/192.168.184.170/data_CD_disk02_cell01',
'o/192.168.184.170/data_CD_disk03_cell01',
'o/192.168.184.170/data_CD_disk04_cell01',
'o/192.168.184.170/data_CD_disk05_cell01',
'o/192.168.184.170/data_CD_disk06_cell01'
FAILGROUP CELL01_DATA_F2 DISK
'o/192.168.184.170/data_CD_disk07_cell01',
'o/192.168.184.170/data_CD_disk08_cell01',
'o/192.168.184.170/data_CD_disk09_cell01',
'o/192.168.184.170/data_CD_disk10_cell01',
'o/192.168.184.170/data_CD_disk11_cell01',
'o/192.168.184.170/data_CD_disk12_cell01'
ATTRIBUTE 'compatible.asm'='11.2.0.0.0','compatible.rdbms'='11.1.0.7.0','au_size'='4M','cell.smart_scan_capable'='TRUE';