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/下,如果你安装在其他目录,请自行修改上面环境变量配置的路径和这几个文件的路径
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
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=
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
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 ***------------------------
二、安装
$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