单机安装oracle,Oracle 11G 单机安装

1. 检查内存，至少1G

grep MemTotal /proc/meminfo

2.交换分区

Available RAMSwap Space Required

Between 1 GB and 2 GB1.5 times the size of RAM

Between 2 GB and 16 GBEqual to the size of RAM

More than 16 GB16 GB

grep "model name" /proc/cpuinfo

grep SwapTotal /proc/meminfo

[root@home ~]# free

total      used      free    shared    buffers    cached

Mem:      1035140    512924    522216          0      51236    335880

-/+ buffers/cache:    125808    909332

Swap:      1052248          0    1052248

3. 共享内存段至少要大于MEMORY_MAX_TARGET and MEMORY_TARGET

[root@home ~]# df -k /dev/shm/

Filesystem          1K-blocks      Used Available Use% Mounted on

tmpfs                  517568        0    517568  0% /dev/shm

4. 至少1G的 /tmp

df -h /tmp

5. 数据库软件和data磁盘空间要求

Installation TypeRequirement for Software Files (GB)

Enterprise Edition3.95

Standard Edition3.88

Installation TypeRequirement for Data Files (GB)

Enterprise Edition1.7

Standard Edition1.5

6. 操作系统版本

Operating System Requirements

The following are the operating system requirements for Oracle Database 11g Release 2 (11.2) for Linux x86:

Asianux 2.0

Asianux 3.0

Oracle Enterprise Linux 4.0 Update 7 or later

Oracle Enterprise Linux 5.0

Red Hat Enterprise Linux 4.0 Update 7 or later

Red Hat Enterprise Linux 5.0

SUSE Linux Enterprise Server 10.0

SUSE Linux Enterprise Server 11.0

For Asianux 3, Oracle Enterprise Linux 5.0, and Red Hat Enterprise Linux 5.0: 2.6.18 or later

[root@home ~]# uname -r

2.6.18-164.el5

[root@rhel5 ~]# uname -a

Linux rhel5.oraclelinux.com 2.6.18-164.el5 #1 SMP Tue Aug 18 15:51:54 EDT 2009 i686 i686 i386 GNU/Linux

[root@rhel5 ~]# uname -s

Linux

7. 检查软件包

yum -y install binutils-*

yum -y install compat-libstdc++-*

yum -y install elfutils-libelf-*

yum -y install elfutils-libelf-devel-*

yum -y install elfutils-libelf-devel-static-*

yum -y install gcc-*

yum -y install gcc-c++-*

yum -y install glibc-*

yum -y install glibc-common-*

yum -y install glibc-devel-*

yum -y install glibc-headers-*

yum -y install kernel-headers-*

yum -y install ksh-*

yum -y install libaio-*

yum -y install libaio-devel-*

yum -y install libgcc-*

yum -y install libgomp-*

yum -y install libstdc++-*

yum -y install libstdc++-devel-*

yum -y install make-*

yum -y install sysstat-*

yum -y install unixODBC-*

yum -y install unixODBC-devel-*

8. 创建组和用户

/usr/sbin/groupadd oinstall

/usr/sbin/groupadd dba

/usr/sbin/useradd -g oinstall -G dba oracle

如果oracle用户已经存在

/usr/sbin/usermod -g oinstall -G dba oracle

echo oracle | passwd --stdin oracle

9. 修改内核参数 vi /etc/sysctl.conf

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 536870912

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048586

10. vi /etc/security/limits.conf

oracle          soft    nproc  2047

oracle          hard    nproc  16384

oracle          soft    nofile  1024

oracle          hard    nofile  65536

11. vi /etc/pam.d/login

session    required    pam_limits.so

12. 修改profile

if [ $USER = "oracle" ]; then

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

ulimit -p 16384

ulimit -n 65536

else

ulimit -u 16384 -n 65536

fi

fi

13. 创建目录结构

mkdir -p /u01/app

chown -R oracle:oinstall /u01/app

chmod -R 775 /u01/app

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1

export ORACLE_SID=orcl

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

14. runInstaller

-ignoreSysPrereqs