1. 修改主机名。 #hostname db1 #vi /e tc/hosts 2. NTP配置 # yum install ntp –y #service ntpd stop #chkconfig ntpd off #/usr/sbin/ntpdatepool.ntp.org #crontab –e */5 * * * * /usr/sbin/ntpdate pool.ntp.org > /dev/null 2>&1 crontab-l 3. 使用脚本配置Oracle环境。 Oracle_install.sh脚本: #!/bin/bash #变量定义,根据实际情况运行此脚本前定义好。 hname=计算机名称 ip=Oracle监听ip地址 shmmax=总内存*80% shmall=总内存/pagesize #配置主机名 sed -i "/HOSTNAME/d" /etc/sysconfig/network sed -i"1a HOSTNAME=$hname" /etc/sysconfig/network #配置hosts文件 echo '$ip $hname' >> /etc/hosts #禁用SELinux setenforce0 &> /dev/null sed -i's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config&> /dev/null #禁用防火墙 serviceiptables stop &> /dev/null chkconfigiptables off &> /dev/null #### 1. 确认已安装必备的软件包############################## echo "Install Required RPM Packages ..." yum -y install binutils compat-libstdc++-33 compat-libstdc++-33.i686 elfutils-libelf elfutils-libelf-devel gcc gcc-c++glibc glibc.i686 glibc-common glibc-devel glibc-devel.i686 glibc-headers libaio libaio.i686 libaio-devellibaio-devel.i686 libgcc libgcc.i686 libstdc++ libstdc++.i686 libstdc++-develmake sysstat unixODBC unixODBC-devel &>/dev/null yum -ygroupinstall "X Window System" "Desktop" &>/dev/null grep Santiago/etc/redhat-release &> /dev/null &&( rpm -eksh --nodeps &> /dev/null rpm -i support-files/pdksh*.rpm &> /dev/null ) #### 2.创建必需的用户、组账号############################### echo "Create Oracle's Groups and User, Directory ..." grepoinstall /etc/group &> /dev/null || groupadd --gid 54321 oinstall grepdba /etc/group &> /dev/null || groupadd --gid 54322 dba greporacle /etc/passwd &> /dev/null || useradd -u 54321 -g oinstall -G dba oracle echo "intest" | passwd --stdin oracle &>/dev/null #### 3. 创建数据库安装目录################################## echo "Create Oracle's Directory ..." exportORACLE_BASE=/u01/oracle exportORACLE_DATA=/indata exportORACLE_INVENTORY=/u01/oraInventory mkdir -p $ORACLE_BASE mkdir -p $ORACLE_DATA mkdir -p $ORACLE_INVENTORY mkdir -p $ORACLE_DATA/{NEY,NEK,backup,dump,scripts} mkdir -p $ORACLE_DATA/NEY/{arch,controlfile,datafile,onlinelog} mkdir -p $ORACLE_DATA/NEK/{arch,controlfile,datafile,onlinelog} mkdir -p $ORACLE_DATA/backup/{ney,nek} mkdir -p $ORACLE_DATA/dump/{ney,nek} mkdir -p $ORACLE_DATA/scripts/{ney,nek} chown -Roracle:oinstall $ORACLE_BASE chown -Roracle:oinstall $ORACLE_DATA chown -Roracle:oinstall $ORACLE_INVENTORY chmod -R 775 $ORACLE_BASE chmod -R 775 $ORACLE_DATA chmod -R 775 $ORACLE_INVENTORY #### 4. 调整内核运行参数#################################### echo "Configure Kernel Parameters ..." echo ' #Virtual Memory vm.swappiness = 0 vm.dirty_background_ratio = 3 vm.dirty_ratio = 80 vm.dirty_expire_centisecs = 500 vm.dirty_writeback_centisecs = 100 #Shared Memory #kernel.shmmax = $shmmax kernel.shmall= $shmall kernel.shmmni = 4096 # Semaphores kernel.sem = 250 32000 100 128 # Network Ports net.ipv4.ip_local_port_range = 9000 65500 # Network Settings net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 #synchronous I/O fs.aio-max-nr = 1048576 # File Handles fs.file-max= 6815744' >> /etc/sysctl.conf sysctl-p &> /dev/null #### 5. 调整用户会话限制#################################### echo "Configure Shell Parameters ..." greporacle /etc/security/limits.d/99-oracle-limits.conf &>/dev/null || echo ' oraclesoft nproc 2047 oraclehard nproc 16384 oraclesoft nofile 1024 oraclehard nofile 65536 oraclesoft stack 10240 oraclehard stack 32768' >> /etc/security/limits.d/99-oracle-limits.conf #greppam_limits.so /etc/pam.d/login &> /dev/null ||echo 'session required pam_limits.so' >> /etc/pam.d/login #### 6.禁用hugepage#################################### echo "disable hugepage ..." echo 'if test -f /sys/kernel/mm/redhat_transparent_hugepage/enabled; then echonever > /sys/kernel/mm/redhat_transparent_hugepage/enabled fi' >> /etc/rc.local #### 7. 配置Oracle用户环境################################## echo "Configure User's Enviroment ..." greporacle /etc/profile.d/oracle.sh &> /dev/null || echo ' if [ $USER= "oracle" ]; then if [ $SHELL= "/bin/ksh" ]; then ulimit-u 16384 ulimit-n 65536 else ulimit-u 16384 -n 65536 fi fi' >> /etc/profile.d/oracle.sh grepORACLE ~oracle/.bash_profile &> /dev/null || echo '#Setting theappropriate ulimits fororacle user #environment for oracle umask 022 exportORACLE_BASE=/u01/oracle exportORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1 exportORACLE_SID=ney exportLANG=en_US.UTF-8 exportNLS_LANG=AMERICAN_AMERICA.UTF8 export PATH=$ORACLE_HOME/bin:$PATH exportLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$ORACLE_HOME/rdbms/lib exportCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib umask 022 alias ney=“exportORACLE_SID=ney” alias nek=“exportORACLE_SID=nek” stty erase^h exportDISPLAY=:0.0' >> ~oracle/.bash_profile reboot #### END #################################################### 4. 安装数据库 说明:如果是远程安装,如要借助xmanager工具。 4-1、首先安装xterm
yum -y install xterm
4-2、Oracle数据库服务器设置变量:export DISPLAY=local_ip:0.0
4-3、xmanager中打开xstart,配置如下图: 点击右箭头选择选择“3 xterm(Linux:Type 2)”。
4、点击运行按钮正常的话会弹出一个shell窗口,在此窗口安装Oracle即可。
|