linux下安装oracle数据库

程序员文章站 2022-05-27 09:33:21

...

一、安装前准备工作

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++-33i686 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 binutils compat-libcap1 compat-libstdc++-33 compat-libstdc++-33i686 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

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密码

用以上命令不能用户目录和用户环境变量文件的可以用下面这个

#usermod -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_HOME=$ORACLE_BASE/product/11.2.0/db_1 export

SQLPATH=/home/oracle/labs （labs如果没有，自己新建）

export PATH=$ORACLE_HOME/bin:$PATH

（或者直接用路径/home/oracle/app/oracle/product/11.2.0/dbhome_1/bin:$PATH）

export ORACLE_SID=orcl

或者参考这个

PATH=$PATH:$HOME/.local/bin:$HOME/bin

export PATH

umask 022

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1

export PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin:$ORACLE_HOME/bin

export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib:$ORACLE_HOME/oracm/lib:$ORACLE_HOME/lib

export LIBPATH=${CLASSPATH}:$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib

export ORACLE_SID=orcl

alias dba='sqlplus / as sysdba'

使之生效

#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

使修改的内容生效

#source /etc/profile

二、解压开始安装

有图形界面时

使用root用户查看用户下是否已设置DISPLAY变量

如果有值出现，则说明已设置DISPLAY变量；否则，就需要手动设置DISPLAY

以下命令允许所有用户使用图形界面

xhost +

（这里如果报错，一般是搞定不了，所以还是用静默安装，）

#su - oracle

$ unzip p10404530_112030_Linux-x86-64_1of7.zip

$ unzip p10404530_112030_Linux-x86-64_2of7.zip

$ export DISPLAY=:0

$ ./database/runInstaller

进入图形界面的安装请参照

http://blog.itpub.net/29742691/viewspace-1214803/

无图形界面静默安装(推荐)

一、修改静默安装的模板

$ cp -R /home/oracle/database/response /home/oracle //复制一份模板

$ cd /home/oracle/response

$ vi db_install.rsp 　　　　　　　　　//修改安装应答文件

三个文件作用分别是：

db_install.rsp：安装应答

dbca.rsp：创建数据库应答

netca.rsp：建立监听、本地服务名等网络设置应答

这三个文件已经为大家准备好，注意：我是安装在/opt/oracle_11/下，如果你安装在其他目录，请自行修改上面环境变量配置的路径和这几个文件的路径

1 ####################################################################

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 ####################################################################

17 #------------------------------------------------------------------------------

18 # Do not change the following system generated value.

19 #------------------------------------------------------------------------------

20 oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0

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

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

39 #-------------------------------------------------------------------------------

40 # Specify the Unix group to be set for the inventory directory.

41 #-------------------------------------------------------------------------------

42 UNIX_GROUP_NAME=oinstall

44 #-------------------------------------------------------------------------------

45 # Specify the location which holds the inventory files.

46 #-------------------------------------------------------------------------------

47 INVENTORY_LOCATION=/opt/oracle_11/oraInventory

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

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

85 #------------------------------------------------------------------------------

86 # Specify the complete path of the Oracle Base.

87 #------------------------------------------------------------------------------

88 ORACLE_BASE=/opt/oracle_11/app

90 #------------------------------------------------------------------------------

91 # Specify the installation edition of the component.

92 #

93 # The value should contain only one of these choices.

94 # EE : Enterprise Edition

95 # SE : Standard Edition

96 # SEONE : Standard Edition One

97 # PE : Personal Edition (WINDOWS ONLY)

98 #------------------------------------------------------------------------------

99 oracle.install.db.InstallEdition=EE

100

101 #------------------------------------------------------------------------------

102 # This variable is used to enable or disable custom install.

103 #

104 # true : Components mentioned as part of 'customComponents' property

105 # are considered for install.

106 # false : Value for 'customComponents' is not considered.

