oracle数据库安装脚本整合,oracle数据库安装预环境一键处理脚本

#!/bin/bash

#添加装置Oracle所需的用户和组

groupadd oinstall

groupadd dba

useradd -g oinstall -G dba -d /home/oracle -m oracle

#树立装置Oracle所需的目录

mkdir -p /u01/app/oracle/product/10.2.0/db_1

chmod -R 775 /u01

chown -R oracle:oinstall /u01

#改动Oracle参数

echo "kernel.shmmni = 4096" >> /etc/sysctl.conf

echo "kernel.sem = 250 32000 100 128" >> /etc/sysctl.conf

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

echo "net.ipv4.ip_local_port_range = 1024 65000" >> /etc/sysctl.conf

echo "net.core.rmem_default=262144" >> /etc/sysctl.conf

echo "net.core.rmem_max=262144" >> /etc/sysctl.conf

echo "net.core.wmem_default=262144" >> /etc/sysctl.conf

echo "net.core.wmem_max=262144" >> /etc/sysctl.conf

/sbin/sysctl -p

#配置Oracle环境变量

echo "ORACLE_BASE=/u01/app/oracle" >> /home/oracle/.bash_profile

echo "ORACLE_HOME=\$ORACLE_BASE/product/10.2.0/db_1" >> /home/oracle/.bash_profile

echo "ORACLE_SID=cmtest" >> /home/oracle/.bash_profile

echo "PATH=\$PATH:\$HOME/bin:\$ORACLE_HOME/bin" >> /home/oracle/.bash_profile

echo "LD_LIBRARY_PATH=\$ORACLE_HOME/lib:/usr/lib" >> /home/oracle/.bash_profile