linux下安装oracle数据库

一、安装前准备工作

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

  fi

fi

使修改的内容生效

#source /etc/profile

二、解压开始安装

有图形界面时

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

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

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

xhost +

(这里如果报错,一般是搞定不了,所以还是用静默安装,)

#su - oracle

$ unzip p10404530_112030_Linux-x86-64_1of7.zip

$ unzip p10404530_112030_Linux-x86-64_2of7.zip

$ export DISPLAY=:0

$ ./database/runInstaller

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

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

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

一、修改静默安装的模板

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

$ cd /home/oracle/response

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

三个文件作用分别是:

db_install.rsp:安装应答

dbca.rsp:创建数据库应答

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

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

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

2 ## Copyright(c) Oracle Corporation 1998,2008. All rights reserved.##

3 ## ##

4 ## Specify values for the variables listed below to customize ##

5 ## your installation. ##

6 ## ##

7 ## Each variable is associated with a comment. The comment ##

8 ## can help to populate the variables with the appropriate ##

9 ## values. ##

10 ## ##

11 ## IMPORTANT NOTE: This file contains plain text passwords and ##

12 ## should be secured to have read permission only by oracle user ##

13 ## or db administrator who owns this installation. ##

14 ## ##

15 ####################################################################

16

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

18 # Do not change the following system generated value.

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

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

21

22 #------------------------------------------------------------------------------

23 # Specify the installation option.

24 # It can be one of the following:

25 # 1. INSTALL_DB_SWONLY

26 # 2. INSTALL_DB_AND_CONFIG

27 # 3. UPGRADE_DB

28 #-------------------------------------------------------------------------------

29 oracle.install.option=INSTALL_DB_SWONLY

30

31 #-------------------------------------------------------------------------------

32 # Specify the hostname of the system as set during the install. It can be used

33 # to force the installation to use an alternative hostname rather than using the

34 # first hostname found on the system. (e.g., for systems with multiple hostnames

35 # and network interfaces)

36 #-------------------------------------------------------------------------------

37 ORACLE_HOSTNAME=centos7

38

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

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

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

42 UNIX_GROUP_NAME=oinstall

43

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

45 # Specify the location which holds the inventory files.

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

47 INVENTORY_LOCATION=/opt/oracle_11/oraInventory

48

49 #-------------------------------------------------------------------------------

50 # Specify the languages in which the components will be installed.

51 #

52 # en : English ja : Japanese

53 # fr : French ko : Korean

54 # ar : Arabic es : Latin American Spanish

55 # bn : Bengali lv : Latvian

56 # pt_BR: Brazilian Portuguese lt : Lithuanian

57 # bg : Bulgarian ms : Malay

58 # fr_CA: Canadian French es_MX: Mexican Spanish

59 # ca : Catalan no : Norwegian

60 # hr : Croatian pl : Polish

61 # cs : Czech pt : Portuguese

62 # da : Danish ro : Romanian

63 # nl : Dutch ru : Russian

64 # ar_EG: Egyptian zh_CN: Simplified Chinese

65 # en_GB: English (Great Britain) sk : Slovak

66 # et : Estonian sl : Slovenian

67 # fi : Finnish es_ES: Spanish

68 # de : German sv : Swedish

69 # el : Greek th : Thai

70 # iw : Hebrew zh_TW: Traditional Chinese

71 # hu : Hungarian tr : Turkish

72 # is : Icelandic uk : Ukrainian

73 # in : Indonesian vi : Vietnamese

74 # it : Italian

75 #

76 # Example : SELECTED_LANGUAGES=en,fr,ja

77 #------------------------------------------------------------------------------

78 SELECTED_LANGUAGES=en,zh_CN

79

80 #------------------------------------------------------------------------------

81 # Specify the complete path of the Oracle Home.

82 #------------------------------------------------------------------------------

83 ORACLE_HOME=/opt/oracle_11/app/oracle/product/11.2.0/dbhome_1

84

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

86 # Specify the complete path of the Oracle Base.

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

88 ORACLE_BASE=/opt/oracle_11/app

89

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

91 # Specify the installation edition of the component.

92 #

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

94 # EE : Enterprise Edition

95 # SE : Standard Edition

96 # SEONE : Standard Edition One

97 # PE : Personal Edition (WINDOWS ONLY)

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

99 oracle.install.db.InstallEdition=EE

100

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

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

103 #

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

105 # are considered for install.

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

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

108 oracle.install.db.isCustomInstall=true

109

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

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

112 #

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

114 #

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

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

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

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

119 #

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

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

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

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

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

125 # oracle.oraolap:11.2.0.1.0 - Oracle OLAP

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

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

128

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

130 # #

131 # PRIVILEGED OPERATING SYSTEM GROUPS #

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

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

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

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

136 # #

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

138

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

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

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

142 oracle.install.db.DBA_GROUP=dba

143

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

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

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

147 oracle.install.db.OPER_GROUP=oinstall

148

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

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

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

152 oracle.install.db.CLUSTER_NODES=

153

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

155 # Specify the type of database to create.

156 # It can be one of the following:

157 # - GENERAL_PURPOSE/TRANSACTION_PROCESSING

158 # - DATA_WAREHOUSE

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

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

161

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

163 # Specify the Starter Database Global Database Name.

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

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

166

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

168 # Specify the Starter Database SID.

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

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

171

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

173 # Specify the Starter Database character set.

174 #

175 # It can be one of the following:

176 # AL32UTF8, WE8ISO8859P15, WE8MSWIN1252, EE8ISO8859P2,

177 # EE8MSWIN1250, NE8ISO8859P10, NEE8ISO8859P4, BLT8MSWIN1257,

178 # BLT8ISO8859P13, CL8ISO8859P5, CL8MSWIN1251, AR8ISO8859P6,