107 #------------------------------------------------------------------------------

108 oracle.install.db.isCustomInstall=true

109

110 #------------------------------------------------------------------------------

111 # This variable is considered only if 'IsCustomInstall' is set to true.

112 #

113 # Description: List of Enterprise Edition Options you would like to install.

114 #

115 # The following choices are available. You may specify any

116 # combination of these choices. The components you choose should

117 # be specified in the form "internal-component-name:version"

118 # Below is a list of components you may specify to install.

119 #

120 # oracle.rdbms.partitioning:11.2.0.1.0 - Oracle Partitioning

121 # oracle.rdbms.dm:11.2.0.1.0 - Oracle Data Mining

122 # oracle.rdbms.dv:11.2.0.1.0 - Oracle Database Vault

123 # oracle.rdbms.lbac:11.2.0.1.0 - Oracle Label Security

124 # oracle.rdbms.rat:11.2.0.1.0 - Oracle Real Application Testing

125 # oracle.oraolap:11.2.0.1.0 - Oracle OLAP

126 #------------------------------------------------------------------------------

127 oracle.install.db.customComponents=oracle.server:11.2.0.1.0,oracle.sysman.ccr:10.2.7.0.0,oracle.xdk:11.2.0.1.0,oracle.rdbms.oci:11.2.0.1.0,oracle.network:11.2.0.1.0,oracle.network.listener:11.2.0.1.0,oracle.rdbms:11.2.0.1.0,oracle.options:11.2.0.1.0,oracle.rdbms.partitioning:11.2.0.1.0,oracle.oraolap:11.2.0.1.0,oracle.rdbms.dm:11.2.0.1.0,oracle.rdbms.dv:11.2.0.1.0,orcle.rdbms.lbac:11.2.0.1.0,oracle.rdbms.rat:11.2.0.1.0

128

129 ###############################################################################

130 # #

131 # PRIVILEGED OPERATING SYSTEM GROUPS #

132 # ------------------------------------------ #

133 # Provide values for the OS groups to which OSDBA and OSOPER privileges #

134 # needs to be granted. If the install is being performed as a member of the #

135 # group "dba", then that will be used unless specified otherwise below. #

136 # #

137 ###############################################################################

138

139 #------------------------------------------------------------------------------

140 # The DBA_GROUP is the OS group which is to be granted OSDBA privileges.

141 #------------------------------------------------------------------------------

142 oracle.install.db.DBA_GROUP=dba

143

144 #------------------------------------------------------------------------------

145 # The OPER_GROUP is the OS group which is to be granted OSOPER privileges.

146 #------------------------------------------------------------------------------

147 oracle.install.db.OPER_GROUP=oinstall

148

149 #------------------------------------------------------------------------------

150 # Specify the cluster node names selected during the installation.

151 #------------------------------------------------------------------------------

152 oracle.install.db.CLUSTER_NODES=

153

154 #------------------------------------------------------------------------------

155 # Specify the type of database to create.

156 # It can be one of the following:

157 # - GENERAL_PURPOSE/TRANSACTION_PROCESSING

158 # - DATA_WAREHOUSE

159 #------------------------------------------------------------------------------

160 oracle.install.db.config.starterdb.type=GENERAL_PURPOSE

161

162 #------------------------------------------------------------------------------

163 # Specify the Starter Database Global Database Name.

164 #------------------------------------------------------------------------------

165 oracle.install.db.config.starterdb.globalDBName=glassfish

166

167 #------------------------------------------------------------------------------

168 # Specify the Starter Database SID.

169 #------------------------------------------------------------------------------

170 oracle.install.db.config.starterdb.SID=glassfish

171

172 #------------------------------------------------------------------------------

173 # Specify the Starter Database character set.

174 #

175 # It can be one of the following:

176 # AL32UTF8, WE8ISO8859P15, WE8MSWIN1252, EE8ISO8859P2,

