加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 百科 > 正文

oracle12.2 单机配置

发布时间:2020-12-12 13:39:32 所属栏目:百科 来源:网络整理
导读:yum install -y binutils- yum install -y compat-libcap1 yum install -y compat-libstdc yum install -y elfutils-libelf yum install -y elfutils-libelf-devel- yum install -y glibc yum install -y glibc-common yum install -y glibc-devel yum insta
yum install -y binutils-
yum install -y compat-libcap1
yum install -y compat-libstdc

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

yum install -y glibc
yum install -y glibc-common

yum install -y glibc-devel
yum install -y glibc-headers

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

yum install -y libaio-devel
yum install -y libgcc

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

yum install -y make
yum install -y sysstat

yum install -y unixODBC
yum 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 PATHexport ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1export PATH=$PATH:$ORACLE_HOME/binexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libexport ORACLE_SID=prod

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读