179 # AR8MSWIN1256, EL8ISO8859P7, EL8MSWIN1253, IW8ISO8859P8,

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

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

182 # ZHT16HKSCS, WE8ISO8859P9, TR8MSWIN1254, VN8MSWIN1258

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

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

185

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

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

188 # in Database is desired.

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

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

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

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

193

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

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

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

197 # on the system.

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

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

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

201

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

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

204 # database or not.

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

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

207

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

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

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

211 # These settings may also be disabled.

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

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

214

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

216 # #

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

218 # starter database: #

219 # SYS #

220 # SYSTEM #

221 # SYSMAN (used by Enterprise Manager) #

222 # DBSNMP (used by Enterprise Manager) #

223 # #

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

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

226 # #

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

228

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

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

231 # starter database.

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

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

234

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

236 # Specify the SYS password for the starter database.

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

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

239

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

241 # Specify the SYSTEM password for the starter database.

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

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

244

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

246 # Specify the SYSMAN password for the starter database.

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

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

249

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

251 # Specify the DBSNMP password for the starter database.

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

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

254

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

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

257 # It can be one of the following:

258 # 1. GRID_CONTROL

259 # 2. DB_CONTROL

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

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

262

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

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

265 # the database.

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

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

268

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

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

271 # alerts when using DB control.

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

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

274

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

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

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

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

279

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

281 # Specify the SMTP server used for email notifications.

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

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

284

285

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

287 # #

288 # SPECIFY BACKUP AND RECOVERY OPTIONS #

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

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

291 # using the entries below. #

292 # #

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

294

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

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

297 # this can be set to true.

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

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

300

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

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

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

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

305 # user that is specified in this variable.

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

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

308

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

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

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

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

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

314 # above operating system user.

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

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

317

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

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

320 # It can be one of the following:

321 # - FILE_SYSTEM_STORAGE

322 # - ASM_STORAGE

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

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

325

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

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

328 # files, redo logs.

329 #

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

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

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

333

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

335 # Specify the backup and recovery location.

336 #

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

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

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

340

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

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

343 #

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

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

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

347

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

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

350 #

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

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

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

354

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

356 # Specify the My Oracle Support Account Username.

357 #

358 # Example : MYORACLESUPPORT_USERNAME=metalink

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

360 MYORACLESUPPORT_USERNAME=

361

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

363 # Specify the My Oracle Support Account Username password.

364 #

365 # Example : MYORACLESUPPORT_PASSWORD=password

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

367 MYORACLESUPPORT_PASSWORD=

368

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

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

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

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

373 #

374 # Example : SECURITY_UPDATES_VIA_MYORACLESUPPORT=true

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

376 SECURITY_UPDATES_VIA_MYORACLESUPPORT=false

377

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

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

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

381 # to be false.

382 #

383 # Example : DECLINE_SECURITY_UPDATES=false

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

385 DECLINE_SECURITY_UPDATES=true

386

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

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

389 #

390 # Example : PROXY_HOST=proxy.domain.com

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

392 PROXY_HOST=

393

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

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

396 #

397 # Example : PROXY_PORT=25

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

399 PROXY_PORT=

400

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

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

403 # blank if your proxy server requires no authentication.

404 #

405 # Example : PROXY_USER=username

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

407 PROXY_USER=

408

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

410 # Specify the proxy password. Leave PROXY_USER and PROXY_PWD

411 # blank if your proxy server requires no authentication.

412 #

413 # Example : PROXY_PWD=password

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

415 PROXY_PWD=

db_install.rsp

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

2 ## ##

3 ## DBCA response file ##

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

5 ## Copyright 1998, 2007, Oracle Corporation. All Rights Reserved. ##

6 ## ##

7 ## Specify values for the variables listed below to customize Oracle ##

8 ## Database Configuration installation. ##

9 ## ##

10 ## Each variable is associated with a comment. The comment identifies the ##

11 ## variable type. ##

12 ## ##

13 ## Please specify the values in the following format : ##

14 ## Type : Example ##

15 ## String : "<value>" ##

16 ## Boolean : True or False ##

17 ## Number : <numeric value> ##

18 ## StringList : {"<value1>","<value2>"} ##

19 ## ##

20 ## Examples : ##

21 ## 1. dbca -progress_only -responseFile <response file> ##

22 ## Display a progress bar depicting progress of database creation ##

23 ## process. ##

24 ## ##

25 ## 2. dbca -silent -responseFile <response file> ##

26 ## Creates database silently. No user interface is displayed. ##

27 ## ##

28 ## 3. dbca -silent -createDatabase -cloneTemplate ##

29 ## -responseFile <response file> ##

30 ## Creates database silently with clone template. The template in ##

31 ## responsefile is a clone template. ##

32 ## ##

33 ## 4. dbca -silent -deleteDatabase -responseFile <response file> ##

34 ## Deletes database silently. ##

35 ##############################################################################

36

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

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

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

40 [GENERAL]

41

42 #-----------------------------------------------------------------------------

43 # Name : RESPONSEFILE_VERSION

44 # Datatype : String

45 # Description : Version of the database to create

46 # Valid values : "11.1.0"

47 # Default value : None

48 # Mandatory : Yes

49 #-----------------------------------------------------------------------------

50 RESPONSEFILE_VERSION = "11.2.0"

51

52 #-----------------------------------------------------------------------------

53 # Name : OPERATION_TYPE

54 # Datatype : String

55 # Description : Type of operation

56 # Valid values : "createDatabase" \ "createTemplateFromDB" \ "createCloneTemplate" \ "deleteDatabase" \ "configureDatabase" \ "addInstance" (RAC-only) \ "deleteInstance" (RAC-only)