177 # EE8MSWIN1250, NE8ISO8859P10, NEE8ISO8859P4, BLT8MSWIN1257,

178 # BLT8ISO8859P13, CL8ISO8859P5, CL8MSWIN1251, AR8ISO8859P6,

179 # AR8MSWIN1256, EL8ISO8859P7, EL8MSWIN1253, IW8ISO8859P8,

180 # IW8MSWIN1255, JA16EUC, JA16EUCTILDE, JA16SJIS, JA16SJISTILDE,

181 # KO16MSWIN949, ZHS16GBK, TH8TISASCII, ZHT32EUC, ZHT16MSWIN950,

182 # ZHT16HKSCS, WE8ISO8859P9, TR8MSWIN1254, VN8MSWIN1258

183 #------------------------------------------------------------------------------

184 oracle.install.db.config.starterdb.characterSet=AL32UTF8

185

186 #------------------------------------------------------------------------------

187 # This variable should be set to true if Automatic Memory Management

188 # in Database is desired.

189 # If Automatic Memory Management is not desired, and memory allocation

190 # is to be done manually, then set it to false.

191 #------------------------------------------------------------------------------

192 oracle.install.db.config.starterdb.memoryOption=true

193

194 #------------------------------------------------------------------------------

195 # Specify the total memory allocation for the database. Value(in MB) should be

196 # at least 256 MB, and should not exceed the total physical memory available

197 # on the system.

198 # Example: oracle.install.db.config.starterdb.memoryLimit=512

199 #------------------------------------------------------------------------------

200 oracle.install.db.config.starterdb.memoryLimit=10240

201

202 #------------------------------------------------------------------------------

203 # This variable controls whether to load Example Schemas onto the starter

204 # database or not.

205 #------------------------------------------------------------------------------

206 oracle.install.db.config.starterdb.installExampleSchemas=false

207

208 #------------------------------------------------------------------------------

209 # This variable includes enabling audit settings, configuring password profiles

210 # and revoking some grants to public. These settings are provided by default.

211 # These settings may also be disabled.

212 #------------------------------------------------------------------------------

213 oracle.install.db.config.starterdb.enableSecuritySettings=true

214

215 ###############################################################################

216 # #

217 # Passwords can be supplied for the following four schemas in the #

218 # starter database: #

219 # SYS #

220 # SYSTEM #

221 # SYSMAN (used by Enterprise Manager) #

222 # DBSNMP (used by Enterprise Manager) #

223 # #

224 # Same password can be used for all accounts (not recommended) #

225 # or different passwords for each account can be provided (recommended) #

226 # #

227 ###############################################################################

228

229 #------------------------------------------------------------------------------

230 # This variable holds the password that is to be used for all schemas in the

231 # starter database.

232 #-------------------------------------------------------------------------------

233 oracle.install.db.config.starterdb.password.ALL=glassfish

234

235 #-------------------------------------------------------------------------------

236 # Specify the SYS password for the starter database.

237 #-------------------------------------------------------------------------------

238 oracle.install.db.config.starterdb.password.SYS=

239

240 #-------------------------------------------------------------------------------

241 # Specify the SYSTEM password for the starter database.

242 #-------------------------------------------------------------------------------

243 oracle.install.db.config.starterdb.password.SYSTEM=

244

245 #-------------------------------------------------------------------------------

246 # Specify the SYSMAN password for the starter database.

247 #-------------------------------------------------------------------------------

248 oracle.install.db.config.starterdb.password.SYSMAN=

249

250 #-------------------------------------------------------------------------------

251 # Specify the DBSNMP password for the starter database.

252 #-------------------------------------------------------------------------------

253 oracle.install.db.config.starterdb.password.DBSNMP=

254

255 #-------------------------------------------------------------------------------

256 # Specify the management option to be selected for the starter database.

257 # It can be one of the following:

258 # 1. GRID_CONTROL

259 # 2. DB_CONTROL

260 #-------------------------------------------------------------------------------

261 oracle.install.db.config.starterdb.control=DB_CONTROL

262

263 #-------------------------------------------------------------------------------

264 # Specify the Management Service to use if Grid Control is selected to manage

265 # the database.

266 #-------------------------------------------------------------------------------

267 oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=

268

269 #-------------------------------------------------------------------------------

270 # This variable indicates whether to receive email notification for critical

271 # alerts when using DB control.

272 #-------------------------------------------------------------------------------

273 oracle.install.db.config.starterdb.dbcontrol.enableEmailNotification=false

274

275 #-------------------------------------------------------------------------------

276 # Specify the email address to which the notifications are to be sent.

277 #-------------------------------------------------------------------------------

278 oracle.install.db.config.starterdb.dbcontrol.emailAddress=

279

280 #-------------------------------------------------------------------------------

281 # Specify the SMTP server used for email notifications.

282 #-------------------------------------------------------------------------------

283 oracle.install.db.config.starterdb.dbcontrol.SMTPServer=

284

285

286 ###############################################################################

287 # #

288 # SPECIFY BACKUP AND RECOVERY OPTIONS #

289 # ------------------------------------ #

290 # Out-of-box backup and recovery options for the database can be mentioned #

291 # using the entries below. #

292 # #

293 ###############################################################################

294

295 #------------------------------------------------------------------------------

296 # This variable is to be set to false if automated backup is not required. Else

297 # this can be set to true.

298 #------------------------------------------------------------------------------

299 oracle.install.db.config.starterdb.automatedBackup.enable=false

300

301 #------------------------------------------------------------------------------

302 # Regardless of the type of storage that is chosen for backup and recovery, if

303 # automated backups are enabled, a job will be scheduled to run daily at

304 # 2:00 AM to backup the database. This job will run as the operating system

305 # user that is specified in this variable.

306 #------------------------------------------------------------------------------

307 oracle.install.db.config.starterdb.automatedBackup.osuid=

308

309 #-------------------------------------------------------------------------------

310 # Regardless of the type of storage that is chosen for backup and recovery, if

311 # automated backups are enabled, a job will be scheduled to run daily at

312 # 2:00 AM to backup the database. This job will run as the operating system user

313 # specified by the above entry. The following entry stores the password for the

314 # above operating system user.

315 #-------------------------------------------------------------------------------

316 oracle.install.db.config.starterdb.automatedBackup.ospwd=

317

318 #-------------------------------------------------------------------------------

319 # Specify the type of storage to use for the database.

320 # It can be one of the following:

321 # - FILE_SYSTEM_STORAGE

322 # - ASM_STORAGE

323 #------------------------------------------------------------------------------

324 oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGE

325

326 #-------------------------------------------------------------------------------

327 # Specify the database file location which is a directory for datafiles, control

328 # files, redo logs.

329 #

330 # Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM

331 #-------------------------------------------------------------------------------

332 oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=

333

334 #-------------------------------------------------------------------------------

335 # Specify the backup and recovery location.

336 #

337 # Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM

338 #-------------------------------------------------------------------------------

339 oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=

340

341 #-------------------------------------------------------------------------------

342 # Specify the existing ASM disk groups to be used for storage.

343 #

344 # Applicable only when oracle.install.db.config.starterdb.storage=ASM

345 #-------------------------------------------------------------------------------

346 oracle.install.db.config.asm.diskGroup=

347

348 #-------------------------------------------------------------------------------

349 # Specify the password for ASMSNMP user of the ASM instance.

350 #

351 # Applicable only when oracle.install.db.config.starterdb.storage=ASM_SYSTEM

352 #-------------------------------------------------------------------------------

353 oracle.install.db.config.asm.ASMSNMPPassword=

354

355 #------------------------------------------------------------------------------

356 # Specify the My Oracle Support Account Username.

357 #

