Linux下的Oracle 11gR2静默安装心得笔记

[root@ora11g ~]# vi /etc/hosts

192.168.100.123    ora11g

[root@ora11g ~]# df -h

[root@ora11g ~]# mount /dev/sr0 /mnt/

[root@ora11g ~]# touch /etc/yum.repos.d/redhat.repo[root@ora11g ~]# vi /etc/yum.repos.d/redhat.repo

[Sever]
name=redhat6.5           #自定义名称
baseurl=file:///mnt/     #本地光盘挂载路径
enabled=1                #启用 yum 源，0 为不启用，1 为启用
gpgcheck=0               #检查 GPG-key，0 为不启用

vi /etc/yum.conf

[root@ora11g ~]#yum install compat-libcap*  
 
  [root@ora11g ~]#yum install compat-libstdc++-33*  
 
  [root@ora11g ~]#yum install compat-libstdc++-33*.i686  
  
  [root@ora11g ~]#yum install gcc*
 
  [root@ora11g ~]#yum install glibc-devel-*.i686
 
  [root@ora11g ~]#yum install libstdc++-devel*.i686
 
  [root@ora11g ~]#yum install libaio*.i686
 
  [root@ora11g ~]#yum install libaio-devel*
 
  [root@ora11g ~]#yum install unixODBC*
 
  [root@ora11g ~]#yum install unixODBC*.i686  [root@ora11g ~]#yum install ksh

[root@ora11g ~]#rpm -q binutils compat-libcap1 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh
 
[root@ora11g ~]#rpm -q libgcc libstdc++ libstdc++-devel libaio libaio-devel make sysstat unixODBC unixODBC-devel

[root@ora11g ~]# vi /etc/sysctl.conf

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

[root@ora11g ~]# vi /etc/security/limits.conf

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

[root@ora11g ~]# vi /etc/pam.d/login

session required /lib64/security/pam_limits.so
session required pam_limits.so

[root@ora11g ~]# vi /etc/profile

if [$USER = "oracle" ]; then
if [$SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi

[root@ora11g ~]# vi /etc/selinux/config

[root@ora11g ~]# groupadd oinstall
 
[root@ora11g ~]# groupadd dba
 
[root@ora11g ~]# useradd -g oinstall -G dba oracle
 
[root@ora11g ~]# passwd oracle
 
## 之后会输入两次 oracle 密���

[root@ora11g ~]# mkdir -p /u01/app/oracle
 
[root@ora11g ~]# chown -R oracle:oinstall /u01/app/

[root@ora11g ~]# su - oracle

[oracle@ora11g ~]$ vi .bash_profile

export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_SID=ora11g
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib

[root@ora11g ~]# mv /home/database/ /u01/
 
[root@ora11g ~]# chown -R oracle:oinstall database/
 
[root@ora11g ~]# chmod -R 777 database/

[root@ora11g ~]# vi /u01/database/response/db_install.rsp

oracle.install.option=INSTALL_DB_SWONLY          #选择安装类型：1. 只装数据库软件 2. 安装数据库软件并建库 3. 升级数据库
 
ORACLE_HOSTNAME=ora11g                           #指定操作系统主机名，通过 hostname 命令获得
 
UNIX_GROUP_NAME=oinstall                         #指定 oracle inventory 目录的所有者，通常会是 oinstall 或者 dba
 
INVENTORY_LOCATION=/u01/app/oraInventory         #指定产品清单 oracle inventory 目录的路径
 
SELECTED_LANGUAGES=en,zh_CN,zh_TW                #指定数据库语言，可以选择多个，用逗号隔开
 
ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1  #设置 ORALCE_HOME 的路径
 
ORACLE_BASE=/u01/app/oracle                      # 设置 ORALCE_BASE 的路径
 
oracle.install.db.InstallEdition=EE              #选择 Oracle 安装数据库软件的版本
 
oracle.install.db.isCustomInstall=false
 
oracle.install.db.DBA_GROUP=dba                  #指定拥有 OSDBA、OSOPER 权限的用户组，通常会是 dba 组
 
oracle.install.db.OPER_GROUP=oinstall
 
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE      #选择数据库的用途，一般用途 /事物处理，数据仓库
 
oracle.install.db.config.starterdb.globalDBName=ora11g       #指定 GlobalName
 
oracle.install.db.config.starterdb.SID=ora11g                #指定 SID
 
oracle.install.db.config.starterdb.characterSet=ZHS16GBK     #选择字符集。不正确的字符集会给数据显示和存储带来麻烦无数。#通常中文选择的有 ZHS16GBK 简体中文库，根据公司规定自行选择
oracle.install.db.config.starterdb.password.ALL=123456       #设定所有数据库用户使用同一个密码，其它数据库用户就不用单独设置了。DECLINE_SECURITY_UPDATES=true                   # False 表示不需要设置安全更新，注意，在 11.2 的静默安装中疑似有一个 BUG
                                                # Response File 中必须指定为 true，否则会提示错误, 不管是否正确填写了邮件地址

[oracle@ora11g ~]$ cd /u01/database/
 
[oracle@ora11g database]$ ./runInstaller -silent -ignorePrereq responseFile /u01/database/response/db_install.rsp

出现类似如下提示表示安装完成：#-------------------------------------------------------------------
.../u01/app/oraInventory/orainstRoot.sh
/u01/app/oracle/product/11.2.0/db_1/root.sh
To execute the configuration scripts:
1. Open a terminal window 
2. Log in as "root" 
3. Run the scripts 
4. Return to this window and hit "Enter" key to continue
 
Successfully Setup Software.
#-------------------------------------------------------------------

[root@ora11g ~]#  /u01/app/oraInventory/orainstRoot.sh
[root@ora11g ~]#  /u01/app/oracle/product/11.2.0/db_1/root.sh

[oracle@ora11g ~]$ /u01/app/oracle/product/11.2.0/db_1/bin/netca /silent /responseFile /u01/database/response/netca.rsp

[root@ora11g ~]# vi /u01/database/response/dbca.rsp

# 以下内容不要修改
RESPONSEFILE_VERSION = "11.2.0"
 
OPERATION_TYPE = "createDatabase"
 
#以下内容必须设置
 
GDBNAME = "ora11g"
 
SID = "ora11g"
 
TEMPLATENAME = "General_Purpose.dbc"
 
#以下内容根据需要修改
 
CHARACTERSET = "ZHS16GBK"

[oracle@ora11g ~]$ /u01/app/oracle/product/11.2.0/db_1/bin/dbca -silent -responseFile /u01/database/response/dbca.rsp

Copying database files
 
...
 
37% complete
 
Creating and starting Oracle instance
 
...
 
62% complete
 
Completing Database Creation
 
...
 
100% complete
 
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/ORCL/ORCL.log" for further details.