57 # Default value : None

58 # Mandatory : Yes

59 #-----------------------------------------------------------------------------

60 OPERATION_TYPE = "createDatabase"

61

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

63

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

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

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

67 [CREATEDATABASE]

68

69 #-----------------------------------------------------------------------------

70 # Name : GDBNAME

71 # Datatype : String

72 # Description : Global database name of the database

73 # Valid values : <db_name>.<db_domain> - when database domain isn't NULL

74 # <db_name> - when database domain is NULL

75 # Default value : None

76 # Mandatory : Yes

77 #-----------------------------------------------------------------------------

78 GDBNAME = "glassfish"

79

80 #-----------------------------------------------------------------------------

81 # Name : POLICYMANAGED

82 # Datatype : Boolean

83 # Description : Set to true if Database is policy managed and

84 # set to false if Database is admin managed

85 # Valid values : TRUE\FALSE

86 # Default value : FALSE

87 # Mandatory : No

88 #-----------------------------------------------------------------------------

89 #POLICYMANAGED = "false"

90

91 #-----------------------------------------------------------------------------

92 # Name : CREATESERVERPOOL

93 # Datatype : Boolean

94 # Description : Set to true if new server pool need to be created for database

95 # if this option is specified then the newly created database

96 # will use this newly created serverpool.

97 # Multiple serverpoolname can not be specified for database

98 # Valid values : TRUE\FALSE

99 # Default value : FALSE

100 # Mandatory : No

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

102 #CREATESERVERPOOL = "false"

103

104 #-----------------------------------------------------------------------------

105 # Name : FORCE

106 # Datatype : Boolean

107 # Description : Set to true if new server pool need to be created by force

108 # if this option is specified then the newly created serverpool

109 # will be assigned server even if no free servers are available.

110 # This may affect already running database.

111 # This flag can be specified for Admin managed as well as policy managed db.

112 # Valid values : TRUE\FALSE

113 # Default value : FALSE

114 # Mandatory : No

115 #-----------------------------------------------------------------------------

116 #FORCE = "false"

117

118 #-----------------------------------------------------------------------------

119 # Name : SERVERPOOLNAME

120 # Datatype : String

121 # Description : Only one serverpool name need to be specified

122 # if Create Server Pool option is specified.

123 # Comma-separated list of Serverpool names if db need to use

124 # multiple Server pool

125 # Valid values : ServerPool name

126 # Default value : None

127 # Mandatory : No [required in case of RAC service centric database]

128 #-----------------------------------------------------------------------------

129 #SERVERPOOLNAME =

130

131 #-----------------------------------------------------------------------------

132 # Name : CARDINALITY

133 # Datatype : Number

134 # Description : Specify Cardinality for create server pool operation

135 # Valid values : any positive Integer value

136 # Default value : Number of qualified nodes on cluster

137 # Mandatory : No [Required when a new serverpool need to be created]

138 #-----------------------------------------------------------------------------

139 #CARDINALITY =

140

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

142 # Name : SID

143 # Datatype : String

144 # Description : System identifier (SID) of the database

145 # Valid values : Check Oracle11g Administrator's Guide

146 # Default value : <db_name> specified in GDBNAME

147 # Mandatory : No

148 #-----------------------------------------------------------------------------

149 SID = "glassfish"

150

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

152 # Name : NODELIST

153 # Datatype : String

154 # Description : Comma-separated list of cluster nodes

155 # Valid values : Cluster node names

156 # Default value : None

157 # Mandatory : No (Yes for RAC database-centric database )

158 #-----------------------------------------------------------------------------

159 #NODELIST=

160

161 #-----------------------------------------------------------------------------

162 # Name : TEMPLATENAME

163 # Datatype : String

164 # Description : Name of the template

165 # Valid values : Template file name

166 # Default value : None

167 # Mandatory : Yes

168 #-----------------------------------------------------------------------------

169 TEMPLATENAME = "General_Purpose.dbc"

170

171 #-----------------------------------------------------------------------------

172 # Name : OBFUSCATEDPASSWORDS

173 # Datatype : Boolean

174 # Description : Set to true if passwords are encrypted

175 # Valid values : TRUE\FALSE

176 # Default value : FALSE

177 # Mandatory : No

178 #-----------------------------------------------------------------------------

179 #OBFUSCATEDPASSWORDS = FALSE

180

181

182 #-----------------------------------------------------------------------------

183 # Name : SYSPASSWORD

184 # Datatype : String

185 # Description : Password for SYS user

186 # Valid values : Check Oracle11g Administrator's Guide

187 # Default value : None

188 # Mandatory : Yes

189 #-----------------------------------------------------------------------------

190 SYSPASSWORD = "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

206 # Valid values : CENTRAL|LOCAL|ALL|NOBACKUP|NOEMAIL|NONE

207 # Default value : NONE

208 # Mandatory : No

209 #-----------------------------------------------------------------------------

210 #EMCONFIGURATION = "NONE"

211

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

213 # Name : DISABLESECURITYCONFIGURATION

214 # Datatype : String

215 # Description : Database Security Settings

216 # Valid values : ALL|NONE|AUDIT|PASSWORD_PROFILE

217 # Default value : NONE

218 # Mandatory : No

219 #-----------------------------------------------------------------------------

220 #DISABLESECURITYCONFIGURATION = "NONE"

221

222

223 #-----------------------------------------------------------------------------

224 # Name : SYSMANPASSWORD

225 # Datatype : String

226 # Description : Password for SYSMAN user

227 # Valid values : Check Oracle11g Administrator's Guide

228 # Default value : None

229 # Mandatory : Yes, if LOCAL specified for EMCONFIGURATION

230 #-----------------------------------------------------------------------------

231 #SYSMANPASSWORD = "password"

