#!/bin/sh
## Desc: This script is installed successful on CentOS6.8&6.10
## After installation on CentOS7.2 CentOS7.4, database running is ok, but EM start fails.
## give "EM agent is not running", Connot manage db on web interface.
## Auth: henry.he<75598595@qq.com>
## Date: 2020.4.20
## [Official document library]https://docs.oracle.com/cd/E11882_01/nav/portal_11.htm
datadir=/datas
if [ -e $datadir ]
then
echo "The default installation directory for oracle[$datadir] already exists. Please specify a new installation directory to continue!"
read -p "Please input installation directory for oracle[Ex: /datas]: " datadir
fi
mkdir $datadir && chmod 777 $datadir
echo "The installation directory for oracle is: $datadir"
read -p "Press Enter to continue ..."
read -p "please enter the password you want to set for SYS,SYSMAN,SYSTEM&DBSNMP[at least 8 characters with digits, upper and lower case letters]:" all_user_password
read -p "Please input oracle server SID[ex: orcl11g]: " osid
# Install some basic tools
echo -e "\ninstall vim && wget ..."
yum -y install vim wget
echo "Make sure the installation file[linux_oracle_xxx.zip] has been unzipped to the '/home' directory"
echo "check ls -l /home : "
ls -l /home
read -p "Press Enter to continue ..."
# Install the system environment pretreatment tool
echo -e "\nThe current version of system kernel is:`cat /etc/redhat-release`"
kv=`cat /proc/version|awk '{print $3}'`
if [[ "$kv" =~ "el6" ]]
then
# CentOS 6
echo "download oracle repos for CentOS 6 ..."
wget http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6 -O /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
wget http://yum.oracle.com/public-yum-ol6.repo -O /etc/yum.repos.d/public-yum-ol6.repo
elif [[ "$kv" =~ "el7" ]]
then
# CentOS 7
echo "download oracle repos for CentOS 7 ..."
wget http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol7 -O /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
wget http://yum.oracle.com/public-yum-ol7.repo -O /etc/yum.repos.d/public-yum-ol7.repo
else
echo "No matching system kernel version, the program quit!"
exit 1
fi
echo -e "\nInstall the pretreatment tool for system environment ..."
#yum list |grep oracle-rdbms-server
yum install -y oracle-rdbms-server-11gR2-preinstall
#read -p "Press Enter to continue ..."
# Install dependent software
echo -e "\ninstall some relational soft ..."
yum -y install binutils compat-libstdc++-33 \
elfutils-libelf elfutils-libelf-devel libXext libXext-devel\
expat gcc gcc-c++ glibc glibc-common glibc-devel \
glibc-headers libaio libaio-devel libgcc libstdc++ \
libstdc++-devel make pdksh sysstat unixODBC unixODBC-devel
echo -e "\ninstall relate i386 & i686 soft ..."
yum install -y libXext.i686 libXext-devel.i686 libaio.i686 glibc.i686 compat-libstdc++.i686 libaio-devel.i686 libgcc.i686 libstdc++.i686 unixODBC.i686 unixODBC-devel.i686
echo -e "\ninstall pdksh ..."
wget -O /tmp/pdksh-5.2.14-37.el5_8.1.x86_64.rpm http://vault.centos.org/5.11/os/x86_64/CentOS/pdksh-5.2.14-37.el5_8.1.x86_64.rpm
rpm -ivh /tmp/pdksh-5.2.14-37.el5_8.1.x86_64.rpm
if [ $? -ne 0 ]
then
echo "pdksh install Failed, check if pdksh conflicts with ksh."
rpm -e --nodeps ksh-20120801*
rpm -ivh /tmp/pdksh-5.2.14-37.el5_8.1.x86_64.rpm
fi
#read -p "Press Enter to continue ..."
echo 'set oracle default password "oracle#321"'
echo "oracle#321" | passwd oracle --stdin
echo -e "\nupdate hosts file,choose Eth0 default ..."
localip=`ip a | grep eth0 | grep inet |awk '{print $2}'|cut -d / -f 1`
echo "$localip $HOSTNAME" >> /etc/hosts
ping -c 3 $HOSTNAME
#read -p "Press Enter to continue ..."
echo "session required /lib64/security/pam_limits.so
session required pam_limits.so" >> /etc/pam.d/login
echo '
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi' >> /etc/profile
sed -i 's/TMOUT/#TMOUT/1' /etc/profile
echo 'TMOUT=1800' >> /etc/profile
source /etc/profile
# Create the oracle installation directory
echo -e "\n\ncreate oracle some filesystem dirs ..."
mkdir -p /$datadir/oracle/product/11.2.0/db_1
mkdir /$datadir/oracle/oradata
mkdir /$datadir/oracle/inventory
mkdir /$datadir/oracle/fast_recovery_area
chown -R oracle:oinstall /$datadir/oracle
chmod -R 775 /$datadir/oracle
echo
echo "define oracle user's env ..."
cat >/home/oracle/.bashrc<<EOF
# .bashrc
# Source global definitions
if [ -f /etc/bashrc ]; then
. /etc/bashrc
fi
# Uncomment the following line if you don't like systemctl's auto-paging feature:
# export SYSTEMD_PAGER=
alias sql='sqlplus / as sysdba'
alias dbn='cd $ORACLE_HOME/network/admin'
# User specific aliases and functions
umask 022
export TZ=Asia/Shanghai
export ORACLE_HOSTNAME=$HOSTNAME
export ORACLE_BASE=$datadir/oracle
export ORACLE_SID=$osid
#export ORACLE_UNQNAME=$osid
export ORACLE_HOME=$datadir/oracle/product/11.2.0/db_1
export ORACLE_OWNER=oracle
PATH=.:\$ORACLE_HOME/bin:\$PATH
export LD_LIBRARY_PATH=\$ORACLE_HOME/lib:\$LD_LIBRARY_PATH
#date format
#export NLS_LANG=AMERICAN
export NLS_LANG="AMERICAN_AMERICA.ZHS16GBK"
export NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"
EOF
echo -e "\n\nThis program uniformly sets the password for sys, system, sysman and DBSNMP accounts."
echo "User defines the following environment variables:"
echo ">> ORACLE_HOME is: $datadir/oracle/product/11.2.0/db_1"
echo ">> ORACLE_BASE is: $datadir/oracle"
echo ">> Database SID is: $osid"
echo ">> SYS&SYSMAN.. user's password is set: $all_user_password "
read -p "Press Enter to continue ..."
cat >/home/oracle/db_install.rsp<<EOF
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
oracle.install.option=INSTALL_DB_AND_CONFIG
ORACLE_HOSTNAME=$HOSTNAME
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=$datadir/oracle/inventory
SELECTED_LANGUAGES=en,zh_CN
ORACLE_HOME=$datadir/oracle/product/11.2.0/db_1
ORACLE_BASE=$datadir/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.isCustomInstall=true
oracle.install.db.customComponents=oracle.server:11.2.0.1.0,oracle.sysman.ccr:10.2.7.0.0,oracle.xdk:11.2.0.1.0,oracle.rdbms.oci:11.2.0.1.0,oracle.network:11.2.0.1.0,oracle.network.listener:11.2.0.1.0,oracle.rdbms:11.2.0.1.0,oracle.options:11.2.0.1.0,oracle.rdbms.partitioning:11.2.0.1.0,oracle.oraolap:11.2.0.1.0,oracle.rdbms.dm:11.2.0.1.0,oracle.rdbms.dv:11.2.0.1.0,orcle.rdbms.lbac:11.2.0.1.0,oracle.rdbms.rat:11.2.0.1.0
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=oinstall
oracle.install.db.CLUSTER_NODES=
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
oracle.install.db.config.starterdb.globalDBName=$osid
oracle.install.db.config.starterdb.SID=$osid
oracle.install.db.config.starterdb.characterSet=AL32UTF8
oracle.install.db.config.starterdb.memoryOption=true
oracle.install.db.config.starterdb.memoryLimit=4096
oracle.install.db.config.starterdb.installExampleSchemas=false
oracle.install.db.config.starterdb.enableSecuritySettings=true
oracle.install.db.config.starterdb.password.ALL=$all_user_password
oracle.install.db.config.starterdb.password.SYS=
oracle.install.db.config.starterdb.password.SYSTEM=
oracle.install.db.config.starterdb.password.SYSMAN=
oracle.install.db.config.starterdb.password.DBSNMP=
oracle.install.db.config.starterdb.control=DB_CONTROL
oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=
oracle.install.db.config.starterdb.dbcontrol.enableEmailNotification=false
oracle.install.db.config.starterdb.dbcontrol.emailAddress=
oracle.install.db.config.starterdb.dbcontrol.SMTPServer=
oracle.install.db.config.starterdb.automatedBackup.enable=false
oracle.install.db.config.starterdb.automatedBackup.osuid=
oracle.install.db.config.starterdb.automatedBackup.ospwd=
oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGE
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=$datadir/oracle/oradata
oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=$datadir/oracle/fas
评论0