358 # Example : MYORACLESUPPORT_USERNAME=metalink

359 #------------------------------------------------------------------------------

360 MYORACLESUPPORT_USERNAME=

361

362 #------------------------------------------------------------------------------

363 # Specify the My Oracle Support Account Username password.

364 #

365 # Example : MYORACLESUPPORT_PASSWORD=password

366 #------------------------------------------------------------------------------

367 MYORACLESUPPORT_PASSWORD=

368

369 #------------------------------------------------------------------------------

370 # Specify whether to enable the user to set the password for

371 # My Oracle Support credentials. The value can be either true or false.

372 # If left blank it will be assumed to be false.

373 #

374 # Example : SECURITY_UPDATES_VIA_MYORACLESUPPORT=true

375 #------------------------------------------------------------------------------

376 SECURITY_UPDATES_VIA_MYORACLESUPPORT=false

377

378 #------------------------------------------------------------------------------

379 # Specify whether user wants to give any proxy details for connection.

380 # The value can be either true or false. If left blank it will be assumed

381 # to be false.

382 #

383 # Example : DECLINE_SECURITY_UPDATES=false

384 #------------------------------------------------------------------------------

385 DECLINE_SECURITY_UPDATES=true

386

387 #------------------------------------------------------------------------------

388 # Specify the Proxy server name. Length should be greater than zero.

389 #

390 # Example : PROXY_HOST=proxy.domain.com

391 #------------------------------------------------------------------------------

392 PROXY_HOST=

393

394 #------------------------------------------------------------------------------

395 # Specify the proxy port number. Should be Numeric and atleast 2 chars.

396 #

397 # Example : PROXY_PORT=25

398 #------------------------------------------------------------------------------

399 PROXY_PORT=

400

401 #------------------------------------------------------------------------------

402 # Specify the proxy user name. Leave PROXY_USER and PROXY_PWD

403 # blank if your proxy server requires no authentication.

404 #

405 # Example : PROXY_USER=username

406 #------------------------------------------------------------------------------

407 PROXY_USER=

408

409 #------------------------------------------------------------------------------

410 # Specify the proxy password. Leave PROXY_USER and PROXY_PWD

411 # blank if your proxy server requires no authentication.

412 #

413 # Example : PROXY_PWD=password

414 #------------------------------------------------------------------------------

415 PROXY_PWD=

db_install.rsp

1 ##############################################################################

2 ## ##

3 ## DBCA response file ##

4 ## ------------------ ##

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 ##############################################################################

37 #-----------------------------------------------------------------------------

38 # GENERAL section is required for all types of database creations.

39 #-----------------------------------------------------------------------------

40 [GENERAL]

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"

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"

62 #----------------------- End of GENERAL section ------------------------

64 #-----------------------------------------------------------------------------

65 # CREATEDATABASE section is used when OPERATION_TYPE is defined as "createDatabase".

66 #-----------------------------------------------------------------------------

67 [CREATEDATABASE]

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"

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"

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 = "oracle"

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 = "oracle"

201

202 #-----------------------------------------------------------------------------

203 # Name : EMCONFIGURATION

204 # Datatype : String

205 # Description : Enterprise Manager Configuration Type

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

833 # Default value : NONE

834 # Mandatory : No

835 #-----------------------------------------------------------------------------

836 #EMCONFIGURATION = "NONE"

837

838 #-----------------------------------------------------------------------------

839 # Name : SYSMANPASSWORD

840 # Datatype : String

841 # Description : Password for SYSMAN user

842 # Valid values : Check Oracle11g Administrator's Guide

843 # Default value : None

844 # Mandatory : Yes, if LOCAL specified for EMCONFIGURATION

845 #-----------------------------------------------------------------------------

846 #SYSMANPASSWORD = "password"

847

848 #-----------------------------------------------------------------------------

849 # Name : DBSNMPPASSWORD

850 # Datatype : String

