oracle12c 单机安装,oracle12.2 单机配置

yum install -y binutils-yum install -y compat-libcap1

yum install -y compat-libstdc

yum install -y elfutils-libelfyum install -y elfutils-libelf-devel-

yum install -y glibcyum install -y glibc-common

yum install -y glibc-develyum install -y glibc-headers

yum install -y ksh-2yum install -y libaio

yum install -y libaio-develyum install -y libgcc

yum install -y libstdc++yum install -y libstdc++-devel

yum install -y makeyum install -y sysstat

yum install -y unixODBCyum install -y unixODBC-devel

#cp /etc/sysctl.conf /etc/sysctl.conf.bak

cat >> /etc/sysctl.conf << EOF

###############

vm.swappiness = 1

vm.dirty_background_ratio = 3

vm.dirty_ratio = 80

vm.dirty_expire_centisecs = 500

vm.dirty_writeback_centisecs = 100

kernel.shmmax = 4398046511104

kernel.shmall = 1073741824

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576

fs.aio-max-nr = 1048576

kernel.panic_on_oops = 1

fs.file-max = 6815744

EOF

groupadd --gid 1000 oinstall

groupadd --gid 1001 dba

groupadd --gid 1005 oper

groupadd --gid 1006 backupdba

groupadd --gid 1007 dgdba

groupadd --gid 1008 kmdba

useradd --uid 1000 --gid oinstall --groups dba,oper,backupdba,dgdba,kmdba oracle

passwd oracle

mkdir -p /u01/app/

chmod -R 775 /u01/app/

mkdir -p /u01/app/oraInventory

chmod -R 775 /u01/app/oraInventory

chown -R oracle:oinstall /u01/app/oraInventory

mkdir -p /u01/app/oracle

mkdir -p /u01/app/oracle/cfgtoollogs

chown -R oracle:oinstall /u01/app/oracle/

chmod -R 775 /u01/app/oracle/

touch /etc/security/limits.d/99-grid-oracle-limits.conf

cat >> /etc/security/limits.d/99-oracle-limits.conf << EOF

oracle soft nproc 16384

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

oracle soft stack 10240

oracle hard stack 32768

EOF

cd /etc/profile.d/

touch oracle.sh

cat >> oracle-grid.sh << EOF

#Setting the appropriate ulimits for oracle and grid user

if [ $USER = "oracle" ]; then

if [ $SHELL = "/bin/ksh" ]; then

ulimit -u 16384

ulimit -n 65536

else

ulimit -u 16384 -n 65536

fi

fi

EOF

oracle:

export PATH

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1

export PATH=$PATH:$ORACLE_HOME/bin

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

export ORACLE_SID=prod