rhel6/7如何自动安装oracle11g单实例

小编给大家分享一下rhel6/7如何自动安装oracle11g单实例，相信大部分人都还不怎么了解，因此分享这篇文章给大家参考一下，希望大家阅读完这篇文章后大有收获，下面让我们一起去了解一下吧！

因日常工作，经常需要在rhel6.X，rhel7.X，Centos6.X，CentOS7.x上安装oracle 11.2.0.4版本单实例数据库（基于文件系统）
故写了自动安装脚本oracle脚本。

全部文件列表如下：



1、其中iso文件是对应的红帽系统的镜像源（根据cat /etc/redhat-release获取红帽版本）
2、其中两个zip安装包，可以从SR上下载（搜索13390677找到对应的文件，注意文件名必须一致）
3、其中三个rsp文件是安装oracle的配置文件，db_install.rsp用于安装数据库软件，dbca.rsp用于创建数据库，netca.rsp用于创建监听。
4、其中sh文件是本人写的脚本，直接使用root用户执行即可（需要chmod u+x auto_install_oracle_server.sh），期间需要用户输入几个信息：字符集、oracle_sid、主机ip地址，memory_target。



因只在红帽6与7的部分版本测试过，可能还有一些问题。可具体修改shell脚本。

操作过程：
1、查看文件是否齐全

点击(此处)折叠或打开

1. [root@testlihb ~]# cd /tmp

2. [root@testlihb tmp]# ls -lrt

3. total 6120464

4. -rw-r--r-- 1 root root 5871 Apr 28 07:00 netca.rsp #监听配置文件

5. -rwxr--r-- 1 root root 17977 Apr 28 07:00 auto_install_oracle_server.sh #主脚本

6. -rw-r--r-- 1 root root 25287 Apr 28 07:00 db_install.rsp #数据库软件配置文件

7. -rw-r--r-- 1 root root 44580 Apr 28 07:00 dbca.rsp #数据库配置文件

8. -rwxr-xr-x 1 root root 1395582860 Apr 28 07:07 p13390677_112040_linux-x86-64_1of7.zip #11.2.0.4 安装包1

9. -rwxr-xr-x 1 root root 1151304589 Apr 28 07:12 p13390677_112040_Linux-x86-64_2of7.zip #11.2.0.4 安装包2

10. -rw-r--r-- 1 root root 3720347648 Jul 24 2018 rhel-server-6.4-x86_64-dvd.iso #操作系统光盘文件

11. [root@testlihb tmp]# chmod u+x auto_install_oracle_server.sh #root赋予可执行权限

2、配置yum源，如果确认yum源已经配置完毕，可忽略此步骤

点击(此处)折叠或打开

1. [root@testlihb tmp]# ./auto_install_oracle_server.sh #root直接执行

2. ========>-------- seletion------------

3. ========>1.install database #安装数据库

4. ========>2.deinstall database #卸载数据库（只可以卸载通过本脚本安装的数据库）

5. ========>3.configure local yum #配置yum源

6. ========>-----------------------------

7. ========>Your choice:3 #选择配置yum源，如果确认yum源已经配置好了，此处可忽略

8. ========>please input the iso location(eg:/tmp/xxx.iso):/tmp/rhel-server-6.4-x86_64-dvd.iso #输入iso文件的路径

9. [OK]====>the yum configure

3、安装数据库

点击(此处)折叠或打开

1. [root@testlihb tmp]# ./auto_install_oracle_server.sh

2. ========>-------- seletion------------

3. ========>1.install database

4. ========>2.deinstall database

5. ========>3.configure local yum

6. ========>-----------------------------

7. ========>Your choice:1 #安装数据库

8. [ok]====>begin install_db

9. [ok]====>current user is root #检查当前用户是否为root

10. [OK]====>the yum configure #检查yum源是否正常

11. [OK]====>the installfile #检查oracle安装包是否存在

12. [OK]====>the config file #检查配置文件是否存在

13. ========>----charcaterset seletion----

14. ========>1.AMERICAN_AMERICA.ZHS16GBK

15. ========>2.AMERICAN_AMERICA.AL32UTF8

16. ========>-----------------------------

17. ========>Your choice:(default 1):1 #选择数据库字符集，此处只有两个选择

18. ========>please input sid(less than 8 letters):oragbk #输入sid，sid必须少于8个字符

19. ========>please input memory target(MB):4096 #输入内存，其中sga和pga比例为3:1

20. ========>please input ORACLE_BASE(will auto create):/database/oragbk #oracle软件目录（如果目录不存在，会自动创建。如果目录存在，该目录必须为空）

21. ========>please input host IP address:192.168.75.236 #输入本机ip地址

22. [ok]====>cpu #检查cpu

23. [ok]====>memory #检查内存

24. [ok]====>/tmp #检查/tmp目录

25. [ok]====>swap #检查交换分区

26. [ok]====>ORACLE_BASE #检查oracle软件目录

27. [OK]====>the yum configure #检查yum源配置

28. [ok]====>the yum package has been installed #通过yum安装依赖包

29. [ok]====>the sysctl.conf has been backup and change #备份和修改sysctl.conf文件

30. [ok]====>the limits.conf has been backup and change #备份和修改limits.conf文件

31. [ok]====>the login has been backup and change #备份和修改login文件

32. [ok]====>the profile has been backup and change #备份和修改profile文件

33. [ok]====>the oracle user and oinstall,dba group has been created #创建oracle用户，oinstall和dba组

34. [ok]====>the .bash_profile has been backup and change #备份和修改.bash_profile文件

35. [ok]====>the dir has been created #检查和创建oracle_base目录

36. [ok]====>the install file has been unzip #解压oracle安装包

37. [ok]====>the hosts has been backup and change #备份和修改hosts文件

38. [ok]====>the db_install.rsp has been backup and change #备份和修改db_install.rsp文件

39. [ok]====>waiting for software install . . . . . . . . . . #此处在安装oracle软件，需要等较长时间，可查看/tmp/db_install.rsp.log

40. [ok]====>software has installed #oracle软件安装完成

41. [ok]====>two script has been run by root #root执行两个shell script文件

42. [ok]====>netca.rsp has been backup and change #备份和修改netca.rsp文件

43. [ok]====>waiting for netca install . #此处在创建listener，不需要等待太长时间，可查看/tmp/netca.rsp.log

44. [ok]====>netca has installed #listener创建完成

45. [ok]====>dbca.rsp has been backup and change #备份和修改dbca.rsp文件

46. Copying database files

47. 1% complete

48. 3% complete

49. 11% complete

50. 18% complete

51. 26% complete

52. 37% complete

53. Creating and starting Oracle instance

54. 40% complete

55. 45% complete

56. 50% complete

57. 55% complete

58. 56% complete

59. 60% complete

60. 62% complete

61. Completing Database Creation

62. 66% complete

63. 70% complete

64. 73% complete

65. 85% complete

66. 96% complete

67. 100% complete

68. Look at the log file "/database/oragbk/cfgtoollogs/dbca/oragbk/oragbk.log" for further details.

69. [ok]====>dbca has installed #数据库创建完成

70. [ok]====>the install process success

4、检查数据库是否正常

点击(此处)折叠或打开

1. [root@testlihb tmp]# ps -ef|grep smon_ |grep -v grep

2. oracle 12863 1 0 07:34 ? 00:00:00 ora_smon_oragbk #进程存在

3. 
   

4. [root@testlihb tmp]# su - oracle

5. [oracle@testlihb ~]$ sqlplus / as sysdba

6. SQL*Plus: Release 11.2.0.4.0 Production on Sat Apr 28 07:35:09 2018

7. Copyright (c) 1982, 2013, Oracle. All rights reserved.

8. Connected to:

9. Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

10. With the Partitioning, OLAP, Data Mining and Real Application Testing options

11. 
    

12. SQL> show parameter name

13. NAME TYPE VALUE

14. ------------------------------------ ----------- ------------------------------

15. cell_offloadgroup_name string

16. db_file_name_convert string

17. db_name string oragbk

18. db_unique_name string oragbk

19. global_names boolean FALSE

20. instance_name string oragbk

21. lock_name_space string

22. log_file_name_convert string

23. processor_group_name string

24. service_names string oragbk

25. 
    

26. SQL> show parameter memory

27. NAME TYPE VALUE

28. ------------------------------------ ----------- ------------------------------

29. hi_shared_memory_address integer 0

30. memory_max_target big integer 0

31. memory_target big integer 0

32. shared_memory_address integer 0

33. 
    

34. SQL> show parameter sga

35. NAME TYPE VALUE

36. ------------------------------------ ----------- ------------------------------

37. lock_sga boolean FALSE

38. pre_page_sga boolean FALSE

39. sga_max_size big integer 3G

40. sga_target big integer 3G

41. 
    

42. SQL> show parameter pga

43. NAME TYPE VALUE

44. ------------------------------------ ----------- ------------------------------

45. pga_aggregate_target big integer 1G

46. 
    

47. SQL> set lines 150 pages 10000

48. SQL> select * from nls_database_parameters where PARAMETER='NLS_CHARACTERSET';

49. PARAMETER VALUE

50. ------------------------------ --------------------------------------------------------------------------------

51. NLS_CHARACTERSET ZHS16GBK

52. 
    

53. SQL> exit

54. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

55. With the Partitioning, OLAP, Data Mining and Real Application Testing options

56. [oracle@testlihb ~]$ loGout

5、卸载数据库

点击(此处)折叠或打开

1. [root@testlihb tmp]# ./auto_install_oracle_server.sh

2. ========>-------- seletion------------

3. ========>1.install database

4. ========>2.deinstall database

5. ========>3.configure local yum

6. ========>-----------------------------

7. ========>Your choice:2

8. please use oracle to run $ORACLE_HOME/deinstall/deinstall and use root to run /tmp/del_ora.sh #切到oracle用户执行脚本，然后在切到root用户执行脚本

9. [root@testlihb tmp]# su - oracle

10. [oracle@testlihb ~]$ $ORACLE_HOME/deinstall/deinstall

11. Checking for required files and bootstrapping ...

12. Please wait ...

13. Location of logs /tmp/deinstall2018-04-28_07-36-48AM/logs/

14. 。。。

15. Specify all Single Instance listeners that are to be de-configured [LISTENER]:

16. Specify the list of database names that are configured in this Oracle home [oragbk]:

17. The details of database(s) oragbk have been discovered automatically. Do you still want to modify the details of oragbk database(s)? [n]: y

18. Specify the type of this database (1.Single Instance Database|2.Oracle Restart Enabled Database) [1]:

19. Specify the diagnostic destination location of the database [/database/oragbk/diag/rdbms/oragbk]:

20. Specify the storage type used by the Database ASM|FS [FS]:

21. Specify the list of directories if any database files exist on a shared file system. If 'oragbk' subdirectory is found, then it will be deleted. Otherwise, the specified directory will be deleted. Alternatively, you can specify list of database files with full path [/database/oragbk/oradata/oragbk,/database/oragbk/fast_recovery_area/oragbk]:

22. Specify the fast recovery area location, if it is configured on the file system. If 'oragbk' subdirectory is found, then it will be deleted. [/database/oragbk/fast_recovery_area/ORAGBK]:

23. Specify the database spfile location [/database/oragbk/product/11.2.0/db_1/dbs/spfileoragbk.ora]:

24. Do you want to continue (y - yes, n - no)? [n]: y

25. 。。。

26. [oracle@testlihb ~]$ logout

27. [root@testlihb tmp]# /tmp/del_ora.sh

6、检查是否已经删除数据库

点击(此处)折叠或打开

1. [root@testlihb tmp]# ps -ef|grep smon_

2. root 16003 7948 0 07:45 pts/1 00:00:00 grep smon_

3. [root@testlihb tmp]# id oracle

4. id: oracle: No such user

如下是具体的脚本：
 auto_install_oracle_server.sh

点击(此处)折叠或打开

1. #!/bin/bash

2. 
   

3. 
   

4. 
   

5. 
   

6. HOSTNAME=`hostname`

