红联Linux门户
Linux帮助

Fedora22下安装Oracle 11g

发布时间:2015-06-29 10:55:16来源:cnblogs.com/windyWu/作者:豆苗稀

下载地址

http://download.oracle.com/otn/linux/oracle11g/R2/linux_11gR2_database_1of2.zip

http://download.oracle.com/otn/linux/oracle11g/R2/linux_11gR2_database_2of2.zip

http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_1of2.zip

http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_2of2.zip


一、硬件检测

1、内存检测 Oracle11g要求最低1GB内存

grep MemTotal  /proc/meminfo


2、交换空间检测 通常交换空间是内存1.5倍

grep  SwapTotal /proc/meminfo


3、临时目录/tmp检查

df -h /tmp


二、配置过程

0 install packages

yum install binutils
yum install gcc
yum install elfutils-libelf-devel
yum install gcc-c++
yum install unixODBC
yum install unixODBC-devel
yum install ksh
yum install libaio-devel
yum install sysstat


1、创建用户和用户组

/usr/sbin/groupadd dba
/usr/sbin/useradd -g dba -m oracle
passwd oracle

mkdir /home/oracle/app
mkdir /home/oracle/app/oracle
mkdir /home/oracle/app/oradata
mkdir /home/oracle/app/oracle/product
chown -R oracle:dba /home/oracle/app


2、修改用户的SHELL的限制

vi /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

vi /etc/pam.d/login
session required /lib/security/pam_limits.so
session required pam_limits.so

vi /etc/profile
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi


3、修改linux内核

vi /etc/sysctl.conf
fs.file-max = 6815744
fs.aio-max-nr = 1048576
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576

立即生效

/sbin/sysctl -p


4、配置oracle用户的环境变量

su – oracle

vi .bash_profile
umask 022
export ORACLE_BASE=/home/oracle/app
export ORACLE_HOME=$ORACLE_BASE/oracle/product/11.2.0/dbhome_1
export ORACLE_SID=orcl
PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib

注销系统


三、安装数据库 (图形界面下)

unzip linux_11gR2_database_1of2.zip
unzip linux_11gR2_database_2of2.zip

export LANG=en_US.UTF-8

./runInstaller


64位Ubuntu安装Oracle 11G:http://www.linuxdiyf.com/linux/9955.html

Linux(RHEL)安装Oracle手记:http://www.linuxdiyf.com/linux/11302.html

总结在Linux安装Oracle的方法:http://www.linuxdiyf.com/linux/6.html

Ubuntu 14.04 LTS 64位安装Oracle 11g:http://www.linuxdiyf.com/linux/9954.html

Ubuntu 14.04安装Oracle数据库管理软件SQL Developer记录:http://www.linuxdiyf.com/linux/9384.html