useradd -u 1100 -g oinstall -G dba oracle
mkdir -p /home/u01/app/oracle/product/12.2.0.1/dbhome_1
mkdir /home/u01/app/oraInventory
mkdir /home/u01/app/oradata
mkdir /home/u01/app/recovery_data
chown -R oracle:oinstall /home/u01
chmod -R 775 /home/u01
#更改密码
passwd oracle
oracle 用户下
Vim ~/.bash_profile
export ORACLE_BASE=/home/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/dbhome_1
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export ORACLE_SID=orcl
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
source ~/.bash_profile # 使配置立即生效
#### sysctl,limits,login ####
vim /etc/sysctl.conf
=>
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmmax = 8180989951
kernel.shmall = 1997312
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
kernel.shmmax:官方建议值:物理内存值 -1 byte
kernel.shmall:物理内存值/4k
sysctl -p
修改系统资源限制
vim /etc/security/limits.conf # 编辑 limits.conf,末尾处添加下面的参数
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft nofile 65536
oracle hard nofile 65536
oracle soft stack 10240
oracle hard stack 32768
修改用户验证选项
vim /etc/pam.d/login
找到这一行:session required pam_namespace.so ,在其下一行添加一条
pam_limits.so
session required pam_limits.so
文档被以下合辑收录
评论