天达云 科技型企业 | 亚太互联网络信息中心(APNIC)成员 | 注册免费体验
天达云首页 > 互联网学习教程 > 关系型数据库 > rhel6/7如何自动安装oracle11g单实例

rhel6/7如何自动安装oracle11g单实例
更新：HHH   时间：2023-1-7

小编给大家分享一下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 #进程存在


  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


  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


  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


  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


  42. SQL> show parameter pga

  43. NAME TYPE VALUE

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

  45. pga_aggregate_target big integer 1G


  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


  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





  6. HOSTNAME=`hostname`

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


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

  10. change_dir(){

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

  12. if [ -z $flag  ];then

  13. ORACLE_BASE=${1%?}

  14. fi

  15. }

  16. ##change_dir $dir


  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


  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


  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


  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


  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


  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


  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


  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


  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


  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


  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


  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


  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


  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


  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


  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


  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


  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


  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


  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


  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


  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


  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


  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


  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


  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


  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


  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


  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



  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


  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


  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


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


  17. #------------------------------------------------------------------------------

  18. # Do not change the following system generated value.

  19. #------------------------------------------------------------------------------

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


  22. #------------------------------------------------------------------------------

  23. # Specify the installation option.

  24. # It can be one of the following:

  25. #   - INSTALL_DB_SWONLY

  26. #   - INSTALL_DB_AND_CONFIG

  27. #   - UPGRADE_DB

  28. #-------------------------------------------------------------------------------

  29. oracle.install.option=INSTALL_DB_SWONLY


  31. #-------------------------------------------------------------------------------

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

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

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

  35. # and network interfaces)

  36. #-------------------------------------------------------------------------------

  37. ORACLE_HOSTNAME=lihb_hostname


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

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

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

  42. UNIX_GROUP_NAME=oinstall


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

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

  46. # This is an optional parameter if installing on

  47. # Windows based Operating System.

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

  49. INVENTORY_LOCATION=lihb_location


  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


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

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

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

  91. ORACLE_HOME=lihb_home


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

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

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

  96. ORACLE_BASE=lihb_base


  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


  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


  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


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


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

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

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

  154. oracle.install.db.DBA_GROUP=dba


  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


  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=


  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=


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

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

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

  181. oracle.install.db.racOneServiceName=


  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


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

  192. # Specify the Starter Database Global Database Name.

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

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


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

  197. # Specify the Starter Database SID.

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

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


  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


  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


  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=


  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


  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


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


  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


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

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

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

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


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

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

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

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


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

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

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

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


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

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

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

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


  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


  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=


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


  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


  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=


  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=


  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


  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


  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=


  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=


  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=


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

  368. # Specify the My Oracle Support Account Username.

  369. #

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

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

  372. MYORACLESUPPORT_USERNAME=


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

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

  376. #

  377. # Example    : MYORACLESUPPORT_PASSWORD=password

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

  379. MYORACLESUPPORT_PASSWORD=


  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=


  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


  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=


  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=


  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=


  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=


  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=


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

  440. # Specify the Oracle Support Hub URL.

  441. #

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

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

  444. COLLECTOR_SUPPORTHUB_URL=


  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=


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


  37. #-----------------------------------------------------------------------------

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

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

  40. [GENERAL]


  42. #-----------------------------------------------------------------------------

  43. # Name          : RESPONSEFILE_VERSION

  44. # Datatype      : String

  45. # Description   : Version of the database to create

  46. # Valid values  : "11.1.0"

  47. # Default value : None

  48. # Mandatory     : Yes

  49. #-----------------------------------------------------------------------------

  50. RESPONSEFILE_VERSION = "11.2.0"


  52. #-----------------------------------------------------------------------------

  53. # Name          : OPERATION_TYPE

  54. # Datatype      : String

  55. # Description   : Type of operation

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

  57. # Default value : None

  58. # Mandatory     : Yes

  59. #-----------------------------------------------------------------------------

  60. OPERATION_TYPE = "createDatabase"


  62. #-----------------------*** End of GENERAL section ***------------------------


  64. #-----------------------------------------------------------------------------

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

  66. #-----------------------------------------------------------------------------

  67. [CREATEDATABASE]


  69. #-----------------------------------------------------------------------------

  70. # Name          : GDBNAME

  71. # Datatype      : String

  72. # Description   : Global database name of the database

  73. # Valid values  : . - when database domain isn't NULL

  74. #                              - when database domain is NULL

  75. # Default value : None

  76. # Mandatory     : Yes

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

  78. GDBNAME = "lihb_gdbname"


  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"


  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 =


  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"


  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"


  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"


  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 =


  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 =


  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"


  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=


  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"


  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



  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"


  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"


  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"


  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"



  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"


  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"


  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 =


  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 =


  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=


  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=


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


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


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


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




  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 =


  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


  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


  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


  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


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


  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



  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"


  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"


  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


  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"


  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"


  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"


  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"


  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 =


  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 =


  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 =


  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


  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"


  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"


  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"


  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"



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


  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"


  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"


  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"


  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"


  600. #-----------------------*** End of createTemplateFromDB section ***------------------------


  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"


  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"


  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"


  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"


  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 =


  654. #-----------------------*** End of createCloneTemplate section ***------------------------


  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"


  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"


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


  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"


  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"


  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 =


  725. #-----------------------*** End of deleteDatabase section ***------------------------


  727. #-----------------------------------------------------------------------------

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

  729. #-----------------------------------------------------------------------------

  730. [CONFIGUREDATABASE]


  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"


  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"



  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 =


  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


  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


  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


  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"


  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"


  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"


  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"




  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"



  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"


  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"


  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"


  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 =


  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 =


  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=


  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=


  907. #-----------------------*** End of CONFIGUREDATABASE section ***------------------------



  910. #-----------------------------------------------------------------------------

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

  912. #-----------------------------------------------------------------------------

  913. [ADDINSTANCE]


  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"


  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"


  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=


  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


  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"


  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"


  974. #-----------------------*** End of ADDINSTANCE section ***------------------------



  977. #-----------------------------------------------------------------------------

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

  979. #-----------------------------------------------------------------------------

  980. [DELETEINSTANCE]


  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"


  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"


  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=


  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


  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"


  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"



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


  30. [GENERAL]

  31. RESPONSEFILE_VERSION="11.2"

  32. CREATE_TYPE="CUSTOM"


  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


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


  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"}


  68. #INSTALL_TYPE;String;type of install

  69. # The possible values for install type are:

  70. # "typical","minimal" or "custom"

  71. INSTALL_TYPE=""typical""


  73. #LISTENER_NUMBER;Number;Number of Listeners

  74. # A typical install sets one listener

  75. LISTENER_NUMBER=1


  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"}


  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"}


  89. #LISTENER_START;String;name of the listener to start, in double quotes

  90. LISTENER_START=""LISTENER""


  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"}


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


  103. #SUN_METAMAP;String; SUN meta map, in double quotes

  104. # A typical install does not use this variable.

  105. #SUN_METAMAP = ""MAP""


  107. #DCE_CELLNAME;String;DCE cell name, in double quotes

  108. # A typical install does not use this variable.

  109. #DCE_CELLNAME = ""CELL""


  111. #NSN_NUMBER;Number;Number of NetService Names

  112. # A typical install sets one net service name

  113. NSN_NUMBER=1


  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"}


  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"}


  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单实例”这篇文章的所有内容，感谢各位的阅读！相信大家都有了一定的了解，希望分享的内容对大家有所帮助，如果还想学习更多知识，欢迎关注天达云行业资讯频道！
返回关系型数据库教程...
400-837-6568
7 * 24小时全天全国服务热线400电话
天达云·专业的云计算服务平台 全国400服务电话：400-837-6568
Copyright © 2011-2025 Tdyun.com. All Rights Reserved. 天达云 版权所有 粤ICP备18083267号-7