Oracle 11.2.0.4 单实例安装

Oracle 11.2.0.4 单实例安装

1 创建用户和用户组

groupadd -g 1000 oinstall
groupadd -g 1001 dba
groupadd -g 1002 oper
useradd -u 1000 -g oinstall -G dba,oper -m -d /home/oracle oracle

2新建安装目录并设置权限

mkdir -p /u01/app/oracle
mkdir -p /u01/app/oraInventory
chown -R oracle:oinstall /u01/
chmod -R 775 /u01

3. 配置用户环境变量
   vi /home/oracle/.bash_profile

# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db; export ORACLE_HOME
ORACLE_SID=zkjsrgl01; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
BASE_PATH=/usr/sbin:$PATH; export BASE_PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMAT
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;export NLS_LANG

4.修改系统参数

步骤1.配置系统用户登录限制参数
#vi /etc/pam.d/login 增加下列内容：

session required pam_limits.so

步骤2.修改SELINUX为disabled，getenforce查看
vi /etc/selinux/config

SELINUX=disabled

setenforce 0 

步骤3 .配置/etc/security/limits.conf，在文件底部增加以下内容

oracle           soft    nproc   2047
oracle           hard    nproc   16384
oracle           soft    nofile  1024
oracle           hard    nofile  65536
oracle           soft    stack   10240
oracle           hard    stack   32768

步骤4.配置/etc/sysctl.conf，kernel.shmmax参数取值为节点物理内存的70%
vi /etc/sysctl.conf

fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 4294967295
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 = 1048586

步骤5.最后刷新以下参数
sysctl -p

5.修改hosts文件
vi /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
10.10.129.26    VM000000056

6.关闭防火墙
service iptables stop
service ip6tables stop
chkconfig –level 2345 iptables off
chkconfig --level 2345 ip6tables off

7.安装依赖包

yum install -y binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel elfutils-libelf-devel-static gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers kernel-headers ksh libaio libaio-devel libgcc libgomp libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel