Linux下安装Oracle的两种方式------有图形界面安装和静默安装

本文参考文章

http://blog.csdn.net/zonej/article/details/50680857

http://blog.csdn.net/tongzidane/article/details/43852705

http://www.cnblogs.com/sopost/archive/2012/07/19/2598981.html

维护版权从我做起。

 

一、安装前准备工作
 
1、修改主机名(不是必须的)
#vi /etc/hosts   //并添加内网IP地址对应的hostname,如下
127.0.0.1           localhost
::1                   localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.8.151    oracledb
 
2、修改/etc/sysconfig/iptables文件,开通1521端口:
# vi /etc/sysconfig/iptables
-A INPUT -m state --state NEW -m tcp -p tcp --dport 1521 -j ACCEPT
 
3、重启iptables服务:
#service iptables restart
 
4、安装依赖包
#yum -y install binutils compat-libcap1 compat-libstdc++-33 compat-libstdc++-33*i686 compat-libstdc++-33*.devel compat-libstdc++-33 compat-libstdc++-33*.devel gcc gcc-c++ glibc glibc*.i686 glibc-devel glibc-devel*.i686 ksh libaio libaio*.i686 libaio-devel libaio-devel*.devel libgcc libgcc*.i686 libstdc++ libstdc++*.i686 libstdc++-devel libstdc++-devel*.devel libXi libXi*.i686 libXtst libXtst*.i686 make sysstat unixODBC unixODBC*.i686 unixODBC-devel unixODBC-devel*.i686
查看系统是否安装了该软件包  
#rpm -q package_name
 
5、编辑/etc/sysctl.conf文件  
# vim /etc/sysctl.conf
在打开的文件底部添加下面内容  
fs.file-max = 6815744  
kernel.shmmax = 536870912  
kernel.sem = 250 32000 100 128  
net.core.rmem_default = 262144  
net.core.wmem_default = 262144  
改变当前系统内核参数值(让/etc/sysctl.conf立即生效)  
#sysctl -p
 
6、修改/etc/security/limits.conf文件  
在打开的文件底部添加下面内容  
oracle     soft     nproc    2047
oracle              hard    nproc    16384  
oralce              soft     nofile    1024
oracle              hard    nofile     65536  
oracle              soft     stack     10240 
 
 
7、建立用户组及用户
# groupadd oinstall
# groupadd dba
# useradd -g oinstall -G dba -d /home/oracle oracle
# passwd oracle          //设置oracle密码
用以上命令不能用户目录和用户环境变量文件的可以用下面这个
#useradd -m -g oinstall -G dba -p password -d /home/oracle -s /bin/bash oracle
 
 8、创建安装目录
# mkdir -p /opt/oracle_11/app/  
# mkdir -p /opt/oracle_11/oraInventory/  
# chown -R oracle:oinstall /opt/oracle_11/app/
# chmod -R 775 /opt/oracle_11/app/  
# chown -R oracle:oinstall /opt/oracle_11/oraInventory/
# chmod -R 775 /opt/oracle_11/oraInventory/  
 
9、编辑 /home/oracle/.bash_profile  配置Oracle用户变量
#vi /home/oracle/.bash_profile
在打开的文件中添加下面内容  
export ORACLE_BASE=/opt/oracle_11/app  
export ORACLE_SID=orcl   
使之生效
#source /home/oracle/.bash_profile
编辑 /etc/pam.d/login
#vi /etc/pam.d/login  
在打开的文件中添加下面内容  
session required /lib/security/pam_limits.so
session required pam_limits.so
配置环境变量
#vim /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
使修改的内容生效
#source /etc/profile
 
 
二、解压开始安装
有图形界面时
使用root用户查看用户下是否已设置DISPLAY变量  
如果有值出现,则说明已设置DISPLAY变量;否则,就需要手动设置DISPLAY 
以下命令允许所有用户使用图形界面
# xhost +  
#su - oracle
$ unzip p10404530_112030_Linux-x86-64_1of7.zip
$ unzip p10404530_112030_Linux-x86-64_2of7.zip  
$ export DISPLAY=:0  
$ ./database/runInstaller  
 
进入图形界面的安装请参照
http://blog.itpub.net/29742691/viewspace-1214803/
            
 
无图形界面静默安装(推荐)
一、修改静默安装的模板
$ cp -R /home/oracle/database/response /home/oracle           //复制一份模板
$ cd /home/oracle/response
$ vi db_install.rsp                                               //修改安装应答文件
三个文件作用分别是:
db_install.rsp:安装应答
dbca.rsp:创建数据库应答
netca.rsp:建立监听、本地服务名等网络设置应答
这三个文件已经为大家准备好,注意:我是安装在/opt/oracle_11/下,如果你安装在其他目录,请自行修改上面环境变量配置的路径和这几个文件的路径
  1 ####################################################################
  2 ## Copyright(c) Oracle Corporation 1998,2008. All rights reserved.##
  3 ##                                                                ##
  4 ## Specify values for the variables listed below to customize     ##
  5 ## your installation.                                             ##
  6 ##                                                                ##
  7 ## Each variable is associated with a comment. The comment        ##
  8 ## can help to populate the variables with the appropriate        ##
  9 ## values.                              ##
 10 ##                                                                ##
 11 ## IMPORTANT NOTE: This file contains plain text passwords and    ##
 12 ## should be secured to have read permission only by oracle user  ##
 13 ## or db administrator who owns this installation.                ##
 14 ##                                                                ##
 15 ####################################################################
 16 
 17 #------------------------------------------------------------------------------
 18 # Do not change the following system generated value. 
 19 #------------------------------------------------------------------------------
 20 oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
 21 
 22 #------------------------------------------------------------------------------
 23 # Specify the installation option.
 24 # It can be one of the following:
 25 # 1. INSTALL_DB_SWONLY
 26 # 2. INSTALL_DB_AND_CONFIG
 27 # 3. UPGRADE_DB
 28 #-------------------------------------------------------------------------------
 29 oracle.install.option=INSTALL_DB_SWONLY
 30 
 31 #-------------------------------------------------------------------------------
 32 # Specify the hostname of the system as set during the install. It can be used
 33 # to force the installation to use an alternative hostname rather than using the
 34 # first hostname found on the system. (e.g., for systems with multiple hostnames 
 35 # and network interfaces)
 36 #-------------------------------------------------------------------------------
 37 ORACLE_HOSTNAME=centos7
 38 
 39 #-------------------------------------------------------------------------------
 40 # Specify the Unix group to be set for the inventory directory.  
 41 #-------------------------------------------------------------------------------
 42 UNIX_GROUP_NAME=oinstall
 43 
 44 #-------------------------------------------------------------------------------
 45 # Specify the location which holds the inventory files.
 46 #-------------------------------------------------------------------------------
 47 INVENTORY_LOCATION=/opt/oracle_11/oraInventory
 48 
 49 #-------------------------------------------------------------------------------
 50 # Specify the languages in which the components will be installed.             
 51 #
 52 # en   : English                  ja   : Japanese                  
 53 # fr   : French                   ko   : Korean                    
 54 # ar   : Arabic                   es   : Latin American Spanish    
 55 # bn   : Bengali                  lv   : Latvian                   
 56 # pt_BR: Brazilian Portuguese     lt   : Lithuanian                
 57 # bg   : Bulgarian                ms   : Malay                     
 58 # fr_CA: Canadian French          es_MX: Mexican Spanish           
 59 # ca   : Catalan                  no   : Norwegian                 
 60 # hr   : Croatian                 pl   : Polish                    
 61 # cs   : Czech                    pt   : Portuguese                
 62 # da   : Danish                   ro   : Romanian                  
 63 # nl   : Dutch                    ru   : Russian                   
 64 # ar_EG: Egyptian                 zh_CN: Simplified Chinese        
 65 # en_GB: English (Great Britain)  sk   : Slovak                    
 66 # et   : Estonian                 sl   : Slovenian                 
 67 # fi   : Finnish                  es_ES: Spanish                   
 68 # de   : German                   sv   : Swedish                   
 69 # el   : Greek                    th   : Thai                      
 70 # iw   : Hebrew                   zh_TW: Traditional Chinese       
 71 # hu   : Hungarian                tr   : Turkish                   
 72 # is   : Icelandic                uk   : Ukrainian                 
 73 # in   : Indonesian               vi   : Vietnamese                
 74 # it   : Italian                                                   
 75 #
 76 # Example : SELECTED_LANGUAGES=en,fr,ja
 77 #------------------------------------------------------------------------------
 78 SELECTED_LANGUAGES=en,zh_CN
 79 
 80 #------------------------------------------------------------------------------
 81 # Specify the complete path of the Oracle Home.
 82 #------------------------------------------------------------------------------
 83 ORACLE_HOME=/opt/oracle_11/app/oracle/product/11.2.0/dbhome_1
 84 
 85 #------------------------------------------------------------------------------
 86 # Specify the complete path of the Oracle Base. 
 87 #------------------------------------------------------------------------------
 88 ORACLE_BASE=/opt/oracle_11/app
 89 
 90 #------------------------------------------------------------------------------
 91 # Specify the installation edition of the component.                        
 92 #                                                             
 93 # The value should contain only one of these choices.        
 94 # EE     : Enterprise Edition                                
 95 # SE     : Standard Edition                                  
 96 # SEONE  : Standard Edition One
 97 # PE     : Personal Edition (WINDOWS ONLY)
 98 #------------------------------------------------------------------------------
 99 oracle.install.db.InstallEdition=EE
