Oracle Database 11g 部署實錄

標籤：oracle

[[email protected] ~]# yum -y install \

binutils \

elfutils-libelf \

elfutils-libelf-devel \

elfutils-libelf-devel-static \

gcc \

gcc-c++ \

glibc \

glibc-common \

glibc-devel \

glibc-headers \

ksh \

libaio \

libaio-devel \

libstdc++ \

libstdc++-devel \

make \

sysstat \

unixODBC \

unixODBC-devel  

[[email protected] ~]# yum -y install compat-libstdc++*

[[email protected] ~]# rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' binutils \

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 \

unixODBC \

unixODBC-devel

[[email protected] ~]# rpm -qa 'compat-libstdc++*'  

[[email protected] ~]# groupadd oinstall

[[email protected] ~]# groupadd dba

[[email protected] ~]# useradd -g oinstall -G dba oracle

[[email protected] ~]# echo oracle | passwd --stdin oracle

[[email protected] ~]# cat >> /etc/sysctl.conf <<EOF

kernel.shmmni = 4096

fs.aio-max-nr = 1048576

fs.file-max = 6815744

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

EOF

[[email protected] ~]# sysctl -p

[[email protected] ~]# cat >> /etc/security/limits.conf <<EOF

oracle              soft    nproc   2047

oracle              hard    nproc   16384

oracle              soft    nofile  1024

oracle              hard    nofile  65536

oracle              soft    stack   10240

EOF

[[email protected] ~]# cat >> /etc/pam.d/login <<EOF

session    required     pam_limits.so

EOF

[[email protected] ~]# cat >> /etc/profile <<EOF

if [ $USER = "oracle" ]; then

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

              ulimit -p 16384

              ulimit -n 65536

        else

              ulimit -u 16384 -n 65536

        fi

fi

EOF

[[email protected] ~]# mkdir -p /u01/app/oracle

[[email protected] ~]# chown -R oracle:oinstall /u01/app

[[email protected] ~]# chmod -R 775 /u01/app

[[email protected] ~]# su - oracle

[[email protected] ~]$ vi .bash_profile 

export ORACLE_SID=king

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1

export PATH=$ORACLE_HOME/bin:$PATH

export DISPLAY=192.168.1.99:0

export NLS_LANG=AMERICAN_AMERICA.UTF8

stty erase ^H

[[email protected] ~]$ source .bash_profile

[[email protected] ~]$ unzip p13390677_112040_Linux-x86-64_1of7.zip 

[[email protected] ~]$ unzip p13390677_112040_Linux-x86-64_2of7.zip

[[email protected] ~]$ cd database/stage/cvu/cv/admin

[[email protected] admin]$ vi cvu_config

change CV_ASSUME_DISTID=OEL4 to CV_ASSUME_DISTID=OEL6

[[email protected] ~]$ cd database

[[email protected] database]$ ./runInstaller

[[email protected] ~]# /u01/app/oraInventory/orainstRoot.sh

[[email protected] ~]# /u01/app/database/11.2.0.4/product/root.sh

Oracle Database 11g 部署實錄