修改系统参数

vi /etc/sysctl.conf

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 536870912

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048586

sysctl -p

vi /etc/security/limits.conf

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

vi /etc/pam.d/login

session required pam_limits.so

1.修改主机名和/etc/hosts文件

172.168.56.60 node1

172.168.56.70 node2

10.10.10.60 node1priv

10.10.10.70 node2priv

172.168.56.101 node1vip

172.168.56.201 node2vip

172.168.56.200 nodesanip

2.增加组、用户、目录

groupadd -g 1000 oinstall

groupadd -g 1100 asmadmin

groupadd -g 1200 dba

groupadd -g 1300 asmdba

groupadd -g 1301 asmoper

useradd -u 1100 -g oinstall -G asmadmin,asmdba,asmoper -d /home/grid grid

useradd -u 1101 -g oinstall -G dba,asmdba -d /home/oracle oracle

echo grid | passwd --stdin grid

echo oracle | passwd --stdin oracle

mkdir -p /oracle/app/oraInventory

chown -R grid:oinstall /oracle/app/oraInventory

chmod -R 775 /oracle/app/oraInventory

mkdir -p /oracle/11.2.0/grid

mkdir -p /oracle/app/grid

chown -R grid:oinstall /oracle/app/grid

chown -R grid:oinstall /oracle/11.2.0/grid

chmod -R 775 /oracle/11.2.0/grid

mkdir -p /oracle/app/oracle

mkdir /oracle/app/oracle/cfgtoollogs

chown -R oracle:oinstall /oracle/app/oracle

chmod -R 775 /oracle/app/oracle

mkdir -p /oracle/app/oracle/product/11.2.0/db_1

chown -R oracle:oinstall /oracle/app/oracle/product/11.2.0/db_1

chmod -R 775 /oracle/app/oracle/product/11.2.0/db_1

3.配置环境变量、互信

node1

su - grid

vi .bash_profile

export ORACLE_SID=+ASM1

export ORACLE_BASE=/oracle/app/grid

export ORACLE_HOME=/oracle/11.2.0/grid

export PATH=$ORACLE_HOME/bin:$PATH

node2

su - grid

vi .bash_profile

export ORACLE_SID=+ASM2

export ORACLE_BASE=/oracle/app/grid

export ORACLE_HOME=/oracle/11.2.0/grid

export PATH=$ORACLE_HOME/bin:$PATH

在node1上执行

root用户执行

/oracle/soft/grid/sshsetup/sshUserSetup.sh -user grid -hosts "node1 node2" -advanced -noPromptPassphrase

/oracle/soft/grid/sshsetup/sshUserSetup.sh -user oracle -hosts "node1 node2" -advanced -noPromptPassphrase

rac1&rac2

su - grid

ssh node1 date

ssh node2 date

ssh node1priv date

ssh node2priv date

su - oracle

ssh node1 date

ssh node2 date

ssh node1priv date

ssh node2priv date

4.创建裸设备

node1进行分区

Disk /dev/sdb: 42.9 GB, 42949672960 bytes

255 heads, 63 sectors/track, 5221 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System

/dev/sdb1 1 1217 9775521 83 Linux

/dev/sdb2 1218 2434 9775552+ 83 Linux

/dev/sdb3 2435 5221 22386577+ 83 Linux

node2执行partprobe

在node1，node2上编辑 /etc/udev/rules.d/60-raw.rules 文件

ACTION=="add", KERNEL=="sdb1",RUN+="/bin/raw /dev/raw/raw1 %N"

ACTION=="add", KERNEL=="sdb2",RUN+="/bin/raw /dev/raw/raw2 %N"

ACTION=="add", KERNEL=="sdb3",RUN+="/bin/raw /dev/raw/raw3 %N"

ACTION=="add",KERNEL=="raw[1-3]", OWNER="grid", GROUP="asmadmin", MODE="660"

start_udev

5.进入grid安装

这个错误是scan解析失败，在os中ping一下scanip和scan name如果能ping通的话，那就没问题，直接ok，然后skip

6.用grid用户asmca创建DG

创建一个归档专用的DG并在下面创建一个lv和文件系统

7.安装rdbms软件

修改oracle用户环境变量

export ORACLE_BASE=/oracle/app/oracle

export ORACLE_HOME=/oracle/app/oracle/product/11.2.0/db_1

export PATH=$ORACLE_HOME/bin:$PATH

export ORACLE_SID=orcl1||2

8.dbca创建数据库

ITPub博客

11g RAC for linux ASM 带图

最新文章