oracle 11gr2 安装需要修改的几个文件和案例

1、内存管理，在该文件末尾添加

/etc/sysctl.conf

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 536870912

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

# /sbin/sysctl -p

2、系统限制，打开文件数和进程数

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

oracle soft stack 10240

3、env

su - oracle

vi .bash_profile

export ORACLE_HOSTNAME=escmtest001

export ORACLE_BASE=/u01/app/oracle/ #跟后面设置的保持一致

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1/ #跟后面设置的保持一致

export ORACLE_SID=<sid> #大小写都可以滴

export PATH=.:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/jdk/bin:$PATH

export LC_ALL="en_US"

export LANG="en_US"

export NLS_LANG="AMERICAN_AMERICA.ZHS16GBK"

export NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"

su - oracle

4、

exit

vi /etc/hosts

add

172.16.0.16 zmcytest001

5、

[root@zmcytest001 network-scripts]# cat ifcfg-eth0

DEVICE="eth0"

NM_CONTROLLED="yes"

ONBOOT="yes"

HWADDR=2C:76:8A:54:88:88

TYPE=Ethernet

BOOTPROTO=none

IPADDR=172.16.0.16

PREFIX=24

GATEWAY=172.16.0.254

DNS1=172.16.0.8

DEFROUTE=yes

IPV4_FAILURE_FATAL=yes

IPV6INIT=no

NAME="System eth0"

UUID=5fb06bd0-0bb0-7ffb-45f1-d6edd65f3e03

[root@zmcytest001 network-scripts]# pwd

/etc/sysconfig/network-scripts