10g安裝
配置YUM源（國(guó)內(nèi)阿里的還不錯(cuò)翘贮，也可以配置掛載的yum源）
yum install -y binutils compat-db control-center gcc* glibc libXp libstdc++ libstdc++-devel make openmotif sysstat control-center
root用戶設(shè)置內(nèi)核參數(shù)
vi /etc/sysctl.conf
kernel.shmall = 2097152(共享內(nèi)存,單位是頁(yè)面數(shù)坠陈，每個(gè)頁(yè)面數(shù)是4K格二，就是塊大小璧诵，操作系統(tǒng)ext3的盛正，一個(gè)塊是4K宣决，設(shè)置共享內(nèi)存8G，官方推薦值，生產(chǎn)中可以自行改大冲呢，8GB/4KB=8388608KB /4KB=2097152（頁(yè)）)
kernel.shmmax = 2147483648 (單個(gè)共享內(nèi)存段的最大尺寸，單位字節(jié)招狸，單次提取最多2G敬拓，不是數(shù)據(jù)倉(cāng)庫(kù)完全夠用2G=210241024*1024(byte))
kernel.sem = 250 32000 100 128 (信號(hào)量)
fs.file-max = 65536 (文件句柄的最大數(shù)量)
net.ipv4.ip_local_port_range = 1024 65000 (端口范圍)
net.core.rmem_default = 262144(默認(rèn)讀內(nèi)存大小)
net.core.rmem_max = 262144(讀內(nèi)存最大值)
net.core.wmem_default = 262144(默認(rèn)寫存大小)
net.core.wmem_max = 262144(寫內(nèi)存最大值)修改Linux版本號(hào)
vi /etc/redhat-release (修改版本號(hào)，oracle10g只支持到redhat版本4裙戏，如果不修改乘凸，檢測(cè)安裝環(huán)境會(huì)報(bào)錯(cuò))
Red Hat Enterprise Linux Server release 3 (Tikanga)）-
使內(nèi)核生效
vi /etc/security/limits.conforacle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 #core - 限制內(nèi)核文件的大小
#date - 最大數(shù)據(jù)大小
#fsize - 最大文件大小
#memlock - 最大鎖定內(nèi)存地址空間
#nofile - 打開文件的最大數(shù)目
#rss - 最大持久設(shè)置大小
#stack - 最大棧大小
#cpu - 以分鐘為單位的最多 CPU 時(shí)間
#noproc - 進(jìn)程的最大數(shù)目
#as - 地址空間限制
#maxlogins - 此用戶允許登錄的最大數(shù)目)
```
/sbin/sysctl –p
vi /etc/pam.d/login
在下面添加以下信息
session required /lib/security/pam_limits.so
用戶環(huán)境變量
groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle
passwd oracle
su -l oracle
vi .bash_profile
stty erase ^H //刪除鍵
ORACLE_BASE=/oracle/app
ORACLE_HOME=$ORACLE_BASE/oracle/product/10.2.0/db_1 //家目錄
ORACLE_SID=ecom //實(shí)例名（與Oracle實(shí)例名相同）
PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK //字符集
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH LD_LIBRARY_PATH NLS_LANG
source .bash_profile-
開始安裝
mkdir -p /oracle/app
chmod 777 /oracle
chown -R oracle:oinstall /oracle
unzip oracle_database_linux32.zip
在上面圖片出來(lái)之后 切換到root下執(zhí)行以下腳本
按ok 退出
-
輸入dbca 進(jìn)入安裝
11g腳本安裝
- prepare.sh
#!/bin/sh
cat <<EOF > /etc/sysconfig/network
NETWORKING=yes
HOSTNAME=DB88
EOF
hostname DB88
cat <<EOF > /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.8.88 DB88
EOF
`sed -i 's/ONBOOT=no/ONBOOT=yes/g' /etc/sysconfig/network-scripts/ifcfg-eth0`
service iptables stop
setenforce 0
`sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config`
yum -y install binutils-* \
compat-libstdc++-* \
compat-libcap1-* \
elfutils-libelf-* \
elfutils-libelf-devel-* \
gcc* \
gcc-c++-* \
glibc* \
glibc-common-* \
glibc-devel-* \
glibc-headers-* \
ksh-* \
libaio-* \
libaio-devel-* \
libgcc-* \
libstdc++-* \
libstdc++-devel* \
make-* \
sysstat-* \
unixODBC-* \
unixODBC-devel-* \
numactl-devel-* \
pdksh-* \
kernel-headers* \
wget
groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle
echo "oracle" | passwd --stdin oracle
echo "umask 022" >>/home/oracle/.bash_profile
echo "stty erase ^H" >>/home/oracle/.bash_profile
echo "PATH=\$PATH:\$HOME/bin" >>/home/oracle/.bash_profile
echo "TMP=/tmp" >>/home/oracle/.bash_profile
echo "TMPDIR=\$TMP" >>/home/oracle/.bash_profile
echo "ORACLE_BASE=/home/oracle/app/oracle" >>/home/oracle/.bash_profile
echo "ORACLE_HOME=\$ORACLE_BASE/product/11.2.0/db_1" >>/home/oracle/.bash_profile
echo "ORACLE_SID=ecom" >>/home/oracle/.bash_profile
echo "ORACLE_TERM=xterm" >>/home/oracle/.bash_profile
echo "PATH=\$PATH:\$HOME/bin:\$ORACLE_HOME/bin" >>/home/oracle/.bash_profile
echo "LD_LIBRARY_PATH=\$ORACLE_HOME/lib:/lib:/usr/lib" >>/home/oracle/.bash_profile
echo "CLASSPATH=\$ORACLE_HOME/JRE:\$ORACLE_HOME/jlib:\$ORACLE_HOME/rdbms/jlib" >>/home/oracle/.bash_profile
echo 'NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"'>>/home/oracle/.bash_profile
echo "NLS_LANG=AMERICAN_AMERICA.ZHS16GBK" >>/home/oracle/.bash_profile
echo "export EDITOR=vi" >>/home/oracle/.bash_profile
echo "export TMP TMPDIR ORACLE_TERM CLASSPATH NLS_DATE_FORMAT ORACLE_BASE ORACLE_HOME ORACLE_SID PATH LD_LIBRARY_PATH NLS_LANG EDITOR" >>/home/oracle/.bash_profile
mkdir -p /home/oracle/app/oracle
chmod -R 777 /home/oracle/app/oracle
chown -R oracle:oinstall /home/oracle
cd /tmp
unzip linux.x64_11gR2_database_1of2.zip
unzip linux.x64_11gR2_database_2of2.zip
rm -rf linux.x64_11gR2_database_1of2.zip linux.x64_11gR2_database_2of2.zip
chmod -R 777 /tmp/database
chown -R oracle.oinstall /tmp/database
- prelimits.sh
#!/bin/bash
#Purpose:Change the /etc/security/limits.conf.
#Usage:Log on as the superuser('root'),and then execute the command:#./prelimits.sh
#Author:TJ
echo "Now modify the /etc/security/limits.conf,but backup it named /etc/security/limits.conf.bak before"
cp /etc/security/limits.conf /etc/security/limits.conf.bak
echo "oracle soft nproc 2047" >>/etc/security/limits.conf
echo "oracle hard nproc 16384" >>/etc/security/limits.conf
echo "oracle soft nofile 1024" >>/etc/security/limits.conf
echo "oracle hard nofile 65536" >>/etc/security/limits.conf
echo "grid soft nproc 2047" >>/etc/security/limits.conf
echo "grid hard nproc 16384" >>/etc/security/limits.conf
echo "grid soft nofile 1024" >>/etc/security/limits.conf
echo "grid hard nofile 65536" >>/etc/security/limits.conf
echo "Modifing the /etc/security/limits.conf has been succeed."
- prelogin.sh
#!/bin/bash
#Purpose:Modify the /etc/pam.d/login.
#Usage:Log on as the superuser('root'),and then execute the command:#./prelimits.sh
#Author:TJ
echo "Now modify the /etc/pam.d/login,but with a backup named /etc/pam.d/login.bak"
cp /etc/pam.d/login /etc/pam.d/login.bak
echo "session required /lib/security/pam_limits.so" >>/etc/pam.d/login
echo "session required pam_limits.so" >>/etc/pam.d/login
echo "Modifing the /etc/pam.d/login has been succeed."
- preprofile.sh
#!/bin/bash
#Purpose:Modify the /etc/profile.
#Usage:Log on as the superuser('root'),and then execute the command:#./preprofile.sh
#Author:TJ
echo "Now modify the /etc/profile,but with a backup named /etc/profile.bak"
cp /etc/profile /etc/profile.bak
echo 'if [ $USER = "oracle" ]||[ $USER = "grid" ]; then' >> /etc/profile
echo 'if [ $SHELL = "/bin/ksh" ]; then' >> /etc/profile
echo 'ulimit -p 16384' >> /etc/profile
echo 'ulimit -n 65536' >> /etc/profile
echo 'else' >> /etc/profile
echo 'ulimit -u 16384 -n 65536' >> /etc/profile
echo 'fi' >> /etc/profile
echo 'fi' >> /etc/profile
echo "Modifing the /etc/profile has been succeed."
- presysctl.sh
#!/bin/bash
#Purpose:Modify the /etc/sysctl.conf.
#Usage:Log on as the superuser('root'),and then execute the command:#./6presysctl.sh
#Author:TJ
echo "Now modify the /etc/sysctl.conf,but with a backup named /etc/sysctl.bak"
cp /etc/sysctl.conf /etc/sysctl.conf.bak
echo "fs.aio-max-nr = 1048576" >> /etc/sysctl.conf
echo "fs.file-max = 6815744" >> /etc/sysctl.conf
echo "kernel.shmall = 2097152" >> /etc/sysctl.conf
echo "kernel.shmmax = 1054472192" >> /etc/sysctl.conf
echo "kernel.shmmni = 4096" >> /etc/sysctl.conf
echo "kernel.sem = 250 32000 100 128" >> /etc/sysctl.conf
echo "net.ipv4.ip_local_port_range = 9000 65500" >> /etc/sysctl.conf
echo "net.core.rmem_default = 262144" >> /etc/sysctl.conf
echo "net.core.rmem_max = 4194304" >> /etc/sysctl.conf
echo "net.core.wmem_default = 262144" >> /etc/sysctl.conf
echo "net.core.wmem_max = 1048586" >> /etc/sysctl.conf
echo "net.ipv4.tcp_wmem = 262144 262144 262144" >> /etc/sysctl.conf
echo "net.ipv4.tcp_rmem = 4194304 4194304 4194304" >> /etc/sysctl.conf
echo "Modifing the /etc/sysctl.conf has been succeed."
echo "Now make the changes take effect....."
/sbin/sysctl -p
