fangxing 发表于 2018-4-13 10:20:15

Oracle数据库安装

1.      修改主机名。#hostname db1#vi /e tc/hosts2.      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>&1crontab-l3.使用脚本配置Oracle环境。Oracle_install.sh脚本:#!/bin/bash#变量定义,根据实际情况运行此脚本前定义好。hname=计算机名称ip=Oracle监听ip地址shmmax=总内存*80%shmall=总内存/pagesize#配置主机名sed -i "/HOSTNAME/d" /etc/sysconfig/networksed -i"1a HOSTNAME=$hname" /etc/sysconfig/network#配置hosts文件echo '$ip $hname' >> /etc/hosts#禁用SELinuxsetenforce0 &> /dev/nullsed -i's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config&> /dev/null#禁用防火墙serviceiptables stop &> /dev/nullchkconfigiptables 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/nullyum -ygroupinstall "X Window System" "Desktop" &>/dev/nullgrep Santiago/etc/redhat-release &> /dev/null &&(rpm -eksh --nodeps &> /dev/nullrpm -i support-files/pdksh*.rpm &> /dev/null)#### 2.创建必需的用户、组账号###############################echo "Create Oracle's Groups and User, Directory ..."grepoinstall /etc/group &> /dev/null || groupadd --gid 54321 oinstallgrepdba /etc/group &> /dev/null || groupadd --gid 54322 dbagreporacle /etc/passwd &> /dev/null || useradd -u 54321 -g oinstall -G dba oracleecho "intest" | passwd --stdin oracle &>/dev/null#### 3. 创建数据库安装目录##################################echo "Create Oracle's Directory ..."exportORACLE_BASE=/u01/oracleexportORACLE_DATA=/indataexportORACLE_INVENTORY=/u01/oraInventorymkdir -p $ORACLE_BASEmkdir -p $ORACLE_DATAmkdir -p $ORACLE_INVENTORYmkdir -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_BASEchown -Roracle:oinstall $ORACLE_DATAchown -Roracle:oinstall $ORACLE_INVENTORYchmod -R 775 $ORACLE_BASEchmod -R 775 $ORACLE_DATAchmod -R 775 $ORACLE_INVENTORY#### 4. 调整内核运行参数####################################echo "Configure Kernel Parameters ..."echo '#Virtual Memoryvm.swappiness = 0vm.dirty_background_ratio = 3vm.dirty_ratio = 80vm.dirty_expire_centisecs = 500vm.dirty_writeback_centisecs = 100#Shared Memory#kernel.shmmax = $shmmaxkernel.shmall= $shmallkernel.shmmni = 4096# Semaphoreskernel.sem = 250 32000 100 128# Network Portsnet.ipv4.ip_local_port_range = 9000 65500# Network Settingsnet.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576#synchronous I/Ofs.aio-max-nr = 1048576# File Handlesfs.file-max= 6815744' >> /etc/sysctl.confsysctl-p &> /dev/null#### 5. 调整用户会话限制####################################echo "Configure Shell Parameters ..."greporacle /etc/security/limits.d/99-oracle-limits.conf &>/dev/null || echo 'oraclesoft nproc 2047oraclehard nproc 16384oraclesoft nofile 1024oraclehard nofile 65536oraclesoft stack 10240oraclehard 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; thenechonever > /sys/kernel/mm/redhat_transparent_hugepage/enabledfi' >> /etc/rc.local#### 7. 配置Oracle用户环境##################################echo "Configure User's Enviroment ..."greporacle /etc/profile.d/oracle.sh &> /dev/null || echo 'if [ $USER= "oracle" ]; thenif [ $SHELL= "/bin/ksh" ]; thenulimit-u 16384ulimit-n 65536elseulimit-u 16384 -n 65536fifi' >> /etc/profile.d/oracle.shgrepORACLE ~oracle/.bash_profile &> /dev/null || echo '#Setting theappropriate ulimits fororacle user#environment for oracleumask 022exportORACLE_BASE=/u01/oracleexportORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1exportORACLE_SID=neyexportLANG=en_US.UTF-8exportNLS_LANG=AMERICAN_AMERICA.UTF8export PATH=$ORACLE_HOME/bin:$PATHexportLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$ORACLE_HOME/rdbms/libexportCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlibumask 022alias ney=“exportORACLE_SID=ney”alias nek=“exportORACLE_SID=nek”stty erase^hexportDISPLAY=:0.0' >> ~oracle/.bash_profilereboot#### 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即可。

zhangxiajun 发表于 2018-4-16 09:16:02

谢谢楼主分享

kouku 发表于 2018-5-10 09:52:02

感谢无偿的分享。

成冠邱雄 发表于 2018-5-10 14:27:52

感谢无私奉献

linux菜鸟 发表于 2018-6-12 08:28:33

没金币。。

fangxing 发表于 2018-12-27 12:10:30

linux菜鸟 发表于 2018-6-12 08:28
没金币。。

不需要金币
页: [1]
查看完整版本: Oracle数据库安装