1.檢查系統包安裝情況
rpm -qa|grep binutils
rpm -ivh sysstat-7.0.2.rpm
binutils-2.17.50.0.6
compat-libstdc++-33-3.2.3
compat-libstdc++-33-3.2.3 (32 bit)
elfutils-libelf-0.125
elfutils-libelf-devel-0.125
gcc-4.1.2
gcc-c++-4.1.2
glibc-2.5-24
glibc-2.5-24 (32 bit)
glibc-common-2.5
glibc-devel-2.5
glibc-devel-2.5 (32 bit)
libaio-0.3.106
libaio-0.3.106 (32 bit)
libaio-devel-0.3.106
libaio-devel-0.3.106 (32 bit)
libgcc-4.1.2
libgcc-4.1.2 (32 bit)
libstdc++-4.1.2
libstdc++-4.1.2 (32 bit)
libstdc++-devel 4.1.2
make-3.81
sysstat-7.0.2
unixODBC-2.2.11 (32-bit) or later
unixODBC-devel-2.2.11 (64-bit) or later
unixODBC-2.2.11 (64-bit) or later
libXp
libXp-devel
2.修改網絡配置
vi /etc/sysconfig/network-scripts/ifcfg-eth0
----------------------------
DEVICE=eth0
BOOTPROTO=none
HWADDR=00:0c:29:d4:f5:b4
ONBOOT=yes
TYPE=Ethernet
USERCTL=yes
IPV6INIT=no
PEERDNS=yes
NETMASK=255.255.255.0
IPADDR=192.168.91.100
GATEWAY=192.168.91.1
----------------------------
vi /etc/hosts
-----------------------------
127.0.0.1 localhost.localdomain localhost
192.168.91.100 RHL5
-----------------------------
3.添加oracle用戶
groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle
passwd oracle
4.添加初始化參數
vi /etc/sysctl.conf
sysctl -p
-----------------------------
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
-----------------------------
5.關閉強制訪問控制，避免路由訪問失敗
vi /etc/selinux/config
-----------------------
SELINUX=disabled
-----------------------
6.設置oracle軟硬件進程數
vi /etc/security/limits.conf
-----------------------
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
-----------------------
7.全局進程，線程配置
vi /etc/profile
----------------------
if [$USER = 'oracle']; then
ulimit -u 16384
ulimit -n 65536
fi
----------------------
8.創建oracle根目錄，並設置目錄權限
mkdir /u01/app/oracle -p
chown -R oracle:oinstall /u01
chmod -R 755 /u01
9.設置oracle用戶環境變量
su - oracle
vi .bash_profile
----------------------
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.2/db_1
export ORACLE_SID=oracle11g
export NLS_LANG=american_america.zhs16gbk
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export PATH=$PATH:$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin
umask 022
----------------------
讓其生效
. ./.bash_profile
檢驗是否設置成功
echo $ORACLE_HOME
