Oracle 11g R2 RAC 前置条件相关脚本
来源:互联网 发布:吴碧霞 知乎 编辑:程序博客网 时间:2024/05/18 00:01
安装系统包
#!/bin/bash
#配置yum本地源
cat >> /etc/yum.repos.d/source.repo << EOF
[Server]
baseurl=file:///mnt/Server
enabled=1
gpgcheck=0
EOF
echo "starting installing required packages"
yum -y install binutils-*
yum -y install compat-libstdc++-*
yum -y install compat-libstdc++-*
yum -y install elfutils-libelf-*
yum -y install elfutils-libelf-devel-*
yum -y install gcc-*
yum -y install gcc-c++-*
yum -y install glibc-*
yum -y install glibc-*
yum -y install glibc-common-*
yum -y install glibc-devel-*
yum -y install glibc-devel-*
yum -y install glibc-headers-*
yum -y install ksh-*
yum -y install libaio-*
yum -y install libaio-*
yum -y install libaio-devel-*
yum -y install libaio-devel-*
yum -y install libgcc-*
yum -y install libgcc-*
yum -y install libstdc++-*
yum -y install libstdc++-*
yum -y install libstdc++-devel*
yum -y install make-*
yum -y install sysstat-*
yum -y install unixODBC-*
创建用户和组
#!/bin/bash
groupadd oinstall
groupadd dba
groupadd oper
groupadd asmadmin
groupadd asmdba
groupadd asmoper
useradd -g oinstall -G dba,asmdba,asmadmin,asmoper grid
useradd -g oinstall -G dba,oper,asmdba oracle
echo -n oracle|passwd --stdin grid
echo -n oracle|passwd --stdin oracle
mkdir -p /u01/app/11.2.0/grid
mkdir -p /u01/app/grid
mkdir -p /u01/app/oracle
chown grid:oinstall /u01/app/11.2.0/grid
chown grid:oinstall /u01/app/grid
chown -R oracle:oinstall /u01/app/oracle
chmod -R 775 /u01/
chown -R grid:oinstall /u01
修改系统内核参数
#!/bin/bash
sed -i 's/kernel.shmmax/#kernel.shmmax/g' /etc/sysctl.conf
sed -i 's/kernel.shmall/#kernel.shmall/g' /etc/sysctl.conf
cat >> /etc/sysctl.conf << EOF
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 1073741824
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
EOF
cat >> /etc/security/limits.conf << EX
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
grid soft stack 10240
EX
修改profile
#!/bin/bash
cat >> /etc/profile << EOF
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
#############################
export PATH=\$PATH:/u01/app/11.2.0/grid/bin
#color of grep
alias grep='grep --color=auto'
EOF
# grid
cat >> /home/grid/.bash_profile <<EOF
export TMP=/tmp;
export TMPDIR=\$TMP;
export ORACLE_HOSTNAME=rac1;
export ORACLE_SID=+ASM1;
export ORACLE_BASE=/u01/app/grid;
export ORACLE_HOME=/u01/app/11.2.0/grid;
export NLS_DATE_FORMAT="yy-mm-dd HH24:MI:SS";
export PATH=\$ORACLE_HOME/bin:\$PATH;
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;
EOF
# oracle
cat >> /home/oracle/.bash_profile <<EX
export TMP=/tmp;
export TMPDIR=\$TMP;
export ORACLE_HOSTNAME=rac1;
export ORACLE_BASE=/u01/app/oracle;
export ORACLE_HOME=\$ORACLE_BASE/product/11.2.0/db_1;
export ORACLE_UNQNAME=prod;
export ORACLE_SID=prod1;
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:\$ORACLE_HOME/jlib:\$ORACLE_HOME/rdbms/jlib;
export NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS";
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;
EX
- Oracle 11g R2 RAC 前置条件相关脚本
- Oracle 11g R2 RAC 前置条件相关脚本
- ORACLE 11G RAC R2 TAF 测试脚本
- ORACLE 11G RAC R2 TAF 测试脚本
- Oracle 11g R2 RAC RMAN备份脚本示例
- oracle 11g r2 Rac install
- Oracle 11G R2 RAC 添加节点
- Oracle 11G R2 RAC 添加节点
- ORACLE 11G R2 RAC安装总结
- Oracle 11G r2 Rac修改IP
- oracle 11g R2 RAC检查
- Oracle 11g R2 RAC安装
- 卸载Oracle 11g R2 RAC
- Oracle 11g R2 RAC 卸载 grid
- Oracle 11G R2 RAC 修改public网络IP
- Linux + Oracle 11g R2 RAC 安装配置详细过程
- Linux + Oracle 11g R2 RAC 安装配置详细过程
- Oracle 11g R2 RAC数据库中文乱码解决
- 工厂模式(C/C++实现理解)
- leetcode - Rotate Image
- 2014 android google 更新 不能访问
- 声飘伞下
- 北京市基本医疗保险A类定点医疗机构
- Oracle 11g R2 RAC 前置条件相关脚本
- python机器学习之adaboost元算法
- Qt浅谈之三:内置标准对话框
- javascript 实现datagrid
- 电脑管家版WiFi共享精灵简介
- VCC AVCC VDD AVDD区别
- Qt编程7:Qt定时器 QTimer使用
- TeamViewer一个很好的免费远程控制软件
- 数据库触发器详解