作者:david_zhang@sh 【转载时请以超链接形式标明文章】
链接:http://www.cnblogs.com/david-zhang-index/p/4182469.html
本文适用Oracle 11.2.0.1 64bit for RHEL6.0 Server x86_64平台
[root@xxx ~]# service iptables stop
2.交换分区及内存分配
AVAILABLE RAM SWAP SPACE REQUIRED Between 1 GB and 2 GB 1.5 times the size of the RAM Between 2 GB and 16 GB Equal to the size of the RAM More than 16 GB 16 GB
3.共享内存分配
[root@xxx ~]# df -h /dev/shm Filesystem Size Used Avail Use% Mounted on tmpfs 876M 420M 457M 48% /dev/shm
修改:
vi /etc/fstab
tmpfs /dev/shm tmpfs defaults,size=1.5G 0 0
mount -o remount /dev/shm
备注:每个数据库实例所需的共享内存至少大于MEMORY_MAX_TARGET和MEMORY_TARGET,最大可用共享内存取决于系统设置
4.创建ORACLE用户
[root@xxx ~]# groupadd oinstall [root@xxx ~]# groupadd dba [root@xxx ~]# useradd -g oinstall -G dba oracle [root@xxx ~]# passwd oracle
[root@xxx ~]# rm /etc/oraInst.loc
[root@xxx ~]# rm /etc/oratab
5.建立需要的目录,并修改bash_profile
[oracle@xxx ~]$ mkdir -p /home/oracle/OracleBase/product/11.2.0/db_1 cat>>$HOME/.bash_profile<<EOF umask 022 LANG=en_US.UTF-8 export ORACLE_BASE=/home/oracle/OracleBase export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1 export ORACLE_SID=xxx export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/network/lib:/usr/local/lib:/usr/lib export TOOLHOME=$HOME/tools export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin:/sbin:/usr/sbin:$TOOLHOME/bin:$ORACLE_HOME/OPatch export TMP=/var/tmp EOF
6.修改linux内核参数
[root@xxx ~]# cat>>/etc/sysctl.conf<<EOF kernel.msgmnb = 65536 kernel.msgmax = 65536 kernel.shmmax = 4294967295 kernel.shmall = 2097152 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 fs.file-max = 6815744 fs.aio-max-nr = 1048576 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 = 1048576 EOF (如果系统已设置了足够大就无需再设置了)
[root@xxx ~]# sysctl -p
以下版RHEL6.0以上版本会报忽略即可:
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
[root@xxx ~]#
cat>>/etc/security/limits.conf<<EOF oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 oracle soft stack 10240 EOF [root@xxx ~]# cat>>/etc/pam.d/login<<EOF session required pam_limits.so EOF
RHEL 6版本下所需要的包: binutils compat-libcap1 compat-libstdc++- compat-libstdc++-(32bit) gcc gcc-c++- glibc glibc(32bit) glibc-devel glibc-devel(32bit) ksh libgcc libgcc(32bit) libstdc++- libstdc++-(32bit) libstdc++- libstdc++-(32bit) libaio libaio(32bit) libaio-devel libaio-devel(32bit) make sysstat 可以单独写入一个文件中,通过简单的shell script循环查看包是否已安装: #!/bin/bash for paks in `cat packages.txt` do pakst=`rpm -qa $paks | head -1` if [ -z $pakst ] then echo “$paks hasn’t install” fi done
建本地yum源
[root@xxx]# mkdir -p /yum/server/
[root@xxx]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_xxx-LogVol00
26G 4.8G 19G 21% /
tmpfs 1.1G 100K 1.1G 1% /dev/shm
/dev/sda1 194M 32M 152M 18% /boot
/dev/sr0 3.5G 3.5G 0 100% /media/RHEL_6.3 x86_64 Disc 1
[root@xxx /]# mount /dev/sr0 /yum/server/
mount: block device /dev/sr0 is write-protected, mounting read-only
[root@xxx]# vi /etc/yum.repos.d/local.repo
[base]
name=local
baseurl=file:///yum/server
gpgcheck=0
enabled=1
文件内容含义解释:
[]:
容器随意命名,表示不同容器ID
name:
后接repository name,用来说明容器,随意命名;
baseurl:
repository的地址,如果是网络地址,就用http://,如果本地地址,就用
file://。我们这里用的就是本地地址。注意上面的之所以是三个“///”,
是因为第三个“/”表示根目录。
enable:
表示这个容器是否启用。启用就设置为1,不启用就设置为0。
gpgcheck:
表示是否检查rpm文件的数字签名。检查就设置为1,不检查就设置为0。
gpgkey:
就是数字签名的公钥文件所在位置。如果gpgcheck值为1,此处就需要指
定gpgkey文件的位置,如果gpgcheck值为0 ,就不需要此项了。上面的
gpgcheck设置为0,此处可以没有gpgkey。
验证
[root@xxx /]# yum list
Loaded plugins: product-id, refresh-packagekit, security, subscription-manager
Updating certificate-based repositories.
Unable to read consumer identity
base | 4.0 kB 00:00 ...
base/primary_db | 3.1 MB 00:00 ...
[oracle@xxx database]$ vi /home/oracle/database/response/db_install.rsp
模板如下:
#################################################################### ## Copyright(c) Oracle Corporation 1998,2008. All rights reserved.## ## ## ## Specify values for the variables listed below to customize ## ## your installation. ## ## ## ## Each variable is associated with a comment. The comment ## ## can help to populate the variables with the appropriate ## ## values. ## ## ## ## IMPORTANT NOTE: This file contains plain text passwords and ## ## should be secured to have read permission only by oracle user ## ## or db administrator who owns this installation. ## ## ## #################################################################### #------------------------------------------------------------------------------ # Do not change the following system generated value. #------------------------------------------------------------------------------
#标注响应文件版本,这个版本必须和要安装的数据库版本相同,否则安装检验无法通过,不能更改# oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0 #------------------------------------------------------------------------------ # Specify the installation option. # It can be one of the following: # 1. INSTALL_DB_SWONLY # 2. INSTALL_DB_AND_CONFIG # 3. UPGRADE_DB #-------------------------------------------------------------------------------
#选择安装类型:1.只装数据库软件 2.安装数据库软件并建库 3.升级数据库# oracle.install.option=INSTALL_DB_SWONLY #------------------------------------------------------------------------------- # Specify the hostname of the system as set during the install. It can be used # to force the installation to use an alternative hostname rather than using the # first hostname found on the system. (e.g., for systems with multiple hostnames # and network interfaces) #-------------------------------------------------------------------------------
#指定操作系统主机名,通过hostname命令获得# ORACLE_HOSTNAME=xxx #------------------------------------------------------------------------------- # Specify the Unix group to be set for the inventory directory. #-------------------------------------------------------------------------------
#指定oracle inventory目录的所有者,通常会是oinstall或者dba#
UNIX_GROUP_NAME=oinstall #------------------------------------------------------------------------------- # Specify the location which holds the inventory files. #-------------------------------------------------------------------------------
#指定产品清单oracle inventory目录的路径,如果是Win平台下可以省略#
INVENTORY_LOCATION=/home/oracle/oraInventory #------------------------------------------------------------------------------- # Specify the languages in which the components will be installed. # # en : English ja : Japanese # fr : French ko : Korean # ar : Arabic es : Latin American Spanish # bn : Bengali lv : Latvian # pt_BR: Brazilian Portuguese lt : Lithuanian # bg : Bulgarian ms : Malay # fr_CA: Canadian French es_MX: Mexican Spanish # ca : Catalan no : Norwegian # hr : Croatian pl : Polish # cs : Czech pt : Portuguese # da : Danish ro : Romanian # nl : Dutch ru : Russian # ar_EG: Egyptian zh_CN: Simplified Chinese # en_GB: English (Great Britain) sk : Slovak # et : Estonian sl : Slovenian # fi : Finnish es_ES: Spanish # de : German sv : Swedish # el : Greek th : Thai # iw : Hebrew zh_TW: Traditional Chinese # hu : Hungarian tr : Turkish # is : Icelandic uk : Ukrainian # in : Indonesian vi : Vietnamese # it : Italian # # Example : SELECTED_LANGUAGES=en,fr,ja #------------------------------------------------------------------------------
#指定数据库语言,可以选择多个,用逗号隔开,选择en, zh_CN(英文和简体中文)# SELECTED_LANGUAGES=zh_CN,en, #------------------------------------------------------------------------------ # Specify the complete path of the Oracle Home. #------------------------------------------------------------------------------
#设置ORALCE_HOME的路径# ORACLE_HOME=/home/oracle/OracleBase/product/11.2.0/db_1 #------------------------------------------------------------------------------ # Specify the complete path of the Oracle Base. #------------------------------------------------------------------------------
#设置ORALCE_BASE的路径# ORACLE_BASE=/home/oracle/OracleBase #------------------------------------------------------------------------------ # Specify the installation edition of the component. # # The value should contain only one of these choices. # EE : Enterprise Edition # SE : Standard Edition # SEONE : Standard Edition One # PE : Personal Edition (WINDOWS ONLY) #------------------------------------------------------------------------------
#选择Oracle安装数据库软件的版本(企业版,标准版,标准版1),不同的版本功能不同#
oracle.install.db.InstallEdition=EE #------------------------------------------------------------------------------ # This variable is used to enable or disable custom install. # # true : Components mentioned as part of 'customComponents' property # are considered for install. # false : Value for 'customComponents' is not considered. #------------------------------------------------------------------------------
#是否自定义Oracle的组件,如果选择false,则会使用默认的组件#
#如果选择true否则需要自己在下面一条参数将要安装的组件一一列出#
#安装相应版权后会安装所有的组件,后期如果缺乏某个组件,再次安装会非常的麻烦#
oracle.install.db.isCustomInstall=false #------------------------------------------------------------------------------ # This variable is considered only if 'IsCustomInstall' is set to true. # # Description: List of Enterprise Edition Options you would like to install. # # The following choices are available. You may specify any # combination of these choices. The components you choose should # be specified in the form "internal-component-name:version" # Below is a list of components you may specify to install. # # oracle.rdbms.partitioning:11.2.0.1.0 - Oracle Partitioning # oracle.rdbms.dm:11.2.0.1.0 - Oracle Data Mining # oracle.rdbms.dv:11.2.0.1.0 - Oracle Database Vault # oracle.rdbms.lbac:11.2.0.1.0 - Oracle Label Security # oracle.rdbms.rat:11.2.0.1.0 - Oracle Real Application Testing # oracle.oraolap:11.2.0.1.0 - Oracle OLAP #------------------------------------------------------------------------------
#oracle.install.db.customComponents=oracle.server:11.2.0.1.0,oracle.sysman.ccr:10.2.7.0.0,oracle.xdk:11.2.0.1.0,oracle.rdbms.oci:11.2.0.1.0,oracle.#network:11.2.0.1.0,oracle.network.listener:11.2.0.1.0,oracle.rdbms:11.2.0.1.0,oracle.options:11.2.0.1.0,oracle.rdbms.partitioning:11.2.0.1.0,oracl#e.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.rdbms.rat:11.2.0.1.0 ############################################################################### # # # PRIVILEGED OPERATING SYSTEM GROUPS # # ------------------------------------------ # # Provide values for the OS groups to which OSDBA and OSOPER privileges # # needs to be granted. If the install is being performed as a member of the # # group "dba", then that will be used unless specified otherwise below. # # # ############################################################################### #------------------------------------------------------------------------------ # The DBA_GROUP is the OS group which is to be granted OSDBA privileges. #------------------------------------------------------------------------------
#指定拥有OSDBA、OSOPER权限的用户组,通常会是dba组# oracle.install.db.DBA_GROUP=dba #------------------------------------------------------------------------------ # The OPER_GROUP is the OS group which is to be granted OSOPER privileges. #------------------------------------------------------------------------------ oracle.install.db.OPER_GROUP=oinstall #------------------------------------------------------------------------------ # Specify the cluster node names selected during the installation. #------------------------------------------------------------------------------
#如果是RAC的安装,在这里指定所有的节点# oracle.install.db.CLUSTER_NODES= #------------------------------------------------------------------------------ # Specify the type of database to create. # It can be one of the following: # - GENERAL_PURPOSE/TRANSACTION_PROCESSING # - DATA_WAREHOUSE #------------------------------------------------------------------------------
#选择数据库的用途,一般用途/事物处理,数据仓库# oracle.install.db.config.starterdb.type=GENERAL_PURPOSE #------------------------------------------------------------------------------ # Specify the Starter Database Global Database Name. #------------------------------------------------------------------------------
#指定GlobalName# oracle.install.db.config.starterdb.globalDBName=xxx #------------------------------------------------------------------------------ # Specify the Starter Database SID. #------------------------------------------------------------------------------
#指定SID# oracle.install.db.config.starterdb.SID=xxx #------------------------------------------------------------------------------ # Specify the Starter Database character set. # # It can be one of the following: # AL32UTF8, WE8ISO8859P15, WE8MSWIN1252, EE8ISO8859P2, # EE8MSWIN1250, NE8ISO8859P10, NEE8ISO8859P4, BLT8MSWIN1257, # BLT8ISO8859P13, CL8ISO8859P5, CL8MSWIN1251, AR8ISO8859P6, # AR8MSWIN1256, EL8ISO8859P7, EL8MSWIN1253, IW8ISO8859P8, # IW8MSWIN1255, JA16EUC, JA16EUCTILDE, JA16SJIS, JA16SJISTILDE, # KO16MSWIN949, ZHS16GBK, TH8TISASCII, ZHT32EUC, ZHT16MSWIN950, # ZHT16HKSCS, WE8ISO8859P9, TR8MSWIN1254, VN8MSWIN1258 #------------------------------------------------------------------------------
#选择字符集。不正确的字符集会给数据显示和存储带来麻烦无数,通常中文选择的有ZHS16GBK简体中文库,建议选择unicode的AL32UTF8国际字符集# oracle.install.db.config.starterdb.characterSet=ZHS16GBK #------------------------------------------------------------------------------ # This variable should be set to true if Automatic Memory Management # in Database is desired. # If Automatic Memory Management is not desired, and memory allocation # is to be done manually, then set it to false. #------------------------------------------------------------------------------
#11g的新特性自动内存管理,也就是SGA_TARGET和PAG_AGGREGATE_TARGET都不用设置了,Oracle会自动调配两部分大小# oracle.install.db.config.starterdb.memoryOption=true #------------------------------------------------------------------------------ # Specify the total memory allocation for the database. Value(in MB) should be # at least 256 MB, and should not exceed the total physical memory available # on the system. # Example: oracle.install.db.config.starterdb.memoryLimit=512 #------------------------------------------------------------------------------
#指定Oracle自动管理内存的大小,最小是256MB# oracle.install.db.config.starterdb.memoryLimit=2048 #------------------------------------------------------------------------------ # This variable controls whether to load Example Schemas onto the starter # database or not. #------------------------------------------------------------------------------
#是否载入模板示例# oracle.install.db.config.starterdb.installExampleSchemas=false #------------------------------------------------------------------------------ # This variable includes enabling audit settings, configuring password profiles # and revoking some grants to public. These settings are provided by default. # These settings may also be disabled. #------------------------------------------------------------------------------
#是否启用安全设置# oracle.install.db.config.starterdb.enableSecuritySettings=true ############################################################################### # # # Passwords can be supplied for the following four schemas in the # # starter database: # # SYS # # SYSTEM # # SYSMAN (used by Enterprise Manager) # # DBSNMP (used by Enterprise Manager) # # # # Same password can be used for all accounts (not recommended) # # or different passwords for each account can be provided (recommended) # # # ############################################################################### #------------------------------------------------------------------------------ # This variable holds the password that is to be used for all schemas in the # starter database. #-------------------------------------------------------------------------------
#设定所有数据库用户使用同一个密码,其它数据库用户就不用单独设置了# oracle.install.db.config.starterdb.password.ALL=oracle #------------------------------------------------------------------------------- # Specify the SYS password for the starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.SYS= #------------------------------------------------------------------------------- # Specify the SYSTEM password for the starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.SYSTEM= #------------------------------------------------------------------------------- # Specify the SYSMAN password for the starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.SYSMAN= #------------------------------------------------------------------------------- # Specify the DBSNMP password for the starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.DBSNMP= #------------------------------------------------------------------------------- # Specify the management option to be selected for the starter database. # It can be one of the following: # 1. GRID_CONTROL # 2. DB_CONTROL #-------------------------------------------------------------------------------
#数据库本地管理工具DB_CONTROL,远程集中管理工具GRID_CONTROL# oracle.install.db.config.starterdb.control=DB_CONTROL #------------------------------------------------------------------------------- # Specify the Management Service to use if Grid Control is selected to manage # the database. #-------------------------------------------------------------------------------
#数据库本地管理工具DB_CONTROL,远程集中管理工具GRID_CONTROL# oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL= #------------------------------------------------------------------------------- # This variable indicates whether to receive email notification for critical # alerts when using DB control. #-------------------------------------------------------------------------------
#是否启用Email通知, 启用后会将告警等信息发送到指定邮箱# oracle.install.db.config.starterdb.dbcontrol.enableEmailNotification=false #------------------------------------------------------------------------------- # Specify the email address to which the notifications are to be sent. #-------------------------------------------------------------------------------
#设置通知EMAIL地址# oracle.install.db.config.starterdb.dbcontrol.emailAddress= #------------------------------------------------------------------------------- # Specify the SMTP server used for email notifications. #-------------------------------------------------------------------------------
#设置EMAIL邮件服务器# oracle.install.db.config.starterdb.dbcontrol.SMTPServer= ############################################################################### # # # SPECIFY BACKUP AND RECOVERY OPTIONS # # ------------------------------------ # # Out-of-box backup and recovery options for the database can be mentioned # # using the entries below. # # # ############################################################################### #------------------------------------------------------------------------------ # This variable is to be set to false if automated backup is not required. Else # this can be set to true. #------------------------------------------------------------------------------
#设置自动备份,和OUI里的自动备份一样# oracle.install.db.config.starterdb.automatedBackup.enable=false #------------------------------------------------------------------------------ # Regardless of the type of storage that is chosen for backup and recovery, if # automated backups are enabled, a job will be scheduled to run daily at # 2:00 AM to backup the database. This job will run as the operating system # user that is specified in this variable. #------------------------------------------------------------------------------
#自动备份会启动一个job,指定启动JOB的系统用户ID# oracle.install.db.config.starterdb.automatedBackup.osuid= #------------------------------------------------------------------------------- # Regardless of the type of storage that is chosen for backup and recovery, if # automated backups are enabled, a job will be scheduled to run daily at # 2:00 AM to backup the database. This job will run as the operating system user # specified by the above entry. The following entry stores the password for the # above operating system user. #-------------------------------------------------------------------------------
#自动备份会开启一个job,需要指定OSUser的密码# oracle.install.db.config.starterdb.automatedBackup.ospwd= #------------------------------------------------------------------------------- # Specify the type of storage to use for the database. # It can be one of the following: # - FILE_SYSTEM_STORAGE # - ASM_STORAGE #------------------------------------------------------------------------------
#自动备份,要求指定使用的文件系统存放数据库文件还是ASM# oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGE #------------------------------------------------------------------------------- # Specify the database file location which is a directory for datafiles, control # files, redo logs. # # Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM #-------------------------------------------------------------------------------
#使用文件系统存放数据库文件才需要指定数据文件、控制文件、Redo log的存放目录# oracle.install.db.config.starterdb.fileSystemStorage.dataLocation= #------------------------------------------------------------------------------- # Specify the backup and recovery location. # # Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM #-------------------------------------------------------------------------------
#使用文件系统存放数据库文件才需要指定备份恢复目录# oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation= #------------------------------------------------------------------------------- # Specify the existing ASM disk groups to be used for storage. # # Applicable only when oracle.install.db.config.starterdb.storage=ASM #-------------------------------------------------------------------------------
#使用ASM存放数据库文件才需要指定存放的磁盘组# oracle.install.db.config.asm.diskGroup= #------------------------------------------------------------------------------- # Specify the password for ASMSNMP user of the ASM instance. # # Applicable only when oracle.install.db.config.starterdb.storage=ASM_SYSTEM #-------------------------------------------------------------------------------
#使用ASM存放数据库文件才需要指定ASM实例密码# oracle.install.db.config.asm.ASMSNMPPassword= #------------------------------------------------------------------------------ # Specify the My Oracle Support Account Username. # # Example : MYORACLESUPPORT_USERNAME=metalink #------------------------------------------------------------------------------
#指定metalink账户用户名# MYORACLESUPPORT_USERNAME= #------------------------------------------------------------------------------ # Specify the My Oracle Support Account Username password. # # Example : MYORACLESUPPORT_PASSWORD=password #------------------------------------------------------------------------------
#指定metalink账户密码# MYORACLESUPPORT_PASSWORD= #------------------------------------------------------------------------------ # Specify whether to enable the user to set the password for # My Oracle Support credentials. The value can be either true or false. # If left blank it will be assumed to be false. # # Example : SECURITY_UPDATES_VIA_MYORACLESUPPORT=true #------------------------------------------------------------------------------
#用户是否可以设置metalink密码# SECURITY_UPDATES_VIA_MYORACLESUPPORT= #------------------------------------------------------------------------------ # Specify whether user wants to give any proxy details for connection. # The value can be either true or false. If left blank it will be assumed # to be false. # # Example : DECLINE_SECURITY_UPDATES=false #------------------------------------------------------------------------------
#False表示不需要设置安全更新,注意,在11.2的静默安装中疑似有一个BUG,Response File中必须指定为true,否则会提示错误,不管是否正确填写了邮件地址# DECLINE_SECURITY_UPDATES=true #------------------------------------------------------------------------------ # Specify the Proxy server name. Length should be greater than zero. # # Example : PROXY_HOST=proxy.domain.com #------------------------------------------------------------------------------
#代理服务器名# PROXY_HOST= #------------------------------------------------------------------------------ # Specify the proxy port number. Should be Numeric and atleast 2 chars. # # Example : PROXY_PORT=25 #------------------------------------------------------------------------------
#代理服务器端口# PROXY_PORT= #------------------------------------------------------------------------------ # Specify the proxy user name. Leave PROXY_USER and PROXY_PWD # blank if your proxy server requires no authentication. # # Example : PROXY_USER=username #------------------------------------------------------------------------------
#代理服务器用户名# PROXY_USER= #------------------------------------------------------------------------------ # Specify the proxy password. Leave PROXY_USER and PROXY_PWD # blank if your proxy server requires no authentication. # # Example : PROXY_PWD=password #------------------------------------------------------------------------------
#代理服务器密码# PROXY_PWD=
各参数含义如下:
-silent 表示以静默方式安装,不会有任何提示 -force 允许安装到一个非空目录 -noconfig 表示不运行配置助手netca -responseFile 表示使用哪个响应文件,必需使用绝对路径 -oracle.install.responseFileVersion 响应文件模板的版本,该参数不要更改
9.开始安装Oracle软件
[oracle@xxx database]$ ./runInstaller -silent -force -noconfig -responseFile /home/oracle/database/response/db_install.rsp
10.静默监听安装
[oracle@xxx response]$ netca /silent /responsefile /home/oracle/database/response/netca.rsp
11.实例安装
[oracle@xxx response]$ dbca -silent -responseFile /home/oracle/database/response/dbca.rsp
个人推荐以下方法:
dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName xxx -sid xxx -SysPassword oracle -SystemPassword oracle -emConfiguration NONE -datafileDestination /home/oracle/OracleBase/oradata -storageType FS -characterSet ZHS16GBK -memoryPercentage 40
12.组件检查
set linesize 200
col COMP_NAME for a40
SQL>select COMP_ID,COMP_NAME,VERSION,STATUS from dba_registry;
COMP_ID COMP_NAME VERSION STATUS ------------------------------ ---------------------------------------- ------------------------------ ---------------------- OWB OWB 11.2.0.1.0 VALID APEX Oracle Application Express 3.2.1.00.10 VALID EM Oracle Enterprise Manager 11.2.0.1.0 VALID AMD OLAP Catalog 11.2.0.1.0 VALID SDO Spatial 11.2.0.1.0 VALID ORDIM Oracle Multimedia 11.2.0.1.0 VALID XDB Oracle XML Database 11.2.0.1.0 VALID CONTEXT Oracle Text 11.2.0.1.0 VALID EXF Oracle Expression Filter 11.2.0.1.0 VALID RUL Oracle Rules Manager 11.2.0.1.0 VALID OWM Oracle Workspace Manager 11.2.0.1.0 VALID COMP_ID COMP_NAME VERSION STATUS ------------------------------ ---------------------------------------- ------------------------------ ---------------------- CATALOG Oracle Database Catalog Views 11.2.0.1.0 VALID CATPROC Oracle Database Packages and Types 11.2.0.1.0 VALID JAVAVM JServer JAVA Virtual Machine 11.2.0.1.0 VALID XML Oracle XDK 11.2.0.1.0 VALID CATJAVA Oracle Database Java Packages 11.2.0.1.0 VALID APS OLAP Analytic Workspace 11.2.0.1.0 VALID XOQ Oracle OLAP API 11.2.0.1.0 VALID
参考资料:
http://database.51cto.com/art/201108/286272.htm
http://www.dbdream.org/?tag=%E9%9D%99%E9%BB%98%E5%AE%89%E8%A3%85oracle
http://www.zhdba.com/onlinekof2001/2014/06/05/oracle%E9%9D%99%E9%BB%98%E5%AE%89%E8%A3%85oracle-silent-installing/
http://docs.oracle.com/cd/B28359_01/server.111/b28310/create002.htm#ADMIN12479