CentOs 6.4 x86_64 静默安装Oracle 11g R2

1、安装所需依赖包

官方文档中提及的依赖包如下：

binutils-2.20.51.0.2-5.11.el6 (x86_64)

compat-libcap1-1.10-1 (x86_64)

compat-libstdc++-33-3.2.3-69.el6 (x86_64)

compat-libstdc++-33-3.2.3-69.el6.i686

gcc-4.4.4-13.el6 (x86_64)

gcc-c++-4.4.4-13.el6 (x86_64)

glibc-2.12-1.7.el6 (i686)

glibc-2.12-1.7.el6 (x86_64)

glibc-devel-2.12-1.7.el6 (x86_64)

glibc-devel-2.12-1.7.el6.i686

ksh

libgcc-4.4.4-13.el6 (i686)

libgcc-4.4.4-13.el6 (x86_64)

libstdc++-4.4.4-13.el6 (x86_64)

libstdc++-4.4.4-13.el6.i686

libstdc++-devel-4.4.4-13.el6 (x86_64)

libstdc++-devel-4.4.4-13.el6.i686

libaio-0.3.107-10.el6 (x86_64)

libaio-0.3.107-10.el6.i686

libaio-devel-0.3.107-10.el6 (x86_64)

libaio-devel-0.3.107-10.el6.i686

make-3.81-19.el6

sysstat-9.0.4-11.el6 (x86_64)

可使用如下命令安装：

[root@hlyddbserver ~]# yum install gcc make binutils setarch compat-db libstdc++-devel unixODBA unixODBC-devel libaio-devel sysstat pdksh

2、配置内核参数

[root@hlyddbserver ~]#vim /etc/sysctl.conf

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

kernel.msgmnb = 65536

kernel.msgmax = 65536

kernel.shmmax = 17179869184

kernel.shmall = 2097152

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

fs.file-max = 6815744

fs.aio-max-nr = 1048576

net.ipv4.tcp_rmem = 4096 4194304 4194304

net.ipv4.tcp_wmem = 98304 4194304 4194304

net.ipv4.tcp_window_scaling = 1

net.core.rmem_default = 262144

net.core.wmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_max = 4194304

net.ipv4.ip_local_port_range = 9000 65500

运行如下命令使之生效

[root@hlyddbserver ~]#/sbin/sysctl –p

3、添加用户及用户组

[root@hlyddbserver ~]# groupadd oracleDba

[root@hlyddbserver ~]# groupadd oinstall

[root@hlyddbserver ~]# useradd oracle -g oinstall -G oracleDba

[root@hlyddbserver ~]# passwd oracle

4、建立目录并设置权限

[root@hlyddbserver ~]# mkdir -p /opt/oracle

[root@hlyddbserver ~]# chown -R oracle:oracleDba /opt/oracle/

[root@hlyddbserver ~]# chmod -R 755 /opt/oracle/

5、修改用户配置文件~/.bash_profile

ORACLE_BASE=/opt/oracle

ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1

ORACLE_SID=orcl

PATH=$ORACLE_HOME/bin:$PATH

ORACLE_OWNER=oracle

export ORACLE_UNQNAME=$ORACLE_SID

export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH ORACLE_OWNR

6、增加shell限制

为了提升性能增加oracle用户的shell限制.

[root@hlyddbserver ~]# vi /etc/security/limits.conf (在文件最后增加或修改以下参数)

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

[root@hlyddbserver ~]# vi /etc/pam.d/login (在文件最后增加或修改以下参数)

session required pam_limits.sosession

session required /lib64/security/pam_limits.so

[root@hlyddbserver ~]# vi /etc/profile (在文件最后增加或修改以下脚本)

if [ $USER = "oracle" ]; then

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

ulimit -p 16384

ulimit -n 65536

else

ulimit -u 16384 -n 65536

7、修改host文件

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 viti

::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 viti

8、切换到oracle用户，并复制响应文件，修改以下内容

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinsta ll_response_schema_v11_2_0

oracle.install.option=INSTALL_DB_SWONLY

ORACLE_HOSTNAME=hlyddbserver

UNIX_GROUP_NAME=oinstall

INVENTORY_LOCATION=/opt/oracle/oraInventory

SELECTED_LANGUAGES=en,zh_CN,zh_TW

ORACLE_HOME=/opt/oracle/product/11.2.0/dbhome_1

ORACLE_BASE=/opt/oracle

oracle.install.db.InstallEdition=EE

oracle.install.db.isCustomInstall=true

oracle.install.db.customComponents=oracle.server:11.2.0.1.0,oracl

https://www.360docs.net/doc/ff10006869.html,r:10.2.7.0.0,oracle.xdk:11.2.0.1.0,oracle.rdbms.oci:11.2.

0.1.0,https://www.360docs.net/doc/ff10006869.html,work:11.2.0.1.0,https://www.360docs.net/doc/ff10006869.html,work.listener:11.2.0.1.0,o

racle.rdbms:11.2.0.1.0,oracle.options:11.2.0.1.0,oracle.rdbms.partit

ioning:11.2.0.1.0,oracle.oraolap:11.2.0.1.0,oracle.rdbms.dm:11.2.0.1

.0,oracle.rdbms.dv:11.2.0.1.0,orcle.rdbms.lbac:11.2.0.1.0,oracle.rdb

ms.rat:11.2.0.1.0

oracle.install.db.DBA_GROUP=oracleDba

oracle.install.db.OPER_GROUP=oinstall

DECLINE_SECURITY_UPDATES=true

9、切换到安装目录下，然后运行如下命令安装

[root@hlyddbserver ~]#./runInstalle -silent -responseFile

/opt/database/response/db_install_swonly.rsp

10、运行完成之后会要求在root用户下运行命令，新开终端，拷贝命令运行

11、复制并修改静默安装建立数据库响应文件dbca.rsp,修改内容如下：

RESPONSEFILE_VERSION = "11.2.0" //不能更改

OPERATION_TYPE = "createDatabase"

GDBNAME = "hlyddb" //数据库的名字

SID = "orcl" //对应的实例名字

TEMPLATENAME = "General_Purpose.dbc" //建库用的模板文件

SYSPASSWORD = "password" //SYS管理员密码

SYSTEMPASSWORD = "passowrd" //SYSTEM管理员密码

DATAFILEDESTINATION = /db //数据文件存放目录

RECOVERYAREADESTINATION=/db_bak //恢复数据存放目录

CHARACTERSET = "ZHS16GBK" //字符集，重要!!! 建库后一般不能更改，所以建库前要确定清楚。

TOTALMEMORY = "24576" //oracle内存

12、运行如下命令安装数据库

[root@hlyddbserver ~]# dbca -silent -responseFile

-createDatabase/opt/database/response/dbca_orcl.rsp

13、配置监听，这里使用默认的netca.rsp文件就可以了（这里需要运行两次，

第一次运行会报错，第二次就好了，不知道为啥）

[root@hlyddbserver ~]# netca /silent /responsefile

/usr/local/oracle/database/response/netca.rsp

14、修改

/opt/oracle/product/11.2.0/dbhome_1/network/admin/listener.or

a,内容如下：

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.210.248)(PORT = 1521))

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = orcl)

(ORACLE_HOME =/opt/oracle/product/11.2.0/dbhome_1)

(SID_NAME = orcl)

)

ADR_BASE_LISTENER = /opt/oracle

15、运行如下命令，启动监听

[root@hlyddbserver ~]#lsnrctl start