一、安装环境
1.linux版本:redhat6.3_x86_64
2.oracle版本：Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
二、安装前准备工作
1、修改主机名（不是必须的，如果不设置，直接使用原来的）
设置主机名为www
hostname www #设置主机名为www
vi /etc/sysconfig/network #编辑配置文件
HOSTNAME=www #修改localhost.localdomain为www
:wq! #保存退出
vi /etc/hosts #编辑配置文件
127.0.0.1 www localhost #修改localhost.localdomain为www :wq! #保存退出
shutdown -r now #重启系统
2、修改/etc/sysconfig/iptables文件，开通1521端口：
# vi /etc/sysconfig/iptables
-A INPUT -m state --state NEW -m tcp -p tcp --dport 1521 -j ACCEPT
重启iptables服务：
#service iptables restart
3、安装依赖包
1）挂载linux ios包
#cd media
#mkdir cdrom
#mount -t iso9660 -o loop /dev/cdrom /media/cdrom
2)配置本地yum库
#cd /etc/yum.repos.d
#vi rhel-media.repo
写入一下内容：
[rhel-media]
name=Red Hat Enterprise Linux 6.3
baseurl=file:///media/cdrom
enabled=1
gpgcheck=1
gpgkey=file:///media/cdrom/RPM-GPG-KEY-redhat-release
保存，测试：
# yum list
um-plugin-aliases.noarch 1.1.30-14.el6 rhel-media
yum-plugin-changelog.noarch 1.1.30-14.el6 rhel-media
yum-plugin-downloadonly.noarch 1.1.30-14.el6 rhel-media
yum-plugin-security.noarch 1.1.30-14.el6 rhel-media
yum-plugin-tmprepo.noarch 1.1.30-14.el6 rhel-media
yum-plugin-verify.noarch 1.1.30-14.el6 rhel-media
yum-plugin-versionlock.noarch 1.1.30-14.el6 rhel-media
yum-presto.noarch 0.6.2-1.el6 rhel-media
......
如类似显示表示已经成功，可以使用yum安装本地库了
3）安装oracle依赖库
yum -y install binutils compat-libcap1 compat-libstdc++-33 compat-libstdc++-33*i686 gcc gcc-c++ glibc glibc*.i686 glibc-devel glibc-devel*.i686 ksh libaio libaio*.i686 libaio-devel libaio-devel*.i686 libgcc libgcc*.i686 libstdc++ libstdc++*.i686 libstdc++-devel libstdc++-devel*.i686 libXau libXau*.i686 libxcb libxcb*.i686 libX11 libX11*.i686 libXext libXext*.i686 libXi libXi*.i686 libXtst libXtst*.i686 make sysstat libtool libtool*.i686 unixODBC unixODBC*.i686 unixODBC-devel unixODBC-devel*.i686
查看系统是否安装了该软件包
#rpm -q package_name
如：#rpm -q compat-libstdc++-33
4、编辑/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
5、修改/etc/security/limits.conf文件
在打开的文件底部添加下面内容
oracle soft nproc 2047
oracle hard nproc 16384
oralce soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
6、建立用户组及用户
# 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
7、创建安装目录
# 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/
8、编辑 /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
注意：if和“[”之间要有空格，“=”两边也要有空格
三、解压安装包到/home/oracle目录下
#su - oracle
$ unzip p10404530_112030_Linux-x86-64_1of7.zip
$ unzip p10404530_112030_Linux-x86-64_2of7.zip
四、修改静默安装的模板
$ 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,2011. 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=www 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 # This is an optional parameter if installing on 47 # Windows based Operating System. 48 #------------------------------------------------------------------------------- 49 INVENTORY_LOCATION=/opt/oracle_11/oraInventory 50 51 #------------------------------------------------------------------------------- 52 # Specify the languages in which the components will be installed. 53 # 54 # en : English ja : Japanese 55 # fr : French ko : Korean 56 # ar : Arabic es : Latin American Spanish 57 # bn : Bengali lv : Latvian 58 # pt_BR: Brazilian Portuguese lt : Lithuanian 59 # bg : Bulgarian ms : Malay 60 # fr_CA: Canadian French es_MX: Mexican Spanish 61 # ca : Catalan no : Norwegian 62 # hr : Croatian pl : Polish 63 # cs : Czech pt : Portuguese 64 # da : Danish ro : Romanian 65 # nl : Dutch ru : Russian 66 # ar_EG: Egyptian zh_CN: Simplified Chinese 67 # en_GB: English (Great Britain) sk : Slovak 68 # et : Estonian sl : Slovenian 69 # fi : Finnish es_ES: Spanish 70 # de : German sv : Swedish 71 # el : Greek th : Thai 72 # iw : Hebrew zh_TW: Traditional Chinese 73 # hu : Hungarian tr : Turkish 74 # is : Icelandic uk : Ukrainian 75 # in : Indonesian vi : Vietnamese 76 # it : Italian 77 # 78 # all_langs : All languages 79 # 80 # Specify value as the following to select any of the languages. 81 # Example : SELECTED_LANGUAGES=en,fr,ja 82 # 83 # Specify value as the following to select all the languages. 84 # Example : SELECTED_LANGUAGES=all_langs 85 #------------------------------------------------------------------------------ 86 SELECTED_LANGUAGES=en,zh_CN 87 88 #------------------------------------------------------------------------------ 89 # Specify the complete path of the Oracle Home. 90 #------------------------------------------------------------------------------ 91 ORACLE_HOME=/opt/oracle_11/app/oracle/product/11.2.0/dbhome_1 92 93 #------------------------------------------------------------------------------ 94 # Specify the complete path of the Oracle Base. 95 #------------------------------------------------------------------------------ 96 ORACLE_BASE=/opt/oracle_11/app 97 98 #------------------------------------------------------------------------------ 99 # Specify the installation edition of the component. 100 # 101 # The value should contain only one of these choices. 102 # EE : Enterprise Edition 103 # SE : Standard Edition 104 # SEONE : Standard Edition One 105 # PE : Personal Edition (WINDOWS ONLY) 106 #------------------------------------------------------------------------------ 107 oracle.install.db.InstallEdition=EE 108 109 #------------------------------------------------------------------------------ 110 # This variable is used to enable or disable custom install and is considered 111 # only if InstallEdition is EE. 112 # 113 # true : Components mentioned as part of 'optionalComponents' property 114 # are considered for install. 115 # false : Value for 'optionalComponents' is not considered. 116 #------------------------------------------------------------------------------ 117 oracle.install.db.EEOptionsSelection=true 118 119 #------------------------------------------------------------------------------ 120 # This variable is considered only if 'EEOptionsSelection' is set to true. 121 # 122 # Description: List of Enterprise Edition Options you would like to enable. 123 # 124 # The following choices are available. You may specify any 125 # combination of these choices. The components you choose should 126 # be specified in the form "internal-component-name:version" 127 # Below is a list of components you may specify to enable. 128 # 129 # oracle.oraolap:11.2.0.3.0 - Oracle OLAP 130 # oracle.rdbms.dm:11.2.0.3.0 - Oracle Data Mining 131 # oracle.rdbms.dv:11.2.0.3.0 - Oracle Database Vault 132 # oracle.rdbms.lbac:11.2.0.3.0 - Oracle Label Security 133 # oracle.rdbms.partitioning:11.2.0.3.0 - Oracle Partitioning 134 # oracle.rdbms.rat:11.2.0.3.0 - Oracle Real Application Testing 135 #------------------------------------------------------------------------------ 136 oracle.install.db.optionalComponents=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 137 138 ############################################################################### 139 # # 140 # PRIVILEGED OPERATING SYSTEM GROUPS # 141 # ------------------------------------------ # 142 # Provide values for the OS groups to which OSDBA and OSOPER privileges # 143 # needs to be granted. If the install is being performed as a member of the # 144 # group "dba", then that will be used unless specified otherwise below. # 145 # # 146 # The value to be specified for OSDBA and OSOPER group is only for UNIX based # 147 # Operating System. # 148 # # 149 ############################################################################### 150 151 #------------------------------------------------------------------------------ 152 # The DBA_GROUP is the OS group which is to be granted OSDBA privileges. 153 #------------------------------------------------------------------------------ 154 oracle.install.db.DBA_GROUP=dba 155 156 #------------------------------------------------------------------------------ 157 # The OPER_GROUP is the OS group which is to be granted OSOPER privileges. 158 # The value to be specified for OSOPER group is optional. 159 #------------------------------------------------------------------------------ 160 oracle.install.db.OPER_GROUP=oinstall 161 162 #------------------------------------------------------------------------------ 163 # Specify the cluster node names selected during the installation. 164 # Example : oracle.install.db.CLUSTER_NODES=node1,node2 165 #------------------------------------------------------------------------------ 166 oracle.install.db.CLUSTER_NODES= 167 168 #------------------------------------------------------------------------------ 169 # This variable is used to enable or disable RAC One Node install. 170 # 171 # true : Value of RAC One Node service name is used. 172 # false : Value of RAC One Node service name is not used. 173 # 174 # If left blank, it will be assumed to be false 175 #------------------------------------------------------------------------------ 176 oracle.install.db.isRACOneInstall= 177 178 #------------------------------------------------------------------------------ 179 # Specify the name for RAC One Node Service. 180 #------------------------------------------------------------------------------ 181 oracle.install.db.racOneServiceName= 182 183 #------------------------------------------------------------------------------ 184 # Specify the type of database to create. 185 # It can be one of the following: 186 # - GENERAL_PURPOSE/TRANSACTION_PROCESSING 187 # - DATA_WAREHOUSE 188 #------------------------------------------------------------------------------ 189 oracle.install.db.config.starterdb.type=GENERAL_PURPOSE 190 191 #------------------------------------------------------------------------------ 192 # Specify the Starter Database Global Database Name. 193 #------------------------------------------------------------------------------ 194 oracle.install.db.config.starterdb.globalDBName=glassfish 195 196 #------------------------------------------------------------------------------ 197 # Specify the Starter Database SID. 198 #------------------------------------------------------------------------------ 199 oracle.install.db.config.starterdb.SID=glassfish 200 201 #------------------------------------------------------------------------------ 202 # Specify the Starter Database character set. 203 # 204 # It can be one of the following: 205 # AL32UTF8, WE8ISO8859P15, WE8MSWIN1252, EE8ISO8859P2, 206 # EE8MSWIN1250, NE8ISO8859P10, NEE8ISO8859P4, BLT8MSWIN1257, 207 # BLT8ISO8859P13, CL8ISO8859P5, CL8MSWIN1251, AR8ISO8859P6, 208 # AR8MSWIN1256, EL8ISO8859P7, EL8MSWIN1253, IW8ISO8859P8, 209 # IW8MSWIN1255, JA16EUC, JA16EUCTILDE, JA16SJIS, JA16SJISTILDE, 210 # KO16MSWIN949, ZHS16GBK, TH8TISASCII, ZHT32EUC, ZHT16MSWIN950, 211 # ZHT16HKSCS, WE8ISO8859P9, TR8MSWIN1254, VN8MSWIN1258 212 #------------------------------------------------------------------------------ 213 oracle.install.db.config.starterdb.characterSet=AL32UTF8 214 215 #------------------------------------------------------------------------------ 216 # This variable should be set to true if Automatic Memory Management 217 # in Database is desired. 218 # If Automatic Memory Management is not desired, and memory allocation 219 # is to be done manually, then set it to false. 220 #------------------------------------------------------------------------------ 221 oracle.install.db.config.starterdb.memoryOption=true 222 223 #------------------------------------------------------------------------------ 224 # Specify the total memory allocation for the database. Value(in MB) should be 225 # at least 256 MB, and should not exceed the total physical memory available 226 # on the system. 227 # Example: oracle.install.db.config.starterdb.memoryLimit=512 228 #------------------------------------------------------------------------------ 229 oracle.install.db.config.starterdb.memoryLimit=1024 230 231 #------------------------------------------------------------------------------ 232 # This variable controls whether to load Example Schemas onto 233 # the starter database or not. 234 #------------------------------------------------------------------------------ 235 oracle.install.db.config.starterdb.installExampleSchemas=false 236 237 #------------------------------------------------------------------------------ 238 # This variable includes enabling audit settings, configuring password profiles 239 # and revoking some grants to public. These settings are provided by default. 240 # These settings may also be disabled. 241 #------------------------------------------------------------------------------ 242 oracle.install.db.config.starterdb.enableSecuritySettings=true 243 244 ############################################################################### 245 # # 246 # Passwords can be supplied for the following four schemas in the # 247 # starter database: # 248 # SYS # 249 # SYSTEM # 250 # SYSMAN (used by Enterprise Manager) # 251 # DBSNMP (used by Enterprise Manager) # 252 # # 253 # Same password can be used for all accounts (not recommended) # 254 # or different passwords for each account can be provided (recommended) # 255 # # 256 ############################################################################### 257 258 #------------------------------------------------------------------------------ 259 # This variable holds the password that is to be used for all schemas in the 260 # starter database. 261 #------------------------------------------------------------------------------- 262 oracle.install.db.config.starterdb.password.ALL=glassfish 263 264 #------------------------------------------------------------------------------- 265 # Specify the SYS password for the starter database. 266 #------------------------------------------------------------------------------- 267 oracle.install.db.config.starterdb.password.SYS= 268 269 #------------------------------------------------------------------------------- 270 # Specify the SYSTEM password for the starter database. 271 #------------------------------------------------------------------------------- 272 oracle.install.db.config.starterdb.password.SYSTEM= 273 274 #------------------------------------------------------------------------------- 275 # Specify the SYSMAN password for the starter database. 276 #------------------------------------------------------------------------------- 277 oracle.install.db.config.starterdb.password.SYSMAN= 278 279 #------------------------------------------------------------------------------- 280 # Specify the DBSNMP password for the starter database. 281 #------------------------------------------------------------------------------- 282 oracle.install.db.config.starterdb.password.DBSNMP= 283 284 #------------------------------------------------------------------------------- 285 # Specify the management option to be selected for the starter database. 286 # It can be one of the following: 287 # 1. GRID_CONTROL 288 # 2. DB_CONTROL 289 #------------------------------------------------------------------------------- 290 oracle.install.db.config.starterdb.control=DB_CONTROL 291 292 #------------------------------------------------------------------------------- 293 # Specify the Management Service to use if Grid Control is selected to manage 294 # the database. 295 #------------------------------------------------------------------------------- 296 oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL= 297 298 ############################################################################### 299 # # 300 # SPECIFY BACKUP AND RECOVERY OPTIONS # 301 # ------------------------------------ # 302 # Out-of-box backup and recovery options for the database can be mentioned # 303 # using the entries below. # 304 # # 305 ############################################################################### 306 307 #------------------------------------------------------------------------------ 308 # This variable is to be set to false if automated backup is not required. Else 309 # this can be set to true. 310 #------------------------------------------------------------------------------ 311 oracle.install.db.config.starterdb.automatedBackup.enable=false 312 313 #------------------------------------------------------------------------------ 314 # Regardless of the type of storage that is chosen for backup and recovery, if 315 # automated backups are enabled, a job will be scheduled to run daily to backup 316 # the database. This job will run as the operating system user that is 317 # specified in this variable. 318 #------------------------------------------------------------------------------ 319 oracle.install.db.config.starterdb.automatedBackup.osuid= 320 321 #------------------------------------------------------------------------------- 322 # Regardless of the type of storage that is chosen for backup and recovery, if 323 # automated backups are enabled, a job will be scheduled to run daily to backup 324 # the database. This job will run as the operating system user specified by the 325 # above entry. The following entry stores the password for the above operating 326 # system user. 327 #------------------------------------------------------------------------------- 328 oracle.install.db.config.starterdb.automatedBackup.ospwd= 329 330 #------------------------------------------------------------------------------- 331 # Specify the type of storage to use for the database. 332 # It can be one of the following: 333 # - FILE_SYSTEM_STORAGE 334 # - ASM_STORAGE 335 #------------------------------------------------------------------------------ 336 oracle.install.db.config.starterdb.storageType= 337 338 #------------------------------------------------------------------------------- 339 # Specify the database file location which is a directory for datafiles, control 340 # files, redo logs. 341 # 342 # Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE 343 #------------------------------------------------------------------------------- 344 oracle.install.db.config.starterdb.fileSystemStorage.dataLocation= 345 346 #------------------------------------------------------------------------------- 347 # Specify the backup and recovery location. 348 # 349 # Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE 350 #------------------------------------------------------------------------------- 351 oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation= 352 353 #------------------------------------------------------------------------------- 354 # Specify the existing ASM disk groups to be used for storage. 355 # 356 # Applicable only when oracle.install.db.config.starterdb.storage=ASM_STORAGE 357 #------------------------------------------------------------------------------- 358 oracle.install.db.config.asm.diskGroup= 359 360 #------------------------------------------------------------------------------- 361 # Specify the password for ASMSNMP user of the ASM instance. 362 # 363 # Applicable only when oracle.install.db.config.starterdb.storage=ASM_STORAGE 364 #------------------------------------------------------------------------------- 365 oracle.install.db.config.asm.ASMSNMPPassword= 366 367 #------------------------------------------------------------------------------ 368 # Specify the My Oracle Support Account Username. 369 # 370 # Example : MYORACLESUPPORT_USERNAME=abc@oracle.com 371 #------------------------------------------------------------------------------ 372 MYORACLESUPPORT_USERNAME= 373 374 #------------------------------------------------------------------------------ 375 # Specify the My Oracle Support Account Username password. 376 # 377 # Example : MYORACLESUPPORT_PASSWORD=password 378 #------------------------------------------------------------------------------ 379 MYORACLESUPPORT_PASSWORD= 380 381 #------------------------------------------------------------------------------ 382 # Specify whether to enable the user to set the password for 383 # My Oracle Support credentials. The value can be either true or false. 384 # If left blank it will be assumed to be false. 385 # 386 # Example : SECURITY_UPDATES_VIA_MYORACLESUPPORT=true 387 #------------------------------------------------------------------------------ 388 SECURITY_UPDATES_VIA_MYORACLESUPPORT=false 389 390 #------------------------------------------------------------------------------ 391 # Specify whether user doesn't want to configure Security Updates. 392 # The value for this variable should be true if you don't want to configure 393 # Security Updates, false otherwise. 394 # 395 # The value can be either true or false. If left blank it will be assumed 396 # to be false. 397 # 398 # Example : DECLINE_SECURITY_UPDATES=false 399 #------------------------------------------------------------------------------ 400 DECLINE_SECURITY_UPDATES=true 401 402 #------------------------------------------------------------------------------ 403 # Specify the Proxy server name. Length should be greater than zero. 404 # 405 # Example : PROXY_HOST=proxy.domain.com 406 #------------------------------------------------------------------------------ 407 PROXY_HOST= 408 409 #------------------------------------------------------------------------------ 410 # Specify the proxy port number. Should be Numeric and atleast 2 chars. 411 # 412 # Example : PROXY_PORT=25 413 #------------------------------------------------------------------------------ 414 PROXY_PORT= 415 416 #------------------------------------------------------------------------------ 417 # Specify the proxy user name. Leave PROXY_USER and PROXY_PWD 418 # blank if your proxy server requires no authentication. 419 # 420 # Example : PROXY_USER=username 421 #------------------------------------------------------------------------------ 422 PROXY_USER= 423 424 #------------------------------------------------------------------------------ 425 # Specify the proxy password. Leave PROXY_USER and PROXY_PWD 426 # blank if your proxy server requires no authentication. 427 # 428 # Example : PROXY_PWD=password 429 #------------------------------------------------------------------------------ 430 PROXY_PWD= 431 432 #------------------------------------------------------------------------------ 433 # Specify the proxy realm. This value is used if auto-updates option is selected. 434 # 435 # Example : PROXY_REALM=metalink 436 #------------------------------------------------------------------------------ 437 PROXY_REALM= 438 439 #------------------------------------------------------------------------------ 440 # Specify the Oracle Support Hub URL. 441 # 442 # Example : COLLECTOR_SUPPORTHUB_URL=https://orasupporthub.company.com:8080/ 443 #------------------------------------------------------------------------------ 444 COLLECTOR_SUPPORTHUB_URL= 445 446 #------------------------------------------------------------------------------ 447 # Specify the auto-updates option. It can be one of the following: 448 # a.MYORACLESUPPORT_DOWNLOAD 449 # b.OFFLINE_UPDATES 450 # c.SKIP_UPDATES 451 #------------------------------------------------------------------------------ 452 oracle.installer.autoupdates.option= 453 #------------------------------------------------------------------------------ 454 # In case MYORACLESUPPORT_DOWNLOAD option is chosen, specify the location where 455 # the updates are to be downloaded. 456 # In case OFFLINE_UPDATES option is chosen, specify the location where the updates 457 # are present. 458 oracle.installer.autoupdates.downloadUpdatesLoc= 459 #------------------------------------------------------------------------------ 460 # Specify the My Oracle Support Account Username which has the patches download privileges 461 # to be used for software updates. 462 # Example : AUTOUPDATES_MYORACLESUPPORT_USERNAME=abc@oracle.com 463 #------------------------------------------------------------------------------ 464 AUTOUPDATES_MYORACLESUPPORT_USERNAME= 465 466 #------------------------------------------------------------------------------ 467 # Specify the My Oracle Support Account Username password which has the patches download privileges 468 # to be used for software updates. 469 # 470 # Example : AUTOUPDATES_MYORACLESUPPORT_PASSWORD=password 471 #------------------------------------------------------------------------------ 472 AUTOUPDATES_MYORACLESUPPORT_PASSWORD=
1 ###################################################################### 2 ## Copyright(c) 1998, 2011 Oracle Corporation. All rights reserved. ## 3 ## ## 4 ## Specify values for the variables listed below to customize your ## 5 ## installation. ## 6 ## ## 7 ## Each variable is associated with a comment. The comment ## 8 ## identifies the variable type. ## 9 ## ## 10 ## Please specify the values in the following format: ## 11 ## ## 12 ## Type Example ## 13 ## String "Sample Value" ## 14 ## Boolean True or False ## 15 ## Number 1000 ## 16 ## StringList {"String value 1","String Value 2"} ## 17 ## ## 18 ###################################################################### 19 ## ## 20 ## This sample response file causes the Oracle Net Configuration ## 21 ## Assistant (NetCA) to complete an Oracle Net configuration during ## 22 ## a custom install of the Oracle11g server which is similar to ## 23 ## what would be created by the NetCA during typical Oracle11g ## 24 ## install. It also documents all of the NetCA response file ## 25 ## variables so you can create your own response file to configure ## 26 ## Oracle Net during an install the way you wish. ## 27 ## ## 28 ###################################################################### 29 30 [GENERAL] 31 RESPONSEFILE_VERSION="11.2" 32 CREATE_TYPE="CUSTOM" 33 34 #------------------------------------------------------------------------------- 35 # Name : SHOW_GUI 36 # Datatype : Boolean 37 # Description: This variable controls appearance/suppression of the NetCA GUI, 38 # Pre-req : N/A 39 # Default : TRUE 40 # Note: 41 # This must be set to false in order to run NetCA in silent mode. 42 # This is a substitute of "/silent" flag in the NetCA command line. 43 # The command line flag has precedence over the one in this response file. 44 # This feature is present since 10.1.0.3. 45 #------------------------------------------------------------------------------- 46 #SHOW_GUI=false 47 48 #------------------------------------------------------------------------------- 49 # Name : LOG_FILE 50 # Datatype : String 51 # Description: If present, NetCA will log output to this file in addition to the 52 # standard out. 53 # Pre-req : N/A 54 # Default : NONE 55 # Note: 56 # This is a substitute of "/log" in the NetCA command line. 57 # The command line argument has precedence over the one in this response file. 58 # This feature is present since 10.1.0.3. 59 #------------------------------------------------------------------------------- 60 #LOG_FILE=""/oracle11gHome/network/tools/log/netca.log"" 61 62 [oracle.net.ca] 63 #INSTALLED_COMPONENTS;StringList;list of installed components 64 # The possible values for installed components are: 65 # "net8","server","client","aso", "cman", "javavm" 66 INSTALLED_COMPONENTS={"server","net8","javavm"} 67 68 #INSTALL_TYPE;String;type of install 69 # The possible values for install type are: 70 # "typical","minimal" or "custom" 71 INSTALL_TYPE=""typical"" 72 73 #LISTENER_NUMBER;Number;Number of Listeners 74 # A typical install sets one listener 75 LISTENER_NUMBER=1 76 77 #LISTENER_NAMES;StringList;list of listener names 78 # The values for listener are: 79 # "LISTENER","LISTENER1","LISTENER2","LISTENER3", ... 80 # A typical install sets only "LISTENER" 81 LISTENER_NAMES={"LISTENER"} 82 83 #LISTENER_PROTOCOLS;StringList;list of listener addresses (protocols and parameters separated by semicolons) 84 # The possible values for listener protocols are: 85 # "TCP;1521","TCPS;2484","NMP;ORAPIPE","IPC;IPCKEY","VI;1521" 86 # A typical install sets only "TCP;1521" 87 LISTENER_PROTOCOLS={"TCP;1521"} 88 89 #LISTENER_START;String;name of the listener to start, in double quotes 90 LISTENER_START=""LISTENER"" 91 92 #NAMING_METHODS;StringList;list of naming methods 93 # The possible values for naming methods are: 94 # LDAP, TNSNAMES, ONAMES, HOSTNAME, NOVELL, NIS, DCE 95 # A typical install sets only: "TNSNAMES","ONAMES","HOSTNAMES" 96 # or "LDAP","TNSNAMES","ONAMES","HOSTNAMES" for LDAP 97 NAMING_METHODS={"TNSNAMES","ONAMES","HOSTNAME"} 98 99 #NOVELL_NAMECONTEXT;String;Novell Directory Service name context, in double quotes 100 # A typical install does not use this variable. 101 #NOVELL_NAMECONTEXT = ""NAMCONTEXT"" 102 103 #SUN_METAMAP;String; SUN meta map, in double quotes 104 # A typical install does not use this variable. 105 #SUN_METAMAP = ""MAP"" 106 107 #DCE_CELLNAME;String;DCE cell name, in double quotes 108 # A typical install does not use this variable. 109 #DCE_CELLNAME = ""CELL"" 110 111 #NSN_NUMBER;Number;Number of NetService Names 112 # A typical install sets one net service name 113 NSN_NUMBER=1 114 115 #NSN_NAMES;StringList;list of Net Service names 116 # A typical install sets net service name to "EXTPROC_CONNECTION_DATA" 117 NSN_NAMES={"EXTPROC_CONNECTION_DATA"} 118 119 #NSN_SERVICE;StringList;Oracle11g database's service name 120 # A typical install sets Oracle11g database's service name to "PLSExtProc" 121 NSN_SERVICE={"PLSExtProc"} 122 123 #NSN_PROTOCOLS;StringList;list of coma separated strings of Net Service Name protocol parameters 124 # The possible values for net service name protocol parameters are: 125 # "TCP;HOSTNAME;1521","TCPS;HOSTNAME;2484","NMP;COMPUTERNAME;ORAPIPE","VI;HOSTNAME;1521","IPC;IPCKEY" 126 # A typical install sets parameters to "IPC;EXTPROC" 127 NSN_PROTOCOLS={"TCP;HOSTNAME;1521"}
1 ############################################################################## 2 ## ## 3 ## DBCA response file ## 4 ## ------------------ ## 5 ## Copyright 1998, 2011, 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 : RACONENODE 82 # Datatype : Boolean 83 # Description : Set to true for RAC One Node database 84 # Valid values : TRUE\FALSE 85 # Default value : FALSE 86 # Mandatory : No 87 #----------------------------------------------------------------------------- 88 #RACONENODE = "false" 89 90 #----------------------------------------------------------------------------- 91 # Name : RACONENODESERVICENAME 92 # Datatype : String 93 # Description : Service is required by application to connect to RAC One 94 # Node Database 95 # Valid values : Service Name 96 # Default value : None 97 # Mandatory : No [required in case RACONENODE flag is set to true] 98 #----------------------------------------------------------------------------- 99 #RACONENODESERVICENAME = 100 101 #----------------------------------------------------------------------------- 102 # Name : POLICYMANAGED 103 # Datatype : Boolean 104 # Description : Set to true if Database is policy managed and 105 # set to false if Database is admin managed 106 # Valid values : TRUE\FALSE 107 # Default value : FALSE 108 # Mandatory : No 109 #----------------------------------------------------------------------------- 110 #POLICYMANAGED = "false" 111 112 #----------------------------------------------------------------------------- 113 # Name : CREATESERVERPOOL 114 # Datatype : Boolean 115 # Description : Set to true if new server pool need to be created for database 116 # if this option is specified then the newly created database 117 # will use this newly created serverpool. 118 # Multiple serverpoolname can not be specified for database 119 # Valid values : TRUE\FALSE 120 # Default value : FALSE 121 # Mandatory : No 122 #----------------------------------------------------------------------------- 123 #CREATESERVERPOOL = "false" 124 125 #----------------------------------------------------------------------------- 126 # Name : FORCE 127 # Datatype : Boolean 128 # Description : Set to true if new server pool need to be created by force 129 # if this option is specified then the newly created serverpool 130 # will be assigned server even if no free servers are available. 131 # This may affect already running database. 132 # This flag can be specified for Admin managed as well as policy managed db. 133 # Valid values : TRUE\FALSE 134 # Default value : FALSE 135 # Mandatory : No 136 #----------------------------------------------------------------------------- 137 #FORCE = "false" 138 139 #----------------------------------------------------------------------------- 140 # Name : SERVERPOOLNAME 141 # Datatype : String 142 # Description : Only one serverpool name need to be specified 143 # if Create Server Pool option is specified. 144 # Comma-separated list of Serverpool names if db need to use 145 # multiple Server pool 146 # Valid values : ServerPool name 147 # Default value : None 148 # Mandatory : No [required in case of RAC service centric database] 149 #----------------------------------------------------------------------------- 150 #SERVERPOOLNAME = 151 152 #----------------------------------------------------------------------------- 153 # Name : CARDINALITY 154 # Datatype : Number 155 # Description : Specify Cardinality for create server pool operation 156 # Valid values : any positive Integer value 157 # Default value : Number of qualified nodes on cluster 158 # Mandatory : No [Required when a new serverpool need to be created] 159 #----------------------------------------------------------------------------- 160 #CARDINALITY = 161 162 #----------------------------------------------------------------------------- 163 # Name : SID 164 # Datatype : String 165 # Description : System identifier (SID) of the database 166 # Valid values : Check Oracle11g Administrator's Guide 167 # Default value : <db_name> specified in GDBNAME 168 # Mandatory : No 169 #----------------------------------------------------------------------------- 170 SID = "glassfish" 171 172 #----------------------------------------------------------------------------- 173 # Name : NODELIST 174 # Datatype : String 175 # Description : Comma-separated list of cluster nodes 176 # Valid values : Cluster node names 177 # Default value : None 178 # Mandatory : No (Yes for RAC database-centric database ) 179 #----------------------------------------------------------------------------- 180 #NODELIST= 181 182 #----------------------------------------------------------------------------- 183 # Name : TEMPLATENAME 184 # Datatype : String 185 # Description : Name of the template 186 # Valid values : Template file name 187 # Default value : None 188 # Mandatory : Yes 189 #----------------------------------------------------------------------------- 190 TEMPLATENAME = "General_Purpose.dbc" 191 192 #----------------------------------------------------------------------------- 193 # Name : OBFUSCATEDPASSWORDS 194 # Datatype : Boolean 195 # Description : Set to true if passwords are encrypted 196 # Valid values : TRUE\FALSE 197 # Default value : FALSE 198 # Mandatory : No 199 #----------------------------------------------------------------------------- 200 #OBFUSCATEDPASSWORDS = FALSE 201 202 203 #----------------------------------------------------------------------------- 204 # Name : SYSPASSWORD 205 # Datatype : String 206 # Description : Password for SYS user 207 # Valid values : Check Oracle11g Administrator's Guide 208 # Default value : None 209 # Mandatory : Yes 210 #----------------------------------------------------------------------------- 211 SYSPASSWORD = "glassfish" 212 213 #----------------------------------------------------------------------------- 214 # Name : SYSTEMPASSWORD 215 # Datatype : String 216 # Description : Password for SYSTEM user 217 # Valid values : Check Oracle11g Administrator's Guide 218 # Default value : None 219 # Mandatory : Yes 220 #----------------------------------------------------------------------------- 221 SYSTEMPASSWORD = "glassfish" 222 223 #----------------------------------------------------------------------------- 224 # Name : EMCONFIGURATION 225 # Datatype : String 226 # Description : Enterprise Manager Configuration Type 227 # Valid values : CENTRAL|LOCAL|ALL|NONE 228 # Default value : NONE 229 # Mandatory : No 230 #----------------------------------------------------------------------------- 231 #EMCONFIGURATION = "NONE" 232 233 #----------------------------------------------------------------------------- 234 # Name : DISABLESECURITYCONFIGURATION 235 # Datatype : String 236 # Description : Database Security Settings 237 # Valid values : ALL|NONE|AUDIT|PASSWORD_PROFILE 238 # Default value : NONE 239 # Mandatory : No 240 #----------------------------------------------------------------------------- 241 #DISABLESECURITYCONFIGURATION = "NONE" 242 243 244 #----------------------------------------------------------------------------- 245 # Name : SYSMANPASSWORD 246 # Datatype : String 247 # Description : Password for SYSMAN user 248 # Valid values : Check Oracle11g Administrator's Guide 249 # Default value : None 250 # Mandatory : Yes, if LOCAL specified for EMCONFIGURATION 251 #----------------------------------------------------------------------------- 252 #SYSMANPASSWORD = "password" 253 254 #----------------------------------------------------------------------------- 255 # Name : DBSNMPPASSWORD 256 # Datatype : String 257 # Description : Password for DBSNMP user 258 # Valid values : Check Oracle11g Administrator's Guide 259 # Default value : None 260 # Mandatory : Yes, if EMCONFIGURATION is specified 261 #----------------------------------------------------------------------------- 262 #DBSNMPPASSWORD = "password" 263 264 #----------------------------------------------------------------------------- 265 # Name : CENTRALAGENT 266 # Datatype : String 267 # Description : Grid Control Central Agent Oracle Home 268 # Default value : None 269 # Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION 270 #----------------------------------------------------------------------------- 271 #CENTRALAGENT = 272 273 #----------------------------------------------------------------------------- 274 # Name : HOSTUSERNAME 275 # Datatype : String 276 # Description : Host user name for EM backup job 277 # Default value : None 278 # Mandatory : Yes, if ALL is specified for EMCONFIGURATION 279 #----------------------------------------------------------------------------- 280 #HOSTUSERNAME = 281 282 #----------------------------------------------------------------------------- 283 # Name : HOSTUSERPASSWORD 284 # Datatype : String 285 # Description : Host user password for EM backup job 286 # Default value : None 287 # Mandatory : Yes, if ALL is specified for EMCONFIGURATION 288 #----------------------------------------------------------------------------- 289 #HOSTUSERPASSWORD= 290 291 #----------------------------------------------------------------------------- 292 # Name : BACKUPSCHEDULE 293 # Datatype : String 294 # Description : Daily backup schedule in the form of hh:mm 295 # Default value : 2:00 296 # Mandatory : Yes, if ALL is specified for EMCONFIGURATION 297 #----------------------------------------------------------------------------- 298 #BACKUPSCHEDULE= 299 300 #----------------------------------------------------------------------------- 301 # Name : DVOWNERNAME 302 # Datatype : String 303 # Description : DataVault Owner 304 # Valid values : Check Oracle11g Administrator's Guide 305 # Default value : None 306 # Mandatory : Yes, if DataVault option is chosen 307 #----------------------------------------------------------------------------- 308 #DVOWNERNAME = "" 309 310 #----------------------------------------------------------------------------- 311 # Name : DVOWNERPASSWORD 312 # Datatype : String 313 # Description : Password for DataVault Owner 314 # Valid values : Check Oracle11g Administrator's Guide 315 # Default value : None 316 # Mandatory : Yes, if DataVault option is chosen 317 #----------------------------------------------------------------------------- 318 #DVOWNERPASSWORD = "" 319 320 #----------------------------------------------------------------------------- 321 # Name : DVACCOUNTMANAGERNAME 322 # Datatype : String 323 # Description : DataVault Account Manager 324 # Valid values : Check Oracle11g Administrator's Guide 325 # Default value : None 326 # Mandatory : No 327 #----------------------------------------------------------------------------- 328 #DVACCOUNTMANAGERNAME = "" 329 330 #----------------------------------------------------------------------------- 331 # Name : DVACCOUNTMANAGERPASSWORD 332 # Datatype : String 333 # Description : Password for DataVault Account Manager 334 # Valid values : Check Oracle11g Administrator's Guide 335 # Default value : None 336 # Mandatory : No 337 #----------------------------------------------------------------------------- 338 #DVACCOUNTMANAGERPASSWORD = "" 339 340 341 342 #----------------------------------------------------------------------------- 343 # Name : DATAFILEJARLOCATION 344 # Datatype : String 345 # Description : Location of the data file jar 346 # Valid values : Directory containing compressed datafile jar 347 # Default value : None 348 # Mandatory : No 349 #----------------------------------------------------------------------------- 350 #DATAFILEJARLOCATION = 351 352 #----------------------------------------------------------------------------- 353 # Name : DATAFILEDESTINATION 354 # Datatype : String 355 # Description : Location of the data file's 356 # Valid values : Directory for all the database files 357 # Default value : $ORACLE_BASE/oradata 358 # Mandatory : No 359 #----------------------------------------------------------------------------- 360 #DATAFILEDESTINATION = 361 362 #----------------------------------------------------------------------------- 363 # Name : RECOVERYAREADESTINATION 364 # Datatype : String 365 # Description : Location of the data file's 366 # Valid values : Recovery Area location 367 # Default value : $ORACLE_BASE/flash_recovery_area 368 # Mandatory : No 369 #----------------------------------------------------------------------------- 370 #RECOVERYAREADESTINATION= 371 372 #----------------------------------------------------------------------------- 373 # Name : STORAGETYPE 374 # Datatype : String 375 # Description : Specifies the storage on which the database is to be created 376 # Valid values : FS (CFS for RAC), ASM 377 # Default value : FS 378 # Mandatory : No 379 #----------------------------------------------------------------------------- 380 #STORAGETYPE=FS 381 382 #----------------------------------------------------------------------------- 383 # Name : DISKGROUPNAME 384 # Datatype : String 385 # Description : Specifies the disk group name for the storage 386 # Default value : DATA 387 # Mandatory : No 388 #----------------------------------------------------------------------------- 389 #DISKGROUPNAME=DATA 390 391 #----------------------------------------------------------------------------- 392 # Name : ASMSNMP_PASSWORD 393 # Datatype : String 394 # Description : Password for ASM Monitoring 395 # Default value : None 396 # Mandatory : No 397 #----------------------------------------------------------------------------- 398 #ASMSNMP_PASSWORD="" 399 400 #----------------------------------------------------------------------------- 401 # Name : RECOVERYGROUPNAME 402 # Datatype : String 403 # Description : Specifies the disk group name for the recovery area 404 # Default value : RECOVERY 405 # Mandatory : No 406 #----------------------------------------------------------------------------- 407 #RECOVERYGROUPNAME=RECOVERY 408 409 410 #----------------------------------------------------------------------------- 411 # Name : CHARACTERSET 412 # Datatype : String 413 # Description : Character set of the database 414 # Valid values : Check Oracle11g National Language Support Guide 415 # Default value : "US7ASCII" 416 # Mandatory : NO 417 #----------------------------------------------------------------------------- 418 CHARACTERSET = "AL32UTF8" 419 420 #----------------------------------------------------------------------------- 421 # Name : NATIONALCHARACTERSET 422 # Datatype : String 423 # Description : National Character set of the database 424 # Valid values : "UTF8" or "AL16UTF16". For details, check Oracle11g National Language Support Guide 425 # Default value : "AL16UTF16" 426 # Mandatory : No 427 #----------------------------------------------------------------------------- 428 #NATIONALCHARACTERSET= "UTF8" 429 430 #----------------------------------------------------------------------------- 431 # Name : REGISTERWITHDIRSERVICE 432 # Datatype : Boolean 433 # Description : Specifies whether to register with Directory Service. 434 # Valid values : TRUE \ FALSE 435 # Default value : FALSE 436 # Mandatory : No 437 #----------------------------------------------------------------------------- 438 #REGISTERWITHDIRSERVICE= TRUE 439 440 #----------------------------------------------------------------------------- 441 # Name : DIRSERVICEUSERNAME 442 # Datatype : String 443 # Description : Specifies the name of the directory service user 444 # Mandatory : YES, if the value of registerWithDirService is TRUE 445 #----------------------------------------------------------------------------- 446 #DIRSERVICEUSERNAME= "name" 447 448 #----------------------------------------------------------------------------- 449 # Name : DIRSERVICEPASSWORD 450 # Datatype : String 451 # Description : The password of the directory service user. 452 # You can also specify the password at the command prompt instead of here. 453 # Mandatory : YES, if the value of registerWithDirService is TRUE 454 #----------------------------------------------------------------------------- 455 #DIRSERVICEPASSWORD= "password" 456 457 #----------------------------------------------------------------------------- 458 # Name : WALLETPASSWORD 459 # Datatype : String 460 # Description : The password for wallet to created or modified. 461 # You can also specify the password at the command prompt instead of here. 462 # Mandatory : YES, if the value of registerWithDirService is TRUE 463 #----------------------------------------------------------------------------- 464 #WALLETPASSWORD= "password" 465 466 #----------------------------------------------------------------------------- 467 # Name : LISTENERS 468 # Datatype : String 469 # Description : Specifies list of listeners to register the database with. 470 # By default the database is configured for all the listeners specified in the 471 # $ORACLE_HOME/network/admin/listener.ora 472 # Valid values : The list should be space separated names like "listener1 listener2". 473 # Mandatory : NO 474 #----------------------------------------------------------------------------- 475 #LISTENERS = "listener1 listener2" 476 477 #----------------------------------------------------------------------------- 478 # Name : VARIABLESFILE 479 # Datatype : String 480 # Description : Location of the file containing variable value pair 481 # Valid values : A valid file-system file. The variable value pair format in this file 482 # is <variable>=<value>. Each pair should be in a new line. 483 # Default value : None 484 # Mandatory : NO 485 #----------------------------------------------------------------------------- 486 #VARIABLESFILE = 487 488 #----------------------------------------------------------------------------- 489 # Name : VARIABLES 490 # Datatype : String 491 # Description : comma separated list of name=value pairs. Overrides variables defined in variablefile and templates 492 # Default value : None 493 # Mandatory : NO 494 #----------------------------------------------------------------------------- 495 #VARIABLES = 496 497 #----------------------------------------------------------------------------- 498 # Name : INITPARAMS 499 # Datatype : String 500 # Description : comma separated list of name=value pairs. Overrides initialization parameters defined in templates 501 # Default value : None 502 # Mandatory : NO 503 #----------------------------------------------------------------------------- 504 #INITPARAMS = 505 506 #----------------------------------------------------------------------------- 507 # Name : SAMPLESCHEMA 508 # Datatype : Boolean 509 # Description : Specifies whether or not to add the Sample Schemas to your database 510 # Valid values : TRUE \ FALSE 511 # Default value : FASLE 512 # Mandatory : No 513 #----------------------------------------------------------------------------- 514 #SAMPLESCHEMA=TRUE 515 516 #----------------------------------------------------------------------------- 517 # Name : MEMORYPERCENTAGE 518 # Datatype : String 519 # Description : percentage of physical memory for Oracle 520 # Default value : None 521 # Mandatory : NO 522 #----------------------------------------------------------------------------- 523 #MEMORYPERCENTAGE = "40" 524 525 #----------------------------------------------------------------------------- 526 # Name : DATABASETYPE 527 # Datatype : String 528 # Description : used for memory distribution when MEMORYPERCENTAGE specified 529 # Valid values : MULTIPURPOSE|DATA_WAREHOUSING|OLTP 530 # Default value : MULTIPURPOSE 531 # Mandatory : NO 532 #----------------------------------------------------------------------------- 533 #DATABASETYPE = "MULTIPURPOSE" 534 535 #----------------------------------------------------------------------------- 536 # Name : AUTOMATICMEMORYMANAGEMENT 537 # Datatype : Boolean 538 # Description : flag to indicate Automatic Memory Management is used 539 # Valid values : TRUE/FALSE 540 # Default value : TRUE 541 # Mandatory : NO 542 #----------------------------------------------------------------------------- 543 #AUTOMATICMEMORYMANAGEMENT = "TRUE" 544 545 #----------------------------------------------------------------------------- 546 # Name : TOTALMEMORY 547 # Datatype : String 548 # Description : total memory in MB to allocate to Oracle 549 # Valid values : 550 # Default value : 551 # Mandatory : NO 552 #----------------------------------------------------------------------------- 553 TOTALMEMORY = "1024" 554 555 556 #-----------------------*** End of CREATEDATABASE section ***------------------------ 557 558 #----------------------------------------------------------------------------- 559 # createTemplateFromDB section is used when OPERATION_TYPE is defined as "createTemplateFromDB". 560 #----------------------------------------------------------------------------- 561 [createTemplateFromDB] 562 #----------------------------------------------------------------------------- 563 # Name : SOURCEDB 564 # Datatype : String 565 # Description : The source database from which to create the template 566 # Valid values : The format is <host>:<port>:<sid> 567 # Default value : none 568 # Mandatory : YES 569 #----------------------------------------------------------------------------- 570 SOURCEDB = "myhost:1521:orcl" 571 572 #----------------------------------------------------------------------------- 573 # Name : SYSDBAUSERNAME 574 # Datatype : String 575 # Description : A user with DBA role. 576 # Default value : none 577 # Mandatory : YES 578 #----------------------------------------------------------------------------- 579 SYSDBAUSERNAME = "system" 580 581 #----------------------------------------------------------------------------- 582 # Name : SYSDBAPASSWORD 583 # Datatype : String 584 # Description : The password of the DBA user. 585 # You can also specify the password at the command prompt instead of here. 586 # Default value : none 587 # Mandatory : YES 588 #----------------------------------------------------------------------------- 589 #SYSDBAPASSWORD = "password" 590 591 #----------------------------------------------------------------------------- 592 # Name : TEMPLATENAME 593 # Datatype : String 594 # Description : Name for the new template. 595 # Default value : None 596 # Mandatory : Yes 597 #----------------------------------------------------------------------------- 598 TEMPLATENAME = "My Copy TEMPLATE" 599 600 #-----------------------*** End of createTemplateFromDB section ***------------------------ 601 602 #----------------------------------------------------------------------------- 603 # createCloneTemplate section is used when OPERATION_TYPE is defined as "createCloneTemplate". 604 #----------------------------------------------------------------------------- 605 [createCloneTemplate] 606 #----------------------------------------------------------------------------- 607 # Name : SOURCEDB 608 # Datatype : String 609 # Description : The source database is the SID from which to create the template. 610 # This database must be local and on the same ORACLE_HOME. 611 # Default value : none 612 # Mandatory : YES 613 #----------------------------------------------------------------------------- 614 SOURCEDB = "orcl" 615 616 #----------------------------------------------------------------------------- 617 # Name : SYSDBAUSERNAME 618 # Datatype : String 619 # Description : A user with DBA role. 620 # Default value : none 621 # Mandatory : YES, if no OS authentication 622 #----------------------------------------------------------------------------- 623 #SYSDBAUSERNAME = "sys" 624 625 #----------------------------------------------------------------------------- 626 # Name : SYSDBAPASSWORD 627 # Datatype : String 628 # Description : The password of the DBA user. 629 # You can also specify the password at the command prompt instead of here. 630 # Default value : none 631 # Mandatory : YES 632 #----------------------------------------------------------------------------- 633 #SYSDBAPASSWORD = "password" 634 635 #----------------------------------------------------------------------------- 636 # Name : TEMPLATENAME 637 # Datatype : String 638 # Description : Name for the new template. 639 # Default value : None 640 # Mandatory : Yes 641 #----------------------------------------------------------------------------- 642 TEMPLATENAME = "My Clone TEMPLATE" 643 644 #----------------------------------------------------------------------------- 645 # Name : DATAFILEJARLOCATION 646 # Datatype : String 647 # Description : Location of the data file jar 648 # Valid values : Directory where the new compressed datafile jar will be placed 649 # Default value : $ORACLE_HOME/assistants/dbca/templates 650 # Mandatory : NO 651 #----------------------------------------------------------------------------- 652 #DATAFILEJARLOCATION = 653 654 #-----------------------*** End of createCloneTemplate section ***------------------------ 655 656 #----------------------------------------------------------------------------- 657 # DELETEDATABASE section is used when DELETE_TYPE is defined as "deleteDatabase". 658 #----------------------------------------------------------------------------- 659 [DELETEDATABASE] 660 #----------------------------------------------------------------------------- 661 # Name : SOURCEDB 662 # Datatype : String 663 # Description : The source database is the SID 664 # This database must be local and on the same ORACLE_HOME. 665 # Default value : none 666 # Mandatory : YES 667 #----------------------------------------------------------------------------- 668 SOURCEDB = "orcl" 669 670 #----------------------------------------------------------------------------- 671 # Name : SYSDBAUSERNAME 672 # Datatype : String 673 # Description : A user with DBA role. 674 # Default value : none 675 # Mandatory : YES, if no OS authentication 676 #----------------------------------------------------------------------------- 677 #SYSDBAUSERNAME = "sys" 678 679 #----------------------------------------------------------------------------- 680 # Name : SYSDBAPASSWORD 681 # Datatype : String 682 # Description : The password of the DBA user. 683 # You can also specify the password at the command prompt instead of here. 684 # Default value : none 685 # Mandatory : YES, if no OS authentication 686 #----------------------------------------------------------------------------- 687 #SYSDBAPASSWORD = "password" 688 #-----------------------*** End of deleteDatabase section ***------------------------ 689 690 #----------------------------------------------------------------------------- 691 # GENERATESCRIPTS section 692 #----------------------------------------------------------------------------- 693 [generateScripts] 694 #----------------------------------------------------------------------------- 695 # Name : TEMPLATENAME 696 # Datatype : String 697 # Description : Name of the template 698 # Valid values : Template name as seen in DBCA 699 # Default value : None 700 # Mandatory : Yes 701 #----------------------------------------------------------------------------- 702 TEMPLATENAME = "New Database" 703 704 #----------------------------------------------------------------------------- 705 # Name : GDBNAME 706 # Datatype : String 707 # Description : Global database name of the database 708 # Valid values : <db_name>.<db_domain> - when database domain isn't NULL 709 # <db_name> - when database domain is NULL 710 # Default value : None 711 # Mandatory : Yes 712 #----------------------------------------------------------------------------- 713 GDBNAME = "orcl11.us.oracle.com" 714 715 #----------------------------------------------------------------------------- 716 # Name : SCRIPTDESTINATION 717 # Datatype : String 718 # Description : Location of the scripts 719 # Valid values : Directory for all the scripts 720 # Default value : None 721 # Mandatory : No 722 #----------------------------------------------------------------------------- 723 #SCRIPTDESTINATION = 724 725 #-----------------------*** End of deleteDatabase section ***------------------------ 726 727 #----------------------------------------------------------------------------- 728 # CONFIGUREDATABASE section is used when OPERATION_TYPE is defined as "configureDatabase". 729 #----------------------------------------------------------------------------- 730 [CONFIGUREDATABASE] 731 732 #----------------------------------------------------------------------------- 733 # Name : SOURCEDB 734 # Datatype : String 735 # Description : The source database is the SID 736 # This database must be local and on the same ORACLE_HOME. 737 # Default value : none 738 # Mandatory : YES 739 #----------------------------------------------------------------------------- 740 #SOURCEDB = "orcl" 741 742 #----------------------------------------------------------------------------- 743 # Name : SYSDBAUSERNAME 744 # Datatype : String 745 # Description : A user with DBA role. 746 # Default value : none 747 # Mandatory : YES, if no OS authentication 748 #----------------------------------------------------------------------------- 749 #SYSDBAUSERNAME = "sys" 750 751 752 #----------------------------------------------------------------------------- 753 # Name : SYSDBAPASSWORD 754 # Datatype : String 755 # Description : The password of the DBA user. 756 # You can also specify the password at the command prompt instead of here. 757 # Default value : none 758 # Mandatory : YES, if no OS authentication 759 #----------------------------------------------------------------------------- 760 #SYSDBAPASSWORD = 761 762 #----------------------------------------------------------------------------- 763 # Name : REGISTERWITHDIRSERVICE 764 # Datatype : Boolean 765 # Description : Specifies whether to register with Directory Service. 766 # Valid values : TRUE \ FALSE 767 # Default value : FALSE 768 # Mandatory : No 769 #----------------------------------------------------------------------------- 770 #REGISTERWITHDIRSERVICE= TRUE 771 772 #----------------------------------------------------------------------------- 773 # Name : UNREGISTERWITHDIRSERVICE 774 # Datatype : Boolean 775 # Description : Specifies whether to unregister with Directory Service. 776 # Valid values : TRUE \ FALSE 777 # Default value : FALSE 778 # Mandatory : No 779 #----------------------------------------------------------------------------- 780 #UNREGISTERWITHDIRSERVICE= TRUE 781 782 #----------------------------------------------------------------------------- 783 # Name : REGENERATEDBPASSWORD 784 # Datatype : Boolean 785 # Description : Specifies whether regenerate database password in OID/Wallet 786 # Valid values : TRUE \ FALSE 787 # Default value : FALSE 788 # Mandatory : No 789 #----------------------------------------------------------------------------- 790 #REGENERATEDBPASSWORD= TRUE 791 792 #----------------------------------------------------------------------------- 793 # Name : DIRSERVICEUSERNAME 794 # Datatype : String 795 # Description : Specifies the name of the directory service user 796 # Mandatory : YES, if the any of the reg/unreg/regenPasswd options specified 797 #----------------------------------------------------------------------------- 798 #DIRSERVICEUSERNAME= "name" 799 800 #----------------------------------------------------------------------------- 801 # Name : DIRSERVICEPASSWORD 802 # Datatype : String 803 # Description : The password of the directory service user. 804 # You can also specify the password at the command prompt instead of here. 805 # Mandatory : YES, if the any of the reg/unreg/regenPasswd options specified 806 #----------------------------------------------------------------------------- 807 #DIRSERVICEPASSWORD= "password" 808 809 #----------------------------------------------------------------------------- 810 # Name : WALLETPASSWORD 811 # Datatype : String 812 # Description : The password for wallet to created or modified. 813 # You can also specify the password at the command prompt instead of here. 814 # Mandatory : YES, if the any of the reg/unreg/regenPasswd options specified 815 #----------------------------------------------------------------------------- 816 #WALLETPASSWORD= "password" 817 818 #----------------------------------------------------------------------------- 819 # Name : DISABLESECURITYCONFIGURATION 820 # Datatype : String 821 # Description : Database Security Settings 822 # Valid values : ALL|NONE|AUDIT|PASSWORD_PROFILE 823 # Default value : NONE 824 # Mandatory : No 825 #----------------------------------------------------------------------------- 826 #DISABLESECURITYCONFIGURATION = "NONE" 827 828 829 830 #----------------------------------------------------------------------------- 831 # Name : ENABLESECURITYCONFIGURATION 832 # Datatype : String 833 # Description : Database Security Settings 834 # Valid values : true|false 835 # Default value : true 836 # Mandatory : No 837 #----------------------------------------------------------------------------- 838 #ENABLESECURITYCONFIGURATION = "true" 839 840 841 #----------------------------------------------------------------------------- 842 # Name : EMCONFIGURATION 843 # Datatype : String 844 # Description : Enterprise Manager Configuration Type 845 # Valid values : CENTRAL|LOCAL|ALL|NONE 846 # Default value : NONE 847 # Mandatory : No 848 #----------------------------------------------------------------------------- 849 #EMCONFIGURATION = "NONE" 850 851 #----------------------------------------------------------------------------- 852 # Name : SYSMANPASSWORD 853 # Datatype : String 854 # Description : Password for SYSMAN user 855 # Valid values : Check Oracle11g Administrator's Guide 856 # Default value : None 857 # Mandatory : Yes, if LOCAL specified for EMCONFIGURATION 858 #----------------------------------------------------------------------------- 859 #SYSMANPASSWORD = "password" 860 861 #----------------------------------------------------------------------------- 862 # Name : DBSNMPPASSWORD 863 # Datatype : String 864 # Description : Password for DBSNMP user 865 # Valid values : Check Oracle11g Administrator's Guide 866 # Default value : None 867 # Mandatory : Yes, if EMCONFIGURATION is specified 868 #----------------------------------------------------------------------------- 869 #DBSNMPPASSWORD = "password" 870 871 #----------------------------------------------------------------------------- 872 # Name : CENTRALAGENT 873 # Datatype : String 874 # Description : Grid Control Central Agent Oracle Home 875 # Default value : None 876 # Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION 877 #----------------------------------------------------------------------------- 878 #CENTRALAGENT = 879 880 #----------------------------------------------------------------------------- 881 # Name : HOSTUSERNAME 882 # Datatype : String 883 # Description : Host user name for EM backup job 884 # Default value : None 885 # Mandatory : Yes, if ALL is specified for EMCONFIGURATION 886 #----------------------------------------------------------------------------- 887 #HOSTUSERNAME = 888 889 #----------------------------------------------------------------------------- 890 # Name : HOSTUSERPASSWORD 891 # Datatype : String 892 # Description : Host user password for EM backup job 893 # Default value : None 894 # Mandatory : Yes, if ALL is specified for EMCONFIGURATION 895 #----------------------------------------------------------------------------- 896 #HOSTUSERPASSWORD= 897 898 #----------------------------------------------------------------------------- 899 # Name : BACKUPSCHEDULE 900 # Datatype : String 901 # Description : Daily backup schedule in the form of hh:mm 902 # Default value : 2:00 903 # Mandatory : Yes, if ALL is specified for EMCONFIGURATION 904 #----------------------------------------------------------------------------- 905 #BACKUPSCHEDULE= 906 907 #-----------------------*** End of CONFIGUREDATABASE section ***------------------------ 908 909 910 #----------------------------------------------------------------------------- 911 # ADDINSTANCE section is used when OPERATION_TYPE is defined as "addInstance". 912 #----------------------------------------------------------------------------- 913 [ADDINSTANCE] 914 915 #----------------------------------------------------------------------------- 916 # Name : DB_UNIQUE_NAME 917 # Datatype : String 918 # Description : DB Unique Name of the RAC database 919 # Valid values : <db_unique_name> 920 # Default value : None 921 # Mandatory : Yes 922 #----------------------------------------------------------------------------- 923 DB_UNIQUE_NAME = "orcl11g.us.oracle.com" 924 925 #----------------------------------------------------------------------------- 926 # Name : INSTANCENAME 927 # Datatype : String 928 # Description : RAC instance name to be added 929 # Valid values : Check Oracle11g Administrator's Guide 930 # Default value : <sid_prefix>+<highest_current_thread+1> 931 # Mandatory : No 932 #----------------------------------------------------------------------------- 933 #INSTANCENAME = "orcl1" 934 935 #----------------------------------------------------------------------------- 936 # Name : NODELIST 937 # Datatype : String 938 # Description : Node on which to add new instance 939 # (in 10gR2, instance addition is supported on 1 node at a time) 940 # Valid values : Cluster node name 941 # Default value : None 942 # Mandatory : Yes 943 #----------------------------------------------------------------------------- 944 NODELIST= 945 946 #----------------------------------------------------------------------------- 947 # Name : OBFUSCATEDPASSWORDS 948 # Datatype : Boolean 949 # Description : Set to true if passwords are encrypted 950 # Valid values : TRUE\FALSE 951 # Default value : FALSE 952 # Mandatory : No 953 #----------------------------------------------------------------------------- 954 #OBFUSCATEDPASSWORDS = FALSE 955 956 #----------------------------------------------------------------------------- 957 # Name : SYSDBAUSERNAME 958 # Datatype : String 959 # Description : A user with DBA role. 960 # Default value : none 961 # Mandatory : YES 962 #----------------------------------------------------------------------------- 963 SYSDBAUSERNAME = "sys" 964 965 #----------------------------------------------------------------------------- 966 # Name : SYSDBAPASSWORD 967 # Datatype : String 968 # Description : The password of the DBA user. 969 # Default value : none 970 # Mandatory : YES 971 #----------------------------------------------------------------------------- 972 #SYSDBAPASSWORD = "password" 973 974 #-----------------------*** End of ADDINSTANCE section ***------------------------ 975 976 977 #----------------------------------------------------------------------------- 978 # DELETEINSTANCE section is used when OPERATION_TYPE is defined as "deleteInstance". 979 #----------------------------------------------------------------------------- 980 [DELETEINSTANCE] 981 982 #----------------------------------------------------------------------------- 983 # Name : DB_UNIQUE_NAME 984 # Datatype : String 985 # Description : DB Unique Name of the RAC database 986 # Valid values : <db_unique_name> 987 # Default value : None 988 # Mandatory : Yes 989 #----------------------------------------------------------------------------- 990 DB_UNIQUE_NAME = "orcl11g.us.oracle.com" 991 992 #----------------------------------------------------------------------------- 993 # Name : INSTANCENAME 994 # Datatype : String 995 # Description : RAC instance name to be deleted 996 # Valid values : Check Oracle11g Administrator's Guide 997 # Default value : None 998 # Mandatory : Yes 999 #----------------------------------------------------------------------------- 1000 INSTANCENAME = "orcl11g" 1001 1002 #----------------------------------------------------------------------------- 1003 # Name : NODELIST 1004 # Datatype : String 1005 # Description : Node on which instance to be deleted (SID) is located 1006 # Valid values : Cluster node name 1007 # Default value : None 1008 # Mandatory : No 1009 #----------------------------------------------------------------------------- 1010 #NODELIST= 1011 1012 #----------------------------------------------------------------------------- 1013 # Name : OBFUSCATEDPASSWORDS 1014 # Datatype : Boolean 1015 # Description : Set to true if passwords are encrypted 1016 # Valid values : TRUE\FALSE 1017 # Default value : FALSE 1018 # Mandatory : No 1019 #----------------------------------------------------------------------------- 1020 #OBFUSCATEDPASSWORDS = FALSE 1021 1022 #----------------------------------------------------------------------------- 1023 # Name : SYSDBAUSERNAME 1024 # Datatype : String 1025 # Description : A user with DBA role. 1026 # Default value : none 1027 # Mandatory : YES 1028 #----------------------------------------------------------------------------- 1029 SYSDBAUSERNAME = "sys" 1030 1031 #----------------------------------------------------------------------------- 1032 # Name : SYSDBAPASSWORD 1033 # Datatype : String 1034 # Description : The password of the DBA user. 1035 # Default value : none 1036 # Mandatory : YES 1037 #----------------------------------------------------------------------------- 1038 #SYSDBAPASSWORD = "password" 1039 1040 1041 #-----------------------*** End of DELETEINSTANCE section ***------------------------
五、安装
$cd /home/oracle/database
$./runInstaller -silent -responseFile /home/oracle/response/db_install.rsp
//当安装界面出现如下信息的时候 打开另一个终端窗口
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 226635 MB Passed
Checking swap space: must be greater than 150 MB. Actual 15999 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2018-11-08_05-19-06PM. Please wait ...localhost.localdomain->oracle$ [WARNING] [INS-13014] Target environment do not meet some optional requirements.
CAUSE: Some of the optional prerequisites are not met. See logs for details. /u01/app/oraInventory/logs/installActions2018-11-08_05-19-06PM.log
ACTION: Identify the list of failed prerequisite checks from the log: /u01/app/oraInventory/logs/installActions2018-11-08_05-19-06PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.
You can find the log of this install session at:
/u01/app/oraInventory/logs/installActions2018-11-08_05-19-06PM.log
The installation of Oracle Database 11g was successful.
Please check '/u01/app/oraInventory/logs/silentInstall2018-11-08_05-19-06PM.log' for more details.
As a root user, execute the following script(s):
1. /opt/oracle_11/app/oracle/product/11.2.0/dbhome_1/root.sh
Successfully Setup Software.
//在新打开的root登录的窗口中执行下面的脚本（具体要看上面提示需要执行的脚步）
#/opt/oracle_11/app/oracle/product/11.2.0/dbhome_1/root.sh
//执行完上面的脚本后回到安装终端窗口按下Enter键以继续
六、配置监听
1.配置netca环境变量
[oracle@www ~]$ cd /home/oracle/
[oracle@www ~]$ vi .bash_profile //添加以下内容
1 # .bash_profile 2 3 # Get the aliases and functions 4 if [ -f ~/.bashrc ]; then 5 . ~/.bashrc 6 fi 7 8 # User specific environment and startup programs 9 10 PATH=$PATH:$HOME/bin 11 12 export PATH 13 14 15 export ORACLE_BASE=/opt/oracle_11/app 16 export ORACLE_HOME=$ORACLE_BASE/oracle/product/11.2.0/dbhome_1 17 export PATH=$PATH:$ORACLE_HOME/bin 18 export ORACLE_SID=orcl 19 20 ".bash_profile" 18L, 337C
$ source .bash_profile #使其生效
2.配置监听
$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
3.查看监听状态
$lsnrctl status
4.配置数据库
$dbca -silent -responseFile /home/oracle/response/dbca.rsp
七、启动数据库并验证安装是否成功
1.启动数据库（启动前，最好先启动监听器）
$ 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> 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看看是否正常
2.关闭数据库：
$:su - oracle
$:sqlplus /nolog
sql>conn / as sysdba
SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
3.启动监听器:
[oracle@master ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 20-JUL-2017 02:58:26
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Starting /opt/oracle_11/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.3.0 - Production
System parameter file is /opt/oracle_11/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /opt/oracle_11/app/diag/tnslsnr/master/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=master)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 20-JUL-2017 02:58:26
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle_11/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /opt/oracle_11/app/diag/tnslsnr/master/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=master)(PORT=1521)))
The listener supports no services
The command completed successfully
4.停止监听器:
[oracle@master ~]$ lsnrctl stop
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 20-JUL-2017 03:12:32
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
The command completed successfully
5、查看监听器状态:
[oracle@master ~]$ lsnrctl
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 20-JUL-2017 03:13:37
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=www)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
LSNRCTL> exit
八、安装过程中出现问题及解决方法
1.oracle11g中启动该实例时都会出现如下错误：
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/oracle/product/11.2.0/dbhome_1/dbs/initorcl.ora‘
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/oracle/product/11.2.0/dbhome_1/dbs/initorcl.ora‘
上面说是没有initfstest.ora文件
解决此问题的方法就是到cd $ORACLE_BASE/admin/glassfish/pfile/目录下，将init.ora.1114201016265复制到 $ORACLE_BASE/oracle/product/11.2.0/dbhome_1/dbs/目录下：
cp init.ora.1114201016265 $ORACLE_BASE/oracle/product/11.2.0/dbhome_1/dbs/initorcl.ora
然后重启linux,再次用sqlplus连接数据库
2.出现cannot mount database in EXCLUSIVE mode问题
把/opt/oracle_11/app/oracle/product/11.2.0/dbhome_1/dbs下的lk***文件删除掉重新启动数据库
然后重启linux,再次用sqlplus连接数据库
3.如果还是有些莫名其妙的问题，就先重启linux系统，然后启动oracle监听，启动数据库，正常情况下就ok了。（如不能解决，请再找google大神或者度娘吧！！！谢谢关注！！！）
2935
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
