虚拟机下安装oracle

1.配置内核参数

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 = 1048576

2.使配置参数生效

sysctl -p

3.设置用户的资源限制

vi /etc/security/limits.conf

增加如下参数设置:

oracle              soft    nproc   2047

oracle              hard    nproc   16384

oracle              soft    nofile  1024

oracle              hard    nofile  65536

oracle              soft    stack   10240

4.创建相关目录

--存放oracle软件

mkdir -p /u01/app/oracle/product/11.2.0/db1

--存放oracle安装程序

mkdir /orasoft

--存放补丁包

mkdir rpm

--挂载光驱目录

mkdir /mnt/cdrom

5.创建组和用户,赋予用户目录权限

groupadd oinstall

groupadd dba

useradd -g oinstall -G dba oracle

passwd oracle

chown -R oracle.dba /u01

6.设置环境变量(oracle下的)

vi .bash_profile

export ORACLE_SID=db1

export ORACLE_BASE=/u01/oracle

export ORACLE_HOME=/u01/oracle/db1

export PATH=$ORACLE_HOME/bin:$PATH

export EDITOR=vi

stty erase ^h

7.使环境变量设置生效

source .bash_profile

8.挂载光驱

mount /dev/cdrom /mnt/cdrom

9.拷贝安装目录

cp -r /mnt/cdrom/database /orasoft/

10.卸载光驱

umount /dev/cdrom

11.设置目录权限

chown -R oracle.dba /orasoft/

12.设置hosts文件

vi /etc/hosts

192.168.0.100   node1

13.去掉多余服务

export LANG=en

setup

system service --> run tools

去掉ip5tables,sendmail

14.开启vncserver(oracle)

vncserver

15.安装包

rpm -q binutils compat-libstdc++- elfutils-libelf elfutils-libelf-devel elfutils-libelf-devel-static gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers kernel-headers ksh libaio libaio-devel libgcc libgomp libstdc++ libstdc++-devel make sysstat

compat-libstdc

libaio-devel

sysstat

rpm -ivh sysstat

16.通过vnc安装oracle

http://170.170.200.102:5801/

17.字符集选择