- 准备
-
添加用户和组
groupadd oinstall groupadd dba groupadd asmadmin groupadd asmdba useradd -g oinstall -G dba,asmdba oracle -d /home/oracle
-
设置系统内核参数:/etc/sysctl.conf
net.core.rmem_default=262144 net.core.rmem_max=4194304 net.core.wmem_default=262144 net.core.wmem_max=1048586 net.ipv4.icmp_echo_ignore_broadcasts = 1 net.ipv4.conf.all.rp_filter = 1 net.ipv4.icmp_echo_ignore_broadcasts = 1 net.ipv4.conf.all.rp_filter = 1 fs.file-max = 6815744 fs.aio-max-nr = 1048576 kernel.shmall = 2097152 kernel.shmmax = 2147483648 kernel.shmmni = 4096 net.ipv4.ip_local_port_range = 9000 65500 kernel.sem = 5010 641280 5010 128
-
修改 /etc/security/limits.conf
oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536
-
修改 /etc/pam.d/login
session required /lib64/security/pam_limits.so session required pam_limits.so
-
修改 /etc/profile
if [ $USER = "oracle" ];then if [ $SHELL = "/bin/ksh" ];then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi fi
-
创建oracle相关目录
mkdir -p /home/oracle/app/oracle/product/11.2.0 mkdir /home/oracle/app/oracle/oradata mkdir /home/oracle/app/oraInventory mkdir /home/oracle/app/oracle/flash_recovery_area chown -R oracle:oinstall /home/oracle/app/oracle chmod -R 775 /home/oracle/app/oracle mkdir -p /home/oracle/app/oraInventory chown -R oracle:oinstall /home/oracle/app/oraInventory
-
修改 .bash_profile
export PATH umask 022 export ORACLE_HOSTNAME=test export ORACLE_BASE=/home/oracle/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/11.2.0 export ORACLE_SID=orcl export ORACLE_TERM=xterm export PATH=.:$ORACLE_HOME/bin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/