851 # Description : Password for DBSNMP user

852 # Valid values : Check Oracle11g Administrator's Guide

853 # Default value : None

854 # Mandatory : Yes, if EMCONFIGURATION is specified

855 #-----------------------------------------------------------------------------

856 #DBSNMPPASSWORD = "password"

857

858 #-----------------------------------------------------------------------------

859 # Name : CENTRALAGENT

860 # Datatype : String

861 # Description : Grid Control Central Agent Oracle Home

862 # Default value : None

863 # Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION

864 #-----------------------------------------------------------------------------

865 #CENTRALAGENT =

866

867 #-----------------------------------------------------------------------------

868 # Name : HOSTUSERNAME

869 # Datatype : String

870 # Description : Host user name for EM backup job

871 # Default value : None

872 # Mandatory : Yes, if ALL or NOEMAIL are specified for EMCONFIGURATION

873 #-----------------------------------------------------------------------------

874 #HOSTUSERNAME =

875

876 #-----------------------------------------------------------------------------

877 # Name : HOSTUSERPASSWORD

878 # Datatype : String

879 # Description : Host user password for EM backup job

880 # Default value : None

881 # Mandatory : Yes, if ALL or NOEMAIL are specified for EMCONFIGURATION

882 #-----------------------------------------------------------------------------

883 #HOSTUSERPASSWORD=

884

885 #-----------------------------------------------------------------------------

886 # Name : BACKUPSCHEDULE

887 # Datatype : String

888 # Description : Daily backup schedule in the form of hh:mm

889 # Default value : 2:00

890 # Mandatory : Yes, if ALL or NOEMAIL are specified for EMCONFIGURATION

891 #-----------------------------------------------------------------------------

892 #BACKUPSCHEDULE=

893

894 #-----------------------------------------------------------------------------

895 # Name : SMTPSERVER

896 # Datatype : String

897 # Description : Outgoing mail (SMTP) server for email notifications

898 # Default value : None

899 # Mandatory : Yes, if ALL or NOBACKUP are specified for EMCONFIGURATION

900 #-----------------------------------------------------------------------------

901 #SMTPSERVER =

902

903 #-----------------------------------------------------------------------------

904 # Name : EMAILADDRESS

905 # Datatype : String

906 # Description : Email address for email notifications

907 # Default value : None

908 # Mandatory : Yes, if ALL or NOBACKUP are specified for EMCONFIGURATION

909 #-----------------------------------------------------------------------------

910 #EMAILADDRESS =

911

912 #----------------------- End of CONFIGUREDATABASE section ------------------------

913

914

915 #-----------------------------------------------------------------------------

916 # ADDINSTANCE section is used when OPERATION_TYPE is defined as "addInstance".

917 #-----------------------------------------------------------------------------

918 [ADDINSTANCE]

919

920 #-----------------------------------------------------------------------------

921 # Name : DB_UNIQUE_NAME

922 # Datatype : String

923 # Description : DB Unique Name of the RAC database

924 # Valid values : <db_unique_name>

925 # Default value : None

926 # Mandatory : Yes

927 #-----------------------------------------------------------------------------

928 DB_UNIQUE_NAME = "orcl11g.us.oracle.com"

929

930 #-----------------------------------------------------------------------------

931 # Name : INSTANCENAME

932 # Datatype : String

933 # Description : RAC instance name to be added

934 # Valid values : Check Oracle11g Administrator's Guide

935 # Default value : <sid_prefix>+<highest_current_thread+1>

936 # Mandatory : No

937 #-----------------------------------------------------------------------------

938 #INSTANCENAME = "orcl1"

939

940 #-----------------------------------------------------------------------------

941 # Name : NODELIST

942 # Datatype : String

943 # Description : Node on which to add new instance

944 # (in 10gR2, instance addition is supported on 1 node at a time)

945 # Valid values : Cluster node name

946 # Default value : None