232

233 #-----------------------------------------------------------------------------

234 # Name : DBSNMPPASSWORD

235 # Datatype : String

236 # Description : Password for DBSNMP user

237 # Valid values : Check Oracle11g Administrator's Guide

238 # Default value : None

239 # Mandatory : Yes, if EMCONFIGURATION is specified

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

241 #DBSNMPPASSWORD = "password"

242

243 #-----------------------------------------------------------------------------

244 # Name : CENTRALAGENT

245 # Datatype : String

246 # Description : Grid Control Central Agent Oracle Home

247 # Default value : None

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

249 #-----------------------------------------------------------------------------

250 #CENTRALAGENT =

251

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

253 # Name : HOSTUSERNAME

254 # Datatype : String

255 # Description : Host user name for EM backup job

256 # Default value : None

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

258 #-----------------------------------------------------------------------------

259 #HOSTUSERNAME =

260

261 #-----------------------------------------------------------------------------

262 # Name : HOSTUSERPASSWORD

263 # Datatype : String

264 # Description : Host user password for EM backup job

265 # Default value : None

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

267 #-----------------------------------------------------------------------------

268 #HOSTUSERPASSWORD=

269

270 #-----------------------------------------------------------------------------

271 # Name : BACKUPSCHEDULE

272 # Datatype : String

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

274 # Default value : 2:00

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

276 #-----------------------------------------------------------------------------

277 #BACKUPSCHEDULE=

278

279 #-----------------------------------------------------------------------------

280 # Name : SMTPSERVER

281 # Datatype : String

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

283 # Default value : None

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

285 #-----------------------------------------------------------------------------

286 #SMTPSERVER =

287

288 #-----------------------------------------------------------------------------

289 # Name : EMAILADDRESS

290 # Datatype : String

291 # Description : Email address for email notifications

292 # Default value : None

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

294 #-----------------------------------------------------------------------------

295 #EMAILADDRESS =

296

297 #-----------------------------------------------------------------------------

298 # Name : DVOWNERNAME

299 # Datatype : String

300 # Description : DataVault Owner

301 # Valid values : Check Oracle11g Administrator's Guide

302 # Default value : None

303 # Mandatory : Yes, if DataVault option is chosen

304 #-----------------------------------------------------------------------------

305 #DVOWNERNAME = ""

306

307 #-----------------------------------------------------------------------------

308 # Name : DVOWNERPASSWORD

309 # Datatype : String

310 # Description : Password for DataVault Owner

311 # Valid values : Check Oracle11g Administrator's Guide

312 # Default value : None

313 # Mandatory : Yes, if DataVault option is chosen

314 #-----------------------------------------------------------------------------

315 #DVOWNERPASSWORD = ""

316

317 #-----------------------------------------------------------------------------

318 # Name : DVACCOUNTMANAGERNAME

319 # Datatype : String

320 # Description : DataVault Account Manager

321 # Valid values : Check Oracle11g Administrator's Guide

322 # Default value : None

323 # Mandatory : No

324 #-----------------------------------------------------------------------------

325 #DVACCOUNTMANAGERNAME = ""

326

327 #-----------------------------------------------------------------------------

328 # Name : DVACCOUNTMANAGERPASSWORD

329 # Datatype : String

330 # Description : Password for DataVault Account Manager

331 # Valid values : Check Oracle11g Administrator's Guide

332 # Default value : None

333 # Mandatory : No

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

335 #DVACCOUNTMANAGERPASSWORD = ""

336

337

338

339 #-----------------------------------------------------------------------------

340 # Name : DATAFILEJARLOCATION

341 # Datatype : String

342 # Description : Location of the data file jar

343 # Valid values : Directory containing compressed datafile jar

344 # Default value : None

345 # Mandatory : No

346 #-----------------------------------------------------------------------------

347 #DATAFILEJARLOCATION =

348

349 #-----------------------------------------------------------------------------

350 # Name : DATAFILEDESTINATION

351 # Datatype : String

352 # Description : Location of the data file's

353 # Valid values : Directory for all the database files

354 # Default value : $ORACLE_BASE/oradata

355 # Mandatory : No

356 #-----------------------------------------------------------------------------

357 #DATAFILEDESTINATION =

358

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

360 # Name : RECOVERYAREADESTINATION

361 # Datatype : String

362 # Description : Location of the data file's

363 # Valid values : Recovery Area location

364 # Default value : $ORACLE_BASE/flash_recovery_area

365 # Mandatory : No

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

367 #RECOVERYAREADESTINATION=

368

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

370 # Name : STORAGETYPE

371 # Datatype : String

372 # Description : Specifies the storage on which the database is to be created

373 # Valid values : FS (CFS for RAC), ASM

374 # Default value : FS

375 # Mandatory : No

376 #-----------------------------------------------------------------------------

377 #STORAGETYPE=FS

378

379 #-----------------------------------------------------------------------------

380 # Name : DISKGROUPNAME

381 # Datatype : String

382 # Description : Specifies the disk group name for the storage

383 # Default value : DATA

384 # Mandatory : No

385 #-----------------------------------------------------------------------------

386 #DISKGROUPNAME=DATA

387

388 #-----------------------------------------------------------------------------

389 # Name : ASMSNMP_PASSWORD

390 # Datatype : String

391 # Description : Password for ASM Monitoring

392 # Default value : None

393 # Mandatory : No

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

395 #ASMSNMP_PASSWORD=""

396

397 #-----------------------------------------------------------------------------

398 # Name : RECOVERYGROUPNAME

399 # Datatype : String

400 # Description : Specifies the disk group name for the recovery area

401 # Default value : RECOVERY

402 # Mandatory : No

403 #-----------------------------------------------------------------------------

