快速在Centos7上静默安装oracle11.2.4 单机单实例

一、规划

如果实例准备搭建dataguard环境，根据实际配置，db_unique_name必须与其他实例不一样，其他name一致。

准备工作

1.安装依赖

#centos7安装依赖
yum install -y binutils compat-libcap1 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel libaio libaio-devel libgcc libstdc++ libstdc++-devel libXi libXtst make sysstat unixODBC unixODBC-devel

2.添加host解析

echo "192.168.1.10 server10" >> /etc/hosts

3.创建oracle用户和组

groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle
passwd oracle

3.切换到oracle修改环境变量

su - oracle 
[root@server10]$ vim ~/.bash_profile 
export ORACLE_BASE=/u02/oracle
export ORACLE_HOME=/u02/oracle/11.2.0
export ORACLE_UNQNAME=caiwupri
export ORACLE_SID=caiwudb
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export PATH=/u02/oracle/11.2.0/bin:$PATH

安装过程

1.上传安装包到/tools/并解压。

[root@server10 tools]$ cd /tools/
[root@server10 tools]unzip p13390677_112040_Linux-x86-64_1of7.zip
[root@server10 tools]unzip p13390677_112040_Linux-x86-64_2of7.zip

2.#把安装目录的属主设为oracle，切换到oracle用户下编辑响应文件。

[oracle@server10]$ chown -R oracle.oinstall /tools/database
[oracle@server10]$ cd /toos/database/response
[oracle@server10]$vim response/db_install.rsp
#db_install.rsp响应文件说明
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
oracle.install.option=INSTALL_DB_SWONLY 
ORACLE_HOSTNAME=server49
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u02/oraInventory
SELECTED_LANGUAGES=en,zh_CN
ORACLE_HOME=/u02/oracle/11.2.0
ORACLE_BASE=/u02/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.EEOptionsSelection=false
oracle.install.db.optionalComponents=oracle.rdbms.partitioning:11.2.0.4.0,oracle.oraolap:11.2.0.4.0,oracle.rdbms.dm:11.2.0.4.0,oracle.rdbms.dv:11.2.0.4.0,oracle.rdbms.lbac:11.2.0.4.0,oracle.rdbms.rat:11.2.0.4.0
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=dba
oracle.install.db.CLUSTER_NODES=
oracle.install.db.isRACOneInstall=
oracle.install.db.racOneServiceName=
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
oracle.install.db.config.starterdb.globalDBName=caiwudb
oracle.install.db.config.starterdb.SID=caiwudb
oracle.install.db.config.starterdb.characterSet=AL32UTF8
oracle.install.db.config.starterdb.memoryOption=true
oracle.install.db.config.starterdb.memoryLimit=51200
oracle.install.db.config.starterdb.installExampleSchemas=false
oracle.install.db.config.starterdb.enableSecuritySettings=true
oracle.install.db.config.starterdb.password.ALL=123456
oracle.install.db.config.starterdb.password.SYS=
oracle.install.db.config.starterdb.password.SYSTEM=
oracle.install.db.config.starterdb.password.SYSMAN=
oracle.install.db.config.starterdb.password.DBSNMP=
oracle.install.db.config.starterdb.control=DB_CONTROL
oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=
oracle.install.db.config.starterdb.automatedBackup.enable=false
oracle.install.db.config.starterdb.automatedBackup.osuid=
oracle.install.db.config.starterdb.automatedBackup.ospwd=
oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGE
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=/u02/oracle/oradata/   （若安装选项为INSTALL_DB_SWONLY，可空）
oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=/u02/oracle/recovery/（若安装选项为INSTALL_DB_SWONLY，可空）
oracle.install.db.config.asm.diskGroup=
oracle.install.db.config.asm.ASMSNMPPassword=
MYORACLESUPPORT_USERNAME=
MYORACLESUPPORT_PASSWORD=
SECURITY_UPDATES_VIA_MYORACLESUPPORT=
DECLINE_SECURITY_UPDATES=true
PROXY_HOST=
PROXY_PORT=
PROXY_USER=
PROXY_PWD=
PROXY_REALM=
COLLECTOR_SUPPORTHUB_URL=
oracle.installer.autoupdates.option=SKIP_UPDATES
oracle.installer.autoupdates.downloadUpdatesLoc=
AUTOUPDATES_MYORACLESUPPORT_USERNAME=
AUTOUPDATES_MYORACLESUPPORT_PASSWORD=

#-silent必须指定绝对路径
[oracle@server10 database]$./runInstaller -silent  -responseFile /tools/oracle/database/response/db_install.rsp

#另开窗口以root用户执行以下两个脚本。无错会提示Successfully Setup Software.
As a root user, execute the following script(s):
        1. /u01/oraInventory/orainstRoot.sh
        2. /u01/oracle/product/11.2.0/db_1/root.sh

创建实例

编辑dbca响应文件

[oracle@server10 response]$ vim dbca.rsp
[GENERAL]
RESPONSEFILE_VERSION = "11.2.0"
OPERATION_TYPE = "createDatabase"
[CREATEDATABASE]
GDBNAME = "caiwupri"
SID = "caiwudb"
TEMPLATENAME = "General_Purpose.dbc"
DATAFILEDESTINATION =/data/oracle
RECOVERYAREADESTINATION=/data/oracle/arch
STORAGETYPE=FS

CHARACTERSET = "AL32UTF8"
NATIONALCHARACTERSET= "AL32UTF8"

[oracle@server10 response]$ dbca -silent -responseFile /tools/database/response/dbca.rsp

创建监听

#netcat.rap无需修改直接默认即可。
[oracle@server10 response]$ netca -silent -responsefile /tools/database/response/netca.rsp

安装后检查

1.默认数据库和监听创建后是启动状态

[oracle@server10 response]$ lsnrctl status

2.检查实例状态

[oracle@server10 response]$ sqlplus / as sysdba
sql> select open_mode,DB_UNIQUE_NAME from v$database;

OPEN_MODE            DB_UNIQUE_NAME
-------------------- ------------------------------
READ WRITE           caiwupri