oracle版本:11.1.0.6.0 redhat版本:RedHat EL4,5 Oracle EL 4,5 CentOS 4,5

安装过程分以下四个步骤

一,安装准备 二,下载安装 三,相关设置 四,常见错误

一,安装准备 1,创建oracle用户 以root用户登录,并创建oracle用户以及所属的dba组

su -
# groupadd dba
# useradd -g dba oracle
# mkdir /home/oracle
# chown oracle:dba /home/oracle  

2,配置系统参数

编辑 /etc/sysctl.conf 文件并添加下列参数:

kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 6553600
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 262144 

编辑后可以运行“sysctl -p" 生效,或者重启系统

对于redhat 版本4:编辑 /etc/pam.d/login 文件,并添加下行参数:

session required /lib/security/pam_limits.so 

对于redhat 版本5:编辑 /etc/pam.d/login 文件,并添加下行参数:

session required pam_limits.so  

编辑 /etc/security/limits.conf 并添加下行参数:

oracle    soft  nproc  2047
oracle    hard  nproc  16384
oracle    soft  nofile  1024
oracle    hard  nofile  65536  

3,创建oracle目录

# mkdir /opt/oracle
# mkdir /opt/oracle/111
# chown -R oracle:dba /opt/oracle 

4,设置oracle环境变量

编辑 /home/oracle/.bash_profile 并添加下列行:

ORACLE_BASE=/opt/oracle
ORACLE_HOME=$ORACLE_BASE/111
ORACLE_SID=ORCL
LD_LIBRARY_PATH=$ORACLE_HOME/lib
PATH=$PATH:$ORACLE_HOME/bin

export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH PATH 

保存后通过下面命令是配置生效

su - oracle
cd /home/oracle
. .bash_profile 

二,下载安装

1,下载并安装需要的rpm软件包

检查软件包安装情况:

rpm -q binutils elfutils elfutils-libelf gcc gcc-c++ glibc glibc-common glibc-devel compat-libstdc++-33 cpp make compat-db sysstat libaio libaio-devel unixODBC unixODBC-devel|sort 

相应软件包下载地址 RedHat Enterprise Linux 4:ftp://ftp.redhat.com/pub/redhat/linux/enterprise/4/en/os/i386/SRPMS/ RedHat Enterprise Linux 5:ftp://ftp.redhat.com/pub/redhat/linux/enterprise/5Server/en/os/SRPMS/ Centos Linux 4:http://centos.arcticnetwork.ca/4/os/i386/CentOS/RPMS/ Centos Linux 5:http://centos.arcticnetwork.ca/5/os/i386/CentOS/ 下载后使用rpm -ivh命令安装即可

2,下载oracle 11g 下载地址:http://www.oracle.com/technology/software/products/database/index.html 解压软件包

unzip linux_11gR1_database.zip 

3,开始安装

cd database
./runInstaller 

三,相关配置

1,自动启动和关闭数据库实例和监听

编辑 /etc/oratab 修改最后参数为“Y” ORCL:/opt/oracle/111:Y

以root用户在 /etc/init.d/ 目录中创建oracle文件,并添加下列内容

#!/bin/bash
#
# oracle Init file for starting and stopping
# Oracle Database. Script is valid for 10g and 11g versions.
#
# chkconfig: 35 80 30
# description: Oracle Database startup script

# Source function library.

. /etc/rc.d/init.d/functions

ORACLE_OWNER="oracle"
ORACLE_HOME="/opt/oracle/111"

case "$1" in
start)
echo -n $"Starting Oracle DB:"
su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/dbstart $ORACLE_HOME"
echo "OK"
;;
stop)
echo -n $"Stopping Oracle DB:"
su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/dbshut $ORACLE_HOME"
echo "OK"
;;
*)
echo $"Usage: $0 {start|stop}"
esac 

设置脚本权限和自启动

chmod 750 /etc/init.d/oracle
chkconfig --add oracle --level 0356 

2,自动启动和关闭 EM

以root用户在 /etc/init.d 中创建oraemctl 文件,并添加下面内容

#!/bin/bash
#
# oraemctl Starting and stopping Oracle Enterprise Manager Database Control.
# Script is valid for 10g and 11g versions.
#
# chkconfig: 35 80 30
# description: Enterprise Manager DB Control startup script

# Source function library.

. /etc/rc.d/init.d/functions

ORACLE_OWNER="oracle"
ORACLE_HOME="/opt/oracle/111"

case "$1" in
start)
echo -n $"Starting Oracle EM DB Console:"
su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/emctl start dbconsole"
echo "OK"
;;
stop)
echo -n $"Stopping Oracle EM DB Console:"
su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/emctl stop dbconsole"
echo "OK"
;;
*)
echo $"Usage: $0 {start|stop}"
esac 

设置权限和自启动

chmod 750 /etc/init.d/oraemctl
chkconfig --add oraemctl --level 0356 

四,常见错误

1,错误:DISPLAY not set. Please set the DISPLAY and try again.

以root用户打开终端或者ssh登录,通过下面命令均可可解决 命令一: export DISPLAY=:0.0 命令二: xhost +

2,错误:error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

安装libaio和libaio-devel软件包,如果仍重复提示错误,以root用户运行”ldconfig“命令可以解决

3,错误:Check complete. The overall result of this check is: Failed ««

检查缺失软件包并安装,或者修改系统参数为需要的值