404 #RECOVERYGROUPNAME=RECOVERY

405

406

407 #-----------------------------------------------------------------------------

408 # Name : CHARACTERSET

409 # Datatype : String

410 # Description : Character set of the database

411 # Valid values : Check Oracle11g National Language Support Guide

412 # Default value : "US7ASCII"

413 # Mandatory : NO

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

415 CHARACTERSET = "AL32UTF8"

416

417 #-----------------------------------------------------------------------------

418 # Name : NATIONALCHARACTERSET

419 # Datatype : String

420 # Description : National Character set of the database

421 # Valid values : "UTF8" or "AL16UTF16". For details, check Oracle11g National Language Support Guide

422 # Default value : "AL16UTF16"

423 # Mandatory : No

424 #-----------------------------------------------------------------------------

425 #NATIONALCHARACTERSET= "UTF8"

426

427 #-----------------------------------------------------------------------------

428 # Name : REGISTERWITHDIRSERVICE

429 # Datatype : Boolean

430 # Description : Specifies whether to register with Directory Service.

431 # Valid values : TRUE \ FALSE

432 # Default value : FALSE

433 # Mandatory : No

434 #-----------------------------------------------------------------------------

435 #REGISTERWITHDIRSERVICE= TRUE

436

437 #-----------------------------------------------------------------------------

438 # Name : DIRSERVICEUSERNAME

439 # Datatype : String

440 # Description : Specifies the name of the directory service user

441 # Mandatory : YES, if the value of registerWithDirService is TRUE

442 #-----------------------------------------------------------------------------

443 #DIRSERVICEUSERNAME= "name"

444

445 #-----------------------------------------------------------------------------

446 # Name : DIRSERVICEPASSWORD

447 # Datatype : String

448 # Description : The password of the directory service user.

449 # You can also specify the password at the command prompt instead of here.

450 # Mandatory : YES, if the value of registerWithDirService is TRUE

451 #-----------------------------------------------------------------------------

452 #DIRSERVICEPASSWORD= "password"

453

454 #-----------------------------------------------------------------------------

455 # Name : WALLETPASSWORD

456 # Datatype : String

457 # Description : The password for wallet to created or modified.

458 # You can also specify the password at the command prompt instead of here.

459 # Mandatory : YES, if the value of registerWithDirService is TRUE

460 #-----------------------------------------------------------------------------

461 #WALLETPASSWORD= "password"

462

463 #-----------------------------------------------------------------------------

464 # Name : LISTENERS

465 # Datatype : String

466 # Description : Specifies list of listeners to register the database with.

467 # By default the database is configured for all the listeners specified in the

468 # $ORACLE_HOME/network/admin/listener.ora

469 # Valid values : The list should be space separated names like "listener1 listener2".

470 # Mandatory : NO

471 #-----------------------------------------------------------------------------

472 #LISTENERS = "listener1 listener2"

473

474 #-----------------------------------------------------------------------------

475 # Name : VARIABLESFILE

476 # Datatype : String

477 # Description : Location of the file containing variable value pair

478 # Valid values : A valid file-system file. The variable value pair format in this file

479 # is <variable>=<value>. Each pair should be in a new line.

480 # Default value : None

481 # Mandatory : NO

482 #-----------------------------------------------------------------------------

483 #VARIABLESFILE =

484

485 #-----------------------------------------------------------------------------

486 # Name : VARIABLES

487 # Datatype : String

488 # Description : comma separated list of name=value pairs. Overrides variables defined in variablefile and templates

489 # Default value : None

490 # Mandatory : NO

491 #-----------------------------------------------------------------------------

492 #VARIABLES =

493

494 #-----------------------------------------------------------------------------

495 # Name : INITPARAMS

496 # Datatype : String

497 # Description : comma separated list of name=value pairs. Overrides initialization parameters defined in templates

498 # Default value : None

499 # Mandatory : NO

500 #-----------------------------------------------------------------------------

501 #INITPARAMS =

502

503 #-----------------------------------------------------------------------------

504 # Name : MEMORYPERCENTAGE

505 # Datatype : String

506 # Description : percentage of physical memory for Oracle

507 # Default value : None

508 # Mandatory : NO

509 #-----------------------------------------------------------------------------

510 #MEMORYPERCENTAGE = "40"

511

512 #-----------------------------------------------------------------------------

513 # Name : DATABASETYPE

514 # Datatype : String

515 # Description : used for memory distribution when MEMORYPERCENTAGE specified

516 # Valid values : MULTIPURPOSE|DATA_WAREHOUSING|OLTP

517 # Default value : MULTIPURPOSE

518 # Mandatory : NO

519 #-----------------------------------------------------------------------------

520 #DATABASETYPE = "MULTIPURPOSE"

521

522 #-----------------------------------------------------------------------------

523 # Name : AUTOMATICMEMORYMANAGEMENT

524 # Datatype : Boolean

525 # Description : flag to indicate Automatic Memory Management is used

526 # Valid values : TRUE/FALSE

527 # Default value : TRUE

528 # Mandatory : NO

529 #-----------------------------------------------------------------------------

530 #AUTOMATICMEMORYMANAGEMENT = "TRUE"

531

532 #-----------------------------------------------------------------------------

533 # Name : TOTALMEMORY

534 # Datatype : String

535 # Description : total memory in MB to allocate to Oracle

536 # Valid values :

537 # Default value :

538 # Mandatory : NO

539 #-----------------------------------------------------------------------------

540 TOTALMEMORY = "10240"

541

542

543 #----------------------- End of CREATEDATABASE section ------------------------

544

545 #-----------------------------------------------------------------------------

546 # createTemplateFromDB section is used when OPERATION_TYPE is defined as "createTemplateFromDB".

