rhel6/7自动安装oracle11g单实例

于 2018-02-26 17:56:13 发布
阅读量495 收藏
点赞数
文章标签： 数据库
因日常工作，经常需要在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 hh24: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"}


来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/31441616/viewspace-2151291/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/31441616/viewspace-2151291/

cuankun4601
关注
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值