在centos 5.5 i386 上安装 oracle 10g xe

在centos 5.5 i386 上安装 oracle 10g xe

 （原创： flexitime ，转载请注明出处，谢谢）

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

 

5. 设置Oracle环境变量(可根据你的需要作适当更改)

 

nano /home/oracle/.bash_profile --加入内容如下

# Oracle Settings

TMP=/tmp; export TMP

TMPDIR=$TMP; export TMPDIR

ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server; export ORACLE_HOME

ORACLE_TERM=xterm; export ORACLE_TERM

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/jre:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

 

if [ $USER = "oracle" ]; then

if [ $SHELL = "/bin/ksh" ]; then

ulimit -p 16384

ulimit -n 65536

else

ulimit -u 16384 -n 65536

fi

fi

 

 

 

6.复制文件，并进行安装

 

su - oracle

rpm -ivh oracle-xe-univ-10.2.0.1-1.0.i386.rpm

 

安装完成后，要执行 root 脚本：

cd /etc

cd init.d

./oracle-xe configure

 

7.测试:

 

用netstat看看8080和1521是否已经监听了。

# netstat –tnl

如果有

tcp 0 0 0.0.0.0:8080 0.0.0.0:* LISTEN

tcp 0 0 0.0.0.0:1521 0.0.0.0:* LISTEN

应该就ok了。

 

http://your_ip:8080/apex

 

注：

Oracle常用几个命令用法

#/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/lsnrctl start //启动监听器

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 18-SEP-2007 00:27:51

Copyright (c) 1991, 2005, Oracle. All rights reserved.

TNS-01106: Listener using listener name LISTENER has already been started

 

然后

# /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/lsnrctl stat

没问题的话，最后会提示

The command completed successfully