100 
101 #------------------------------------------------------------------------------
102 # This variable is used to enable or disable custom install.
103 #
104 # true  : Components mentioned as part of 'customComponents' property
105 #         are considered for install.
106 # false : Value for 'customComponents' is not considered.
107 #------------------------------------------------------------------------------
108 oracle.install.db.isCustomInstall=true
109 
110 #------------------------------------------------------------------------------
111 # This variable is considered only if 'IsCustomInstall' is set to true. 
112 #
113 # Description: List of Enterprise Edition Options you would like to install.
114 #
115 #              The following choices are available. You may specify any
116 #              combination of these choices.  The components you choose should
117 #              be specified in the form "internal-component-name:version"
118 #              Below is a list of components you may specify to install.
119 #        
120 #              oracle.rdbms.partitioning:11.2.0.1.0 - Oracle Partitioning
121 #              oracle.rdbms.dm:11.2.0.1.0 - Oracle Data Mining
122 #              oracle.rdbms.dv:11.2.0.1.0 - Oracle Database Vault 
123 #              oracle.rdbms.lbac:11.2.0.1.0 - Oracle Label Security
124 #              oracle.rdbms.rat:11.2.0.1.0 - Oracle Real Application Testing 
125 #              oracle.oraolap:11.2.0.1.0 - Oracle OLAP
126 #------------------------------------------------------------------------------
127 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,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.rdbms.rat:11.2.0.1.0
128 
129 ###############################################################################
130 #                                                                             #
131 # PRIVILEGED OPERATING SYSTEM GROUPS                                            #
132 # ------------------------------------------                                  #
133 # Provide values for the OS groups to which OSDBA and OSOPER privileges       #
134 # needs to be granted. If the install is being performed as a member of the   #        
135 # group "dba", then that will be used unless specified otherwise below.          #
136 #                                                                             #
137 ###############################################################################
138 
139 #------------------------------------------------------------------------------
140 # The DBA_GROUP is the OS group which is to be granted OSDBA privileges.
141 #------------------------------------------------------------------------------
142 oracle.install.db.DBA_GROUP=dba
143 
144 #------------------------------------------------------------------------------
145 # The OPER_GROUP is the OS group which is to be granted OSOPER privileges.
146 #------------------------------------------------------------------------------
147 oracle.install.db.OPER_GROUP=oinstall
148 
149 #------------------------------------------------------------------------------
150 # Specify the cluster node names selected during the installation.
151 #------------------------------------------------------------------------------
152 oracle.install.db.CLUSTER_NODES=
153 
154 #------------------------------------------------------------------------------
155 # Specify the type of database to create.
156 # It can be one of the following:
157 # - GENERAL_PURPOSE/TRANSACTION_PROCESSING          
158 # - DATA_WAREHOUSE                                
159 #------------------------------------------------------------------------------
160 oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
161 
162 #------------------------------------------------------------------------------
163 # Specify the Starter Database Global Database Name. 
164 #------------------------------------------------------------------------------
165 oracle.install.db.config.starterdb.globalDBName=glassfish
166 
167 #------------------------------------------------------------------------------
168 # Specify the Starter Database SID.
169 #------------------------------------------------------------------------------
170 oracle.install.db.config.starterdb.SID=glassfish
171 
172 #------------------------------------------------------------------------------
173 # Specify the Starter Database character set.
174 #                                              
175 # It can be one of the following:
176 # AL32UTF8, WE8ISO8859P15, WE8MSWIN1252, EE8ISO8859P2,
177 # EE8MSWIN1250, NE8ISO8859P10, NEE8ISO8859P4, BLT8MSWIN1257,
178 # BLT8ISO8859P13, CL8ISO8859P5, CL8MSWIN1251, AR8ISO8859P6,
179 # AR8MSWIN1256, EL8ISO8859P7, EL8MSWIN1253, IW8ISO8859P8,
180 # IW8MSWIN1255, JA16EUC, JA16EUCTILDE, JA16SJIS, JA16SJISTILDE,
181 # KO16MSWIN949, ZHS16GBK, TH8TISASCII, ZHT32EUC, ZHT16MSWIN950,
182 # ZHT16HKSCS, WE8ISO8859P9, TR8MSWIN1254, VN8MSWIN1258
183 #------------------------------------------------------------------------------
184 oracle.install.db.config.starterdb.characterSet=AL32UTF8
185 
186 #------------------------------------------------------------------------------
187 # This variable should be set to true if Automatic Memory Management 
188 # in Database is desired.
189 # If Automatic Memory Management is not desired, and memory allocation
190 # is to be done manually, then set it to false.
191 #------------------------------------------------------------------------------
192 oracle.install.db.config.starterdb.memoryOption=true
193 
194 #------------------------------------------------------------------------------
195 # Specify the total memory allocation for the database. Value(in MB) should be
196 # at least 256 MB, and should not exceed the total physical memory available 
197 # on the system.
198 # Example: oracle.install.db.config.starterdb.memoryLimit=512
199 #------------------------------------------------------------------------------
200 oracle.install.db.config.starterdb.memoryLimit=10240
201 
202 #------------------------------------------------------------------------------
203 # This variable controls whether to load Example Schemas onto the starter
204 # database or not.
205 #------------------------------------------------------------------------------
206 oracle.install.db.config.starterdb.installExampleSchemas=false
207 
208 #------------------------------------------------------------------------------
209 # This variable includes enabling audit settings, configuring password profiles
210 # and revoking some grants to public. These settings are provided by default. 
211 # These settings may also be disabled.    
212 #------------------------------------------------------------------------------
213 oracle.install.db.config.starterdb.enableSecuritySettings=true
214 
215 ###############################################################################
216 #                                                                             #
217 # Passwords can be supplied for the following four schemas in the          #
218 # starter database:                                    #
219 #   SYS                                                                       #
220 #   SYSTEM                                                                    #
221 #   SYSMAN (used by Enterprise Manager)                                       #
222 #   DBSNMP (used by Enterprise Manager)                                       #
223 #                                                                             #
224 # Same password can be used for all accounts (not recommended)               #
225 # or different passwords for each account can be provided (recommended)       #
226 #                                                                             #
227 ###############################################################################
228 
229 #------------------------------------------------------------------------------
230 # This variable holds the password that is to be used for all schemas in the
231 # starter database.
232 #-------------------------------------------------------------------------------
233 oracle.install.db.config.starterdb.password.ALL=glassfish
234 
235 #-------------------------------------------------------------------------------
236 # Specify the SYS password for the starter database.
237 #-------------------------------------------------------------------------------
238 oracle.install.db.config.starterdb.password.SYS=
239 
240 #-------------------------------------------------------------------------------
241 # Specify the SYSTEM password for the starter database.
242 #-------------------------------------------------------------------------------
243 oracle.install.db.config.starterdb.password.SYSTEM=
244 
245 #-------------------------------------------------------------------------------
246 # Specify the SYSMAN password for the starter database.
247 #-------------------------------------------------------------------------------
248 oracle.install.db.config.starterdb.password.SYSMAN=
249 
250 #-------------------------------------------------------------------------------
251 # Specify the DBSNMP password for the starter database.
252 #-------------------------------------------------------------------------------
253 oracle.install.db.config.starterdb.password.DBSNMP=
254 
255 #-------------------------------------------------------------------------------
256 # Specify the management option to be selected for the starter database. 
257 # It can be one of the following:
258 # 1. GRID_CONTROL
259 # 2. DB_CONTROL
260 #-------------------------------------------------------------------------------
261 oracle.install.db.config.starterdb.control=DB_CONTROL
262 
263 #-------------------------------------------------------------------------------
264 # Specify the Management Service to use if Grid Control is selected to manage 
265 # the database.      
266 #-------------------------------------------------------------------------------
267 oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=
268 
269 #-------------------------------------------------------------------------------
270 # This variable indicates whether to receive email notification for critical 
271 # alerts when using DB control.   
272 #-------------------------------------------------------------------------------
273 oracle.install.db.config.starterdb.dbcontrol.enableEmailNotification=false
274 
275 #-------------------------------------------------------------------------------
276 # Specify the email address to which the notifications are to be sent.
277 #-------------------------------------------------------------------------------
278 oracle.install.db.config.starterdb.dbcontrol.emailAddress=
279 
280 #-------------------------------------------------------------------------------
281 # Specify the SMTP server used for email notifications.
282 #-------------------------------------------------------------------------------
283 oracle.install.db.config.starterdb.dbcontrol.SMTPServer=
284 
285 
286 ###############################################################################
287 #                                                                             #
288 # SPECIFY BACKUP AND RECOVERY OPTIONS                                           #
289 # ------------------------------------                                      #
290 # Out-of-box backup and recovery options for the database can be mentioned    #
291 # using the entries below.                              #    
292 #                                                                             #
293 ###############################################################################
294 
295 #------------------------------------------------------------------------------
296 # This variable is to be set to false if automated backup is not required. Else 
297 # this can be set to true.
298 #------------------------------------------------------------------------------
299 oracle.install.db.config.starterdb.automatedBackup.enable=false
300 
301 #------------------------------------------------------------------------------
302 # Regardless of the type of storage that is chosen for backup and recovery, if 
303 # automated backups are enabled, a job will be scheduled to run daily at
304 # 2:00 AM to backup the database. This job will run as the operating system 
305 # user that is specified in this variable.
306 #------------------------------------------------------------------------------
307 oracle.install.db.config.starterdb.automatedBackup.osuid=
308 
309 #-------------------------------------------------------------------------------
310 # Regardless of the type of storage that is chosen for backup and recovery, if 
311 # automated backups are enabled, a job will be scheduled to run daily at
312 # 2:00 AM to backup the database. This job will run as the operating system user
313 # specified by the above entry. The following entry stores the password for the
314 # above operating system user.
315 #-------------------------------------------------------------------------------
316 oracle.install.db.config.starterdb.automatedBackup.ospwd=
317 
318 #-------------------------------------------------------------------------------
319 # Specify the type of storage to use for the database.
320 # It can be one of the following:
321 # - FILE_SYSTEM_STORAGE
322 # - ASM_STORAGE
323 #------------------------------------------------------------------------------
324 oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGE
325 
326 #-------------------------------------------------------------------------------
327 # Specify the database file location which is a directory for datafiles, control
328 # files, redo logs.         
329 #
330 # Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM 
331 #-------------------------------------------------------------------------------
332 oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=
333 
334 #-------------------------------------------------------------------------------
335 # Specify the backup and recovery location.
336 #
337 # Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM 
338 #-------------------------------------------------------------------------------
339 oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=
340 
341 #-------------------------------------------------------------------------------
342 # Specify the existing ASM disk groups to be used for storage.
343 #
344 # Applicable only when oracle.install.db.config.starterdb.storage=ASM
345 #-------------------------------------------------------------------------------
346 oracle.install.db.config.asm.diskGroup=
347 
348 #-------------------------------------------------------------------------------
349 # Specify the password for ASMSNMP user of the ASM instance.                  
350 #
351 # Applicable only when oracle.install.db.config.starterdb.storage=ASM_SYSTEM 
352 #-------------------------------------------------------------------------------
353 oracle.install.db.config.asm.ASMSNMPPassword=
354 
355 #------------------------------------------------------------------------------
356 # Specify the My Oracle Support Account Username.
357 #
358 #  Example   : MYORACLESUPPORT_USERNAME=metalink
359 #------------------------------------------------------------------------------
360 MYORACLESUPPORT_USERNAME=
361 
362 #------------------------------------------------------------------------------
363 # Specify the My Oracle Support Account Username password.
364 #
365 # Example    : MYORACLESUPPORT_PASSWORD=password
366 #------------------------------------------------------------------------------
367 MYORACLESUPPORT_PASSWORD=
368 
369 #------------------------------------------------------------------------------
370 # Specify whether to enable the user to set the password for
371 # My Oracle Support credentials. The value can be either true or false.
372 # If left blank it will be assumed to be false.
373 #
374 # Example    : SECURITY_UPDATES_VIA_MYORACLESUPPORT=true
375 #------------------------------------------------------------------------------
376 SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
377 
378 #------------------------------------------------------------------------------
379 # Specify whether user wants to give any proxy details for connection. 
380 # The value can be either true or false. If left blank it will be assumed
381 # to be false.
382 #
383 # Example    : DECLINE_SECURITY_UPDATES=false
384 #------------------------------------------------------------------------------
385 DECLINE_SECURITY_UPDATES=true
386 
387 #------------------------------------------------------------------------------
388 # Specify the Proxy server name. Length should be greater than zero.
389 #
390 # Example    : PROXY_HOST=proxy.domain.com 
391 #------------------------------------------------------------------------------
392 PROXY_HOST=
393 
394 #------------------------------------------------------------------------------
395 # Specify the proxy port number. Should be Numeric and atleast 2 chars.
396 #
397 # Example    : PROXY_PORT=25 
398 #------------------------------------------------------------------------------
399 PROXY_PORT=
400 
401 #------------------------------------------------------------------------------
402 # Specify the proxy user name. Leave PROXY_USER and PROXY_PWD 
403 # blank if your proxy server requires no authentication.
404 #
405 # Example    : PROXY_USER=username 
406 #------------------------------------------------------------------------------
407 PROXY_USER=
408 
409 #------------------------------------------------------------------------------
410 # Specify the proxy password. Leave PROXY_USER and PROXY_PWD  
411 # blank if your proxy server requires no authentication.
412 #
413 # Example    : PROXY_PWD=password 
414 #------------------------------------------------------------------------------
415 PROXY_PWD=
db_install.rsp
   1 ##############################################################################
   2 ##                                                                          ##
   3 ##                            DBCA response file                            ##
   4 ##                            ------------------                            ##
   5 ## Copyright   1998, 2007, Oracle Corporation. All Rights Reserved.         ##
   6 ##                                                                          ##
   7 ## Specify values for the variables listed below to customize Oracle        ##
   8 ## Database Configuration installation.                                     ##
   9 ##                                                                          ##
  10 ## Each variable is associated with a comment. The comment identifies the   ##
  11 ## variable type.                                                           ##
  12 ##                                                                          ##
  13 ## Please specify the values in the following format :                      ##
  14 ##          Type       :  Example                                           ##
  15 ##          String     :  "<value>"                                         ##
  16 ##          Boolean    :  True or False                                     ##
  17 ##          Number     :  <numeric value>                                   ##
  18 ##          StringList :  {"<value1>","<value2>"}                           ##
  19 ##                                                                          ##
  20 ## Examples :                                                               ##
  21 ##     1. dbca -progress_only -responseFile <response file>                 ##
  22 ##        Display a progress bar depicting progress of database creation    ##
  23 ##        process.                                                          ##
  24 ##                                                                          ##
  25 ##     2. dbca -silent -responseFile <response file>                        ##
  26 ##        Creates database silently. No user interface is displayed.        ##
  27 ##                                                                          ##
  28 ##     3. dbca -silent -createDatabase -cloneTemplate                       ##
  29 ##             -responseFile <response file>                      ##
  30 ##        Creates database silently with clone template. The template in    ##
  31 ##      responsefile is a clone template.                         ##
  32 ##                                                                          ##
  33 ##     4. dbca -silent -deleteDatabase -responseFile <response file>        ##
  34 ##        Deletes database silently.                                        ##
  35 ##############################################################################
  36 
  37 #-----------------------------------------------------------------------------
  38 # GENERAL section is required for all types of database creations.
  39 #-----------------------------------------------------------------------------
  40 [GENERAL]
  41 
  42 #-----------------------------------------------------------------------------
  43 # Name          : RESPONSEFILE_VERSION
  44 # Datatype      : String
  45 # Description   : Version of the database to create
  46 # Valid values  : "11.1.0"
  47 # Default value : None
  48 # Mandatory     : Yes
  49 #-----------------------------------------------------------------------------
  50 RESPONSEFILE_VERSION = "11.2.0"
  51 
  52 #-----------------------------------------------------------------------------
  53 # Name          : OPERATION_TYPE
  54 # Datatype      : String
  55 # Description   : Type of operation
  56 # Valid values  : "createDatabase" \ "createTemplateFromDB" \ "createCloneTemplate" \ "deleteDatabase" \ "configureDatabase" \ "addInstance" (RAC-only) \ "deleteInstance" (RAC-only)
  57 # Default value : None
  58 # Mandatory     : Yes
  59 #-----------------------------------------------------------------------------
  60 OPERATION_TYPE = "createDatabase"
  61 
  62 #-----------------------*** End of GENERAL section ***------------------------
  63 
  64 #-----------------------------------------------------------------------------
  65 # CREATEDATABASE section is used when OPERATION_TYPE is defined as "createDatabase". 
  66 #-----------------------------------------------------------------------------
  67 [CREATEDATABASE]
  68 
  69 #-----------------------------------------------------------------------------
  70 # Name          : GDBNAME
  71 # Datatype      : String
  72 # Description   : Global database name of the database
  73 # Valid values  : <db_name>.<db_domain> - when database domain isn't NULL
  74 #                 <db_name>             - when database domain is NULL
  75 # Default value : None
  76 # Mandatory     : Yes
  77 #-----------------------------------------------------------------------------
  78 GDBNAME = "glassfish"
  79 
  80 #-----------------------------------------------------------------------------
  81 # Name          : POLICYMANAGED
  82 # Datatype      : Boolean
  83 # Description   : Set to true if Database is policy managed and 
  84 #          set to false if  Database is admin managed
  85 # Valid values  : TRUE\FALSE
  86 # Default value : FALSE
  87 # Mandatory     : No
  88 #-----------------------------------------------------------------------------
  89 #POLICYMANAGED = "false"
  90 
  91 #-----------------------------------------------------------------------------
  92 # Name          : CREATESERVERPOOL
  93 # Datatype      : Boolean
  94 # Description   : Set to true if new server pool need to be created for database 
  95 #          if this option is specified then the newly created database 
  96 #          will use this newly created serverpool. 
  97 #          Multiple serverpoolname can not be specified for database
  98 # Valid values  : TRUE\FALSE
  99 # Default value : FALSE
 100 # Mandatory     : No
 101 #-----------------------------------------------------------------------------
 102 #CREATESERVERPOOL = "false"
 103 
 104 #-----------------------------------------------------------------------------
 105 # Name          : FORCE
 106 # Datatype      : Boolean
 107 # Description   : Set to true if new server pool need to be created by force 
 108 #          if this option is specified then the newly created serverpool
 109 #          will be assigned server even if no free servers are available.
 110 #          This may affect already running database.
 111 #          This flag can be specified for Admin managed as well as policy managed db.
 112 # Valid values  : TRUE\FALSE
 113 # Default value : FALSE
 114 # Mandatory     : No
 115 #-----------------------------------------------------------------------------
 116 #FORCE = "false"
 117 
 118 #-----------------------------------------------------------------------------
 119 # Name          : SERVERPOOLNAME
 120 # Datatype      : String
 121 # Description   : Only one serverpool name need to be specified 
 122 #           if Create Server Pool option is specified. 
 123 #           Comma-separated list of Serverpool names if db need to use
 124 #           multiple Server pool
 125 # Valid values  : ServerPool name
 126 # Default value : None
 127 # Mandatory     : No [required in case of RAC service centric database]
 128 #-----------------------------------------------------------------------------
 129 #SERVERPOOLNAME = 
 130 
 131 #-----------------------------------------------------------------------------
 132 # Name          : CARDINALITY
 133 # Datatype      : Number
 134 # Description   : Specify Cardinality for create server pool operation
 135 # Valid values  : any positive Integer value
 136 # Default value : Number of qualified nodes on cluster
 137 # Mandatory     : No [Required when a new serverpool need to be created]
 138 #-----------------------------------------------------------------------------
 139 #CARDINALITY = 
 140 
 141 #-----------------------------------------------------------------------------
 142 # Name          : SID
 143 # Datatype      : String
 144 # Description   : System identifier (SID) of the database
 145 # Valid values  : Check Oracle11g Administrator's Guide
 146 # Default value : <db_name> specified in GDBNAME
 147 # Mandatory     : No
 148 #-----------------------------------------------------------------------------
 149 SID = "glassfish"
 150 
 151 #-----------------------------------------------------------------------------
 152 # Name          : NODELIST
 153 # Datatype      : String
 154 # Description   : Comma-separated list of cluster nodes
 155 # Valid values  : Cluster node names
 156 # Default value : None
 157 # Mandatory     : No (Yes for RAC database-centric database )
 158 #-----------------------------------------------------------------------------
 159 #NODELIST=
 160 
 161 #-----------------------------------------------------------------------------
 162 # Name          : TEMPLATENAME
 163 # Datatype      : String
 164 # Description   : Name of the template
 165 # Valid values  : Template file name
 166 # Default value : None
 167 # Mandatory     : Yes
 168 #-----------------------------------------------------------------------------
 169 TEMPLATENAME = "General_Purpose.dbc"
 170 
 171 #-----------------------------------------------------------------------------
 172 # Name          : OBFUSCATEDPASSWORDS
 173 # Datatype      : Boolean
 174 # Description   : Set to true if passwords are encrypted
 175 # Valid values  : TRUE\FALSE
 176 # Default value : FALSE
 177 # Mandatory     : No
 178 #-----------------------------------------------------------------------------
 179 #OBFUSCATEDPASSWORDS = FALSE
 180 
 181 
 182 #-----------------------------------------------------------------------------
 183 # Name          : SYSPASSWORD
 184 # Datatype      : String
 185 # Description   : Password for SYS user
 186 # Valid values  : Check Oracle11g Administrator's Guide
 187 # Default value : None
 188 # Mandatory     : Yes
 189 #-----------------------------------------------------------------------------
 190 SYSPASSWORD = "glassfish"
 191 
 192 #-----------------------------------------------------------------------------
 193 # Name          : SYSTEMPASSWORD
 194 # Datatype      : String
 195 # Description   : Password for SYSTEM user
 196 # Valid values  : Check Oracle11g Administrator's Guide
 197 # Default value : None
 198 # Mandatory     : Yes
 199 #-----------------------------------------------------------------------------
 200 SYSTEMPASSWORD = "glassfish"
 201 
 202 #-----------------------------------------------------------------------------
 203 # Name          : EMCONFIGURATION
 204 # Datatype      : String
 205 # Description   : Enterprise Manager Configuration Type
 206 # Valid values  : CENTRAL|LOCAL|ALL|NOBACKUP|NOEMAIL|NONE
 207 # Default value : NONE
 208 # Mandatory     : No
 209 #-----------------------------------------------------------------------------
 210 #EMCONFIGURATION = "NONE"
 211 
 212 #-----------------------------------------------------------------------------
 213 # Name          : DISABLESECURITYCONFIGURATION
 214 # Datatype      : String
 215 # Description   : Database Security Settings
 216 # Valid values  : ALL|NONE|AUDIT|PASSWORD_PROFILE
 217 # Default value : NONE
 218 # Mandatory     : No
 219 #-----------------------------------------------------------------------------
 220 #DISABLESECURITYCONFIGURATION = "NONE"
 221 
 222 
 223 #-----------------------------------------------------------------------------
 224 # Name          : SYSMANPASSWORD
 225 # Datatype      : String
 226 # Description   : Password for SYSMAN user
 227 # Valid values  : Check Oracle11g Administrator's Guide
 228 # Default value : None
 229 # Mandatory     : Yes, if LOCAL specified for EMCONFIGURATION
 230 #-----------------------------------------------------------------------------
 231 #SYSMANPASSWORD = "password"
 232 
 233 #-----------------------------------------------------------------------------
 234 # Name          : DBSNMPPASSWORD
 235 # Datatype      : String
 236 # Description   : Password for DBSNMP user
 237 # Valid values  : Check Oracle11g Administrator's Guide
 238 # Default value : None
 239 # Mandatory     : Yes, if EMCONFIGURATION is specified
 240 #-----------------------------------------------------------------------------
 241 #DBSNMPPASSWORD = "password"
 242 
 243 #-----------------------------------------------------------------------------
 244 # Name          : CENTRALAGENT
 245 # Datatype      : String
 246 # Description   : Grid Control Central Agent Oracle Home
 247 # Default value : None
 248 # Mandatory     : Yes, if CENTRAL is specified for EMCONFIGURATION
 249 #-----------------------------------------------------------------------------
 250 #CENTRALAGENT = 
 251 
 252 #-----------------------------------------------------------------------------
 253 # Name          : HOSTUSERNAME
 254 # Datatype      : String
 255 # Description   : Host user name for EM backup job
 256 # Default value : None
 257 # Mandatory     : Yes, if ALL or NOEMAIL are specified for EMCONFIGURATION
 258 #-----------------------------------------------------------------------------
 259 #HOSTUSERNAME = 
 260 
 261 #-----------------------------------------------------------------------------
 262 # Name          : HOSTUSERPASSWORD
 263 # Datatype      : String
 264 # Description   : Host user password for EM backup job
 265 # Default value : None
 266 # Mandatory     : Yes, if ALL or NOEMAIL are specified for EMCONFIGURATION
 267 #-----------------------------------------------------------------------------
 268 #HOSTUSERPASSWORD= 
 269 
 270 #-----------------------------------------------------------------------------
 271 # Name          : BACKUPSCHEDULE
 272 # Datatype      : String
 273 # Description   : Daily backup schedule in the form of hh:mm
 274 # Default value : 2:00
 275 # Mandatory     : Yes, if ALL or NOEMAIL are specified for EMCONFIGURATION
 276 #-----------------------------------------------------------------------------
 277 #BACKUPSCHEDULE=
 278 
 279 #-----------------------------------------------------------------------------
 280 # Name          : SMTPSERVER
 281 # Datatype      : String
 282 # Description   : Outgoing mail (SMTP) server for email notifications
 283 # Default value : None
 284 # Mandatory     : Yes, if ALL or NOBACKUP are specified for EMCONFIGURATION
 285 #-----------------------------------------------------------------------------
 286 #SMTPSERVER =
 287 
 288 #-----------------------------------------------------------------------------
 289 # Name          : EMAILADDRESS
 290 # Datatype      : String
 291 # Description   : Email address for email notifications
 292 # Default value : None
 293 # Mandatory     : Yes, if ALL or NOBACKUP are specified for EMCONFIGURATION
 294 #-----------------------------------------------------------------------------
 295 #EMAILADDRESS =
 296 
 297 #-----------------------------------------------------------------------------
 298 # Name          : DVOWNERNAME
 299 # Datatype      : String
 300 # Description   : DataVault Owner
 301 # Valid values  : Check Oracle11g Administrator's Guide
 302 # Default value : None
 303 # Mandatory     : Yes, if DataVault option is chosen
 304 #-----------------------------------------------------------------------------
 305 #DVOWNERNAME = ""
 306 
 307 #-----------------------------------------------------------------------------
 308 # Name          : DVOWNERPASSWORD
 309 # Datatype      : String
 310 # Description   : Password for DataVault Owner
 311 # Valid values  : Check Oracle11g Administrator's Guide
 312 # Default value : None
 313 # Mandatory     : Yes, if DataVault option is chosen
 314 #-----------------------------------------------------------------------------
 315 #DVOWNERPASSWORD = ""
 316 
 317 #-----------------------------------------------------------------------------
 318 # Name          : DVACCOUNTMANAGERNAME
 319 # Datatype      : String
 320 # Description   : DataVault Account Manager
 321 # Valid values  : Check Oracle11g Administrator's Guide
 322 # Default value : None
 323 # Mandatory     : No
 324 #-----------------------------------------------------------------------------
 325 #DVACCOUNTMANAGERNAME = ""
 326 
 327 #-----------------------------------------------------------------------------
 328 # Name          : DVACCOUNTMANAGERPASSWORD
 329 # Datatype      : String
 330 # Description   : Password for  DataVault Account Manager
 331 # Valid values  : Check Oracle11g Administrator's Guide
 332 # Default value : None
 333 # Mandatory     : No
 334 #-----------------------------------------------------------------------------
 335 #DVACCOUNTMANAGERPASSWORD = ""
 336 
 337 
 338 
 339 #-----------------------------------------------------------------------------
 340 # Name          : DATAFILEJARLOCATION 
 341 # Datatype      : String
 342 # Description   : Location of the data file jar 
 343 # Valid values  : Directory containing compressed datafile jar
 344 # Default value : None
 345 # Mandatory     : No
 346 #-----------------------------------------------------------------------------
 347 #DATAFILEJARLOCATION =
 348 
 349 #-----------------------------------------------------------------------------
 350 # Name          : DATAFILEDESTINATION 
 351 # Datatype      : String
 352 # Description   : Location of the data file's
 353 # Valid values  : Directory for all the database files
 354 # Default value : $ORACLE_BASE/oradata
 355 # Mandatory     : No
 356 #-----------------------------------------------------------------------------
 357 #DATAFILEDESTINATION =
 358 
 359 #-----------------------------------------------------------------------------
 360 # Name          : RECOVERYAREADESTINATION
 361 # Datatype      : String
 362 # Description   : Location of the data file's
 363 # Valid values  : Recovery Area location
 364 # Default value : $ORACLE_BASE/flash_recovery_area
 365 # Mandatory     : No
 366 #-----------------------------------------------------------------------------
 367 #RECOVERYAREADESTINATION=
 368 
 369 #-----------------------------------------------------------------------------
 370 # Name          : STORAGETYPE
 371 # Datatype      : String
 372 # Description   : Specifies the storage on which the database is to be created
 373 # Valid values  : FS (CFS for RAC), ASM
 374 # Default value : FS
 375 # Mandatory     : No
 376 #-----------------------------------------------------------------------------
 377 #STORAGETYPE=FS
 378 
 379 #-----------------------------------------------------------------------------
 380 # Name          : DISKGROUPNAME
 381 # Datatype      : String
 382 # Description   : Specifies the disk group name for the storage
 383 # Default value : DATA
 384 # Mandatory     : No
 385 #-----------------------------------------------------------------------------
 386 #DISKGROUPNAME=DATA
 387 
 388 #-----------------------------------------------------------------------------
 389 # Name          : ASMSNMP_PASSWORD
 390 # Datatype      : String
 391 # Description   : Password for ASM Monitoring
 392 # Default value : None
 393 # Mandatory     : No
 394 #-----------------------------------------------------------------------------
 395 #ASMSNMP_PASSWORD=""
 396 
 397 #-----------------------------------------------------------------------------
 398 # Name          : RECOVERYGROUPNAME
 399 # Datatype      : String
 400 # Description   : Specifies the disk group name for the recovery area
 401 # Default value : RECOVERY
 402 # Mandatory     : No
 403 #-----------------------------------------------------------------------------
 404 #RECOVERYGROUPNAME=RECOVERY
 405 
 406 
 407 #-----------------------------------------------------------------------------
 408 # Name          : CHARACTERSET
 409 # Datatype      : String
 410 # Description   : Character set of the database
 411 # Valid values  : Check Oracle11g National Language Support Guide
 412 # Default value : "US7ASCII"
 413 # Mandatory     : NO
 414 #-----------------------------------------------------------------------------
 415 CHARACTERSET = "AL32UTF8"
 416 
 417 #-----------------------------------------------------------------------------
 418 # Name          : NATIONALCHARACTERSET
 419 # Datatype      : String
 420 # Description   : National Character set of the database
 421 # Valid values  : "UTF8" or "AL16UTF16". For details, check Oracle11g National Language Support Guide
 422 # Default value : "AL16UTF16"
 423 # Mandatory     : No
 424 #-----------------------------------------------------------------------------
 425 #NATIONALCHARACTERSET= "UTF8"
 426 
 427 #-----------------------------------------------------------------------------
 428 # Name          : REGISTERWITHDIRSERVICE
 429 # Datatype      : Boolean
 430 # Description   : Specifies whether to register with Directory Service.
 431 # Valid values  : TRUE \ FALSE
 432 # Default value : FALSE
 433 # Mandatory     : No
 434 #-----------------------------------------------------------------------------
 435 #REGISTERWITHDIRSERVICE= TRUE
 436 
 437 #-----------------------------------------------------------------------------
 438 # Name          : DIRSERVICEUSERNAME
 439 # Datatype      : String
 440 # Description   : Specifies the name of the directory service user
 441 # Mandatory     : YES, if the value of registerWithDirService is TRUE
 442 #-----------------------------------------------------------------------------
 443 #DIRSERVICEUSERNAME= "name"
 444 
 445 #-----------------------------------------------------------------------------
 446 # Name          : DIRSERVICEPASSWORD
 447 # Datatype      : String
 448 # Description   : The password of the directory service user.
 449 #          You can also specify the password at the command prompt instead of here.
 450 # Mandatory     : YES, if the value of registerWithDirService is TRUE
 451 #-----------------------------------------------------------------------------
 452 #DIRSERVICEPASSWORD= "password"
 453 
 454 #-----------------------------------------------------------------------------
 455 # Name          : WALLETPASSWORD
 456 # Datatype      : String
 457 # Description   : The password for wallet to created or modified.
 458 #          You can also specify the password at the command prompt instead of here.
 459 # Mandatory     : YES, if the value of registerWithDirService is TRUE
 460 #-----------------------------------------------------------------------------
 461 #WALLETPASSWORD= "password"
 462 
 463 #-----------------------------------------------------------------------------
 464 # Name          : LISTENERS
 465 # Datatype      : String
 466 # Description   : Specifies list of listeners to register the database with.
 467 #          By default the database is configured for all the listeners specified in the 
 468 #          $ORACLE_HOME/network/admin/listener.ora     
 469 # Valid values  : The list should be space separated names like "listener1 listener2".
 470 # Mandatory     : NO
 471 #-----------------------------------------------------------------------------
 472 #LISTENERS = "listener1 listener2"
 473 
 474 #-----------------------------------------------------------------------------
 475 # Name          : VARIABLESFILE 
 476 # Datatype      : String
 477 # Description   : Location of the file containing variable value pair
 478 # Valid values  : A valid file-system file. The variable value pair format in this file 
 479 #          is <variable>=<value>. Each pair should be in a new line.
 480 # Default value : None
 481 # Mandatory     : NO
 482 #-----------------------------------------------------------------------------
 483 #VARIABLESFILE =
 484 
 485 #-----------------------------------------------------------------------------
 486 # Name          : VARIABLES
 487 # Datatype      : String
 488 # Description   : comma separated list of name=value pairs. Overrides variables defined in variablefile and templates
 489 # Default value : None
 490 # Mandatory     : NO
 491 #-----------------------------------------------------------------------------
 492 #VARIABLES =
 493 
 494 #-----------------------------------------------------------------------------
 495 # Name          : INITPARAMS
 496 # Datatype      : String
 497 # Description   : comma separated list of name=value pairs. Overrides initialization parameters defined in templates
 498 # Default value : None
 499 # Mandatory     : NO
 500 #-----------------------------------------------------------------------------
 501 #INITPARAMS =
 502 
 503 #-----------------------------------------------------------------------------
 504 # Name          : MEMORYPERCENTAGE
 505 # Datatype      : String
 506 # Description   : percentage of physical memory for Oracle
 507 # Default value : None
 508 # Mandatory     : NO
 509 #-----------------------------------------------------------------------------
 510 #MEMORYPERCENTAGE = "40"
 511 
 512 #-----------------------------------------------------------------------------
 513 # Name          : DATABASETYPE
 514 # Datatype      : String
 515 # Description   : used for memory distribution when MEMORYPERCENTAGE specified
 516 # Valid values  : MULTIPURPOSE|DATA_WAREHOUSING|OLTP
 517 # Default value : MULTIPURPOSE
 518 # Mandatory     : NO
 519 #-----------------------------------------------------------------------------
 520 #DATABASETYPE = "MULTIPURPOSE"
 521 
 522 #-----------------------------------------------------------------------------
 523 # Name          : AUTOMATICMEMORYMANAGEMENT
 524 # Datatype      : Boolean
 525 # Description   : flag to indicate Automatic Memory Management is used
 526 # Valid values  : TRUE/FALSE
 527 # Default value : TRUE
 528 # Mandatory     : NO
 529 #-----------------------------------------------------------------------------
 530 #AUTOMATICMEMORYMANAGEMENT = "TRUE"
 531 
 532 #-----------------------------------------------------------------------------
 533 # Name          : TOTALMEMORY
 534 # Datatype      : String
 535 # Description   : total memory in MB to allocate to Oracle
 536 # Valid values  : 
 537 # Default value : 
 538 # Mandatory     : NO
 539 #-----------------------------------------------------------------------------
 540 TOTALMEMORY = "10240"
 541 
 542 
 543 #-----------------------*** End of CREATEDATABASE section ***------------------------
 544 
 545 #-----------------------------------------------------------------------------
 546 # createTemplateFromDB section is used when OPERATION_TYPE is defined as "createTemplateFromDB". 
 547 #-----------------------------------------------------------------------------
 548 [createTemplateFromDB]
 549 #-----------------------------------------------------------------------------
 550 # Name          : SOURCEDB 
 551 # Datatype      : String
 552 # Description   : The source database from which to create the template
 553 # Valid values  : The format is <host>:<port>:<sid>
 554 # Default value : none
 555 # Mandatory     : YES
 556 #-----------------------------------------------------------------------------
 557 SOURCEDB = "myhost:1521:orcl"
 558 
 559 #-----------------------------------------------------------------------------
 560 # Name          : SYSDBAUSERNAME 
 561 # Datatype      : String
 562 # Description   : A user with DBA role.
 563 # Default value : none
 564 # Mandatory     : YES
 565 #-----------------------------------------------------------------------------
 566 SYSDBAUSERNAME = "system"
 567 
 568 #-----------------------------------------------------------------------------
 569 # Name          : SYSDBAPASSWORD 
 570 # Datatype      : String
 571 # Description   : The password of the DBA user.
 572 #          You can also specify the password at the command prompt instead of here.
 573 # Default value : none
 574 # Mandatory     : YES
 575 #-----------------------------------------------------------------------------
 576 #SYSDBAPASSWORD = "password"
 577 
 578 #-----------------------------------------------------------------------------
 579 # Name          : TEMPLATENAME
 580 # Datatype      : String
 581 # Description   : Name for the new template.
 582 # Default value : None
 583 # Mandatory     : Yes
 584 #-----------------------------------------------------------------------------
 585 TEMPLATENAME = "My Copy TEMPLATE"
 586 
 587 #-----------------------*** End of createTemplateFromDB section ***------------------------
 588 
 589 #-----------------------------------------------------------------------------
 590 # createCloneTemplate section is used when OPERATION_TYPE is defined as "createCloneTemplate". 
 591 #-----------------------------------------------------------------------------
 592 [createCloneTemplate]
 593 #-----------------------------------------------------------------------------
 594 # Name          : SOURCEDB
 595 # Datatype      : String
 596 # Description   : The source database is the SID from which to create the template. 
 597 #          This database must be local and on the same ORACLE_HOME.
 598 # Default value : none
 599 # Mandatory     : YES
 600 #-----------------------------------------------------------------------------
 601 SOURCEDB = "orcl"
 602 
 603 #-----------------------------------------------------------------------------
 604 # Name          : SYSDBAUSERNAME
 605 # Datatype      : String
 606 # Description   : A user with DBA role.
 607 # Default value : none
 608 # Mandatory     : YES, if no OS authentication
 609 #-----------------------------------------------------------------------------
 610 #SYSDBAUSERNAME = "sys"
 611 
 612 #-----------------------------------------------------------------------------
 613 # Name          : SYSDBAPASSWORD
 614 # Datatype      : String
 615 # Description   : The password of the DBA user.
 616 #          You can also specify the password at the command prompt instead of here.
 617 # Default value : none
 618 # Mandatory     : YES
 619 #-----------------------------------------------------------------------------
 620 #SYSDBAPASSWORD = "password"
 621 
 622 #-----------------------------------------------------------------------------
 623 # Name          : TEMPLATENAME
 624 # Datatype      : String
 625 # Description   : Name for the new template.
 626 # Default value : None
 627 # Mandatory     : Yes
 628 #-----------------------------------------------------------------------------
 629 TEMPLATENAME = "My Clone TEMPLATE"
 630 
 631 #-----------------------------------------------------------------------------
 632 # Name          : DATAFILEJARLOCATION
 633 # Datatype      : String
 634 # Description   : Location of the data file jar 
 635 # Valid values  : Directory where the new compressed datafile jar will be placed
 636 # Default value : $ORACLE_HOME/assistants/dbca/templates
 637 # Mandatory     : NO
 638 #-----------------------------------------------------------------------------
 639 #DATAFILEJARLOCATION = 
 640 
 641 #-----------------------*** End of createCloneTemplate section ***------------------------
 642 
 643 #-----------------------------------------------------------------------------
 644 # DELETEDATABASE section is used when DELETE_TYPE is defined as "deleteDatabase". 
 645 #-----------------------------------------------------------------------------
 646 [DELETEDATABASE]
 647 #-----------------------------------------------------------------------------
 648 # Name          : SOURCEDB
 649 # Datatype      : String
 650 # Description   : The source database is the SID 
 651 #          This database must be local and on the same ORACLE_HOME.
 652 # Default value : none
 653 # Mandatory     : YES
 654 #-----------------------------------------------------------------------------
 655 SOURCEDB = "orcl"
 656 
 657 #-----------------------------------------------------------------------------
 658 # Name          : SYSDBAUSERNAME
 659 # Datatype      : String
 660 # Description   : A user with DBA role.
 661 # Default value : none
 662 # Mandatory     : YES, if no OS authentication
 663 #-----------------------------------------------------------------------------
 664 #SYSDBAUSERNAME = "sys"
 665 
 666 #-----------------------------------------------------------------------------
 667 # Name          : SYSDBAPASSWORD
 668 # Datatype      : String
 669 # Description   : The password of the DBA user.
 670 #          You can also specify the password at the command prompt instead of here.
 671 # Default value : none
 672 # Mandatory     : YES, if no OS authentication
 673 #-----------------------------------------------------------------------------
 674 #SYSDBAPASSWORD = "password"
 675 #-----------------------*** End of deleteDatabase section ***------------------------
 676 
 677 #-----------------------------------------------------------------------------
 678 # GENERATESCRIPTS section 
 679 #-----------------------------------------------------------------------------
 680 [generateScripts]
 681 #-----------------------------------------------------------------------------
 682 # Name          : TEMPLATENAME
 683 # Datatype      : String
 684 # Description   : Name of the template
 685 # Valid values  : Template name as seen in DBCA
 686 # Default value : None
 687 # Mandatory     : Yes
 688 #-----------------------------------------------------------------------------
 689 TEMPLATENAME = "New Database"
 690 
 691 #-----------------------------------------------------------------------------
 692 # Name          : GDBNAME
 693 # Datatype      : String
 694 # Description   : Global database name of the database
 695 # Valid values  : <db_name>.<db_domain> - when database domain isn't NULL
 696 #                 <db_name>             - when database domain is NULL
 697 # Default value : None
 698 # Mandatory     : Yes
 699 #-----------------------------------------------------------------------------
 700 GDBNAME = "orcl11.us.oracle.com"
 701 
 702 #-----------------------------------------------------------------------------
 703 # Name          : SCRIPTDESTINATION 
 704 # Datatype      : String
 705 # Description   : Location of the scripts
 706 # Valid values  : Directory for all the scripts
 707 # Default value : None
 708 # Mandatory     : No
 709 #-----------------------------------------------------------------------------
 710 #SCRIPTDESTINATION =
 711 
 712 #-----------------------*** End of deleteDatabase section ***------------------------
 713 
 714 #-----------------------------------------------------------------------------
 715 # CONFIGUREDATABASE section is used when OPERATION_TYPE is defined as "configureDatabase". 
 716 #-----------------------------------------------------------------------------
 717 [CONFIGUREDATABASE]
 718 
 719 #-----------------------------------------------------------------------------
 720 # Name          : SOURCEDB
 721 # Datatype      : String
 722 # Description   : The source database is the SID 
 723 #          This database must be local and on the same ORACLE_HOME.
 724 # Default value : none
 725 # Mandatory     : YES
 726 #-----------------------------------------------------------------------------
 727 #SOURCEDB = "orcl"
 728 
 729 #-----------------------------------------------------------------------------
 730 # Name          : SYSDBAUSERNAME
 731 # Datatype      : String
 732 # Description   : A user with DBA role.
 733 # Default value : none
 734 # Mandatory     : YES, if no OS authentication
 735 #-----------------------------------------------------------------------------
 736 #SYSDBAUSERNAME = "sys"
 737 
 738 
 739 #-----------------------------------------------------------------------------
 740 # Name          : SYSDBAPASSWORD
 741 # Datatype      : String
 742 # Description   : The password of the DBA user.
 743 #          You can also specify the password at the command prompt instead of here.
 744 # Default value : none
 745 # Mandatory     : YES, if no OS authentication
 746 #-----------------------------------------------------------------------------
 747 #SYSDBAPASSWORD =
 748 
 749 #-----------------------------------------------------------------------------
 750 # Name          : REGISTERWITHDIRSERVICE
 751 # Datatype      : Boolean
 752 # Description   : Specifies whether to register with Directory Service.
 753 # Valid values  : TRUE \ FALSE
 754 # Default value : FALSE
 755 # Mandatory     : No
 756 #-----------------------------------------------------------------------------
 757 #REGISTERWITHDIRSERVICE= TRUE
 758 
 759 #-----------------------------------------------------------------------------
 760 # Name          : UNREGISTERWITHDIRSERVICE
 761 # Datatype      : Boolean
 762 # Description   : Specifies whether to unregister with Directory Service.
 763 # Valid values  : TRUE \ FALSE
 764 # Default value : FALSE
 765 # Mandatory     : No
 766 #-----------------------------------------------------------------------------
 767 #UNREGISTERWITHDIRSERVICE= TRUE
 768 
 769 #-----------------------------------------------------------------------------
 770 # Name          : REGENERATEDBPASSWORD
 771 # Datatype      : Boolean
 772 # Description   : Specifies whether regenerate database password in OID/Wallet
 773 # Valid values  : TRUE \ FALSE
 774 # Default value : FALSE
 775 # Mandatory     : No
 776 #-----------------------------------------------------------------------------
 777 #REGENERATEDBPASSWORD= TRUE
 778 
 779 #-----------------------------------------------------------------------------
 780 # Name          : DIRSERVICEUSERNAME
 781 # Datatype      : String
 782 # Description   : Specifies the name of the directory service user
 783 # Mandatory     : YES, if the any of the reg/unreg/regenPasswd options specified
 784 #-----------------------------------------------------------------------------
 785 #DIRSERVICEUSERNAME= "name"
 786 
 787 #-----------------------------------------------------------------------------
 788 # Name          : DIRSERVICEPASSWORD
 789 # Datatype      : String
 790 # Description   : The password of the directory service user.
 791 #          You can also specify the password at the command prompt instead of here.
 792 # Mandatory     : YES, if the any of the reg/unreg/regenPasswd options specified
 793 #-----------------------------------------------------------------------------
 794 #DIRSERVICEPASSWORD= "password"
 795 
 796 #-----------------------------------------------------------------------------
 797 # Name          : WALLETPASSWORD
 798 # Datatype      : String
 799 # Description   : The password for wallet to created or modified.
 800 #          You can also specify the password at the command prompt instead of here.
 801 # Mandatory     : YES, if the any of the reg/unreg/regenPasswd options specified
 802 #-----------------------------------------------------------------------------
 803 #WALLETPASSWORD= "password"
 804 
 805 #-----------------------------------------------------------------------------
 806 # Name          : DISABLESECURITYCONFIGURATION
 807 # Datatype      : String
 808 # Description   : Database Security Settings
 809 # Valid values  : ALL|NONE|AUDIT|PASSWORD_PROFILE
 810 # Default value : NONE
 811 # Mandatory     : No
 812 #-----------------------------------------------------------------------------
 813 #DISABLESECURITYCONFIGURATION = "NONE"
 814 
 815 
 816 
 817 #-----------------------------------------------------------------------------
 818 # Name          : ENABLESECURITYCONFIGURATION
 819 # Datatype      : String
 820 # Description   : Database Security Settings
 821 # Valid values  : true|false
 822 # Default value : true
 823 # Mandatory     : No
 824 #-----------------------------------------------------------------------------
 825 #ENABLESECURITYCONFIGURATION = "true"
 826 
 827 
 828 #-----------------------------------------------------------------------------
 829 # Name          : EMCONFIGURATION
 830 # Datatype      : String
 831 # Description   : Enterprise Manager Configuration Type
 832 # Valid values  : CENTRAL|LOCAL|ALL|NOBACKUP|NOEMAIL|NONE
 833 # Default value : NONE
 834 # Mandatory     : No
 835 #-----------------------------------------------------------------------------
 836 #EMCONFIGURATION = "NONE"
 837 
 838 #-----------------------------------------------------------------------------
 839 # Name          : SYSMANPASSWORD
 840 # Datatype      : String
 841 # Description   : Password for SYSMAN user
 842 # Valid values  : Check Oracle11g Administrator's Guide
 843 # Default value : None
 844 # Mandatory     : Yes, if LOCAL specified for EMCONFIGURATION
 845 #-----------------------------------------------------------------------------
 846 #SYSMANPASSWORD = "password"
 847 
 848 #-----------------------------------------------------------------------------
 849 # Name          : DBSNMPPASSWORD
 850 # Datatype      : String
 851 # Description   : Password for DBSNMP user
 852 # Valid values  : Check Oracle11g Administrator's Guide
 853 # Default value : None
 854 # Mandatory     : Yes, if EMCONFIGURATION is specified
 855 #-----------------------------------------------------------------------------
 856 #DBSNMPPASSWORD = "password"
 857 
 858 #-----------------------------------------------------------------------------
 859 # Name          : CENTRALAGENT
 860 # Datatype      : String
 861 # Description   : Grid Control Central Agent Oracle Home
 862 # Default value : None
 863 # Mandatory     : Yes, if CENTRAL is specified for EMCONFIGURATION
 864 #-----------------------------------------------------------------------------
 865 #CENTRALAGENT = 
 866 
 867 #-----------------------------------------------------------------------------
 868 # Name          : HOSTUSERNAME
 869 # Datatype      : String
 870 # Description   : Host user name for EM backup job
 871 # Default value : None
 872 # Mandatory     : Yes, if ALL or NOEMAIL are specified for EMCONFIGURATION
 873 #-----------------------------------------------------------------------------
 874 #HOSTUSERNAME = 
 875 
 876 #-----------------------------------------------------------------------------
 877 # Name          : HOSTUSERPASSWORD
 878 # Datatype      : String
 879 # Description   : Host user password for EM backup job
 880 # Default value : None
 881 # Mandatory     : Yes, if ALL or NOEMAIL are specified for EMCONFIGURATION
 882 #-----------------------------------------------------------------------------
 883 #HOSTUSERPASSWORD= 
 884 
 885 #-----------------------------------------------------------------------------
 886 # Name          : BACKUPSCHEDULE
 887 # Datatype      : String
 888 # Description   : Daily backup schedule in the form of hh:mm
 889 # Default value : 2:00
 890 # Mandatory     : Yes, if ALL or NOEMAIL are specified for EMCONFIGURATION
 891 #-----------------------------------------------------------------------------
 892 #BACKUPSCHEDULE=
 893 
 894 #-----------------------------------------------------------------------------
 895 # Name          : SMTPSERVER
 896 # Datatype      : String
 897 # Description   : Outgoing mail (SMTP) server for email notifications
 898 # Default value : None
 899 # Mandatory     : Yes, if ALL or NOBACKUP are specified for EMCONFIGURATION
 900 #-----------------------------------------------------------------------------
 901 #SMTPSERVER =
 902 
 903 #-----------------------------------------------------------------------------
 904 # Name          : EMAILADDRESS
 905 # Datatype      : String
 906 # Description   : Email address for email notifications
 907 # Default value : None
 908 # Mandatory     : Yes, if ALL or NOBACKUP are specified for EMCONFIGURATION
 909 #-----------------------------------------------------------------------------
 910 #EMAILADDRESS =
 911 
 912 #-----------------------*** End of CONFIGUREDATABASE section ***------------------------
 913 
 914 
 915 #-----------------------------------------------------------------------------
 916 # ADDINSTANCE section is used when OPERATION_TYPE is defined as "addInstance". 
 917 #-----------------------------------------------------------------------------
 918 [ADDINSTANCE]
 919 
 920 #-----------------------------------------------------------------------------
 921 # Name          : DB_UNIQUE_NAME
 922 # Datatype      : String
 923 # Description   : DB Unique Name of the RAC database
 924 # Valid values  : <db_unique_name>
 925 # Default value : None
 926 # Mandatory     : Yes
 927 #-----------------------------------------------------------------------------
 928 DB_UNIQUE_NAME = "orcl11g.us.oracle.com"
 929 
 930 #-----------------------------------------------------------------------------
 931 # Name          : INSTANCENAME
 932 # Datatype      : String
 933 # Description   : RAC instance name to be added
 934 # Valid values  : Check Oracle11g Administrator's Guide
 935 # Default value : <sid_prefix>+<highest_current_thread+1>
 936 # Mandatory     : No
 937 #-----------------------------------------------------------------------------
 938 #INSTANCENAME = "orcl1"
 939 
 940 #-----------------------------------------------------------------------------
 941 # Name          : NODELIST
 942 # Datatype      : String
 943 # Description   : Node on which to add new instance 
 944 #                 (in 10gR2, instance addition is supported on 1 node at a time)
 945 # Valid values  : Cluster node name
 946 # Default value : None
 947 # Mandatory     : Yes
 948 #-----------------------------------------------------------------------------
 949 NODELIST=
 950 
 951 #-----------------------------------------------------------------------------
 952 # Name          : OBFUSCATEDPASSWORDS
 953 # Datatype      : Boolean
 954 # Description   : Set to true if passwords are encrypted
 955 # Valid values  : TRUE\FALSE
 956 # Default value : FALSE
 957 # Mandatory     : No
 958 #-----------------------------------------------------------------------------
 959 #OBFUSCATEDPASSWORDS = FALSE
 960 
 961 #-----------------------------------------------------------------------------
 962 # Name          : SYSDBAUSERNAME 
 963 # Datatype      : String
 964 # Description   : A user with DBA role.
 965 # Default value : none
 966 # Mandatory     : YES
 967 #-----------------------------------------------------------------------------
 968 SYSDBAUSERNAME = "sys"
 969 
 970 #-----------------------------------------------------------------------------
 971 # Name          : SYSDBAPASSWORD 
 972 # Datatype      : String
 973 # Description   : The password of the DBA user.
 974 # Default value : none
 975 # Mandatory     : YES
 976 #-----------------------------------------------------------------------------
 977 #SYSDBAPASSWORD = "password"
 978 
 979 #-----------------------*** End of ADDINSTANCE section ***------------------------
 980 
 981 
 982 #-----------------------------------------------------------------------------
 983 # DELETEINSTANCE section is used when OPERATION_TYPE is defined as "deleteInstance". 
 984 #-----------------------------------------------------------------------------
 985 [DELETEINSTANCE]
 986 
 987 #-----------------------------------------------------------------------------
 988 # Name          : DB_UNIQUE_NAME
 989 # Datatype      : String
 990 # Description   : DB Unique Name of the RAC database
 991 # Valid values  : <db_unique_name>
 992 # Default value : None
 993 # Mandatory     : Yes
 994 #-----------------------------------------------------------------------------
 995 DB_UNIQUE_NAME = "orcl11g.us.oracle.com"
 996 
 997 #-----------------------------------------------------------------------------
 998 # Name          : INSTANCENAME
 999 # Datatype      : String
