脚本部署oracle

AdmirerShura

已于 2022-11-17 12:18:05 修改

阅读量480

点赞数 1

文章标签： oracle 数据库 dba

于 2022-11-17 12:09:33 首次发布

本文链接：https://blog.csdn.net/qq_69243343/article/details/127896852

版权

6、修改/opt/database/response/dbca.rsp

7、静默dbca建库

8、启动数据库

9、配置开机自动启动监听、启动Oracle

前言

准备oracle11g部署包，放入root目录下即可

1、在root下执行此脚本

#!/usr/bin/env bash
#FROM:admire
#FileName:install oracle：user root
ORACLE_FILE1=linux.x64_11gR2_database_1of2.zip
ORACLE_FILE2=linux.x64_11gR2_database_2of2.zip
HOSTS=`ip a show dev ens33|grep -w inet|awk '{print $2}' |awk -F '/' '{print $1}'`
SRC_DIR=/opt/
COLOR="echo -e \\033[01;31m"
END='\033[0m'
db_FILEDIR=/opt/database/response/db_install.rsp

if [ ! -e /root/${ORACLE_FILE1} ] || [ ! -e /root/${ORACLE_FILE2} ]; then
  ${COLOR}缺少${ORACLE_FILE1}或${ORACLE_FIEL2}请放入离线包，正在退出......${END};exit
else
  ${COLOR}已有${ORACLE_FILE1}和${ORACLE_FILE2}正在部署....${END}
  mv /root/${ORACLE_FILE1} ${ORACLE_FILE2} ${SRC_DIR}
fi


yum -y install binutils compat-libcap1 compat-libstdc++-33 compat-libstdc++-33*i686 compat-libstdc++-33*.devel compat-libstdc++-33 compat-libstdc++-33*.devel gcc gcc-c++ glibc glibc*.i686 glibc-devel glibc-devel*.i686 ksh libaio libaio*.i686 libaio-devel libaio-devel*.devel libgcc libgcc*.i686 libstdc++ libstdc++*.i686 libstdc++-devel libstdc++-devel*.devel libXi libXi*.i686 libXtst libXtst*.i686 make sysstat unixODBC unixODBC*.i686 unixODBC-devel unixODBC-devel*.i686 unzip vim net-tools &> /dev/null

rpm -q binutils compat-libcap1 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel libXi libXtst make sysstat unixODBC unixODBC-devel

sed -i "s/HOSTNAME=localhost.localdomain/HOSTNAME=oracledb/" /etc/sysconfig/network
hostname oracledb

echo "${HOSTS} oracledb" >> /etc/hosts

groupadd -g 200 oinstall
groupadd -g 201 dba
useradd -u 440 -g oinstall -G dba oracle #（主组oinstall，其它组：dba）
echo 123 |passwd oracle --stdin

cat >> /etc/sysctl.conf <<EOF
net.ipv4.ip_local_port_range= 9000 65500
fs.file-max = 6815744
kernel.shmall = 105