7. PWD="$( cd "$( dirname "$0"  )" && pwd  )"

8. 
   

9. # 102 去掉目录最后的/

10. change_dir(){

11. flag=${1##*/}

12. if [ -z $flag  ];then

13. ORACLE_BASE=${1%?}

14. fi

15. }

16. ##change_dir $dir

17. 
    

18. # 101 检查文件夹是否可以作为ORACLE_BASE目录

19. check_dir(){

20. if [ -d $1 ];then

21. if [ `ls -al $1|wc -l` -gt 3 ];then

22. echo "[fail]====>the ORACLE_BASE must without any file(s)"

23. exit 101

24. fi

25. else

26. mkdir -p $1

27. fi

28. }

29. ##read -p "input dir:" dir

30. ##check_dir $dir

31. 
    

32. # 0 检查传入参数是否为空

33. isnull(){

34. if [ -z $1 ];then

35. echo $1

36. echo "[fail]====>parameter is null"

37. exit 0

38. fi

39. }

40. ##isnull $hah

41. 
    

42. # 1 检查yum源是否正常

43. check_yum(){

44. yum clean all >/dev/null 2>&1

45. var=`yum repolist|grep repolist|awk -F : '{print $2}'|awk -F , '{print $1}'`

46. ##    echo $var

47. if [ $var -eq 0 ];then

48. echo "[fail]====>the yum configure is wrong ,see /etc/yum.repos.d/*.repo"

49. exit 1

50. else

51. echo "[OK]====>the yum configure"

52. fi

53. }

54. ##check_yum

55. 
    

56. # 2 检查数据库安装软件是否已经上传

57. check_installfile(){

58. cd $PWD

59. if [ -f "p13390677_112040_Linux-x86-64_1of7.zip" -a -f "p13390677_112040_Linux-x86-64_2of7.zip" ];then

60. echo "[OK]====>the installfile"

61. else

62. echo "[fail]====>the $PWD does not have p13390677_112040_Linux-* "

63. exit 2

64. fi

65. 
    

66. if [ -f "dbca.rsp" -a -f "netca.rsp" -a -f "db_install.rsp" ];then

67. echo "[OK]====>the config file"

68. else

69. echo "[fail]====>the $PWD does not have *.rsp"

70. exit 2

71. fi

72. }

73. ##check_installfile

74. 
    

75. # 3 判断执行用户是否root

76. isroot(){

77. if [ $USER != "root" ];then

78. echo "[fail]====>current user is not root"

79. exit 3

80. else

81. echo "[ok]====>current user is root"

82. fi

83. }

84. ##isroot

85. 
    

86. # 4 获取输入数据库基本信息

87. get_infORMation(){

88. echo "========>----charcaterset seletion----"

89. echo "========>1.AMERICAN_AMERICA.ZHS16GBK"

90. echo "========>2.AMERICAN_AMERICA.AL32UTF8"

91. echo "========>-----------------------------"

92. echo -e "========>Your choice:(default 1):\c"

93. read NLS_LANG

94. case $NLS_LANG in

95. 1) NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

96. CHARACTERSET=ZHS16GBK

97. ;;

98. 2) NLS_LANG=AMERICAN_AMERICA.AL32UTF8

99. CHARACTERSET=AL32UTF8

100. ;;

101. *) NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

102. CHARACTERSET=ZHS16GBK

103. ;;

104. esac

105. echo -e "========>please input sid(less than 8 letters):\c"

106. read SID

107. isnull $SID

108. echo -e "========>please input memory target(MB):\c"

109. read MEMORY

110. isnull $MEMORY

111. echo -e "========>please input ORACLE_BASE(will auto create):\c"

112. read ORACLE_BASE

113. isnull $ORACLE_BASE

114. check_dir $ORACLE_BASE

115. change_dir $ORACLE_BASE

116. ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1

117. echo -e "========>please input host IP address:\c"

118. read IP

119. isnull $IP

120. }

121. ##get_information

122. 
     

123. # 5 检查cpu，内存，磁盘空间

124. check_cpu_mem_disk(){

125. cpu=`cat /proc/cpuinfo | grep name|wc -l`

126. ##    echo $cpu

127. if [ $cpu -gt 1 ];then

128. echo "[ok]====>cpu "

129. else

130. echo "[fail]====>cpu must more than 1 cores"

131. exit 5

132. fi

133. 
     

134. mem=`free -m|grep '+'|awk '{print $4}'`

135. mem7=`free -m|grep Mem|awk '{print $7}'`

136. ##    echo $mem

137. if [[ $mem -gt 2048 || $mem7 -gt 2048 ]];then

138. echo "[ok]====>memory"

139. else

140. echo "[fail]====>the memory must more than 2G available"

141. exit 5

142. fi

143. 
     

144. if [ `df -m /tmp|wc -l` -eq 2 ];then

145. tmp=`df -m /tmp|tail -1|awk '{print $4}'`

146. else

147. tmp=`df -m /tmp|tail -1|awk '{print $3}'`

148. fi

149. if [ $tmp -gt 120 ];then

150. echo "[ok]====>/tmp"

151. else

152. echo "[fail]====>/tmp must more than 120MB"

153. exit 5

154. fi

155. 
     

156. if [ `free -m|grep Swap|awk '{print $2}'` -gt 150 ];then

157. echo "[ok]====>swap"

158. else

159. echo "[fail]====>swap must more than 150MB"

160. exit 5

161. fi

162. 
     

163. if [ `df -m $ORACLE_BASE|wc -l` -eq 2 ];then

164. base=`df -m $ORACLE_BASE|tail -1|awk '{print $4}'`

165. else

166. base=`df -m $ORACLE_BASE|tail -1|awk '{print $3}'`

167. fi

168. 
     

169. if [ $base -gt 8000 ];then

170. echo "[ok]====>ORACLE_BASE"

171. else

172. echo "[fail]====>ORACLE_BASE must more than 20g"

173. exit 5

174. fi

175. }

176. ##check_cpu_mem_disk

177. 
     

178. # 6 安装依赖包

179. yum_install(){

180. check_yum

181. yum install -y binutils  >/dev/null

182. yum install -y compat-libstdc++-33 >/dev/null

183. yum install -y elfutils-libelf  >/dev/null

184. yum install -y elfutils-libelf-devel  >/dev/null

185. yum install -y GCc  >/dev/null

186. yum install -y gcc-c++ >/dev/null

187. yum install -y glibc-common >/dev/null

188. yum install -y glibc-devel >/dev/null

189. yum install -y glibc-headers >/dev/null

190. yum install -y libaio >/dev/null

191. yum install -y libaio-devel >/dev/null

192. yum install -y libgcc >/dev/null

193. yum install -y libstdc++ >/dev/null

194. yum install -y libstdc++-devel >/dev/null

195. yum install -y make >/dev/null

196. yum install -y sysstat >/dev/null

197. yum install -y unzip >/dev/null

198. echo "[ok]====>the yum package has been installed"

199. }

200. ##yum_install

201. 
     

202. # 7 修改/etc/sysctl.conf文件

203. sysctl_set(){

204. if [ ! -f /etc/sysctl.conf.lihb_bak ];then

205. cp /etc/sysctl.conf /etc/sysctl.conf.lihb_bak

206. echo "kernel.shmmni = 4096" >>/etc/sysctl.conf

207. echo "kernel.sem = 250 32000 100 128" >>/etc/sysctl.conf

208. echo "fs.file-max = 6815744" >>/etc/sysctl.conf

209. echo "net.ipv4.ip_local_port_range = 9000 65500" >>/etc/sysctl.conf

210. echo "net.core.rmem_default = 1048576" >>/etc/sysctl.conf

211. echo "net.core.rmem_max = 4194304" >>/etc/sysctl.conf

212. echo "net.core.wmem_default = 262144" >>/etc/sysctl.conf

213. echo "net.core.wmem_max = 1048576" >>/etc/sysctl.conf

214. echo "fs.aio-max-nr = 1048576" >>/etc/sysctl.conf

215. /sbin/sysctl -p >/dev/null 2>&1

216. echo "[ok]====>the sysctl.conf has been backup and change"

217. fi

218. }

219. ##sysctl_set

220. 
     

221. # 8 修改/etc/security/limits.conf文件

222. limits_set(){

223. if [ ! -f /etc/security/limits.conf.lihb_bak ];then

224. cp /etc/security/limits.conf /etc/security/limits.conf.lihb_bak

225. echo "oracle    soft    nproc    2047" >>/etc/security/limits.conf

226. echo "oracle    hard    nproc    16384" >>/etc/security/limits.conf

227. echo "oracle    soft    nofile    1024" >>/etc/security/limits.conf

228. echo "oracle    hard    nofile    65536" >>/etc/security/limits.conf

229. echo "[ok]====>the limits.conf has been backup and change"

230. fi

231. }

232. ##limits_set

233. 
     

234. # 9 修改/etc/pam.d/login文件

235. login_set(){

236. if [ ! -f /etc/pam.d/login.lihb_bak ];then

237. cp /etc/pam.d/login /etc/pam.d/login.lihb_bak

238. echo "session    required    /lib64/security/pam_limits.so" >>/etc/pam.d/login

239. echo "[ok]====>the login has been backup and change"

240. fi

241. }

242. ##login_set

243. 
     

244. # 10 修改/etc/profile文件

245. profile_set(){

246. if [ ! -f /etc/profile.lihb_bak ];then

247. cp /etc/profile /etc/profile.lihb_bak

248. echo 'if [ "$USER" = "oracle" ];then ' >>/etc/profile

249. echo '    if [ "$SHELL" = "/bin/ksh" ];then ' >>/etc/profile

250. echo '        ulimit -p 16384' >>/etc/profile

251. echo '        ulimit -n 65536' >>/etc/profile

252. echo '    else' >>/etc/profile

253. echo '        ulimit -u 16384' >>/etc/profile

254. echo '        ulimit -n 65536' >>/etc/profile

255. echo '    fi' >>/etc/profile

256. echo '    umask 022' >>/etc/profile

257. echo 'fi' >>/etc/profile

258. echo "[ok]====>the profile has been backup and change"

259. fi

260. }

261. ##profile_set

262. 
     

263. # 11 创建oracle用户和oinstall,dba用户组

264. user_group_add(){

265. if [[ `grep "oinstall" /etc/group` = "" ]];then

266. /usr/sbin/groupadd  -g 1100 oinstall >/dev/null 2>&1

267. fi

268. if [[ `grep "dba" /etc/group` = "" ]];then

269. /usr/sbin/groupadd  -g 1101 dba   >/dev/null 2>&1

270. fi

271. if [[ `grep "oracle" /etc/passwd` = "" ]];then

272. /usr/sbin/useradd -g 1100 -G 1101 -u 1100 -m oracle >/dev/null 2>&1

273. echo "[ok]====>the oracle user and oinstall,dba group has been created"

274. else

275. echo "[fail]====>the oracle user has exist"

276. exit 11

277. fi

278. }

279. ##user_group_add

280. 
     

281. # 12 修改/home/oracle/.bash_profile文件

282. bash_profile_set(){

283. if [ ! -f /home/oracle/.bash_profile.lihb_bak ];then

284. cp /home/oracle/.bash_profile /home/oracle/.bash_profile.lihb_bak

285. echo "" >>/home/oracle/.bash_profile

286. echo "export ORACLE_BASE=$ORACLE_BASE" >>/home/oracle/.bash_profile

287. echo "export ORACLE_HOME=$ORACLE_HOME" >>/home/oracle/.bash_profile

288. echo "export ORACLE_SID=$SID" >>/home/oracle/.bash_profile

289. echo 'export LD_LIBRARY_PATH=$ORACLE_HOME/lib' >>/home/oracle/.bash_profile

290. echo 'stty erase ^H' >>/home/oracle/.bash_profile

291. echo 'export NLS_LANG10=$ORACLE_HOME/nls/data' >>/home/oracle/.bash_profile

292. echo 'export ORACLE_HOME_LISTNER=$ORACLE_HOME' >>/home/oracle/.bash_profile

293. echo 'export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin' >>/home/oracle/.bash_profile

294. echo 'export TEMP=/tmp' >>/home/oracle/.bash_profile

295. echo 'export TMPDIR=/tmp' >>/home/oracle/.bash_profile

296. echo "export NLS_LANG=$NLS_LANG" >>/home/oracle/.bash_profile

297. echo "export NLS_DATE_FORMAT='yyyy-mm-dd hh34:mi:ss'" >>/home/oracle/.bash_profile

298. echo 'umask 022' >>/home/oracle/.bash_profile

299. echo "[ok]====>the .bash_profile has been backup and change"

300. fi

301. }

