Shulou(Shulou.com)06/01 Report--

1. Download Oracle 11g

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

2. System environment

free -h

file mode add swap handover partition

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

3, check the system is not installed dependency package

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. Set Linux kernel parameters

Fixed/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

Make Configuration Effective #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

Create user groups and folders

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. Edit oracle static installation file db_install.rsp

./ runInstaller -silent -responseFile /db_install.rsp

create a library

dbca -silent -createdatabase -responseFile /dbca.rsp

delete library

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.