547 #-----------------------------------------------------------------------------

548 [createTemplateFromDB]

549 #-----------------------------------------------------------------------------

550 # Name : SOURCEDB

551 # Datatype : String

552 # Description : The source database from which to create the template

553 # Valid values : The format is <host>:<port>:<sid>

554 # Default value : none

555 # Mandatory : YES

556 #-----------------------------------------------------------------------------

557 SOURCEDB = "myhost:1521:orcl"

558

559 #-----------------------------------------------------------------------------

560 # Name : SYSDBAUSERNAME

561 # Datatype : String

562 # Description : A user with DBA role.

563 # Default value : none

564 # Mandatory : YES

565 #-----------------------------------------------------------------------------

566 SYSDBAUSERNAME = "system"

567

568 #-----------------------------------------------------------------------------

569 # Name : SYSDBAPASSWORD

570 # Datatype : String

571 # Description : The password of the DBA user.

572 # You can also specify the password at the command prompt instead of here.

573 # Default value : none

574 # Mandatory : YES

575 #-----------------------------------------------------------------------------

576 #SYSDBAPASSWORD = "password"

577

578 #-----------------------------------------------------------------------------

579 # Name : TEMPLATENAME

580 # Datatype : String

581 # Description : Name for the new template.

582 # Default value : None

583 # Mandatory : Yes

584 #-----------------------------------------------------------------------------

585 TEMPLATENAME = "My Copy TEMPLATE"

586

587 #----------------------- End of createTemplateFromDB section ------------------------

588

589 #-----------------------------------------------------------------------------

590 # createCloneTemplate section is used when OPERATION_TYPE is defined as "createCloneTemplate".

591 #-----------------------------------------------------------------------------

592 [createCloneTemplate]

593 #-----------------------------------------------------------------------------

594 # Name : SOURCEDB

595 # Datatype : String

596 # Description : The source database is the SID from which to create the template.

597 # This database must be local and on the same ORACLE_HOME.

598 # Default value : none

599 # Mandatory : YES

600 #-----------------------------------------------------------------------------

601 SOURCEDB = "orcl"

602

603 #-----------------------------------------------------------------------------

604 # Name : SYSDBAUSERNAME

605 # Datatype : String

606 # Description : A user with DBA role.

607 # Default value : none

608 # Mandatory : YES, if no OS authentication

609 #-----------------------------------------------------------------------------

610 #SYSDBAUSERNAME = "sys"

611

612 #-----------------------------------------------------------------------------

613 # Name : SYSDBAPASSWORD

614 # Datatype : String

615 # Description : The password of the DBA user.

616 # You can also specify the password at the command prompt instead of here.

617 # Default value : none

618 # Mandatory : YES

619 #-----------------------------------------------------------------------------

620 #SYSDBAPASSWORD = "password"

621

622 #-----------------------------------------------------------------------------

623 # Name : TEMPLATENAME

624 # Datatype : String

625 # Description : Name for the new template.

626 # Default value : None

627 # Mandatory : Yes

628 #-----------------------------------------------------------------------------

629 TEMPLATENAME = "My Clone TEMPLATE"

630

631 #-----------------------------------------------------------------------------

632 # Name : DATAFILEJARLOCATION

633 # Datatype : String

634 # Description : Location of the data file jar

635 # Valid values : Directory where the new compressed datafile jar will be placed

636 # Default value : $ORACLE_HOME/assistants/dbca/templates

637 # Mandatory : NO

638 #-----------------------------------------------------------------------------

639 #DATAFILEJARLOCATION =

640

641 #----------------------- End of createCloneTemplate section ------------------------

642

643 #-----------------------------------------------------------------------------

644 # DELETEDATABASE section is used when DELETE_TYPE is defined as "deleteDatabase".

645 #-----------------------------------------------------------------------------

646 [DELETEDATABASE]

647 #-----------------------------------------------------------------------------

648 # Name : SOURCEDB

649 # Datatype : String

650 # Description : The source database is the SID

651 # This database must be local and on the same ORACLE_HOME.

652 # Default value : none

653 # Mandatory : YES

654 #-----------------------------------------------------------------------------

655 SOURCEDB = "orcl"

656

657 #-----------------------------------------------------------------------------

658 # Name : SYSDBAUSERNAME

659 # Datatype : String

660 # Description : A user with DBA role.

661 # Default value : none

662 # Mandatory : YES, if no OS authentication

663 #-----------------------------------------------------------------------------

664 #SYSDBAUSERNAME = "sys"

665

666 #-----------------------------------------------------------------------------

667 # Name : SYSDBAPASSWORD

668 # Datatype : String

669 # Description : The password of the DBA user.

670 # You can also specify the password at the command prompt instead of here.

671 # Default value : none

672 # Mandatory : YES, if no OS authentication

673 #-----------------------------------------------------------------------------

674 #SYSDBAPASSWORD = "password"

675 #----------------------- End of deleteDatabase section ------------------------

676

677 #-----------------------------------------------------------------------------

678 # GENERATESCRIPTS section

679 #-----------------------------------------------------------------------------

680 [generateScripts]

681 #-----------------------------------------------------------------------------

682 # Name : TEMPLATENAME

683 # Datatype : String

684 # Description : Name of the template

685 # Valid values : Template name as seen in DBCA

686 # Default value : None

687 # Mandatory : Yes

688 #-----------------------------------------------------------------------------

689 TEMPLATENAME = "New Database"

690

691 #-----------------------------------------------------------------------------

692 # Name : GDBNAME

693 # Datatype : String

694 # Description : Global database name of the database

695 # Valid values : <db_name>.<db_domain> - when database domain isn't NULL

696 # <db_name> - when database domain is NULL

697 # Default value : None

698 # Mandatory : Yes