302. ##bash_profile_set

303. 
     

304. # 13 创建ORACLE_BASE和ORACLE_HOME和数据文件目录并授权

305. create_dir(){

306. mkdir -p $ORACLE_HOME

307. mkdir -p $ORACLE_BASE/oradata

308. mkdir -p $ORACLE_BASE/oraInventory

309. mkdir -p $ORACLE_BASE/flash_recovery_area

310. chown -R oracle:oinstall  $ORACLE_BASE

311. echo "[ok]====>the dir has been created"

312. }

313. ##create_dir

314. 
     

315. # 14 解压数据库安装包

316. unzip_file(){

317. cd $PWD

318. /usr/bin/unzip p13390677_112040_Linux-x86-64_1of7.zip >/dev/null 2>&1

319. /usr/bin/unzip p13390677_112040_Linux-x86-64_2of7.zip >/dev/null 2>&1

320. chown -R oracle:oinstall $PWD/database

321. echo "[ok]====>the install file has been unzip"

322. }

323. ##unzip_file

324. 
     

325. # 15 修改/etc/hosts文件

326. hosts_set(){

327. if [ ! -f /etc/hosts.lihb_bak ];then

328. cp /etc/hosts /etc/hosts.lihb_bak

329. echo "$IP    $HOSTNAME" >>/etc/hosts

330. echo "[ok]====>the hosts has been backup and change"

331. fi

332. }

333. ##hosts_set

334. 
     

335. # 16 修改db_install.rsp 数据库软件安装配置文件

336. db_install_set(){

337. cd $PWD

338. chown oracle:oinstall db_install.rsp

339. if [ ! -f db_install.rsp.lihb_bak ];then

340. cp db_install.rsp db_install.rsp.lihb_bak

341. sed -i "s|lihb_hostname|$HOSTNAME|g" db_install.rsp

342. sed -i "s|lihb_location|$ORACLE_BASE/oraInventory|g" db_install.rsp

343. sed -i "s|lihb_home|$ORACLE_HOME|g" db_install.rsp

344. sed -i "s|lihb_base|$ORACLE_BASE|g" db_install.rsp

345. sed -i "s|lihb_globaldbname|$SID|g" db_install.rsp

346. sed -i "s|lihb_sid|$SID|g" db_install.rsp

347. sed -i "s|lihb_datalocation|$ORACLE_BASE/oradata|g" db_install.rsp

348. echo "[ok]====>the db_install.rsp has been backup and change"

349. fi

350. }

351. ##db_install_set

352. 
     

353. # 17 开始安装oracle软件

354. install_software(){

355. su - oracle -c "$PWD/database/runInstaller -silent -force -ignorePrereq -responseFile $PWD/db_install.rsp"  >/tmp/db_install.rsp.log

356. sleep 10s

357. echo -e "[ok]====>waiting for software install \c"

358. while [ ! `grep "root.sh" /tmp/db_install.rsp.log |wc -l` -eq 1 ]

359. do

360. echo -e ". \c"

361. sleep 2s

362. done

363. echo "."

364. echo "[ok]====>software has installed"

365. $ORACLE_BASE/oraInventory/orainstRoot.sh >/dev/null 2>&1

366. $ORACLE_BASE/product/11.2.0/db_1/root.sh >/dev/null 2>&1

367. echo "[ok]====>two script has been run by root"

368. }

369. ##install_software

370. 
     

371. # 18 修改netca.rsp  监听安装配置文件

372. netca_set(){

373. cd $PWD

374. chown oracle:oinstall netca.rsp

375. if [ ! -f netca.rsp.lihb_bak ];then

376. cp netca.rsp netca.rsp.lihb_bak

377. echo "[ok]====>netca.rsp has been backup and change"

378. fi

379. }

380. ##netca_set

381. 
     

382. # 19 开始安装监听软件

383. install_netca(){

384. #    ORACLE_HOME=/database/oracle/product/11.2.0/db_1/

385. chown -R oracle:dba /var/tmp/.oracle >/dev/null 2>&1

386. chown -R oracle:dba /tmp/.oracle >/dev/null 2>&1

387. su - oracle -c "$ORACLE_HOME/bin/netca -silent -responseFile $PWD/netca.rsp" >/tmp/netca.rsp.log

388. sleep 2s

389. echo -e "[ok]====>waiting for netca install \c"

390. while [ ! `grep "The exit code is" /tmp/netca.rsp.log|wc -l` -eq 1 ]

391. do

392. echo -e ". \c"

393. sleep 1s

394. done

395. echo "."

396. echo "[ok]====>netca has installed"

397. chown -R oracle:dba /var/tmp/.oracle >/dev/null 2>&1

398. chown -R oracle:dba /tmp/.oracle >/dev/null 2>&1

399. }

400. ##install_netca

401. 
     

402. # 20  修改dbca.rsp 创建数据库配置文件

403. dbca_set(){

404. cd $PWD

405. chown oracle:oinstall dbca.rsp

406. if [ ! -f dbca.rsp.lihb_bak ];then

407. cp dbca.rsp dbca.rsp.lihb_bak

408. #        SID=cgkcglxt

409. #        ORACLE_BASE=/database/oracle

410. #        CHARACTERSET=ZHS16GBK

411. #        MEMORY=4096

412. sed -i "s|lihb_sid|$SID|g" dbca.rsp

413. sed -i "s|lihb_datafiledestination|$ORACLE_BASE/oradata|g" dbca.rsp

414. sed -i "s|lihb_recoveryareadestination|$ORACLE_BASE/flash_recovery_area|g" dbca.rsp

415. sed -i "s|lihb_characterset|$CHARACTERSET|g" dbca.rsp

416. sed -i "s|lihb_totalmemory|$MEMORY|g" dbca.rsp

417. sed -i "s|lihb_gdbname|$SID|g" dbca.rsp

418. echo "[ok]====>dbca.rsp has been backup and change"

419. fi

420. }

421. ##dbca_set

422. 
     

423. # 21 开始创建数据库

424. install_dbca(){

425. #    ORACLE_HOME=/database/oracle/product/11.2.0/db_1/

426. su - oracle -c "$ORACLE_HOME/bin/dbca -silent -force -responseFile $PWD/dbca.rsp"

427. echo "[ok]====>dbca has installed"

428. }

429. ##install_dbca

430. 
     

431. 
     

432. # install_db 安装数据库

433. install_db(){

434. echo "[ok]====>begin install_db"

435. #    check_dir  $dir        #检查文件夹是否可以作为ORACLE_BASE目录

436. #    isnull $hah            #检查传入参数是否为空

437. isroot                 #判断执行用户是否root

438. check_yum              #检查yum源是否正常

439. check_installfile      #检查数据库安装软件是否已经上传

440. get_information        #获取输入数据库基本信息

441. check_cpu_mem_disk     #检查cpu，内存，磁盘空间

442. yum_install            #安装依赖包

443. sysctl_set             #修改/etc/sysctl.conf文件

444. limits_set             #修改/etc/security/limits.conf文件

445. login_set              #修改/etc/pam.d/login文件

446. profile_set            #修改/etc/profile文件

447. user_group_add         #创建oracle用户和oinstall,dba用户组

448. bash_profile_set       #修改/home/oracle/.bash_profile文件

449. create_dir             #创建ORACLE_BASE和ORACLE_HOME和数据文件目录并授权

450. unzip_file             #解压数据库安装包

451. hosts_set              #修改/etc/hosts文件

452. db_install_set         #修改db_install.rsp 数据库软件安装配置文件

453. install_software       #开始安装oracle软件

454. netca_set              #修改netca.rsp  监听安装配置文件

455. install_netca          #开始安装监听软件

456. dbca_set               #修改dbca.rsp 创建数据库配置文件

457. install_dbca           #开始创建数据库

458. echo "[ok]====>the install process success"

459. }

460. ##install_db

461. 
     

462. # deinstall_db 卸载数据库软件

463. deinstall_db(){

464. PWD="$( cd "$( dirname "$0"  )" && pwd  )"

465. touch /tmp/del_ora.sh >/dev/null 2>&1

466. echo "#!/bin/bash" >/tmp/del_ora.sh

467. echo "cd $PWD" >>/tmp/del_ora.sh

468. echo 'rm -rf database' >>/tmp/del_ora.sh

469. echo 'mv -f db_install.rsp.lihb_bak db_install.rsp >/dev/null 2>&1' >>/tmp/del_ora.sh

470. echo 'mv -f netca.rsp.lihb_bak netca.rsp >/dev/null 2>&1' >>/tmp/del_ora.sh

471. echo 'mv -f dbca.rsp.lihb_bak dbca.rsp >/dev/null 2>&1' >>/tmp/del_ora.sh

472. echo 'mv -f /etc/hosts.lihb_bak /etc/hosts >/dev/null 2>&1' >>/tmp/del_ora.sh

473. echo 'mv -f /etc/profile.lihb_bak /etc/profile >/dev/null 2>&1' >>/tmp/del_ora.sh

474. echo 'mv -f /etc/pam.d/login.lihb_bak /etc/pam.d/login >/dev/null 2>&1' >>/tmp/del_ora.sh

475. echo 'mv -f /etc/security/limits.conf.lihb_bak /etc/security/limits.conf >/dev/null 2>&1' >>/tmp/del_ora.sh

476. echo 'mv -f /etc/sysctl.conf.lihb_bak /etc/sysctl.conf >/dev/null 2>&1' >>/tmp/del_ora.sh

477. echo '/sbin/sysctl -p >/dev/null 2>&1' >>/tmp/del_ora.sh

478. echo 'rm -rf /opt/tmp/.oracle' >>/tmp/del_ora.sh

479. echo 'rm -rf /tmp/.oracle' >>/tmp/del_ora.sh

480. echo 'rm -rf /opt/ORCLfmap' >>/tmp/del_ora.sh

481. echo 'rm -rf /etc/oraInst.loc' >>/tmp/del_ora.sh

482. echo 'rm -rf /etc/oratab' >>/tmp/del_ora.sh

483. echo 'userdel -r oracle >/dev/null 2>&1' >>/tmp/del_ora.sh

484. ORACLE_BASE=`cat /home/oracle/.bash_profile|grep ORACLE_BASE|awk -F = '{print $2}'`

485. echo "rm -rf $ORACLE_BASE" >>/tmp/del_ora.sh

486. chmod u+x /tmp/del_ora.sh

487. echo 'please use oracle to run $ORACLE_HOME/deinstall/deinstall and use root to run /tmp/del_ora.sh'

488. }

489. ##deinstall_db

490. 
     

491. # configure_yum 配置yum源

