oracle11g + centos6.5 靜默安裝

作業系統centos6.5
oracle:11g
一、檢查安裝oracle所需的rpm包

二、環境配置

ROOT使用者下操作
1）修改使用者的SHELL的限制，修改/etc/security/limits.conf檔案
[root@localhost /]# vi /etc/security/limits.conf
新增以下內容
oracle   soft    nproc    2047
oracle   hard    nproc    16384
oracle   soft    nofile     1024
oracle   hard    nofile    65536

2）修改/etc/pam.d/login 檔案
[root@localhost /]# vi /etc/pam.d/login
新增以下內容
session   required    pam_limits.so

3）修改/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

4）修改linux核心，修改/etc/sysctl.conf檔案。
[root@localhost /]# vi /etc/sysctl.conf
fs.file-max = 6815744 
fs.aio-max-nr = 1048576 
kernel.shmall = 2097152 
kernel.shmmax = 2147483648 
kernel.shmmni = 4096 
kernel.sem = 250 32000 100 128 
net.ipv4.ip_local_port_range = 9000 65500 
net.core.rmem_default = 4194304 
net.core.rmem_max = 4194304 
net.core.wmem_default = 262144 
net.core.wmem_max = 1048576
 
5）要使/etc/sysctl.conf 更改立即生效，執行以下命令。

[root@localhost etc]# sysctl -p
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
error: "net.bridge.bridge-nf-call-ip6tables" is an unknown key
error: "net.bridge.bridge-nf-call-iptables" is an unknown key
error: "net.bridge.bridge-nf-call-arptables" is an unknown key
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 68719476736
kernel.shmall = 4294967296
fs.file-max = 6815744
fs.aio-max-nr = 1048576
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576

6）建立相關使用者和組
[root@localhost ~]# groupadd oinstall
[root@localhost ~]# groupadd dba
[root@localhost ~]# groupadd oper
[root@localhost ~]# useradd -g oinstall -G dba oracle
[root@localhost ~]# passwd oracle


7）建立oracle安裝資料夾
[root@localhost ~]# mkdir -p /u01/app/oracle/product/11.2/db_1
[root@localhost ~]# mkdir -p /u01/oraInventory
[root@localhost ~]# chown -R oracle:oinstall /u01/
[root@localhost ~]# chmod -R 775 /u01/


8）配置
[root@localhost ~]# vi /home/oracle/.bash_profile
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=$ORACLE_BASE/product/11.2/db_1
ORACLE_SID=orcl
PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH




oracle 使用者 生效環境變數
source ~/.bash_profile


9)檢查網路 
/etc/hosts
/etc/sysconfig/network
/etc/sysconfig/network-scripts/ifcfg-eth0

三 配置應答檔案db_install.rsp
應答檔案的預設模板目錄response在解壓後database目錄下。
主要配置內容如下：
oracle.install.option --安裝型別
 1.只裝資料庫軟體（INSTALL_DB_SWONLY） 2.安裝資料庫軟體並建庫(INSTALL_DB_AND_CONFIG) 3.升級資料庫 (UPGRADE_DB)
oracle.install.option=   INSTALL_DB_SWONLY

指定作業系統主機名，透過hostname命令獲得
ORACLE_HOSTNAME=oracle

指定oracle inventory 目錄的所有者通常是oinstall 或dba
UNIX_GROUP_NAME=oinstall

指定產品清單oracle inventory目錄路徑，win平臺可以省略
INVENTORY_LOCATION=

指定資料庫語言，可以選擇多個，用逗號隔開。選擇en，zh_CH
SELECTED_LANGUAGES=en,zh_CH

設定ORACLE_HOME的路徑
ORACLE_HOME=

設定ORACLE_BASE的路徑
ORACLE_BASE=

選擇Oracle安裝資料庫軟體版本
oracle.install.db.InstallEdition=

指定擁有OSDBA、OSOPER許可權使用者組，通常回事dba組
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=oinstall

如果是安裝RAC，在這裡指定所有節點
oracle.install.db.CLUSTER_NODES=node1,node2

[oracle@oracle database]$ ./runInstaller -silent -responseFile /soft/database/response/db_install.rsp

建立監聽
[oracle@oracle /]$ netca /silent /responsefile /u01/database/response/netca.rsp 

Parsing command line arguments:
    Parameter "silent" = true
    Parameter "responsefile" = /u01/database/response/netca.rsp
Done parsing command line arguments.
Oracle Net Services Configuration:
Profile configuration complete.
Oracle Net Listener Startup:
    Running Listener Control: 
      /u01/app/oracle/product/11.2.0/db_1/bin/lsnrctl start LISTENER
    Listener Control complete.
    Listener started successfully.
Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0

[oracle@oracle /]$ dbca -silent -responseFile /u01/database/response/dbca.rsp 
Enter SYS user password: 
 
Enter SYSTEM user password: 
 
Copying database files
1% complete
3% complete
11% complete
18% complete
26% complete
37% complete
Creating and starting Oracle instance
40% complete
45% complete
50% complete
55% complete
56% complete
60% complete
62% complete
Completing Database Creation
66% complete
70% complete
73% complete
85% complete
96% complete
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/orcl11g/orcl11g.log" for further details.