699 #-----------------------------------------------------------------------------

700 GDBNAME = "orcl11.us.oracle.com"

701

702 #-----------------------------------------------------------------------------

703 # Name : SCRIPTDESTINATION

704 # Datatype : String

705 # Description : Location of the scripts

706 # Valid values : Directory for all the scripts

707 # Default value : None

708 # Mandatory : No

709 #-----------------------------------------------------------------------------

710 #SCRIPTDESTINATION =

711

712 #----------------------- End of deleteDatabase section ------------------------

713

714 #-----------------------------------------------------------------------------

715 # CONFIGUREDATABASE section is used when OPERATION_TYPE is defined as "configureDatabase".

716 #-----------------------------------------------------------------------------

717 [CONFIGUREDATABASE]

718

719 #-----------------------------------------------------------------------------

720 # Name : SOURCEDB

721 # Datatype : String

722 # Description : The source database is the SID

723 # This database must be local and on the same ORACLE_HOME.

724 # Default value : none

725 # Mandatory : YES

726 #-----------------------------------------------------------------------------

727 #SOURCEDB = "orcl"

728

729 #-----------------------------------------------------------------------------

730 # Name : SYSDBAUSERNAME

731 # Datatype : String

732 # Description : A user with DBA role.

733 # Default value : none

734 # Mandatory : YES, if no OS authentication

735 #-----------------------------------------------------------------------------

736 #SYSDBAUSERNAME = "sys"

737

738

739 #-----------------------------------------------------------------------------

740 # Name : SYSDBAPASSWORD

741 # Datatype : String

742 # Description : The password of the DBA user.

743 # You can also specify the password at the command prompt instead of here.

744 # Default value : none

745 # Mandatory : YES, if no OS authentication

746 #-----------------------------------------------------------------------------

747 #SYSDBAPASSWORD =

748

749 #-----------------------------------------------------------------------------

750 # Name : REGISTERWITHDIRSERVICE

751 # Datatype : Boolean

752 # Description : Specifies whether to register with Directory Service.

753 # Valid values : TRUE \ FALSE

754 # Default value : FALSE

755 # Mandatory : No

756 #-----------------------------------------------------------------------------

757 #REGISTERWITHDIRSERVICE= TRUE

758

759 #-----------------------------------------------------------------------------

760 # Name : UNREGISTERWITHDIRSERVICE

761 # Datatype : Boolean

762 # Description : Specifies whether to unregister with Directory Service.

763 # Valid values : TRUE \ FALSE

764 # Default value : FALSE

765 # Mandatory : No

766 #-----------------------------------------------------------------------------

767 #UNREGISTERWITHDIRSERVICE= TRUE

768

769 #-----------------------------------------------------------------------------

770 # Name : REGENERATEDBPASSWORD

771 # Datatype : Boolean

772 # Description : Specifies whether regenerate database password in OID/Wallet

773 # Valid values : TRUE \ FALSE

774 # Default value : FALSE

775 # Mandatory : No

776 #-----------------------------------------------------------------------------

777 #REGENERATEDBPASSWORD= TRUE

778

779 #-----------------------------------------------------------------------------

780 # Name : DIRSERVICEUSERNAME

781 # Datatype : String

782 # Description : Specifies the name of the directory service user

783 # Mandatory : YES, if the any of the reg/unreg/regenPasswd options specified

784 #-----------------------------------------------------------------------------

785 #DIRSERVICEUSERNAME= "name"

786

787 #-----------------------------------------------------------------------------

788 # Name : DIRSERVICEPASSWORD

789 # Datatype : String

790 # Description : The password of the directory service user.

791 # You can also specify the password at the command prompt instead of here.

792 # Mandatory : YES, if the any of the reg/unreg/regenPasswd options specified

793 #-----------------------------------------------------------------------------

794 #DIRSERVICEPASSWORD= "password"

795

796 #-----------------------------------------------------------------------------

797 # Name : WALLETPASSWORD

798 # Datatype : String

799 # Description : The password for wallet to created or modified.

800 # You can also specify the password at the command prompt instead of here.

801 # Mandatory : YES, if the any of the reg/unreg/regenPasswd options specified

802 #-----------------------------------------------------------------------------

803 #WALLETPASSWORD= "password"

804

805 #-----------------------------------------------------------------------------

806 # Name : DISABLESECURITYCONFIGURATION

807 # Datatype : String

808 # Description : Database Security Settings

809 # Valid values : ALL|NONE|AUDIT|PASSWORD_PROFILE

810 # Default value : NONE

811 # Mandatory : No

812 #-----------------------------------------------------------------------------

813 #DISABLESECURITYCONFIGURATION = "NONE"

814

815

816

817 #-----------------------------------------------------------------------------

818 # Name : ENABLESECURITYCONFIGURATION

819 # Datatype : String

820 # Description : Database Security Settings

821 # Valid values : true|false

822 # Default value : true

823 # Mandatory : No

824 #-----------------------------------------------------------------------------

825 #ENABLESECURITYCONFIGURATION = "true"

826

827

828 #-----------------------------------------------------------------------------

829 # Name : EMCONFIGURATION

830 # Datatype : String

831 # Description : Enterprise Manager Configuration Type

832 # Valid values : CENTRAL|LOCAL|ALL|NOBACKUP|NOEMAIL|NONE

833 # Default value : NONE

834 # Mandatory : No

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

836 #EMCONFIGURATION = "NONE"

837

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

839 # Name : SYSMANPASSWORD

840 # Datatype : String

841 # Description : Password for SYSMAN user

842 # Valid values : Check Oracle11g Administrator's Guide

843 # Default value : None

844 # Mandatory : Yes, if LOCAL specified for EMCONFIGURATION

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

