A useful guide for installation oracle on redhat.
1.Download Software
Download Sun's Java Development Kit (JDK 1.3.1).
Download the Oracle installation files from otn.oracle.com.
Download the Oracle 9.2.0.4.0 patchset files from metalink.oracle.com.
Download the following patches (3006854, 3119415) from metalink.oracle.com.
从网上下载升级补丁包,用于将Oracle9.2.0升级到9.2.0.4: p3006854_9204_LINUX.zip
所有的补丁说明如下：
p3006854_9204_LINUX.zip 在运行 runInstaller 之前打.
/***如果直接安装9204，不需打如下补丁包
p3095277_9204_LINUX.zip 9.2.0.4.0的升级补丁包.
p2617419_210_GENERIC.zip 打3119415补丁所需要的补丁.
p3119415_9204_LINUX.zip 在升级到9.2.0.4.0之后打.
***/
1).用rpm -qa│grep compat 查看系统中是否安有以下几个软件包： (su -root)
compat-libstdc++-7.3-2.96.122
compat-gcc-c++-7.3-2.96.122
compat-libstdc++-devel-7.3-2.96.122
compat-db-4.0.14-5
compat-gcc-7.3-2.96.122
tcl-devel-8.3.5-92.i386.ipm
其他相关软件包（安装上述软件包时可能需要）：
glibc-kemheadsers-2.4-8.34.i386.rpm
glib-headers-2.3.2-95.20.i386.rpm
glib-derel-2.3.2-95.20.i386.rpm
2). rpm -qa │ grep openmotif查看下列软件包
openmotif21-2.1.30-8
3). rpm -qa │ grep setarch查看:
setarch-1.3-1
4)Put gcc296 and g++296 first in $PATH variable by creating the following symbolic links:
mv /usr/bin/gcc /usr/bin/gcc323
mv /usr/bin/g++ /usr/bin/g++323
ln -s /usr/bin/gcc296 /usr/bin/gcc
ln -s /usr/bin/g++296 /usr/bin/g++
**如果没有安装，请使用如下命令安装
---加载文件命令：#rpm –ivh /mnt/cdrom/RedHat/RPMB/[filename].rpm
# From RedHat AS3 Disk 2
su -root
cd /mnt/cdrom/RedHat/RPMS
rpm -Uvh setarch-1.3-1.i386.rpm
rpm -Uvh tcl-8.3.5-92.i386.rpm
# From RedHat AS3 Disk 3
cd /mnt/cdrom/RedHat/RPMS
rpm -Uvh openmotif21-2.1.30-8.i386.rpm
rpm -Uvh compat-db-4.0.14-5.i386.rpm \
compat-gcc-7.3-2.96.122.i386.rpm \
compat-gcc-c++-7.3-2.96.122.i386.rpm \
compat-libstdc++-7.3-2.96.122.i386.rpm \
compat-libstdc++-devel-7.3-2.96.122.i386.rpm
2.Set Kernel Parameters
设置内核参数，调节信号灯及共享内存：
修改 /etc/sysctl.conf 这个文件，加入以下的语句：
kernel.shmmax = 2147483648 (机器内存2G，如果你的没这么大可相应设置小些)
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
sem 4个参数依次为SEMMSL(每个用户拥有信号量最大数)；SEMMNS(系统信号量最大数)；SEMOPM(每次semopm系统调用操作数)；SEMMNI(系统辛苦量集数最大数).
Shmmax 最大共享内存2GB 物理内存如果小的话可以设置成 536870912.
Shmmni 最小共享内存 4096KB.
Shmall 所有内存大小.
设置完成后用命令 more /etc/sysctl.conf |grep kernel.s 检查.
3、设置oracle对文件的要求：
编辑文件：/etc/security/limits.conf 加入以下语句：
oracle soft nofile 65536
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
4.Setup
1).Create the new groups and users:
groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle
passwd oracle
2).Create the directories in which the Oracle software will be installed:
# mkdir -p /opt/ora9/product/9.2
# mkdir /var/opt/oracle
# chown oracle.dba /var/opt/oracle
# chown -R oracle.dba /opt/ora9
3)Login as the oracle user and add the following lines at the end of the .bash_profile file:
设置oracle用户的环境， 新开一个终端，***注意一定要新开一个 ***
su - oracle
打开.bash_profile文件，将如下内容加入：
(命令vi $HOME/.bash_profile 编辑用VI使用可查手册 I 进入edit ;w 存盘 ;q退出)
#oracle 9i
export DISPLAY=”192.9.200.24:0.0” (127.0.0.1:0.0)
export ORACLE_BASE=/opt/ora9
export ORACLE_HOME=/opt/ora9/product/9.2
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATH
export ORACLE_OWNER=oracle
export ORACLE_SID=ora9i (数据库全局变量名)
export ORACLE_TERM=xterm (xterm窗口模式 vt100 终端调试模式)
export LD_ASSUME_KERNEL=2.4.1
export THREADS_FLAG=native
export LD_LIBRARY_PATH=/opt/ora9/product/9.2/lib:$LD_LIBRARY_PATH
export PATH=/opt/ora9/product/9.2/bin:$PATH
export NLS_LANG=AMERICAN (设置语言AMERICAN英文)
export LANG=us_en
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
保存后退出. 执行： source .bash_profile 查看 set | more
然后。退出登录，再次进入，这时候oracle的环境就已经生效了.
Make sure the hostname command returns a fully qualified host name by amending the /etc/hosts file if necessary: hostname