1000 # Description   : RAC instance name to be deleted
1001 # Valid values  : Check Oracle11g Administrator's Guide
1002 # Default value : None
1003 # Mandatory     : Yes
1004 #-----------------------------------------------------------------------------
1005 INSTANCENAME = "orcl11g"
1006 
1007 #-----------------------------------------------------------------------------
1008 # Name          : NODELIST
1009 # Datatype      : String
1010 # Description   : Node on which instance to be deleted (SID) is located
1011 # Valid values  : Cluster node name
1012 # Default value : None
1013 # Mandatory     : No
1014 #-----------------------------------------------------------------------------
1015 #NODELIST=
1016 
1017 #-----------------------------------------------------------------------------
1018 # Name          : OBFUSCATEDPASSWORDS
1019 # Datatype      : Boolean
1020 # Description   : Set to true if passwords are encrypted
1021 # Valid values  : TRUE\FALSE
1022 # Default value : FALSE
1023 # Mandatory     : No
1024 #-----------------------------------------------------------------------------
1025 #OBFUSCATEDPASSWORDS = FALSE
1026 
1027 #-----------------------------------------------------------------------------
1028 # Name          : SYSDBAUSERNAME 
1029 # Datatype      : String
1030 # Description   : A user with DBA role.
1031 # Default value : none
1032 # Mandatory     : YES
1033 #-----------------------------------------------------------------------------
1034 SYSDBAUSERNAME = "sys"
1035 
1036 #-----------------------------------------------------------------------------
1037 # Name          : SYSDBAPASSWORD 
1038 # Datatype      : String
1039 # Description   : The password of the DBA user.
1040 # Default value : none
1041 # Mandatory     : YES
1042 #-----------------------------------------------------------------------------
1043 #SYSDBAPASSWORD = "password"
1044 
1045 
1046 #-----------------------*** End of DELETEINSTANCE section ***------------------------
dbca.rsp
 