846 #SYSMANPASSWORD = "password"

847

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

849 # Name : DBSNMPPASSWORD

850 # Datatype : String

851 # Description : Password for DBSNMP user

852 # Valid values : Check Oracle11g Administrator's Guide

853 # Default value : None

854 # Mandatory : Yes, if EMCONFIGURATION is specified

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

856 #DBSNMPPASSWORD = "password"

857

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

859 # Name : CENTRALAGENT

860 # Datatype : String

861 # Description : Grid Control Central Agent Oracle Home

862 # Default value : None

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

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

865 #CENTRALAGENT =

866

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

868 # Name : HOSTUSERNAME

869 # Datatype : String

870 # Description : Host user name for EM backup job

871 # Default value : None

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

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

874 #HOSTUSERNAME =

875

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

877 # Name : HOSTUSERPASSWORD

878 # Datatype : String

879 # Description : Host user password for EM backup job

880 # Default value : None

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

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

883 #HOSTUSERPASSWORD=

884

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

886 # Name : BACKUPSCHEDULE

887 # Datatype : String

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

889 # Default value : 2:00

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

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

892 #BACKUPSCHEDULE=

893

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

895 # Name : SMTPSERVER

896 # Datatype : String

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

898 # Default value : None

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

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

901 #SMTPSERVER =

902

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

904 # Name : EMAILADDRESS

905 # Datatype : String

906 # Description : Email address for email notifications

907 # Default value : None

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

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

910 #EMAILADDRESS =

911

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

913

914

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

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

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

918 [ADDINSTANCE]

919

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

921 # Name : DB_UNIQUE_NAME

922 # Datatype : String

923 # Description : DB Unique Name of the RAC database

924 # Valid values : <db_unique_name>

925 # Default value : None

926 # Mandatory : Yes

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

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

929

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

931 # Name : INSTANCENAME

932 # Datatype : String

933 # Description : RAC instance name to be added

934 # Valid values : Check Oracle11g Administrator's Guide

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

936 # Mandatory : No

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

938 #INSTANCENAME = "orcl1"

939

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

941 # Name : NODELIST

942 # Datatype : String

943 # Description : Node on which to add new instance

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

945 # Valid values : Cluster node name

946 # Default value : None

947 # Mandatory : Yes

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

949 NODELIST=

950

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

952 # Name : OBFUSCATEDPASSWORDS

953 # Datatype : Boolean

954 # Description : Set to true if passwords are encrypted

955 # Valid values : TRUE\FALSE

956 # Default value : FALSE

957 # Mandatory : No

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

959 #OBFUSCATEDPASSWORDS = FALSE

960

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

962 # Name : SYSDBAUSERNAME

963 # Datatype : String

964 # Description : A user with DBA role.

965 # Default value : none

966 # Mandatory : YES

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

968 SYSDBAUSERNAME = "sys"

969

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

971 # Name : SYSDBAPASSWORD

972 # Datatype : String

973 # Description : The password of the DBA user.

974 # Default value : none

975 # Mandatory : YES

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

977 #SYSDBAPASSWORD = "password"

978

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

980

981

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

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

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

985 [DELETEINSTANCE]

986

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

988 # Name : DB_UNIQUE_NAME

989 # Datatype : String

990 # Description : DB Unique Name of the RAC database

991 # Valid values : <db_unique_name>

992 # Default value : None

993 # Mandatory : Yes

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

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

996

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

998 # Name : INSTANCENAME

999 # Datatype : String

1000 # Description : RAC instance name to be deleted

1001 # Valid values : Check Oracle11g Administrator's Guide

1002 # Default value : None

1003 # Mandatory : Yes

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

1005 INSTANCENAME = "orcl11g"

1006

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

1008 # Name : NODELIST

1009 # Datatype : String

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

1011 # Valid values : Cluster node name

1012 # Default value : None

1013 # Mandatory : No

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

1015 #NODELIST=

1016

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

1018 # Name : OBFUSCATEDPASSWORDS

1019 # Datatype : Boolean

1020 # Description : Set to true if passwords are encrypted

1021 # Valid values : TRUE\FALSE

1022 # Default value : FALSE

1023 # Mandatory : No

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

1025 #OBFUSCATEDPASSWORDS = FALSE

1026

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

1028 # Name : SYSDBAUSERNAME

1029 # Datatype : String

1030 # Description : A user with DBA role.

1031 # Default value : none

1032 # Mandatory : YES

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

1034 SYSDBAUSERNAME = "sys"

1035

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

1037 # Name : SYSDBAPASSWORD

1038 # Datatype : String

1039 # Description : The password of the DBA user.

1040 # Default value : none

1041 # Mandatory : YES

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

1043 #SYSDBAPASSWORD = "password"

1044

1045

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

dbca.rsp

二、安装

$cd /home/oracle/database

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

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

The installation of Oracle Database 11g was successful.

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

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

  1. /home/oracle/oraInventory/orainstRoot.sh (执行就行,不用修改权限等)

  2. /home/oracle/app/oracle/product/11.2.0/dbhome_1/root.sh (执行就行,不用修改权限等)

Successfully Setup Software.

//在新打开的root登录的窗口中执行下面的脚本

#/opt/oracle_11/oraInventory/orainstRoot.sh

#/opt/oracle_11/app/oracle/product/11.2.0/dbhome_1/root.sh

//执行完上面的脚本后回到安装终端窗口按下Enter键以继续

三、配置监听

$cd /home/oracle/response

$netca /silent /responsefile /home/oracle/response/netca.rsp

这里如果报错,就检查 .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前有个空格

[oracle@oracledb ~]$ sqlplus / as sysdba

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

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to an idle instance.

SQL> start

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

SQL> startup

报错没有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 停止监听

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值