947 # Mandatory : Yes

948 #-----------------------------------------------------------------------------

949 NODELIST=

950

951 #-----------------------------------------------------------------------------

952 # Name : OBFUSCATEDPASSWORDS

953 # Datatype : Boolean

954 # Description : Set to true if passwords are encrypted

955 # Valid values : TRUE\FALSE

956 # Default value : FALSE

957 # Mandatory : No

958 #-----------------------------------------------------------------------------

959 #OBFUSCATEDPASSWORDS = FALSE

960

961 #-----------------------------------------------------------------------------

962 # Name : SYSDBAUSERNAME

963 # Datatype : String

964 # Description : A user with DBA role.

965 # Default value : none

966 # Mandatory : YES

967 #-----------------------------------------------------------------------------

968 SYSDBAUSERNAME = "sys"

969

970 #-----------------------------------------------------------------------------

971 # Name : SYSDBAPASSWORD

972 # Datatype : String

973 # Description : The password of the DBA user.

974 # Default value : none

975 # Mandatory : YES

976 #-----------------------------------------------------------------------------

977 #SYSDBAPASSWORD = "password"

978

979 #----------------------- End of ADDINSTANCE section ------------------------

980

981

982 #-----------------------------------------------------------------------------

983 # DELETEINSTANCE section is used when OPERATION_TYPE is defined as "deleteInstance".

984 #-----------------------------------------------------------------------------

985 [DELETEINSTANCE]

986

987 #-----------------------------------------------------------------------------

988 # Name : DB_UNIQUE_NAME

989 # Datatype : String

990 # Description : DB Unique Name of the RAC database

991 # Valid values : <db_unique_name>

992 # Default value : None

993 # Mandatory : Yes

994 #-----------------------------------------------------------------------------

995 DB_UNIQUE_NAME = "orcl11g.us.oracle.com"

996

997 #-----------------------------------------------------------------------------

998 # Name : INSTANCENAME

999 # Datatype : String

1000 # Description : RAC instance name to be deleted

1001 # Valid values : Check Oracle11g Administrator's Guide

1002 # Default value : None

1003 # Mandatory : Yes

1004 #-----------------------------------------------------------------------------

1005 INSTANCENAME = "orcl11g"

1006

1007 #-----------------------------------------------------------------------------

1008 # Name : NODELIST

1009 # Datatype : String

1010 # Description : Node on which instance to be deleted (SID) is located

1011 # Valid values : Cluster node name

1012 # Default value : None

1013 # Mandatory : No

1014 #-----------------------------------------------------------------------------

1015 #NODELIST=

1016

1017 #-----------------------------------------------------------------------------

1018 # Name : OBFUSCATEDPASSWORDS

1019 # Datatype : Boolean

1020 # Description : Set to true if passwords are encrypted

1021 # Valid values : TRUE\FALSE

1022 # Default value : FALSE

1023 # Mandatory : No

1024 #-----------------------------------------------------------------------------

1025 #OBFUSCATEDPASSWORDS = FALSE

1026

1027 #-----------------------------------------------------------------------------

1028 # Name : SYSDBAUSERNAME

1029 # Datatype : String

1030 # Description : A user with DBA role.

1031 # Default value : none

1032 # Mandatory : YES

1033 #-----------------------------------------------------------------------------

1034 SYSDBAUSERNAME = "sys"

1035

1036 #-----------------------------------------------------------------------------

1037 # Name : SYSDBAPASSWORD

1038 # Datatype : String

1039 # Description : The password of the DBA user.

1040 # Default value : none

1041 # Mandatory : YES

1042 #-----------------------------------------------------------------------------

1043 #SYSDBAPASSWORD = "password"

1044

1045

1046 #----------------------- End of DELETEINSTANCE section ------------------------

dbca.rsp

二、安装

$cd /home/oracle/database

$./runInstaller -silent -responseFile /home/oracle/response/db_install.rsp