二、安装
$cd /home/oracle/database
$./runInstaller -silent -responseFile /home/oracle/response/db_install.rsp
 
//当安装界面出现如下信息的时候  打开另一个终端窗口
The installation of Oracle Database 11g was successful.
Please check '/home/oracle/oraInventory/logs/silentInstall2016-02-04_09-21-13AM.log' for more details.
As a root user, execute the following script(s):
 1. /home/oracle/oraInventory/orainstRoot.sh
 2. /home/oracle/app/oracle/product/11.2.0/dbhome_1/root.sh
Successfully Setup Software.
 
//在新打开的root登录的窗口中执行下面的脚本
#/opt/oracle_11/oraInventory/orainstRoot.sh
#/opt/oracle_11/app/oracle/product/11.2.0/dbhome_1/root.sh
//执行完上面的脚本后回到安装终端窗口按下Enter键以继续
 
三、配置监听
$cd /home/oracle/response
$netca /silent /responsefile /home/oracle/response/netca.rsp
出现以下则成功
Parsing command line arguments:
    Parameter "silent" = true
    Parameter "responsefile" = /opt/database/response/netca.rsp
Done parsing command line arguments.
Oracle Net Services Configuration:
Profile configuration complete.
Listener "LISTENER" already exists.
Oracle Net Services configuration successful. The exit code is 0
 
