11g r2 rac on redhat6.4 环境准备
来源:互联网 发布:c语言实型数据 编辑:程序博客网 时间:2024/03/28 18:08
1:2个节点安装系统并安装好oracle官方网站要求的包和资源限制(所有节点)
grid soft nofile 1024
grid hard nofile 65536
grid soft nproc 2047
grid hard nproc 16384
grid soft stack 10240
grid hard stack 32768
2:配置/etc/hosts 网络(所有节点)
192.168.1.81 rac1
192.168.1.82 rac2
192.168.1.83 rac1-vip
192.168.1.84 rac2-vip
192.168.1.86 rac-cluster rac-cluster-scan
10.10.10.2 rac1-priv
10.10.10.3 rac2-priv
3:创建用户和组(所有节点)
groupadd -g 5000 asmadmin
groupadd -g 5001 asmdba
groupadd -g 5002 asmoper
groupadd -g 6000 oinstall
groupadd -g 6001 dba
groupadd -g 6002 oper
useradd -g oinstall -G asmadmin,asmdba,asmoper grid
useradd -g oinstall -G dba,asmdba oracle
passwd oracle
passwd grid
mkdir /s01 存放oracle软件
mkdir /g01 存放集群软件
chown oracle:oinstall /s01
chown grid:oinstall /g01
4:通过udev配置asm磁盘(所有节点)
for i in b c d e f g;
do
echo "KERNEL==\"sd*\", BUS==\"scsi\", PROGRAM==\"/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/\$name\", RESULT==\"`/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/sd$i`\", NAME=\"asm-disk$i\", OWNER=\"grid\", GROUP=\"asmadmin\", MODE=\"0660\"" >> /etc/udev/rules.d/99-oracle-asmdevices.rules
done
5:配置grid用户环境变量
节点1:
export GRID_HOME=/g01/app/11.2.0/grid
export ORACLE_HOME=/g01/app/11.2.0/grid
export PATH=$GRID_HOME/bin:$GRID_HOME/OPatch:/sbin:/bin:/usr/sbin:/usr/bin
export ORACLE_SID=+ASM1
export LD_LIBRARY_PATH=$GRID_HOME/lib:$GRID_HOME/lib32
export ORACLE_BASE=/g01/app
节点2:
export GRID_HOME=/g01/app/11.2.0/grid
export ORACLE_HOME=/g01/app/11.2.0/grid
export PATH=$GRID_HOME/bin:$GRID_HOME/OPatch:/sbin:/bin:/usr/sbin:/usr/bin
export ORACLE_SID=+ASM2
export LD_LIBRARY_PATH=$GRID_HOME/lib:$GRID_HOME/lib32
export ORACLE_BASE=/g01/app
6:root用户的环境变量(所有节点)
export GRID_HOME=/g01/app/11.2.0/grid
export ORACLE_HOME=/g01/app/11.2.0/grid
export PATH=$GRID_HOME/bin:$GRID_HOME/OPatch:/sbin:/bin:/usr/sbin:/usr/bin
7:oracle用户的环境变量
节点1:
export ORACLE_HOME=/s01/app/oracle/product/11.2.0/dbhome_1
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:/sbin:/bin:/usr/sbin:/usr/bin
export ORACLE_SID=ORCL1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32
export ORACLE_BASE=/s01/app
节点2:
export ORACLE_HOME=/s01/app/oracle/product/11.2.0/dbhome_1
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:/sbin:/bin:/usr/sbin:/usr/bin
export ORACLE_SID=ORCL2
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32
export ORACLE_BASE=/s01/app
8:环境准备好之后先安装grid,然后安装oracle,最后创建数据库。过程中会遇到一些问题,具体问题再具体解决。
grid soft nofile 1024
grid hard nofile 65536
grid soft nproc 2047
grid hard nproc 16384
grid soft stack 10240
grid hard stack 32768
2:配置/etc/hosts 网络(所有节点)
192.168.1.81 rac1
192.168.1.82 rac2
192.168.1.83 rac1-vip
192.168.1.84 rac2-vip
192.168.1.86 rac-cluster rac-cluster-scan
10.10.10.2 rac1-priv
10.10.10.3 rac2-priv
3:创建用户和组(所有节点)
groupadd -g 5000 asmadmin
groupadd -g 5001 asmdba
groupadd -g 5002 asmoper
groupadd -g 6000 oinstall
groupadd -g 6001 dba
groupadd -g 6002 oper
useradd -g oinstall -G asmadmin,asmdba,asmoper grid
useradd -g oinstall -G dba,asmdba oracle
passwd oracle
passwd grid
mkdir /s01 存放oracle软件
mkdir /g01 存放集群软件
chown oracle:oinstall /s01
chown grid:oinstall /g01
4:通过udev配置asm磁盘(所有节点)
for i in b c d e f g;
do
echo "KERNEL==\"sd*\", BUS==\"scsi\", PROGRAM==\"/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/\$name\", RESULT==\"`/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/sd$i`\", NAME=\"asm-disk$i\", OWNER=\"grid\", GROUP=\"asmadmin\", MODE=\"0660\"" >> /etc/udev/rules.d/99-oracle-asmdevices.rules
done
/sbin/start_udev
udev映射asm磁盘具体请参阅:点击打开链接
5:配置grid用户环境变量
节点1:
export GRID_HOME=/g01/app/11.2.0/grid
export ORACLE_HOME=/g01/app/11.2.0/grid
export PATH=$GRID_HOME/bin:$GRID_HOME/OPatch:/sbin:/bin:/usr/sbin:/usr/bin
export ORACLE_SID=+ASM1
export LD_LIBRARY_PATH=$GRID_HOME/lib:$GRID_HOME/lib32
export ORACLE_BASE=/g01/app
节点2:
export GRID_HOME=/g01/app/11.2.0/grid
export ORACLE_HOME=/g01/app/11.2.0/grid
export PATH=$GRID_HOME/bin:$GRID_HOME/OPatch:/sbin:/bin:/usr/sbin:/usr/bin
export ORACLE_SID=+ASM2
export LD_LIBRARY_PATH=$GRID_HOME/lib:$GRID_HOME/lib32
export ORACLE_BASE=/g01/app
6:root用户的环境变量(所有节点)
export GRID_HOME=/g01/app/11.2.0/grid
export ORACLE_HOME=/g01/app/11.2.0/grid
export PATH=$GRID_HOME/bin:$GRID_HOME/OPatch:/sbin:/bin:/usr/sbin:/usr/bin
7:oracle用户的环境变量
节点1:
export ORACLE_HOME=/s01/app/oracle/product/11.2.0/dbhome_1
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:/sbin:/bin:/usr/sbin:/usr/bin
export ORACLE_SID=ORCL1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32
export ORACLE_BASE=/s01/app
节点2:
export ORACLE_HOME=/s01/app/oracle/product/11.2.0/dbhome_1
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:/sbin:/bin:/usr/sbin:/usr/bin
export ORACLE_SID=ORCL2
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32
export ORACLE_BASE=/s01/app
8:环境准备好之后先安装grid,然后安装oracle,最后创建数据库。过程中会遇到一些问题,具体问题再具体解决。
- 11g r2 rac on redhat6.4 环境准备
- Oracle 11g R2+ RAC+ ASM+ OracleLinux6.4安装详解(1)前期准备
- 配置oracle 11g r2 RAC on rhel5.5 (一)
- 10g rac环境准备
- Redhat5.4 11g R2 RAC Deinstall
- Oracle-11g-R2 RAC 环境下 GPnP Profile 文件
- redhat6 + 11G RAC 双节点部署
- Oracle 11g R2 RAC Hands on Training RAC 性能优化
- 《Oracle RAC最佳部署手册 环境Oracle 11G R2 RAC for Linux》pdf
- Oracle 11g R2 RAC with Raw Disk on CentOS5.7_x64 by VMware Server 2.0
- oracle 11g r2 Rac install
- Oracle 11G R2 RAC 添加节点
- Linux 安装11g R2 RAC
- Oracle 11G R2 RAC 添加节点
- 11g R2 RAC修改 SCAN IP
- 11g R2 rac linstener 监听配置
- ORACLE 11G R2 RAC安装总结
- 11G R2 RAC添加删除节点
- FragmentPagerAdapter与FragmentStatePagerAdapter差异
- C++类中拷贝构造函数详解
- Linux C++ 一个线程池的简单实现(附代码)
- 【WA】题目1456:胜利大逃亡[BFS]
- Hadoop系统完全分布式集群搭建方法
- 11g r2 rac on redhat6.4 环境准备
- oracle minus用法和讲解
- 我允许失败,但是我不允许不努力!
- 软件定义无线电 (SDR) 和业余试验
- 威盛/网易笔试准备
- linux中的字符设备与块设备
- 企业 一
- 自动消失对话框
- C++的继承方式