1、下载oracle 11g

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

2、系统环境

free -h

文件方式添加swap交接分区

dd if=/dev/zero of=/swapfile bs=1M count=2048 &&mkswap /swapfile &&swapon /swapfile

3、检查系统没有安装的依赖包

rpm -q make binutils gcc libaio glibc compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel glibc glibc-common glibc-devel glibc-headers gcc-c++ libaio-devel libaio-devel libgcc libstdc++ libstdc++-devel sysstat unixODBC unixODBC-devel pdksh expat |grep not

4、设置linux内核参数

修改/etc/security/limits.conf、/etc/pam.d/login、/etc/profile、/home/.bashrc

#vi /etc/sysctl.conf

kernel.shmall = 2097152

kernel.shmmax = 2147483648

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.core.rmem_default = 4194304

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

fs.file-max = 6815744

net.ipv4.ip_local_port_range = 9000 65500

net.core.wmem_max = 1048576

fs.aio-max-nr = 104857

使配置生效 #sysctl -p

#vi /etc/security/limits.con

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

#vi /etc/profile

if [ $USER = "oracle" ]; then

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

ulimit -p 16384

ulimit -n 65536

else

ulimit -u 16384 -n 65536

#vi /home/.bashrc

export ORACLE_BASE=/data/oracle/product/

export ORACLE_HOME=/data/oracle/product/11.2/db_1

export ORACLE_SID=tohmain

export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib

5、建立用户组和文件夹

groupadd oinstall

groupadd dba

useradd -g oinstall -G dba oracle

passwd oracle

mkdir -p /data/oracle/product/11.2

chown -R oracle.oinstall /data/oracle

mkdir -p /home/oracle

chown -R oracle.dba  /home/oracle

5、编辑oracle静态安装文件db_install.rsp

./runInstaller -silent -responseFile /db_install.rsp

创建库

dbca -silent -createdatabase -responseFile /dbca.rsp    

删除库

dbca -silent -deleteDatabase -sourceDB orcl -sid orcl -sysDBAUserName sys -sysDBAPassword password

Instant Client Downloads

http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

http://blog.sina.com.cn/s/blog_4c98be4501010opf.html