492. configure_yum(){

493. echo -e "========>please input the iso location(eg:/tmp/xxx.iso):\c"

494. read ISOLOCATION

495. mkdir -p /media/lihb_iso

496. mount -t iso9660 -o loop $ISOLOCATION /media/lihb_iso

497. mkdir -p /etc/yum.repos.d/lihb_bak

498. mv /etc/yum.repos.d/*.repo /etc/yum.repos.d/lihb_bak

499. touch /etc/yum.repos.d/lihb_local.repo

500. echo "[lihb_local]" >/etc/yum.repos.d/lihb_local.repo

501. echo "name=lihb_local" >>/etc/yum.repos.d/lihb_local.repo

502. echo "baseurl=file:///media/lihb_iso" >>/etc/yum.repos.d/lihb_local.repo

503. echo "gpgcheck=0" >>/etc/yum.repos.d/lihb_local.repo

504. echo "enabled=1" >>/etc/yum.repos.d/lihb_local.repo

505. check_yum

506. }

507. ##configure_yum

508. 
     

509. # main 程序入口

510. main(){

511. echo "========>-------- seletion------------"

512. echo "========>1.install database"

513. echo "========>2.deinstall database"

514. echo "========>3.configure local yum"

515. echo "========>-----------------------------"

516. echo -e "========>Your choice:\c"

517. read FLAG

518. case $FLAG in

519. 1) install_db     #安装数据库

520. ;;

521. 2) deinstall_db   #卸载数据库

522. ;;

523. 3) configure_yum  #配置本地yum源

524. ;;

525. *) exit 200

526. ;;

527. esac

528. }

529. main

如下是db_install.rsp的内容：

点击(此处)折叠或打开

1. ####################################################################

2. ## Copyright(c) Oracle Corporation 1998,2013. 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. #   - INSTALL_DB_SWONLY

26. #   - INSTALL_DB_AND_CONFIG

27. #   - 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=lihb_hostname

38. 
    

39. #-------------------------------------------------------------------------------

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

41. #-------------------------------------------------------------------------------

42. UNIX_GROUP_NAME=oinstall

43. 
    

44. #-------------------------------------------------------------------------------

45. # Specify the location which holds the inventory files.

46. # This is an optional parameter if installing on

47. # windows based Operating System.

48. #-------------------------------------------------------------------------------

49. INVENTORY_LOCATION=lihb_location

50. 
    

51. #-------------------------------------------------------------------------------

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

53. #

54. # en   : English                  ja   : Japanese

55. # fr   : French                   ko   : Korean

56. # ar   : Arabic                   es   : Latin American Spanish

57. # bn   : Bengali                  lv   : Latvian

58. # pt_BR: Brazilian Portuguese     lt   : Lithuanian

59. # bg   : Bulgarian                ms   : Malay

60. # fr_CA: Canadian French          es_MX: Mexican Spanish

61. # ca   : Catalan                  no   : Norwegian

62. # hr   : Croatian                 pl   : Polish

63. # cs   : Czech                    pt   : Portuguese

64. # da   : Danish                   ro   : Romanian

65. # nl   : Dutch                    ru   : Russian

66. # ar_EG: Egyptian                 zh_CN: Simplified Chinese

67. # en_GB: English (Great Britain)  sk   : Slovak

68. # et   : Estonian                 sl   : Slovenian

69. # fi   : Finnish                  es_ES: Spanish

70. # de   : German                   sv   : Swedish

71. # el   : Greek                    th   : Thai

72. # iw   : Hebrew                   zh_TW: Traditional Chinese

73. # hu   : Hungarian                tr   : Turkish

74. # is   : Icelandic                uk   : Ukrainian

75. # in   : Indonesian               vi   : Vietnamese

76. # it   : Italian

77. #

78. # all_langs   : All languages

79. #

80. # Specify value as the following to select any of the languages.

81. # Example : SELECTED_LANGUAGES=en,fr,ja

82. #

83. # Specify value as the following to select all the languages.

84. # Example : SELECTED_LANGUAGES=all_langs

85. #------------------------------------------------------------------------------

86. SELECTED_LANGUAGES=en

87. 
    

88. #------------------------------------------------------------------------------

89. # Specify the complete path of the Oracle Home.

90. #------------------------------------------------------------------------------

91. ORACLE_HOME=lihb_home

92. 
    

93. #------------------------------------------------------------------------------

94. # Specify the complete path of the Oracle Base.

95. #------------------------------------------------------------------------------

96. ORACLE_BASE=lihb_base

97. 
    

98. #------------------------------------------------------------------------------

99. # Specify the installation edition of the component.

100. #

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

102. #   - EE     : Enterprise Edition

103. #   - SE     : Standard Edition

104. #   - SEONE  : Standard Edition One

105. #   - PE     : Personal Edition (WINDOWS ONLY)

106. #------------------------------------------------------------------------------

107. oracle.install.db.InstallEdition=EE

108. 
     

109. #------------------------------------------------------------------------------

110. # This variable is used to enable or disable custom install and is considered

111. # only if InstallEdition is EE.

112. #

113. # true  : Components mentioned as part of 'optionalComponents' property

114. #         are considered for install.

115. # false : Value for 'optionalComponents' is not considered.

116. #------------------------------------------------------------------------------

117. oracle.install.db.EEOptionsSelection=false

118. 
     

119. #------------------------------------------------------------------------------

120. # This variable is considered only if 'EEOptionsSelection' is set to true.

121. #

122. # Description: List of Enterprise Edition Options you would like to enable.

123. #

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

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

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

127. #              Below is a list of components you may specify to enable.

128. #

129. #              oracle.oraolap:11.2.0.4.0 - Oracle OLAP

130. #              oracle.rdbms.dm:11.2.0.4.0 - Oracle Data Mining

131. #              oracle.rdbms.dv:11.2.0.4.0 - Oracle Database Vault

132. #              oracle.rdbms.lbac:11.2.0.4.0 - Oracle Label Security

133. #              oracle.rdbms.partitioning:11.2.0.4.0 - Oracle Partitioning

134. #              oracle.rdbms.rat:11.2.0.4.0 - Oracle Real Application Testing

135. #------------------------------------------------------------------------------

136. oracle.install.db.optionalComponents=oracle.rdbms.partitioning:11.2.0.4.0,oracle.oraolap:11.2.0.4.0,oracle.rdbms.dm:11.2.0.4.0,oracle.rdbms.dv:11.2.0.4.0,oracle.rdbms.lbac:11.2.0.4.0,oracle.rdbms.rat:11.2.0.4.0

137. 
     

138. ###############################################################################

139. #                                                                             #

140. # PRIVILEGED OPERATING SYSTEM GROUPS                                        #

141. # ------------------------------------------                                  #

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

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

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

145. #                                                                             #

146. # The value to be specified for OSDBA and OSOPER group is only for UNIX based #

147. # Operating System.                                                           #

148. #                                                                             #

149. ###############################################################################

150. 
     

151. #------------------------------------------------------------------------------

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

153. #------------------------------------------------------------------------------

154. oracle.install.db.DBA_GROUP=dba

155. 
     

156. #------------------------------------------------------------------------------

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

158. # The value to be specified for OSOPER group is optional.

159. #------------------------------------------------------------------------------

160. oracle.install.db.OPER_GROUP=oinstall

161. 
     

162. #------------------------------------------------------------------------------

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

164. # Example : oracle.install.db.CLUSTER_NODES=node1,node2

165. #------------------------------------------------------------------------------

166. oracle.install.db.CLUSTER_NODES=

167. 
     

168. #------------------------------------------------------------------------------

169. # This variable is used to enable or disable RAC One Node install.

170. #

171. #   - true  : Value of RAC One Node service name is used.

172. #   - false : Value of RAC One Node service name is not used.

173. #

174. # If left blank, it will be assumed to be false

175. #------------------------------------------------------------------------------

176. oracle.install.db.isRACOneInstall=

177. 
     

178. #------------------------------------------------------------------------------

179. # Specify the name for RAC One Node Service.

180. #------------------------------------------------------------------------------

181. oracle.install.db.racOneServiceName=

182. 
     

183. #------------------------------------------------------------------------------

184. # Specify the type of database to create.

185. # It can be one of the following:

186. #   - GENERAL_PURPOSE/TRANSACTION_PROCESSING

187. #   - DATA_WAREHOUSE

188. #------------------------------------------------------------------------------

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

190. 
     

191. #------------------------------------------------------------------------------

192. # Specify the Starter Database Global Database Name.

193. #------------------------------------------------------------------------------

194. oracle.install.db.config.starterdb.globalDBName=lihb_globaldbname

195. 
     

196. #------------------------------------------------------------------------------

197. # Specify the Starter Database SID.

198. #------------------------------------------------------------------------------

199. oracle.install.db.config.starterdb.SID=lihb_sid

200. 
     

201. #------------------------------------------------------------------------------

202. # Specify the Starter Database character set.

203. #

204. # It can be one of the following:

205. # AL32UTF8, WE8ISO8859P15, WE8MSWIN1252, EE8ISO8859P2,

206. # EE8MSWIN1250, NE8ISO8859P10, NEE8ISO8859P4, BLT8MSWIN1257,

207. # BLT8ISO8859P13, CL8ISO8859P5, CL8MSWIN1251, AR8ISO8859P6,

208. # AR8MSWIN1256, EL8ISO8859P7, EL8MSWIN1253, IW8ISO8859P8,

209. # IW8MSWIN1255, JA16EUC, JA16EUCTILDE, JA16SJIS, JA16SJISTILDE,

210. # KO16MSWIN949, ZHS16GBK, TH8TISASCII, ZHT32EUC, ZHT16MSWIN950,

211. # ZHT16HKSCS, WE8ISO8859P9, TR8MSWIN1254, VN8MSWIN1258

212. #------------------------------------------------------------------------------

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

214. 
     

215. #------------------------------------------------------------------------------

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

217. # in Database is desired.

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

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

220. #------------------------------------------------------------------------------

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

222. 
     

223. #------------------------------------------------------------------------------

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

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

226. # on the system.

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

228. #------------------------------------------------------------------------------

229. oracle.install.db.config.starterdb.memoryLimit=

230. 
     

231. #------------------------------------------------------------------------------

232. # This variable controls whether to load Example Schemas onto

233. # the starter database or not.

234. #------------------------------------------------------------------------------

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

236. 
     

237. #------------------------------------------------------------------------------

238. # This variable includes enabling audit settings, configuring password profiles

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

240. # These settings may also be disabled.

241. #------------------------------------------------------------------------------

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

243. 
     

244. ###############################################################################

245. #                                                                             #

246. # Passwords can be supplied for the following four schemas in the      #

247. # starter database:            #

248. #   SYS                                                                       #

249. #   SYSTEM                                                                    #

250. #   SYSMAN (used by Enterprise Manager)                                       #

251. #   DBSNMP (used by Enterprise Manager)                                       #

252. #                                                                             #

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

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

255. #                                                                             #

256. ###############################################################################

257. 
     

258. #------------------------------------------------------------------------------

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

260. # starter database.

261. #-------------------------------------------------------------------------------

262. oracle.install.db.config.starterdb.password.ALL=mima_0001

263. 
     

264. #-------------------------------------------------------------------------------

265. # Specify the SYS password for the starter database.

266. #-------------------------------------------------------------------------------

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

268. 
     

269. #-------------------------------------------------------------------------------

270. # Specify the SYSTEM password for the starter database.

271. #-------------------------------------------------------------------------------

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

273. 
     

274. #-------------------------------------------------------------------------------

275. # Specify the SYSMAN password for the starter database.

276. #-------------------------------------------------------------------------------

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

278. 
     

279. #-------------------------------------------------------------------------------

280. # Specify the DBSNMP password for the starter database.

281. #-------------------------------------------------------------------------------

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

283. 
     

284. #-------------------------------------------------------------------------------

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

286. # It can be one of the following:

287. #   - GRID_CONTROL

288. #   - DB_CONTROL

289. #-------------------------------------------------------------------------------

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

291. 
     

292. #-------------------------------------------------------------------------------

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

294. # the database.

295. #-------------------------------------------------------------------------------

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

297. 
     

298. ###############################################################################

299. #                                                                             #

300. # SPECIFY BACKUP AND RECOVERY OPTIONS                                      #

301. # ------------------------------------                              #

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

303. # using the entries below.      #

304. #                                                                             #

305. ###############################################################################

306. 
     

307. #------------------------------------------------------------------------------

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

309. # this can be set to true.

310. #------------------------------------------------------------------------------

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

312. 
     

313. #------------------------------------------------------------------------------

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

315. # automated backups are enabled, a job will be scheduled to run daily to backup

316. # the database. This job will run as the operating system user that is

317. # specified in this variable.

318. #------------------------------------------------------------------------------

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

320. 
     

321. #-------------------------------------------------------------------------------

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

323. # automated backups are enabled, a job will be scheduled to run daily to backup

324. # the database. This job will run as the operating system user specified by the

325. # above entry. The following entry stores the password for the above operating

326. # system user.

327. #-------------------------------------------------------------------------------

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

329. 
     

330. #-------------------------------------------------------------------------------

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

332. # It can be one of the following:

333. #   - FILE_SYSTEM_STORAGE

334. #   - ASM_STORAGE

335. #------------------------------------------------------------------------------

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

337. 
     

338. #-------------------------------------------------------------------------------

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

340. # files, redo logs.

341. #

342. # Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE

343. #-------------------------------------------------------------------------------

344. oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=lihb_datalocation

345. 
     

346. #-------------------------------------------------------------------------------

347. # Specify the backup and recovery location.

348. #

349. # Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE

350. #-------------------------------------------------------------------------------

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

352. 
     

353. #-------------------------------------------------------------------------------

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

355. #

356. # Applicable only when oracle.install.db.config.starterdb.storage=ASM_STORAGE

357. #-------------------------------------------------------------------------------

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

359. 
     

360. #-------------------------------------------------------------------------------

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

362. #

363. # Applicable only when oracle.install.db.config.starterdb.storage=ASM_STORAGE

364. #-------------------------------------------------------------------------------

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

366. 
     

367. #------------------------------------------------------------------------------

368. # Specify the My Oracle Support Account Username.

369. #

370. #  Example   : MYORACLESUPPORT_USERNAME=abc@oracle.com

371. #------------------------------------------------------------------------------

372. MYORACLESUPPORT_USERNAME=

373. 
     

374. #------------------------------------------------------------------------------

375. # Specify the My Oracle Support Account Username password.

376. #

377. # Example    : MYORACLESUPPORT_PASSWORD=password

378. #------------------------------------------------------------------------------

379. MYORACLESUPPORT_PASSWORD=

380. 
     

381. #------------------------------------------------------------------------------

382. # Specify whether to enable the user to set the password for

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

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

385. #

386. # Example    : SECURITY_UPDATES_VIA_MYORACLESUPPORT=true

387. #------------------------------------------------------------------------------

388. SECURITY_UPDATES_VIA_MYORACLESUPPORT=

389. 
     

390. #------------------------------------------------------------------------------

391. # Specify whether user doesn't want to configure Security Updates.

392. # The value for this variable should be true if you don't want to configure

393. # Security Updates, false otherwise.

394. #

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

396. # to be false.

397. #

398. # Example    : DECLINE_SECURITY_UPDATES=false

399. #------------------------------------------------------------------------------

400. DECLINE_SECURITY_UPDATES=true

401. 
     

402. #------------------------------------------------------------------------------

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

404. #

405. # Example    : PROXY_HOST=proxy.domain.com

406. #------------------------------------------------------------------------------

407. PROXY_HOST=

408. 
     

409. #------------------------------------------------------------------------------

410. # Specify the proxy port number. Should be Numeric and at least 2 chars.

411. #

412. # Example    : PROXY_PORT=25

413. #------------------------------------------------------------------------------

414. PROXY_PORT=

415. 
     

416. #------------------------------------------------------------------------------

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

418. # blank if your proxy server requires no authentication.

419. #

420. # Example    : PROXY_USER=username

421. #------------------------------------------------------------------------------

422. PROXY_USER=

423. 
     

424. #------------------------------------------------------------------------------

425. # Specify the proxy password. Leave PROXY_USER and PROXY_PWD

426. # blank if your proxy server requires no authentication.

427. #

428. # Example    : PROXY_PWD=password

429. #------------------------------------------------------------------------------

430. PROXY_PWD=

431. 
     

432. #------------------------------------------------------------------------------

433. # Specify the proxy realm. This value is used if auto-updates option is selected.

434. #

435. # Example    : PROXY_REALM=metalink

436. #------------------------------------------------------------------------------

437. PROXY_REALM=

438. 
     

439. #------------------------------------------------------------------------------

440. # Specify the Oracle Support Hub URL.

441. #

442. # Example    : COLLECTOR_SUPPORTHUB_URL=https://orasupporthub.company.com:8080/

443. #------------------------------------------------------------------------------

444. COLLECTOR_SUPPORTHUB_URL=

445. 
     

446. #------------------------------------------------------------------------------

447. # Specify the auto-updates option. It can be one of the following:

448. #   - MYORACLESUPPORT_DOWNLOAD

449. #   - OFFLINE_UPDATES

450. #   - SKIP_UPDATES

451. #------------------------------------------------------------------------------

452. oracle.installer.autoupdates.option=

453. #------------------------------------------------------------------------------

454. # In case MYORACLESUPPORT_DOWNLOAD option is chosen, specify the location where

455. # the updates are to be downloaded.

456. # In case OFFLINE_UPDATES option is chosen, specify the location where the updates

457. # are present.

458. #------------------------------------------------------------------------------

459. oracle.installer.autoupdates.downloadUpdatesLoc=

460. #------------------------------------------------------------------------------

461. # Specify the My Oracle Support Account Username which has the patches download privileges

462. # to be used for software updates.

463. #  Example   : AUTOUPDATES_MYORACLESUPPORT_USERNAME=abc@oracle.com

464. #------------------------------------------------------------------------------

465. AUTOUPDATES_MYORACLESUPPORT_USERNAME=

466. 
     

467. #------------------------------------------------------------------------------

468. # Specify the My Oracle Support Account Username password which has the patches download privileges

469. # to be used for software updates.

470. #

471. # Example    : AUTOUPDATES_MYORACLESUPPORT_PASSWORD=password

472. #------------------------------------------------------------------------------

473. AUTOUPDATES_MYORACLESUPPORT_PASSWORD=

如下是dbca.rsp的内容：

点击(此处)折叠或打开

1. ##############################################################################

2. ##                                                                          ##

3. ##                            DBCA response file                            ##

4. ##                            ------------------                            ##

5. ## Copyright   1998, 2013, 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     :  ""                                         ##

16. ##          Boolean    :  True or False                                     ##

17. ##          Number     :                                     ##

18. ##          StringList :  {"",""}                           ##

19. ##                                                                          ##

20. ## Examples :                                                               ##

21. ##     1. dbca -progress_only -responseFile                  ##

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

23. ##        process.                                                          ##

24. ##                                                                          ##

25. ##     2. dbca -silent -responseFile                         ##

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

27. ##                                                                          ##

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

29. ## -responseFile                       ##

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

31. ##  responsefile is a clone template.            ##

32. ##                                                                          ##

33. ##     4. dbca -silent -deleteDatabase -responseFile         ##

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  : . - when database domain isn't NULL

74. #                              - when database domain is NULL

75. # Default value : None

76. # Mandatory     : Yes

77. #-----------------------------------------------------------------------------

78. GDBNAME = "lihb_gdbname"

79. 
    

80. #-----------------------------------------------------------------------------

81. # Name          : RACONENODE

82. # Datatype      : Boolean

83. # Description   : Set to true for RAC One Node database

84. # Valid values  : TRUE\FALSE

85. # Default value : FALSE

86. # Mandatory     : No

87. #-----------------------------------------------------------------------------

88. #RACONENODE  = "false"

89. 
    

90. #-----------------------------------------------------------------------------

91. # Name          : RACONENODESERVICENAME

92. # Datatype      : String

93. # Description   : Service is required by application to connect to RAC One

94. #  Node Database

95. # Valid values  : Service Name

96. # Default value : None

97. # Mandatory     : No [required in case RACONENODE flag is set to true]

98. #-----------------------------------------------------------------------------

99. #RACONENODESERVICENAME =

100. 
     

101. #-----------------------------------------------------------------------------

102. # Name          : POLICYMANAGED

103. # Datatype      : Boolean

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

105. #  set to false if  Database is admin managed

106. # Valid values  : TRUE\FALSE

107. # Default value : FALSE

108. # Mandatory     : No

109. #-----------------------------------------------------------------------------

110. #POLICYMANAGED = "false"

111. 
     

112. #-----------------------------------------------------------------------------

113. # Name          : CREATESERVERPOOL

114. # Datatype      : Boolean

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

116. #  if this option is specified then the newly created database

117. #  will use this newly created serverpool.

118. #  Multiple serverpoolname can not be specified for database

119. # Valid values  : TRUE\FALSE

120. # Default value : FALSE

121. # Mandatory     : No

122. #-----------------------------------------------------------------------------

123. #CREATESERVERPOOL = "false"

124. 
     

125. #-----------------------------------------------------------------------------

126. # Name          : FORCE

127. # Datatype      : Boolean

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

129. #  if this option is specified then the newly created serverpool

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

131. #  This may affect already running database.

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

133. # Valid values  : TRUE\FALSE

134. # Default value : FALSE

135. # Mandatory     : No

136. #-----------------------------------------------------------------------------

137. #FORCE = "false"

138. 
     

139. #-----------------------------------------------------------------------------

140. # Name          : SERVERPOOLNAME

141. # Datatype      : String

142. # Description   : Only one serverpool name need to be specified

143. #   if Create Server Pool option is specified.

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

145. #   multiple Server pool

146. # Valid values  : ServerPool name

147. # Default value : None

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

149. #-----------------------------------------------------------------------------

150. #SERVERPOOLNAME =

151. 
     

152. #-----------------------------------------------------------------------------

153. # Name          : CARDINALITY

154. # Datatype      : Number

155. # Description   : Specify Cardinality for create server pool operation

156. # Valid values  : any positive Integer value

157. # Default value : Number of qualified nodes on cluster

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

159. #-----------------------------------------------------------------------------

160. #CARDINALITY =

161. 
     

162. #-----------------------------------------------------------------------------

163. # Name          : SID

164. # Datatype      : String

165. # Description   : System identifier (SID) of the database

166. # Valid values  : Check Oracle11g Administrator's Guide

167. # Default value :  specified in GDBNAME

168. # Mandatory     : No

169. #-----------------------------------------------------------------------------

170. SID = "lihb_sid"

171. 
     

172. #-----------------------------------------------------------------------------

173. # Name          : NODELIST

174. # Datatype      : String

175. # Description   : Comma-separated list of cluster nodes

176. # Valid values  : Cluster node names

177. # Default value : None

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

179. #-----------------------------------------------------------------------------

180. #NODELIST=

181. 
     

182. #-----------------------------------------------------------------------------

183. # Name          : TEMPLATENAME

184. # Datatype      : String

185. # Description   : Name of the template

186. # Valid values  : Template file name

187. # Default value : None

188. # Mandatory     : Yes

189. #-----------------------------------------------------------------------------

190. TEMPLATENAME = "General_Purpose.dbc"

191. 
     

192. #-----------------------------------------------------------------------------

193. # Name          : OBFUSCATEDPASSWORDS

194. # Datatype      : Boolean

195. # Description   : Set to true if passwords are encrypted

196. # Valid values  : TRUE\FALSE

197. # Default value : FALSE

198. # Mandatory     : No

199. #-----------------------------------------------------------------------------

200. #OBFUSCATEDPASSWORDS = FALSE

201. 
     

202. 
     

203. #-----------------------------------------------------------------------------

204. # Name          : SYSPASSWORD

205. # Datatype      : String

206. # Description   : Password for SYS user

207. # Valid values  : Check Oracle11g Administrator's Guide

208. # Default value : None

209. # Mandatory     : Yes

210. #-----------------------------------------------------------------------------

211. SYSPASSWORD = "mima_0001"

212. 
     

213. #-----------------------------------------------------------------------------

214. # Name          : SYSTEMPASSWORD

215. # Datatype      : String

216. # Description   : Password for SYSTEM user

217. # Valid values  : Check Oracle11g Administrator's Guide

218. # Default value : None

219. # Mandatory     : Yes

220. #-----------------------------------------------------------------------------

221. SYSTEMPASSWORD = "mima_0001"

222. 
     

223. #-----------------------------------------------------------------------------

224. # Name          : EMCONFIGURATION

225. # Datatype      : String

226. # Description   : Enterprise Manager Configuration Type

227. # Valid values  : CENTRAL|LOCAL|ALL|NONE

228. # Default value : NONE

229. # Mandatory     : No

230. #-----------------------------------------------------------------------------

231. #EMCONFIGURATION = "NONE"

232. 
     

233. #-----------------------------------------------------------------------------

234. # Name          : DISABLESECURITYCONFIGURATION

235. # Datatype      : String

236. # Description   : Database Security Settings

237. # Valid values  : ALL|NONE|AUDIT|PASSWORD_PROFILE

238. # Default value : NONE

239. # Mandatory     : No

240. #-----------------------------------------------------------------------------

241. #DISABLESECURITYCONFIGURATION = "NONE"

242. 
     

243. 
     

244. #-----------------------------------------------------------------------------

245. # Name          : SYSMANPASSWORD

246. # Datatype      : String

247. # Description   : Password for SYSMAN user

248. # Valid values  : Check Oracle11g Administrator's Guide

249. # Default value : None

250. # Mandatory     : Yes, if LOCAL specified for EMCONFIGURATION

251. #-----------------------------------------------------------------------------

252. #SYSMANPASSWORD = "password"

253. 
     

254. #-----------------------------------------------------------------------------

255. # Name          : DBSNMPPASSWORD

256. # Datatype      : String

257. # Description   : Password for DBSNMP user

258. # Valid values  : Check Oracle11g Administrator's Guide

259. # Default value : None

260. # Mandatory     : Yes, if EMCONFIGURATION is specified

261. #-----------------------------------------------------------------------------

262. #DBSNMPPASSWORD = "password"

263. 
     

264. #-----------------------------------------------------------------------------

265. # Name          : CENTRALAGENT

266. # Datatype      : String

267. # Description   : Grid Control Central Agent Oracle Home

268. # Default value : None

269. # Mandatory     : Yes, if CENTRAL is specified for EMCONFIGURATION

270. #-----------------------------------------------------------------------------

271. #CENTRALAGENT =

272. 
     

273. #-----------------------------------------------------------------------------

274. # Name          : HOSTUSERNAME

275. # Datatype      : String

276. # Description   : Host user name for EM backup job

277. # Default value : None

278. # Mandatory     : Yes, if ALL is specified for EMCONFIGURATION

279. #-----------------------------------------------------------------------------

280. #HOSTUSERNAME =

281. 
     

282. #-----------------------------------------------------------------------------

283. # Name          : HOSTUSERPASSWORD

284. # Datatype      : String

285. # Description   : Host user password for EM backup job

286. # Default value : None

287. # Mandatory     : Yes, if ALL is specified for EMCONFIGURATION

288. #-----------------------------------------------------------------------------

289. #HOSTUSERPASSWORD=

290. 
     

291. #-----------------------------------------------------------------------------

292. # Name          : BACKUPSCHEDULE

293. # Datatype      : String

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

295. # Default value : 2:00

296. # Mandatory     : Yes, if ALL is specified for EMCONFIGURATION

297. #-----------------------------------------------------------------------------

298. #BACKUPSCHEDULE=

299. 
     

300. #-----------------------------------------------------------------------------

301. # Name          : DVOWNERNAME

302. # Datatype      : String

303. # Description   : DataVault Owner

304. # Valid values  : Check Oracle11g Administrator's Guide

305. # Default value : None

306. # Mandatory     : Yes, if DataVault option is chosen

307. #-----------------------------------------------------------------------------

308. #DVOWNERNAME = ""

309. 
     

310. #-----------------------------------------------------------------------------

311. # Name          : DVOWNERPASSWORD

312. # Datatype      : String

313. # Description   : Password for DataVault Owner

314. # Valid values  : Check Oracle11g Administrator's Guide

315. # Default value : None

316. # Mandatory     : Yes, if DataVault option is chosen

317. #-----------------------------------------------------------------------------

318. #DVOWNERPASSWORD = ""

319. 
     

320. #-----------------------------------------------------------------------------

321. # Name          : DVACCOUNTMANAGERNAME

322. # Datatype      : String

323. # Description   : DataVault Account Manager

324. # Valid values  : Check Oracle11g Administrator's Guide

325. # Default value : None

326. # Mandatory     : No

327. #-----------------------------------------------------------------------------

328. #DVACCOUNTMANAGERNAME = ""

329. 
     

330. #-----------------------------------------------------------------------------

331. # Name          : DVACCOUNTMANAGERPASSWORD

332. # Datatype      : String

333. # Description   : Password for  DataVault Account Manager

334. # Valid values  : Check Oracle11g Administrator's Guide

335. # Default value : None

336. # Mandatory     : No

337. #-----------------------------------------------------------------------------

338. #DVACCOUNTMANAGERPASSWORD = ""

339. 
     

340. 
     

341. 
     

342. #-----------------------------------------------------------------------------

343. # Name          : DATAFILEjarLOCATION

344. # Datatype      : String

345. # Description   : Location of the data file jar

346. # Valid values  : Directory containing compressed datafile jar

347. # Default value : None

348. # Mandatory     : No

349. #-----------------------------------------------------------------------------

350. #DATAFILEJARLOCATION =

351. 
     

352. #-----------------------------------------------------------------------------

353. # Name          : DATAFILEDESTINATION

354. # Datatype      : String

355. # Description   : Location of the data file's

356. # Valid values  : Directory for all the database files

357. # Default value : $ORACLE_BASE/oradata

358. # Mandatory     : No

359. #-----------------------------------------------------------------------------

360. DATAFILEDESTINATION = lihb_datafiledestination

361. 
     

362. #-----------------------------------------------------------------------------

363. # Name          : RECOVERYAREADESTINATION

364. # Datatype      : String

365. # Description   : Location of the data file's

366. # Valid values  : Recovery Area location

367. # Default value : $ORACLE_BASE/flash_recovery_area

368. # Mandatory     : No

369. #-----------------------------------------------------------------------------

370. RECOVERYAREADESTINATION= lihb_recoveryareadestination

371. 
     

372. #-----------------------------------------------------------------------------

373. # Name          : STORAGETYPE

374. # Datatype      : String

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

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

377. # Default value : FS

378. # Mandatory     : No

379. #-----------------------------------------------------------------------------

380. STORAGETYPE=FS

381. 
     

382. #-----------------------------------------------------------------------------

383. # Name          : DISKGROUPNAME

384. # Datatype      : String

385. # Description   : Specifies the disk group name for the storage

386. # Default value : DATA

387. # Mandatory     : No

388. #-----------------------------------------------------------------------------

389. #DISKGROUPNAME=DATA

390. 
     

391. #-----------------------------------------------------------------------------

392. # Name          : ASMSNMP_PASSWORD

393. # Datatype      : String

394. # Description   : Password for ASM Monitoring

395. # Default value : None

396. # Mandatory     : No

397. #-----------------------------------------------------------------------------

398. #ASMSNMP_PASSWORD=""

399. 
     

400. #-----------------------------------------------------------------------------

401. # Name          : RECOVERYGROUPNAME

402. # Datatype      : String

403. # Description   : Specifies the disk group name for the recovery area

404. # Default value : RECOVERY

405. # Mandatory     : No

406. #-----------------------------------------------------------------------------

407. #RECOVERYGROUPNAME=RECOVERY

408. 
     

409. 
     

410. #-----------------------------------------------------------------------------

411. # Name          : CHARACTERSET

412. # Datatype      : String

413. # Description   : Character set of the database

414. # Valid values  : Check Oracle11g National Language Support Guide

415. # Default value : "US7ASCII"

416. # Mandatory     : NO

417. #-----------------------------------------------------------------------------

418. CHARACTERSET = "lihb_characterset"

419. 
     

420. #-----------------------------------------------------------------------------

421. # Name          : NATIONALCHARACTERSET

422. # Datatype      : String

423. # Description   : National Character set of the database

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

425. # Default value : "AL16UTF16"

426. # Mandatory     : No

427. #-----------------------------------------------------------------------------

428. NATIONALCHARACTERSET= "AL16UTF16"

429. 
     

430. #-----------------------------------------------------------------------------

431. # Name          : REGISTERWITHDIRSERVICE

432. # Datatype      : Boolean

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

434. # Valid values  : TRUE \ FALSE

435. # Default value : FALSE

436. # Mandatory     : No

437. #-----------------------------------------------------------------------------

438. #REGISTERWITHDIRSERVICE= TRUE

439. 
     

440. #-----------------------------------------------------------------------------

441. # Name          : DIRSERVICEUSERNAME

442. # Datatype      : String

443. # Description   : Specifies the name of the directory service user

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

445. #-----------------------------------------------------------------------------

446. #DIRSERVICEUSERNAME= "name"

447. 
     

448. #-----------------------------------------------------------------------------

449. # Name          : DIRSERVICEPASSWORD

450. # Datatype      : String

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

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

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

454. #-----------------------------------------------------------------------------

455. #DIRSERVICEPASSWORD= "password"

456. 
     

457. #-----------------------------------------------------------------------------

458. # Name          : WALLETPASSWORD

459. # Datatype      : String

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

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

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

463. #-----------------------------------------------------------------------------

464. #WALLETPASSWORD= "password"

465. 
     

466. #-----------------------------------------------------------------------------

467. # Name          : LISTENERS

468. # Datatype      : String

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

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

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

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

473. # Mandatory     : NO

474. #-----------------------------------------------------------------------------

475. LISTENERS = "LISTENER"

476. 
     

477. #-----------------------------------------------------------------------------

478. # Name          : VARIABLESFILE

479. # Datatype      : String

480. # Description   : Location of the file containing variable value pair

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

482. #  is =. Each pair should be in a new line.

483. # Default value : None

484. # Mandatory     : NO

485. #-----------------------------------------------------------------------------

486. #VARIABLESFILE =

487. 
     

488. #-----------------------------------------------------------------------------

489. # Name          : VARIABLES

490. # Datatype      : String

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

492. # Default value : None

493. # Mandatory     : NO

494. #-----------------------------------------------------------------------------

495. #VARIABLES =

496. 
     

497. #-----------------------------------------------------------------------------

498. # Name          : INITPARAMS

499. # Datatype      : String

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

501. # Default value : None

502. # Mandatory     : NO

503. #-----------------------------------------------------------------------------

504. #INITPARAMS =

505. 
     

506. #-----------------------------------------------------------------------------

507. # Name          : SAMPLESCHEMA

508. # Datatype      : Boolean

509. # Description   : Specifies whether or not to add the Sample Schemas to your database

510. # Valid values  : TRUE \ FALSE

511. # Default value : FASLE

512. # Mandatory     : No

513. #-----------------------------------------------------------------------------

514. #SAMPLESCHEMA=TRUE

515. 
     

516. #-----------------------------------------------------------------------------

517. # Name          : MEMORYPERCENTAGE

518. # Datatype      : String

519. # Description   : percentage of physical memory for Oracle

520. # Default value : None

521. # Mandatory     : NO

522. #-----------------------------------------------------------------------------

523. #MEMORYPERCENTAGE = "40"

524. 
     

525. #-----------------------------------------------------------------------------

526. # Name          : DATABASETYPE

527. # Datatype      : String

528. # Description   : used for memory distribution when MEMORYPERCENTAGE specified

529. # Valid values  : MULTIPURPOSE|DATA_WAREHOUSING|OLTP

530. # Default value : MULTIPURPOSE

531. # Mandatory     : NO

532. #-----------------------------------------------------------------------------

533. #DATABASETYPE = "MULTIPURPOSE"

534. 
     

535. #-----------------------------------------------------------------------------

536. # Name          : AUTOMATICMEMORYMANAGEMENT

537. # Datatype      : Boolean

538. # Description   : flag to indicate Automatic Memory Management is used

539. # Valid values  : TRUE/FALSE

540. # Default value : TRUE

541. # Mandatory     : NO

542. #-----------------------------------------------------------------------------

543. #AUTOMATICMEMORYMANAGEMENT = "TRUE"

544. 
     

545. #-----------------------------------------------------------------------------

546. # Name          : TOTALMEMORY

547. # Datatype      : String

548. # Description   : total memory in MB to allocate to Oracle

549. # Valid values  :

550. # Default value :

551. # Mandatory     : NO

552. #-----------------------------------------------------------------------------

553. TOTALMEMORY = "lihb_totalmemory"

554. 
     

555. 
     

556. #-----------------------*** End of CREATEDATABASE section ***------------------------

557. 
     

558. #-----------------------------------------------------------------------------

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

560. #-----------------------------------------------------------------------------

561. [createTemplateFromDB]

562. #-----------------------------------------------------------------------------

563. # Name          : SOURCEDB

564. # Datatype      : String

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

566. # Valid values  : The format is ::

567. # Default value : none

568. # Mandatory     : YES

569. #-----------------------------------------------------------------------------

570. SOURCEDB = "myhost:1521:orcl"

571. 
     

572. #-----------------------------------------------------------------------------

573. # Name          : SYSDBAUSERNAME

574. # Datatype      : String

575. # Description   : A user with DBA role.

576. # Default value : none

577. # Mandatory     : YES

578. #-----------------------------------------------------------------------------

579. SYSDBAUSERNAME = "system"

580. 
     

581. #-----------------------------------------------------------------------------

582. # Name          : SYSDBAPASSWORD

583. # Datatype      : String

584. # Description   : The password of the DBA user.

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

586. # Default value : none

587. # Mandatory     : YES

588. #-----------------------------------------------------------------------------

589. #SYSDBAPASSWORD = "password"

590. 
     

591. #-----------------------------------------------------------------------------

592. # Name          : TEMPLATENAME

593. # Datatype      : String

594. # Description   : Name for the new template.

595. # Default value : None

596. # Mandatory     : Yes

597. #-----------------------------------------------------------------------------

598. TEMPLATENAME = "My Copy TEMPLATE"

599. 
     

600. #-----------------------*** End of createTemplateFromDB section ***------------------------

601. 
     

602. #-----------------------------------------------------------------------------

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

604. #-----------------------------------------------------------------------------

605. [createCloneTemplate]

606. #-----------------------------------------------------------------------------

607. # Name          : SOURCEDB

608. # Datatype      : String

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

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

611. # Default value : none

612. # Mandatory     : YES

613. #-----------------------------------------------------------------------------

614. SOURCEDB = "orcl"

615. 
     

616. #-----------------------------------------------------------------------------

617. # Name          : SYSDBAUSERNAME

618. # Datatype      : String

619. # Description   : A user with DBA role.

620. # Default value : none

621. # Mandatory     : YES, if no OS authentication

622. #-----------------------------------------------------------------------------

623. #SYSDBAUSERNAME = "sys"

624. 
     

625. #-----------------------------------------------------------------------------

626. # Name          : SYSDBAPASSWORD

627. # Datatype      : String

628. # Description   : The password of the DBA user.

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

630. # Default value : none

631. # Mandatory     : YES

632. #-----------------------------------------------------------------------------

633. #SYSDBAPASSWORD = "password"

634. 
     

635. #-----------------------------------------------------------------------------

636. # Name          : TEMPLATENAME

637. # Datatype      : String

638. # Description   : Name for the new template.

639. # Default value : None

640. # Mandatory     : Yes

641. #-----------------------------------------------------------------------------

642. TEMPLATENAME = "My Clone TEMPLATE"

643. 
     

644. #-----------------------------------------------------------------------------

645. # Name          : DATAFILEJARLOCATION

646. # Datatype      : String

647. # Description   : Location of the data file jar

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

649. # Default value : $ORACLE_HOME/assistants/dbca/templates

650. # Mandatory     : NO

651. #-----------------------------------------------------------------------------

652. #DATAFILEJARLOCATION =

653. 
     

654. #-----------------------*** End of createCloneTemplate section ***------------------------

655. 
     

656. #-----------------------------------------------------------------------------

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

658. #-----------------------------------------------------------------------------

659. [DELETEDATABASE]

660. #-----------------------------------------------------------------------------

661. # Name          : SOURCEDB

662. # Datatype      : String

663. # Description   : The source database is the SID

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

665. # Default value : none

666. # Mandatory     : YES

667. #-----------------------------------------------------------------------------

668. SOURCEDB = "orcl"

669. 
     

670. #-----------------------------------------------------------------------------

671. # Name          : SYSDBAUSERNAME

672. # Datatype      : String

673. # Description   : A user with DBA role.

674. # Default value : none

675. # Mandatory     : YES, if no OS authentication

676. #-----------------------------------------------------------------------------

677. #SYSDBAUSERNAME = "sys"

678. 
     

679. #-----------------------------------------------------------------------------

680. # Name          : SYSDBAPASSWORD

681. # Datatype      : String

682. # Description   : The password of the DBA user.

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

684. # Default value : none

685. # Mandatory     : YES, if no OS authentication

686. #-----------------------------------------------------------------------------

687. #SYSDBAPASSWORD = "password"

688. #-----------------------*** End of deleteDatabase section ***------------------------

689. 
     

690. #-----------------------------------------------------------------------------

691. # GENERATESCRIPTS section

692. #-----------------------------------------------------------------------------

693. [generateScripts]

694. #-----------------------------------------------------------------------------

695. # Name          : TEMPLATENAME

696. # Datatype      : String

697. # Description   : Name of the template

698. # Valid values  : Template name as seen in DBCA

699. # Default value : None

700. # Mandatory     : Yes

701. #-----------------------------------------------------------------------------

702. TEMPLATENAME = "New Database"

703. 
     

704. #-----------------------------------------------------------------------------

705. # Name          : GDBNAME

706. # Datatype      : String

707. # Description   : Global database name of the database

708. # Valid values  : . - when database domain isn't NULL

709. #                              - when database domain is NULL

710. # Default value : None

711. # Mandatory     : Yes

712. #-----------------------------------------------------------------------------

713. GDBNAME = "lihb_gdbname"

714. 
     

715. #-----------------------------------------------------------------------------

716. # Name          : SCRIPTDESTINATION

717. # Datatype      : String

718. # Description   : Location of the scripts

719. # Valid values  : Directory for all the scripts

720. # Default value : None

721. # Mandatory     : No

722. #-----------------------------------------------------------------------------

723. #SCRIPTDESTINATION =

724. 
     

725. #-----------------------*** End of deleteDatabase section ***------------------------

726. 
     

727. #-----------------------------------------------------------------------------

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

729. #-----------------------------------------------------------------------------

730. [CONFIGUREDATABASE]

731. 
     

732. #-----------------------------------------------------------------------------

733. # Name          : SOURCEDB

734. # Datatype      : String

735. # Description   : The source database is the SID

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

737. # Default value : none

738. # Mandatory     : YES

739. #-----------------------------------------------------------------------------

740. #SOURCEDB = "orcl"

741. 
     

742. #-----------------------------------------------------------------------------

743. # Name          : SYSDBAUSERNAME

744. # Datatype      : String

745. # Description   : A user with DBA role.

746. # Default value : none

747. # Mandatory     : YES, if no OS authentication

748. #-----------------------------------------------------------------------------

749. #SYSDBAUSERNAME = "sys"

750. 
     

751. 
     

752. #-----------------------------------------------------------------------------

753. # Name          : SYSDBAPASSWORD

754. # Datatype      : String

755. # Description   : The password of the DBA user.

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

757. # Default value : none

758. # Mandatory     : YES, if no OS authentication

759. #-----------------------------------------------------------------------------

760. #SYSDBAPASSWORD =

761. 
     

762. #-----------------------------------------------------------------------------

763. # Name          : REGISTERWITHDIRSERVICE

764. # Datatype      : Boolean

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

766. # Valid values  : TRUE \ FALSE

767. # Default value : FALSE

768. # Mandatory     : No

769. #-----------------------------------------------------------------------------

770. #REGISTERWITHDIRSERVICE= TRUE

771. 
     

772. #-----------------------------------------------------------------------------

773. # Name          : UNREGISTERWITHDIRSERVICE

774. # Datatype      : Boolean

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

776. # Valid values  : TRUE \ FALSE

777. # Default value : FALSE

778. # Mandatory     : No

779. #-----------------------------------------------------------------------------

780. #UNREGISTERWITHDIRSERVICE= TRUE

781. 
     

782. #-----------------------------------------------------------------------------

783. # Name          : REGENERATEDBPASSWORD

784. # Datatype      : Boolean

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

786. # Valid values  : TRUE \ FALSE

787. # Default value : FALSE

788. # Mandatory     : No

789. #-----------------------------------------------------------------------------

790. #REGENERATEDBPASSWORD= TRUE

791. 
     

792. #-----------------------------------------------------------------------------

793. # Name          : DIRSERVICEUSERNAME

794. # Datatype      : String

795. # Description   : Specifies the name of the directory service user

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

797. #-----------------------------------------------------------------------------

798. #DIRSERVICEUSERNAME= "name"

799. 
     

800. #-----------------------------------------------------------------------------

801. # Name          : DIRSERVICEPASSWORD

802. # Datatype      : String

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

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

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

806. #-----------------------------------------------------------------------------

807. #DIRSERVICEPASSWORD= "password"

808. 
     

809. #-----------------------------------------------------------------------------

810. # Name          : WALLETPASSWORD

811. # Datatype      : String

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

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

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

815. #-----------------------------------------------------------------------------

816. #WALLETPASSWORD= "password"

817. 
     

818. #-----------------------------------------------------------------------------

819. # Name          : DISABLESECURITYCONFIGURATION

820. # Datatype      : String

821. # Description   : Database Security Settings

822. # Valid values  : ALL|NONE|AUDIT|PASSWORD_PROFILE

823. # Default value : NONE

824. # Mandatory     : No

825. #-----------------------------------------------------------------------------

826. #DISABLESECURITYCONFIGURATION = "NONE"

827. 
     

828. 
     

829. 
     

830. #-----------------------------------------------------------------------------

831. # Name          : ENABLESECURITYCONFIGURATION

832. # Datatype      : String

833. # Description   : Database Security Settings

834. # Valid values  : true|false

835. # Default value : true

836. # Mandatory     : No

837. #-----------------------------------------------------------------------------

838. #ENABLESECURITYCONFIGURATION = "true"

839. 
     

840. 
     

841. #-----------------------------------------------------------------------------

842. # Name          : EMCONFIGURATION

843. # Datatype      : String

844. # Description   : Enterprise Manager Configuration Type

845. # Valid values  : CENTRAL|LOCAL|ALL|NONE

846. # Default value : NONE

847. # Mandatory     : No

848. #-----------------------------------------------------------------------------

849. #EMCONFIGURATION = "NONE"

850. 
     

851. #-----------------------------------------------------------------------------

852. # Name          : SYSMANPASSWORD

853. # Datatype      : String

854. # Description   : Password for SYSMAN user

855. # Valid values  : Check Oracle11g Administrator's Guide

856. # Default value : None

857. # Mandatory     : Yes, if LOCAL specified for EMCONFIGURATION

858. #-----------------------------------------------------------------------------

859. #SYSMANPASSWORD = "password"

860. 
     

861. #-----------------------------------------------------------------------------

862. # Name          : DBSNMPPASSWORD

863. # Datatype      : String

864. # Description   : Password for DBSNMP user

865. # Valid values  : Check Oracle11g Administrator's Guide

866. # Default value : None

867. # Mandatory     : Yes, if EMCONFIGURATION is specified

868. #-----------------------------------------------------------------------------

869. #DBSNMPPASSWORD = "password"

870. 
     

871. #-----------------------------------------------------------------------------

872. # Name          : CENTRALAGENT

873. # Datatype      : String

874. # Description   : Grid Control Central Agent Oracle Home

875. # Default value : None

876. # Mandatory     : Yes, if CENTRAL is specified for EMCONFIGURATION

877. #-----------------------------------------------------------------------------

878. #CENTRALAGENT =

879. 
     

880. #-----------------------------------------------------------------------------

881. # Name          : HOSTUSERNAME

882. # Datatype      : String

883. # Description   : Host user name for EM backup job

884. # Default value : None

885. # Mandatory     : Yes, if ALL is specified for EMCONFIGURATION

886. #-----------------------------------------------------------------------------

887. #HOSTUSERNAME =

888. 
     

889. #-----------------------------------------------------------------------------

890. # Name          : HOSTUSERPASSWORD

891. # Datatype      : String

892. # Description   : Host user password for EM backup job

893. # Default value : None

894. # Mandatory     : Yes, if ALL is specified for EMCONFIGURATION

895. #-----------------------------------------------------------------------------

896. #HOSTUSERPASSWORD=

897. 
     

898. #-----------------------------------------------------------------------------

899. # Name          : BACKUPSCHEDULE

900. # Datatype      : String

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

902. # Default value : 2:00

903. # Mandatory     : Yes, if ALL is specified for EMCONFIGURATION

904. #-----------------------------------------------------------------------------

905. #BACKUPSCHEDULE=

906. 
     

907. #-----------------------*** End of CONFIGUREDATABASE section ***------------------------

908. 
     

909. 
     

910. #-----------------------------------------------------------------------------

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

912. #-----------------------------------------------------------------------------

913. [ADDINSTANCE]

914. 
     

915. #-----------------------------------------------------------------------------

916. # Name          : DB_UNIQUE_NAME

917. # Datatype      : String

918. # Description   : DB Unique Name of the RAC database

919. # Valid values  :

920. # Default value : None

921. # Mandatory     : Yes

922. #-----------------------------------------------------------------------------

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

924. 
     

925. #-----------------------------------------------------------------------------

926. # Name          : INSTANCENAME

927. # Datatype      : String

928. # Description   : RAC instance name to be added

929. # Valid values  : Check Oracle11g Administrator's Guide

930. # Default value : +

931. # Mandatory     : No

932. #-----------------------------------------------------------------------------

933. #INSTANCENAME = "orcl1"

934. 
     

935. #-----------------------------------------------------------------------------

936. # Name          : NODELIST

937. # Datatype      : String

938. # Description   : Node on which to add new instance

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

940. # Valid values  : Cluster node name

941. # Default value : None

942. # Mandatory     : Yes

943. #-----------------------------------------------------------------------------

944. NODELIST=

945. 
     

946. #-----------------------------------------------------------------------------

947. # Name          : OBFUSCATEDPASSWORDS

948. # Datatype      : Boolean

949. # Description   : Set to true if passwords are encrypted

950. # Valid values  : TRUE\FALSE

951. # Default value : FALSE

952. # Mandatory     : No

953. #-----------------------------------------------------------------------------

954. #OBFUSCATEDPASSWORDS = FALSE

955. 
     

956. #-----------------------------------------------------------------------------

957. # Name          : SYSDBAUSERNAME

958. # Datatype      : String

959. # Description   : A user with DBA role.

960. # Default value : none

961. # Mandatory     : YES

962. #-----------------------------------------------------------------------------

963. SYSDBAUSERNAME = "sys"

964. 
     

965. #-----------------------------------------------------------------------------

966. # Name          : SYSDBAPASSWORD

967. # Datatype      : String

968. # Description   : The password of the DBA user.

969. # Default value : none

970. # Mandatory     : YES

971. #-----------------------------------------------------------------------------

972. #SYSDBAPASSWORD = "password"

973. 
     

974. #-----------------------*** End of ADDINSTANCE section ***------------------------

975. 
     

976. 
     

977. #-----------------------------------------------------------------------------

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

979. #-----------------------------------------------------------------------------

980. [DELETEINSTANCE]

981. 
     

982. #-----------------------------------------------------------------------------

983. # Name          : DB_UNIQUE_NAME

984. # Datatype      : String

985. # Description   : DB Unique Name of the RAC database

986. # Valid values  :

987. # Default value : None

988. # Mandatory     : Yes

989. #-----------------------------------------------------------------------------

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

991. 
     

992. #-----------------------------------------------------------------------------

993. # Name          : INSTANCENAME

994. # Datatype      : String

995. # Description   : RAC instance name to be deleted

996. # Valid values  : Check Oracle11g Administrator's Guide

997. # Default value : None

998. # Mandatory     : Yes

999. #-----------------------------------------------------------------------------

1000. INSTANCENAME = "orcl11g"

1001. 
      

1002. #-----------------------------------------------------------------------------

1003. # Name          : NODELIST

1004. # Datatype      : String

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

1006. # Valid values  : Cluster node name

1007. # Default value : None

1008. # Mandatory     : No

1009. #-----------------------------------------------------------------------------

1010. #NODELIST=

1011. 
      

1012. #-----------------------------------------------------------------------------

1013. # Name          : OBFUSCATEDPASSWORDS

1014. # Datatype      : Boolean

1015. # Description   : Set to true if passwords are encrypted

1016. # Valid values  : TRUE\FALSE

1017. # Default value : FALSE

1018. # Mandatory     : No

1019. #-----------------------------------------------------------------------------

1020. #OBFUSCATEDPASSWORDS = FALSE

1021. 
      

1022. #-----------------------------------------------------------------------------

1023. # Name          : SYSDBAUSERNAME

1024. # Datatype      : String

1025. # Description   : A user with DBA role.

1026. # Default value : none

1027. # Mandatory     : YES

1028. #-----------------------------------------------------------------------------

1029. SYSDBAUSERNAME = "sys"

1030. 
      

1031. #-----------------------------------------------------------------------------

1032. # Name          : SYSDBAPASSWORD

1033. # Datatype      : String

1034. # Description   : The password of the DBA user.

1035. # Default value : none

1036. # Mandatory     : YES

1037. #-----------------------------------------------------------------------------

1038. #SYSDBAPASSWORD = "password"

1039. 
      

1040. 
      

1041. #-----------------------*** End of DELETEINSTANCE section ***------------------------

如下是netca.rsp的具体内容：

点击(此处)折叠或打开

1. ######################################################################

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

3. ##                                                                  ##

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

5. ## installation.                                                    ##

6. ##                                                                  ##

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

8. ## identifies the variable type.                                    ##

9. ##                                                                  ##

10. ## Please specify the values in the following format:               ##

11. ##                                                                  ##

12. ##         Type         Example                                     ##

13. ##         String       "Sample Value"                              ##

14. ##         Boolean      True or False                               ##

15. ##         Number       1000                                        ##

16. ##         StringList   {"String value 1","String Value 2"}         ##

17. ##                                                                  ##

18. ######################################################################

19. ##                                                                  ##

20. ## This sample response file causes the Oracle Net Configuration    ##

21. ## Assistant (NetCA) to complete an Oracle Net configuration during ##

22. ## a custom install of the Oracle11g server which is similar to     ##

23. ## what would be created by the NetCA during typical Oracle11g      ##

24. ## install. It also documents all of the NetCA response file        ##

25. ## variables so you can create your own response file to configure  ##

26. ## Oracle Net during an install the way you wish.                   ##

27. ##                                                                  ##

28. ######################################################################

29. 
    

30. [GENERAL]

31. RESPONSEFILE_VERSION="11.2"

32. CREATE_TYPE="CUSTOM"

33. 
    

34. #-------------------------------------------------------------------------------

35. # Name       : SHOW_GUI

36. # Datatype   : Boolean

37. # Description: This variable controls appearance/suppression of the NetCA GUI,

38. # Pre-req    : N/A

39. # Default    : TRUE

40. # Note:

41. # This must be set to false in order to run NetCA in silent mode.

42. # This is a substitute of "/silent" flag in the NetCA command line.

43. # The command line flag has precedence over the one in this response file.

44. # This feature is present since 10.1.0.3.

45. #-------------------------------------------------------------------------------

46. #SHOW_GUI=false

47. 
    

48. #-------------------------------------------------------------------------------

49. # Name       : LOG_FILE

50. # Datatype   : String

51. # Description: If present, NetCA will log output to this file in addition to the

52. #       standard out.

53. # Pre-req    : N/A

54. # Default    : NONE

55. # Note:

56. # This is a substitute of "/log" in the NetCA command line.

57. # The command line argument has precedence over the one in this response file.

58. # This feature is present since 10.1.0.3.

59. #-------------------------------------------------------------------------------

60. #LOG_FILE=""/oracle11gHome/network/tools/log/netca.log""

61. 
    

62. [oracle.net.ca]

63. #INSTALLED_COMPONENTS;StringList;list of installed components

64. # The possible values for installed components are:

65. # "net8","server","client","aso", "cman", "javavm"

66. INSTALLED_COMPONENTS={"server","net8","javavm"}

67. 
    

68. #INSTALL_TYPE;String;type of install

69. # The possible values for install type are:

70. # "typical","minimal" or "custom"

71. INSTALL_TYPE=""typical""

72. 
    

73. #LISTENER_NUMBER;Number;Number of Listeners

74. # A typical install sets one listener

75. LISTENER_NUMBER=1

76. 
    

77. #LISTENER_NAMES;StringList;list of listener names

78. # The values for listener are:

79. # "LISTENER","LISTENER1","LISTENER2","LISTENER3", ...

80. # A typical install sets only "LISTENER"

81. LISTENER_NAMES={"LISTENER"}

82. 
    

83. #LISTENER_PROTOCOLS;StringList;list of listener addresses (protocols and parameters separated by semicolons)

84. # The possible values for listener protocols are:

85. # "tcp;1521","TCPS;2484","NMP;ORapiPE","IPC;IPCKEY","VI;1521"

86. # A typical install sets only "TCP;1521"

87. LISTENER_PROTOCOLS={"TCP;1521"}

88. 
    

89. #LISTENER_START;String;name of the listener to start, in double quotes

90. LISTENER_START=""LISTENER""

91. 
    

92. #NAMING_METHODS;StringList;list of naming methods

93. # The possible values for naming methods are:

94. # LDAP, TNSNAMES, ONAMES, HOSTNAME, NOVELL, NIS, DCE

95. # A typical install sets only: "TNSNAMES","ONAMES","HOSTNAMES"

96. # or "LDAP","TNSNAMES","ONAMES","HOSTNAMES" for LDAP

97. NAMING_METHODS={"TNSNAMES","ONAMES","HOSTNAME"}

98. 
    

99. #NOVELL_NAMECONTEXT;String;Novell Directory Service name context, in double quotes

100. # A typical install does not use this variable.

101. #NOVELL_NAMECONTEXT = ""NAMCONTEXT""

102. 
     

103. #SUN_METAMAP;String; SUN meta map, in double quotes

104. # A typical install does not use this variable.

105. #SUN_METAMAP = ""MAP""

106. 
     

107. #DCE_CELLNAME;String;DCE cell name, in double quotes

108. # A typical install does not use this variable.

109. #DCE_CELLNAME = ""CELL""

110. 
     

111. #NSN_NUMBER;Number;Number of NetService Names

112. # A typical install sets one net service name

113. NSN_NUMBER=1

114. 
     

115. #NSN_NAMES;StringList;list of Net Service names

116. # A typical install sets net service name to "EXTPROC_CONNECTION_DATA"

117. NSN_NAMES={"EXTPROC_CONNECTION_DATA"}

118. 
     

119. #NSN_SERVICE;StringList;Oracle11g database's service name

120. # A typical install sets Oracle11g database's service name to "PLSExtProc"

121. NSN_SERVICE={"PLSExtProc"}

122. 
     

123. #NSN_PROTOCOLS;StringList;list of coma separated strings of Net Service Name protocol parameters

124. # The possible values for net service name protocol parameters are:

125. # "TCP;HOSTNAME;1521","TCPS;HOSTNAME;2484","NMP;COMPUTERNAME;ORAPIPE","VI;HOSTNAME;1521","IPC;IPCKEY"

126. # A typical install sets parameters to "IPC;EXTPROC"

127. NSN_PROTOCOLS={"TCP;HOSTNAME;1521"}

以上是“rhel6/7如何自动安装oracle11g单实例”这篇文章的所有内容，感谢各位的阅读！相信大家都有了一定的了解，希望分享的内容对大家有所帮助，如果还想学习更多知识，欢迎关注编程网数据库频道！