Oracle数据库安装

fangxing

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即可。

zhangxiajun

谢谢楼主分享

kouku

感谢无偿的分享。

成冠邱雄

感谢无私奉献

linux菜鸟

没金币。。

fangxing

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

不需要金币