在CentOS5.5i386上安装Oracle10GXE

TNS-01106: Listener using listener name LISTENER has already been started然后# /usr/lib/oracle/xe/app/oracle/product/10.

1.安装rpm包

nano /v.sh

将下面内容复制进去

#!/bin/bash

rpm -Uvh compat-db-4.2.52-5.1.i386.rpm

rpm -Uvh compat-libstdc++-33-3.2.3-61.i386.rpm

rpm -Uvh make-3.81-3.el5.i386.rpm

rpm -Uvh setarch-2.0-1.1.i386.rpm

rpm -Uvh libgomp-4.4.0-6.el5.i386.rpm

rpm -Uvh libXp-1.0.0-8.1.el5.i386.rpm

rpm -Uvh openmotif-2.3.1-2.el5_4.1.i386.rpm

rpm -Uvh kernel-headers-2.6.18-194.el5.i386.rpm

rpm -Uvh glibc-headers-2.5-49.i386.rpm

rpm -Uvh glibc-devel-2.5-49.i386.rpm

rpm -Uvh compat-gcc-34-3.4.6-4.i386.rpm

rpm -Uvh libstdc++-devel-4.1.2-48.el5.i386.rpm

rpm -Uvh gcc-4.1.2-48.el5.i386.rpm

rpm -Uvh gcc-c++-4.1.2-48.el5.i386.rpm

rpm -Uvh compat-gcc-34-c++-3.4.6-4.i386.rpm

存盘

bash /v.sh

rm -f /v.sh

2.调整内核参数

nano /etc/sysctl.conf

#将原来的# kernel.shmmax和kernel.shmall这两行参数屏蔽

kernel.shmall = 2097152

kernel.shmmax = 2147483648

kernel.shmmni = 4096

# semaphores: semmsl, semmns, semopm, semmni

kernel.sem = 250 32000 100 128

fs.file-max = 65536

net.ipv4.ip_local_port_range = 1024 65000

net.core.rmem_default=262144

net.core.rmem_max=262144

net.core.wmem_default=262144

net.core.wmem_max=262144

nano /etc/security/limits.conf --加入以下四行代码

* soft nproc 2047

* hard nproc 16384

* soft nofile 1024

* hard nofile 65536

nano /etc/pam.d/login --加入下面一行代码

session required /lib/security/pam_limits.so

3.增加用户及组

groupadd oinstall

groupadd dba

groupadd oper

useradd -g oinstall -G dba Oracle

passwd oracle

4.伪装操作系统版本，使安装Oracle时，，通过操作系统验证。

cp /etc/RedHat-release /etc/redhat-release.bak

nano /etc/redhat-release

替换为如下代码：

redhat-4