//当安装界面出现如下信息的时候打开另一个终端窗口

The installation of Oracle Database 11g was successful.

Please check '/home/oracle/oraInventory/logs/silentInstall2016-02-04_09-21-13AM.log' for more details.

As a root user, execute the following script(s):

/home/oracle/oraInventory/orainstRoot.sh （执行就行，不用修改权限等）
/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

这里如果报错，就检查 .bash_profile这个配置文件的环境变量是否正确。

出现以下则成功

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 start开启监听。）

查看监听状态

$lsnrctl status

$dbca -silent -responseFile /home/oracle/response/dbca.rsp （这里如果报错的话，就检查dbca.rsp文件的内容是否正确。）

四、启动数据库

$ sqlplus / as sysdba //as前有个空格

[[email protected] ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Feb 16 14:26:57 2015

Connected to an idle instance.

SQL> start

SP2-1506: START, @ or @@ command has no arguments

SQL> startup

（

报错没有initicare1.ora文件。

解决此问题的方法就是到cd /oracle/app/oracle/admin/orcl/pfile/目录下，将ora.1114201016265复制到dbs目录下，重新命名：

cp init.ora.4202014111350 /u01/app/oracle/product/11.2.0/db_1/initicare1.ora

）

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看看是否正常

五，监听如果有问题：查看/u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora 文件。

//注意HOST 与 /etc/hosts 下面配置的名字一致。

//文件内容如下。

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

  (ADDRESS = (PROTOCOL = TCP)(HOST = vhora )(PORT = 1521))

)

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

 (GLOBAL_DBNAME = orcl)

 (SID_NAME = orcl)

)

六，如果reboot后，需要执行：

SQL> startup 启动实例

SQL> shutdown immediate 启动实例

$ lsnrctl start 启动监听程序

$ lsnrctl stop 停止监听

上一篇：朱元璋为什么使用卫所制度？募兵制是怎么出现的？

下一篇： PHP 实现Word，excel等转换pdf

linux下安装oracle数据库

vi /etc/sysconfig/iptables

vim /etc/sysctl.conf

groupadd oinstall

groupadd dba

useradd -g oinstall -G dba -d /home/oracle oracle

passwd oracle //设置oracle密码

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/

xhost +

HP-UX IA64 11.31系统上安装Oracle 10.2数据库相关要求

Redhat Linux AS4下的LAMP与Discuz安装_PHP教程

Linux同平台Oracle数据库整体物理迁移

HP-UX IA64 11.31系统上安装Oracle 11.2数据库相关要求

Oracle 11g数据库软件静默安装

Linux+Nginx下SSL证书安装

Weblogic815在Linux下的安装和配置

Linux下安装Oracle参数自动初始化脚本

在RedHat Linux 5.5 (x32/x64)上安装Oracle 10g r2(10.2.0.5)

RHEL 5 下安装 Oracle 10g 心得笔记

linux下安装oracle数据库

vi /etc/sysconfig/iptables

vim /etc/sysctl.conf

groupadd oinstall

groupadd dba

useradd -g oinstall -G dba -d /home/oracle oracle

passwd oracle //设置oracle密码

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/

xhost +

HP-UX IA64 11.31系统上安装Oracle 10.2数据库相关要求

Redhat Linux AS4下的LAMP与Discuz安装_PHP教程

Linux同平台Oracle数据库整体物理迁移

HP-UX IA64 11.31系统上安装Oracle 11.2数据库相关要求

Oracle 11g数据库软件静默安装

Linux+Nginx下SSL证书安装

Weblogic815在Linux下的安装和配置

Linux下安装Oracle参数自动初始化脚本

在RedHat Linux 5.5 (x32/x64)上安装Oracle 10g r2(10.2.0.5)

RHEL 5 下 安装 Oracle 10g 心得笔记

RHEL 5 下安装 Oracle 10g 心得笔记