查看监听状态
$lsnrctl status
$dbca -silent -responseFile /home/oracle/response/dbca.rsp 
 
四、启动数据库
$ sqlplus / as sysdba  //as前有个空格
[oracle@oracledb ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Mon Feb 16 14:26:57 2015
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> start
SP2-1506: START, @ or @@ command has no arguments
SQL> startup
ORACLE instance started.
Total System Global Area 3290345472 bytes
Fixed Size                  2217832 bytes
Variable Size            1795164312 bytes
Database Buffers         1476395008 bytes
Redo Buffers               16568320 bytes
Database mounted.
Database opened.
SQL> 
使用show parameter;或者select table_name from dba_tables看看是否正常
 
 
一些错误总结:
1、
解决:
换一个终端窗口切换到Oracle继续安装
2、
Checking swap space: 0 MB available, 150 MB required.    Failed <<<<
解决:

dd if=/dev/zero of=/home/swapfile bs=1M count=512
mkswap /home/swapfile
swapon /home/swapfile

/home/swapfile swap swap defaults 0 0

3、

Error in writing to directory/tmp/OraInstall2012-09-16_01-54-05AM. Please ensure that this directory iswritable and has atleast 60 MB of disk space.

解决:

权限问题,请检查权限和路径

4、

[SEVERE] - Email Address Not Specified

如果你是下载我提供的模板,是不会出现这个问题。

这个是因为db_install.rsp 中的 DECLINE_SECURITY_UPDATES没有设或者为false

注意:DECLINE_SECURITY_UPDATES=true

posted @ 2016-09-18 09:13  风吹过的绿洲  阅读(3610)  评论(3编辑  收藏  举报