linux安装oracle11gR2

制作本地镜像

mkdir /media/cdrom
mount -o loop -t iso9660 /home/hadoop/Downloads/rhel-server-7.0-x86_64-dvd.iso /media/cdrom/
vi /etc/yum.repo.d/redhat-base.repo

[redhat-base]
name=redhat-base
baseurl=file:///media/cdrom
gpgcheck=0
enable=1

修改系统参数

vi /etc/sysctl.conf

fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 980742144
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

sysctl -p//生效

修改系统参数

vi /etc/security/limits.conf

oracle  soft    nofile  1024
oracle  hard    nofile  65536
oracle  soft    nproc   2047
oracle  hard    nproc   16384
oracle  soft    stack   10240
oracle  hard    stack   32768

设置环境变量

vi /home/oracle/.bash_profile

export PATH
export ORACLE_BASE=/opt/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_SID=orcl
export ORACLE_TERM=xterm
export PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export LANG=""
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export DISPLAY=:0.0

添加用户和用户组

groupadd dba
groupadd oinstall
useradd -g oinstall -G dba oracle
passwd oracle

配置安装目录和权限

mkdir -p /opt/app/oracle
mkdir -p /opt/app/oraInventory
chown -R oracle:oinstall /opt/app
chmod 755 /opt/app

安装依赖（检测安装）

rpm -qa --qf "%{NAME}-%{VERSION}-%{RELEASE}-%{ARCH}\n" binutils \
compat-libstdc++-33 compat-db control-center elfutils-libelf elfutils-libelf-devel gcc \
gcc-c++ glibc glibc-common glibc-devel libaio libaio-devel libgcc libstdc++ \
libstdc++-devel make sysstat unixODBC glibc-headers unixODBC-devel \
oracleasm oracleasmlib oracleasm-support \
pdksh sysstat xscreensaver | grep not | awk '{print "yum install -y " $2 }'

也可以直接安装

yum install -y compat-libstdc++-33 elfutils-libelf-devel gcc gcc-c++ glibc-devel
yum install -y ksh libaio-devel numactl-devel
yum install -y unixODBC unixODBC-devel oracleasm oracleasmlib oracleasm-support

解压

unzip linux_11gR2_database_1of2.zip -d /opt/app/database/
unzip linux_11gR2_database_2of2.zip -d /opt/app/database/
chown -R oracle:oinstall /opt/app/database/database/

//增加虚拟内存->2.67G

dd if=/dev/zero of=/home/swap bs=1024 count=1024000
mkswap /home/swap
swapon /home/swap

进入目录开始安装

cd /opt/app/database/database
./runInstaller

//出错解决办法

./runInstaller: /opt/app/database/install/.oui: /lib/ld-linux.so.2: bad ELF interpreter: No such file or directory

yum install -y ld-linux.so.2
yum install -y libXext.i686

//启动数据库配置

dbca

//配置数据库监听器

netca

链接数据库

sqlplus /nolog
conn sys as sysdba
sqlplus sys/123456 as sysdba;
startup