在ORACLE LINUX 6.4中安装ORACLE11G_R2过程

但是我们的DB SERVER无法连接外网，也就无法使用YUM连接ORACLE LINUX的更新服务器获得更新。从ORACLE LINUX 6.3开始可以从ORACLE LINUX安装光盘获得preinstall安装包。 1. 挂载光盘

[root@oem ~]# df -h

文件系统容量已用可用已用%% 挂载点

/dev/sda3 24G 8.4G 14G 38% / tmpfs 3.0G 100K 3.0G 1% /dev/shm /dev/sda1 97M 51M 42M 55% /boot

/dev/sr0 3.5G 3.5G 0 100% /media/OL6.4 x86_64 Disc 1 20130225

2. 修改yum repository配置

[root@oem tmp]# cd /etc/yum.repos.d/

[root@oem yum.repos.d]# cp public-yum-ol6.repo public-yum-ol6.repo.bak [root@oem yum.repos.d]# vi public-yum-ol6.repo

[ol6_dvd]

name=Oracle Linux DVD

baseurl=file:///media/OL6.4\\ x86_64\\ Disc\\ 1\\ 20130225/Server #gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6 gpgcheck=0 enabled=1

3. 安装oracle-rdbms-server-11gR2-preinstall包

[root@oem yum.repos.d]# yum update

[root@oem yum.repos.d]# yum install oracle-rdbms-server-11gR2-preinstall

手动配置

如果不使用preinstall包自动配置，就需要手工的做配置，具体的配置工作如下： 1. 修改/etc/sysctl.conf文件

Oracle需求的最小配置如下：

fs.suid_dumpable = 1 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 = 1048586

可以使用如下命令来查看某个参数值：

/sbin/sysctl -a | grep

在/etc/sysctl.conf文件里在添加或者修改如下内容：

fs.suid_dumpable = 1 fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 536870912 kernel.shmmni = 4096

# semaphores: semmsl, semmns, semopm, semmni 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

修改完成之后执行如下命令使修改生效：

/sbin/sysctl –p

2. 在/etc/security/limits.conf文件里添加如下内容

oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 4096 oracle hard nofile 65536 oracle soft stack 10240

3. 安装相关的RPM 包

# From Oracle Linux 6 DVD cd /media/cdrom/Server/Packages rpm -Uvh binutils-2*x86_64*

rpm -Uvh glibc-2*x86_64* nss-softokn-freebl-3*x86_64* rpm -Uvh glibc-2*i686* nss-softokn-freebl-3*i686* rpm -Uvh compat-libstdc++-33*x86_64* rpm -Uvh glibc-common-2*x86_64* rpm -Uvh glibc-devel-2*x86_64* rpm -Uvh glibc-devel-2*i686*

rpm -Uvh glibc-headers-2*x86_64* rpm -Uvh elfutils-libelf-0*x86_64* rpm -Uvh elfutils-libelf-devel-0*x86_64* rpm -Uvh gcc-4*x86_64* rpm -Uvh gcc-c++-4*x86_64* rpm -Uvh ksh-*x86_64* rpm -Uvh libaio-0*x86_64* rpm -Uvh libaio-devel-0*x86_64* rpm -Uvh libaio-0*i686* rpm -Uvh libaio-devel-0*i686* rpm -Uvh libgcc-4*x86_64* rpm -Uvh libgcc-4*i686* rpm -Uvh libstdc++-4*x86_64* rpm -Uvh libstdc++-4*i686*

rpm -Uvh libstdc++-devel-4*x86_64* rpm -Uvh make-3.81*x86_64* rpm -Uvh numactl-devel-2*x86_64* rpm -Uvh sysstat-9*x86_64*

rpm -Uvh compat-libstdc++-33*i686* rpm -Uvh compat-libcap* cd / eject

4. 创建groups和users

groupadd -g 501 oinstall groupadd -g 502 dba groupadd -g 503 oper groupadd -g 504 asmadmin groupadd -g 505 asmoper groupadd -g 506 asmdba

useradd -u 502 -g oinstall -G dba,asmdba,oper oracle passwd oracle

其它设置

1. 设置oracle用户密码

passwd oracle

2. 修改/etc/security/limits.d/90-nproc.conf

See MOS Note [ID 1487773.1]

# Change this

* soft nproc 1024

# To this * - nproc 16384

3. 禁用SELINUX

在/etc/selinux/config里设置：

SELINUX=disabled

修改这个参数需要重启系统才能生效。 4. 防火墙设置

To turn off the firewall do the following as the \

# service iptables stop # chkconfig iptables off

5. 创建ORACLE安装目录并赋权

mkdir -p /u01/app/oracle/product/11.2.0/db_1 chown -R oracle:oinstall /u01 chmod -R 775 /u01

6. 切换到oracle用户，并修改.bash_profile 文件

# Oracle Settings TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR

ORACLE_HOSTNAME=oem.localdomain; export ORACLE_HOSTNAME ORACLE_UNQNAME=oem; export ORACLE_UNQNAME ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME ORACLE_SID=oem; export ORACLE_SID

PATH=/usr/sbin:$PATH; export PATH PATH=$ORACLE_HOME/bin:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

3. 使用ORACLE用户，上传并解压ORACLE安装文件

将下载的ORACLE安装文件

p10404530_112030_Linux-x86-64_1of7.zip p10404530_112030_Linux-x86-64_2of7.zip