六.创建 Oracle 清单组、用户
1. ### 创建 Oracle 清单组 2. [root@orcl-12 ~]# /usr/sbin/groupadd oinstall 3. [root@orcl-12 ~]# /usr/sbin/groupadd dba 4. 5. ### 检查清单组信息 6. [root@orcl-12 ~]# grep "oinstall" /etc/group 7. oinstall:x:1000: 8. [root@orcl-12 ~]# grep "dba" /etc/group 9. dba:x:1001: 10. 11. ### 创建 Oracle 软件所有者用户 12. [root@orcl-12 ~]#/usr/sbin/useradd -g oinstall -G dba oracle 13. ### 设置Oracle账户密码(可以不设置) 14. [root@orcl-12 ~]#passwd oracle 15. 16. ### 检查用户信息 17. [root@orcl-12 ~]# id oracle 18. uid=1000(oracle) gid=1000(oinstall) groups=1000(oinstall),1001(dba)
七.创建数据目录
1、挂载数据盘
1. [root@orcl-12 ~]#mkdir /u01 2. [root@orcl-12 ~]#mount /dev/sdb1 /u01 (生产环境直接挂载数据盘,测试环境可省略此步骤) 3. [root@orcl-12 ~]#chown -R oracle.oinstall /u01
2.为 Oracle 数据库文件创建目录
数据库文件目录:
1. mkdir -p /u01/oradata/ 2. chown oracle:oinstall /u01/oradata/
恢复文件目录(快速恢复区域)
1. mkdir -p /u01/oradata/rcv_area 2. chown oracle:oinstall /u01/oradata/rcv_area 3. chmod 775 /u01/oradata/rcv_area
八,安装所依赖的包
检查有哪些包没安:
1. rpm -q \ 2. binutils \ 3. compat-libstdc++-33 \ 4. elfutils-libelf \ 5. elfutils-libelf-devel \ 6. expat \ 7. gcc \ 8. gcc-c++ \ 9. glibc \ 10. glibc-common \ 11. glibc-devel \ 12. glibc-headers \ 13. libaio \ 14. libaio-devel \ 15. libgcc \ 16. libstdc++ \ 17. libstdc++-devel \ 18. make \ 19. ksh \ 20. sysstat \ 21. libnsl.x86_64 \ 22. numactl-devel \ 23. libgomp \ 24. kernel-headers \ 25. compat-libcap1 \ 26. smartmontools \ 27. net-tools \ 28. unixODBC \ 29. unixODBC-devel | grep "not installed"
安装这些包
1. yum install -y \ 2. binutils \ 3. compat-libstdc++-33 \ 4. elfutils-libelf \ 5. elfutils-libelf-devel \ 6. expat \ 7. gcc \ 8. gcc-c++ \ 9. glibc \ 10. glibc-common \ 11. glibc-devel \ 12. glibc-headers \ 13. libaio \ 14. libaio-devel \ 15. libgcc \ 16. libstdc++ \ 17. libstdc++-devel \ 18. make \ 19. ksh \ 20. sysstat \ 21. libnsl.x86_64 \ 22. numactl-devel \ 23. libgomp \ 24. kernel-headers \ 25. compat-libcap1 \ 26. smartmontools \ 27. net-tools \ 28. unixODBC \ 29. unixODBC-devel
在安装过程中我发现有一个包安装不了,但是经过测试,不安装那个包也可以完成安装
package libnsl.x86_64 is not installed
九,关闭防火墙
1. # 关闭Selinux 2. # 永久关闭,输入 vim /etc/selinux/config 将其中的SELINUX=enforcing 改为 SELINUX=disabled 3. 4. 5. [root@orcl-12 home]# setenforce 0 6. [root@orcl-12 home]# getenforce 7. Permissive 8. 9. ### 关闭iptables 10. 11. #CentOS 6 版本 12. [root@orcl-12 home]# ptables -F 13. [root@orcl-12 home]# service iptable save 14. 15. ##CentOS 7 及后续版本防火墙为firewalld 16. [root@orcl-12 home]# systemctl disable firewalld 17. [root@orcl-12 home]# systemctl stop firewalld
十、上传安装包并解压
上传压缩包到/home/software目录,这一步需要实现创建这个目录,我是用桌面环境直接创建的,也可以用xshell中输入指令创建。
1. # 解压安装包 2. [root@orcl-12 software]# unzip V839960-01.zip 3. 4. # 修改静默安装文件 5. [root@orcl-12 home]# cd /home/software/database/response 6. 7. 8. # 编辑静默安装文件(详细内容,详见db_install.rsp文件) 9. [root@orcl-12 response]# vim db_install.rsp
十一.安装Oracle Database
配置db_install.rsp文件,具体文件详见附件一,获取地址:
链接:https://pan.baidu.com/s/1zVOrl_yOObZZMJn13Ha68g?pwd=abcd
提取码:abcd
具体内容也可见附件一
执行静默安装命令,安装Oracle database,安装成功后,要切换root用户,执行系统提醒我们执行的两个文件。
1. /u01/app/oraInventory/orainstRoot.sh 2. /u01/app/oracle/12.2.0/db_1/root.sh
1. [root@orcl-12 home]# su - oracle 2. [oracle@orcl-12 database]$ ./runInstaller -silent -responseFile /home/software/database/response/db_install.rsp 3. 正在启动 Oracle Universal Installer... 4. 5. 检查临时空间: 必须大于 500 MB。 实际为 4729 MB 通过 6. 检查交换空间: 必须大于 150 MB。 实际为 6143 MB 通过 7. 准备从以下地址启动 Oracle Universal Installer /tmp/OraInstall2022-07-28_05-13-13PM. 请稍候...[oracle@orcl-12 database]$ 可以在以下位置找到本次安装会话的日志: 8. /u01/app/oraInventory/logs/installActions2022-07-28_05-13-13PM.log 9. Oracle Database 12c 的 安装 已成功。 10. 请查看 '/u01/app/oraInventory/logs/silentInstall2022-07-28_05-13-13PM.log' 以获取详细资料。 11. 12. 以 root 用户的身份执行以下脚本: 13. 1. /u01/app/oraInventory/orainstRoot.sh 14. 2. /u01/app/oracle/12.2.0/db_1/root.sh 15. 16. 17. 18. Successfully Setup Software. 19. 20. [oracle@orcl-12 database]$ su root 21. 密码: 22. [root@orcl-12 database]# /u01/app/oraInventory/orainstRoot.sh 23. 更改权限/u01/app/oraInventory. 24. 添加组的读取和写入权限。 25. 删除全局的读取, 写入和执行权限。 26. 27. 更改组名/u01/app/oraInventory 到 oinstall. 28. 脚本的执行已完成。 29. [root@orcl-12 database]# /u01/app/oracle/12.2.0/db_1/root.sh 30. Check /u01/app/oracle/12.2.0/db_1/install/root_orcl-12_2022-07-28_17-26-56-521635560.log for the output of root script 31. [root@orcl-12 database]#
十二.配置Oracle database环境变量
修改当前用户环境变量,在用户家目录下编辑 .bash_profile 文件,增加环境变量参数。(修改全部系统环境变量,直接编辑 /etc/profile 文件即可)
1. [root@orcl-12 ~]# su oracle 2. [oracle@orcl-12 root]$ vim /home/oracle/.bash_profile # 增加下列变量
变量参数
1. export ORACLE_BASE=/u01/app/oracle 2. export ORACLE_HOME=$ORACLE_BASE/12.2.0/db_1 3. export ORACLE_SID=orcl 4. export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin 5. export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib 6. NLS_LANG='SIMPLIFIED CHINESE_CHINA.AL32UTF8'; export NLS_LANG
生效当前变量
1. [oracle@orcl-12 root]$ source !$ 2. source /home/oracle/.bash_profile # 使当前配置立即生效
十三、配置网络
使用默认的netca.rsp响应文件,未做修改。
1. [root@orcl-12 ~]# su oracle 2. [oracle@orcl-12 root]$ netca -silent -responsefile /home/software/database/response/netca.rsp
配置监听文件 【需进一步确认】
1. vim /u01/app/oracle/12.2.0/db_1/network/admin/listener.ora 2. 3. # 在 “LISTENER =” 这行前面增加以下内容 4. SID_LIST_LISTENER = 5. (SID_LIST = 6. (SID_DESC = 7. (SID_NAME = PLSExtProc) 8. (ORACLE_HOME =/u01/app/oracle/12.2.0/db_1) 9. (PROGRAM = extproc) 10. ) 11. (SID_DESC = 12. (SID_NAME = orcl) 13. (ORACLE_HOME =/u01/app/oracle/12.2.0/db_1) 14. (GLOBAL_DBNAME= orcl) 15. ) 16. )
十四、部署数据库
配置dbca.rsp响应文件,具体文件在上一步的安装包中,内容见附件二。
执行部署命令
1. [oracle@orcl-12 root]$ dbca -silent -createDatabase -responseFile /home/software/database/response/dbca.rsp 2. 复制数据库文件 3. 1%已完成 4. 2%已完成 5. 18%已完成 6. 33%已完成 7. 正在创建并启动 Oracle 实例 8. 35%已完成 9. 40%已完成 10. 44%已完成 11. 49%已完成 12. 50%已完成 13. 53%已完成 14. 55%已完成 15. 正在进行数据库创建 16. 56%已完成 17. 57%已完成 18. 58%已完成 19. 62%已完成 20. 65%已完成 21. 66%已完成 22. 执行配置后操作 23. 100%已完成 24. 有关详细信息, 请参阅日志文件 "/u01/app/oracle/cfgtoollogs/dbca/orcl/orcl.log"。 25. [oracle@orcl-12 root]$
十五、启动数据库
1、修改oracle启动配置文件
1. su - oracle 2. vi /etc/oratab 3. orcl:/usr/oracle/product/11.2.0/db_1:Y //把“N”改成“Y”
2、开启、关闭Oracle Database
1. 启动 dbstart $ORACLE_HOME 2. 3. 关闭 dbshut $ORACLE_HOME
3、监听
1. 查看监听器状态:lsnrctl status 2. 3. 开启监听 :lsnrctl start 4. 5. 关闭监听:lsnrctl stop
十六、使用归档日志
1. [oracle@orcl-12 root]$ sqlplus / as sysdba 2. SQL> shutdown immediate; #关闭数据库 3. SQL> startup mount; #打开控制文件 4. SQL> archive log list #查看归档相关信息 5. SQL> alter database archivelog; #开启归档模式 6. SQL> show parameter db_recovery_file_dest; #查看快速恢复分区详情 7. SQL> ALTER SYSTEM SET db_recovery_file_dest_size=10g; #设定闪回空间大小为10G 8. SQL> ALTER SYSTEM SET db_flashback_retention_target=30; #设定保留时间为半小时,默认为1440. 9. SQL> alter system set db_recovery_file_dest='/u01/oradata/rcv_area/archivelog'; #设置存档文件路径(需提前设定好闪回空间大小) 10. SQL> alter database flashback on; (如果要启用数据库闪回功能则执行) 11. SQL> alter database open; #打开数据库 12. 13. SQL> execute utl_recomp.recomp_serial(); (重新编译所有可能失效对象) 14. SQL> alter system archive log current; (手工归档测试) 15. 16. # 默认安装的数据库用户检查 17. SQL> set lines 256 pages 500; 18. SQL> select USER_ID,USERNAME,ACCOUNT_STATUS,DEFAULT_TABLESPACE from dba_users order by 1;
十七.第一次创建用户以及连接
登录数据库
sqlplus / as sysdba
创建数据库用户
1. create user 用户名 identified by 口令[即密码]; 2. 例如: 3. create user oracle identified by 123;
给用户授权
1. grant connect, resource,dba to 用户名; 2. 例如:grant connect, resource,dba to oracle;
这样我们就可以在navicat中通过oracle用户连接数据库了,从而可以通过图形化界面方便的创建用户以及表空间
在navicat中新建链接
主机填服务器的地址,用户名就是我们刚才创建的oracle,密码就是我们刚才赋予的123
测试链接
十八.创建表空间及其用户
参考的文章是参考中的第三个链接,使用的工具是navicat16,下载及破解地址在这
https://learnku.com/articles/67706
点击其他,再点击表空间
新建表空间
填写参数, 点击保存即可
新建用户
临时表空间可以填系统自带的,默认表空间填写刚才自己创建的,密码自己设置一个,用户名随便填
成员属于填DBA的两项,不然无法连接数据库
新建连接
遇到的bug以及解决方案
1.提示内存不足
这个问题是在服务器安装的过程中出现的,具体原因是我通过window的远程桌面连接的服务器,服务器运行桌面程序占用了大量内存
解决:关闭远程桌面连接
2.提示硬盘容量不足
这个问题是我在虚拟机中安装时遇到的,我们虚拟机硬盘也就十多G,而Oracle需要的硬盘容量要在25G左右
解决:重装系统,设置硬盘大小为64G
3.使用navicat连接数据库提示:ORA-12514 TNS 监听程序当前无法识别连接描述符中请求服务
可能是我在启动数据库之后才启动的监听,导致监听异常’
解决:重启数据库
4. runInstaller找不到
运行./runInstaller -silent -responseFile /home/software/database/response/db_install.rsp时,提示找不到文件
解决:可以去datbase文件下看一看是否生成./runInstaller,如果没有生成,可能是防火墙的问题,关闭防火墙之后再尝试解压,如果还没有生成文件,我的做法是重装系统,也可以仔细检查文章中的每一步。一般只要生成就可以运行,只是环境没有配置对的话,哪怕执行也会报错。
附件
附件一:db_install.rsp
1. #################################################################### 2. ## Copyright(c) Oracle Corporation 1998,2017. All rights reserved.## 3. ## ## 4. ## Specify values for the variables listed below to customize ## 5. ## your installation. ## 6. ## ## 7. ## Each variable is associated with a comment. The comment ## 8. ## can help to populate the variables with the appropriate ## 9. ## values. ## 10. ## ## 11. ## IMPORTANT NOTE: This file contains plain text passwords and ## 12. ## should be secured to have read permission only by oracle user ## 13. ## or db administrator who owns this installation. ## 14. ## ## 15. #################################################################### 16. 17. 18. #------------------------------------------------------------------------------- 19. # Do not change the following system generated value. 20. #------------------------------------------------------------------------------- 21. oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.2.0 22. 23. #------------------------------------------------------------------------------- 24. # Specify the installation option. 25. # It can be one of the following: 26. # - INSTALL_DB_SWONLY 27. # - INSTALL_DB_AND_CONFIG 28. # - UPGRADE_DB 29. #------------------------------------------------------------------------------- 30. oracle.install.option=INSTALL_DB_SWONLY 31. 32. #------------------------------------------------------------------------------- 33. # Specify the Unix group to be set for the inventory directory. 34. #------------------------------------------------------------------------------- 35. UNIX_GROUP_NAME=oinstall 36. 37. #------------------------------------------------------------------------------- 38. # Specify the location which holds the inventory files. 39. # This is an optional parameter if installing on 40. # Windows based Operating System. 41. #------------------------------------------------------------------------------- 42. INVENTORY_LOCATION=/u01/app/oraInventory 43. #------------------------------------------------------------------------------- 44. # Specify the complete path of the Oracle Home. 45. #------------------------------------------------------------------------------- 46. ORACLE_HOME=/u01/app/oracle/12.2.0/db_1 47. #ORACLE_HOME=/u01/app/oracle/product/12.2.0/db_1 48. #------------------------------------------------------------------------------- 49. # Specify the complete path of the Oracle Base. 50. #------------------------------------------------------------------------------- 51. ORACLE_BASE=/u01/app/oracle 52. 53. #------------------------------------------------------------------------------- 54. # Specify the installation edition of the component. 55. # 56. # The value should contain only one of these choices. 57. # - EE : Enterprise Edition 58. # - SE2 : Standard Edition 2 59. #------------------------------------------------------------------------------- 60. oracle.install.db.InstallEdition=EE 61. 62. ############################################################################### 63. # # 64. # PRIVILEGED OPERATING SYSTEM GROUPS # 65. # ------------------------------------------ # 66. # Provide values for the OS groups to which SYSDBA and SYSOPER privileges # 67. # needs to be granted. If the install is being performed as a member of the # 68. # group "dba", then that will be used unless specified otherwise below. # 69. # # 70. # The value to be specified for OSDBA and OSOPER group is only for UNIX based # 71. # Operating System. # 72. # # 73. ############################################################################### 74. 75. #------------------------------------------------------------------------------ 76. # The OSDBA_GROUP is the OS group which is to be granted SYSDBA privileges. 77. #------------------------------------------------------------------------------- 78. oracle.install.db.OSDBA_GROUP=dba 79. 80. #------------------------------------------------------------------------------ 81. # The OSOPER_GROUP is the OS group which is to be granted SYSOPER privileges. 82. # The value to be specified for OSOPER group is optional. 83. #------------------------------------------------------------------------------ 84. oracle.install.db.OSOPER_GROUP=dba 85. 86. #------------------------------------------------------------------------------ 87. # The OSBACKUPDBA_GROUP is the OS group which is to be granted SYSBACKUP privileges. 88. #------------------------------------------------------------------------------ 89. oracle.install.db.OSBACKUPDBA_GROUP=dba 90. 91. #------------------------------------------------------------------------------ 92. # The OSDGDBA_GROUP is the OS group which is to be granted SYSDG privileges. 93. #------------------------------------------------------------------------------ 94. oracle.install.db.OSDGDBA_GROUP=dba 95. 96. #------------------------------------------------------------------------------ 97. # The OSKMDBA_GROUP is the OS group which is to be granted SYSKM privileges. 98. #------------------------------------------------------------------------------ 99. oracle.install.db.OSKMDBA_GROUP=dba 100. 101. #------------------------------------------------------------------------------ 102. # The OSRACDBA_GROUP is the OS group which is to be granted SYSRAC privileges. 103. #------------------------------------------------------------------------------ 104. oracle.install.db.OSRACDBA_GROUP=dba 105. 106. ############################################################################### 107. # # 108. # Grid Options # 109. # # 110. ############################################################################### 111. #------------------------------------------------------------------------------ 112. # Specify the type of Real Application Cluster Database 113. # 114. # - ADMIN_MANAGED: Admin-Managed 115. # - POLICY_MANAGED: Policy-Managed 116. # 117. # If left unspecified, default will be ADMIN_MANAGED 118. #------------------------------------------------------------------------------ 119. oracle.install.db.rac.configurationType= 120. 121. #------------------------------------------------------------------------------ 122. # Value is required only if RAC database type is ADMIN_MANAGED 123. # 124. # Specify the cluster node names selected during the installation. 125. # Leaving it blank will result in install on local server only (Single Instance) 126. # 127. # Example : oracle.install.db.CLUSTER_NODES=node1,node2 128. #------------------------------------------------------------------------------ 129. oracle.install.db.CLUSTER_NODES= 130. 131. #------------------------------------------------------------------------------ 132. # This variable is used to enable or disable RAC One Node install. 133. # 134. # - true : Value of RAC One Node service name is used. 135. # - false : Value of RAC One Node service name is not used. 136. # 137. # If left blank, it will be assumed to be false. 138. #------------------------------------------------------------------------------ 139. oracle.install.db.isRACOneInstall= 140. 141. #------------------------------------------------------------------------------ 142. # Value is required only if oracle.install.db.isRACOneInstall is true. 143. # 144. # Specify the name for RAC One Node Service 145. #------------------------------------------------------------------------------ 146. oracle.install.db.racOneServiceName= 147. 148. #------------------------------------------------------------------------------ 149. # Value is required only if RAC database type is POLICY_MANAGED 150. # 151. # Specify a name for the new Server pool that will be configured 152. # Example : oracle.install.db.rac.serverpoolName=pool1 153. #------------------------------------------------------------------------------ 154. oracle.install.db.rac.serverpoolName= 155. 156. #------------------------------------------------------------------------------ 157. # Value is required only if RAC database type is POLICY_MANAGED 158. # 159. # Specify a number as cardinality for the new Server pool that will be configured 160. # Example : oracle.install.db.rac.serverpoolCardinality=2 161. #------------------------------------------------------------------------------ 162. oracle.install.db.rac.serverpoolCardinality= 163. 164. ############################################################################### 165. # # 166. # Database Configuration Options # 167. # # 168. ############################################################################### 169. 170. #------------------------------------------------------------------------------- 171. # Specify the type of database to create. 172. # It can be one of the following: 173. # - GENERAL_PURPOSE 174. # - DATA_WAREHOUSE 175. # GENERAL_PURPOSE: A starter database designed for general purpose use or transaction-heavy applications. 176. # DATA_WAREHOUSE : A starter database optimized for data warehousing applications. 177. #------------------------------------------------------------------------------- 178. oracle.install.db.config.starterdb.type=GENERAL_PURPOSE 179. 180. #------------------------------------------------------------------------------- 181. # Specify the Starter Database Global Database Name. 182. #------------------------------------------------------------------------------- 183. oracle.install.db.config.starterdb.globalDBName=orcl 184. 185. #------------------------------------------------------------------------------- 186. # Specify the Starter Database SID. 187. #------------------------------------------------------------------------------- 188. oracle.install.db.config.starterdb.SID=orcl 189. 190. #------------------------------------------------------------------------------- 191. # Specify whether the database should be configured as a Container database. 192. # The value can be either "true" or "false". If left blank it will be assumed 193. # to be "false". 194. #------------------------------------------------------------------------------- 195. oracle.install.db.ConfigureAsContainerDB=true 196. 197. #------------------------------------------------------------------------------- 198. # Specify the Pluggable Database name for the pluggable database in Container Database. 199. #------------------------------------------------------------------------------- 200. oracle.install.db.config.PDBName=pdb1 201. 202. #------------------------------------------------------------------------------- 203. # Specify the Starter Database character set. 204. # 205. # One of the following 206. # AL32UTF8, WE8ISO8859P15, WE8MSWIN1252, EE8ISO8859P2, 207. # EE8MSWIN1250, NE8ISO8859P10, NEE8ISO8859P4, BLT8MSWIN1257, 208. # BLT8ISO8859P13, CL8ISO8859P5, CL8MSWIN1251, AR8ISO8859P6, 209. # AR8MSWIN1256, EL8ISO8859P7, EL8MSWIN1253, IW8ISO8859P8, 210. # IW8MSWIN1255, JA16EUC, JA16EUCTILDE, JA16SJIS, JA16SJISTILDE, 211. # KO16MSWIN949, ZHS16GBK, TH8TISASCII, ZHT32EUC, ZHT16MSWIN950, 212. # ZHT16HKSCS, WE8ISO8859P9, TR8MSWIN1254, VN8MSWIN1258 213. #------------------------------------------------------------------------------- 214. oracle.install.db.config.starterdb.characterSet=AL32UTF8 215. 216. #------------------------------------------------------------------------------ 217. # This variable should be set to true if Automatic Memory Management 218. # in Database is desired. 219. # If Automatic Memory Management is not desired, and memory allocation 220. # is to be done manually, then set it to false. 221. #------------------------------------------------------------------------------ 222. oracle.install.db.config.starterdb.memoryOption=true 223. 224. #------------------------------------------------------------------------------- 225. # Specify the total memory allocation for the database. Value(in MB) should be 226. # at least 256 MB, and should not exceed the total physical memory available 227. # on the system. 228. # Example: oracle.install.db.config.starterdb.memoryLimit=512 229. #------------------------------------------------------------------------------- 230. oracle.install.db.config.starterdb.memoryLimit= 231. 232. #------------------------------------------------------------------------------- 233. # This variable controls whether to load Example Schemas onto 234. # the starter database or not. 235. # The value can be either "true" or "false". If left blank it will be assumed 236. # to be "false". 237. #------------------------------------------------------------------------------- 238. oracle.install.db.config.starterdb.installExampleSchemas=false 239. 240. ############################################################################### 241. # # 242. # Passwords can be supplied for the following four schemas in the # 243. # starter database: # 244. # SYS # 245. # SYSTEM # 246. # DBSNMP (used by Enterprise Manager) # 247. # # 248. # Same password can be used for all accounts (not recommended) # 249. # or different passwords for each account can be provided (recommended) # 250. # # 251. ############################################################################### 252. 253. #------------------------------------------------------------------------------ 254. # This variable holds the password that is to be used for all schemas in the 255. # starter database. 256. #------------------------------------------------------------------------------- 257. oracle.install.db.config.starterdb.password.ALL=Oracle#2022 258. 259. #------------------------------------------------------------------------------- 260. # Specify the SYS password for the starter database. 261. #------------------------------------------------------------------------------- 262. oracle.install.db.config.starterdb.password.SYS= 263. 264. #------------------------------------------------------------------------------- 265. # Specify the SYSTEM password for the starter database. 266. #------------------------------------------------------------------------------- 267. oracle.install.db.config.starterdb.password.SYSTEM= 268. 269. #------------------------------------------------------------------------------- 270. # Specify the DBSNMP password for the starter database. 271. # Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL 272. #------------------------------------------------------------------------------- 273. oracle.install.db.config.starterdb.password.DBSNMP= 274. 275. #------------------------------------------------------------------------------- 276. # Specify the PDBADMIN password required for creation of Pluggable Database in the Container Database. 277. #------------------------------------------------------------------------------- 278. oracle.install.db.config.starterdb.password.PDBADMIN= 279. 280. #------------------------------------------------------------------------------- 281. # Specify the management option to use for managing the database. 282. # Options are: 283. # 1. CLOUD_CONTROL - If you want to manage your database with Enterprise Manager Cloud Control along with Database Express. 284. # 2. DEFAULT -If you want to manage your database using the default Database Express option. 285. #------------------------------------------------------------------------------- 286. oracle.install.db.config.starterdb.managementOption= 287. 288. #------------------------------------------------------------------------------- 289. # Specify the OMS host to connect to Cloud Control. 290. # Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL 291. #------------------------------------------------------------------------------- 292. oracle.install.db.config.starterdb.omsHost= 293. 294. #------------------------------------------------------------------------------- 295. # Specify the OMS port to connect to Cloud Control. 296. # Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL 297. #------------------------------------------------------------------------------- 298. oracle.install.db.config.starterdb.omsPort= 299. 300. #------------------------------------------------------------------------------- 301. # Specify the EM Admin user name to use to connect to Cloud Control. 302. # Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL 303. #------------------------------------------------------------------------------- 304. oracle.install.db.config.starterdb.emAdminUser= 305. 306. #------------------------------------------------------------------------------- 307. # Specify the EM Admin password to use to connect to Cloud Control. 308. # Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL 309. #------------------------------------------------------------------------------- 310. oracle.install.db.config.starterdb.emAdminPassword= 311. 312. ############################################################################### 313. # # 314. # SPECIFY RECOVERY OPTIONS # 315. # ------------------------------------ # 316. # Recovery options for the database can be mentioned using the entries below # 317. # # 318. ############################################################################### 319. 320. #------------------------------------------------------------------------------ 321. # This variable is to be set to false if database recovery is not required. Else 322. # this can be set to true. 323. #------------------------------------------------------------------------------- 324. oracle.install.db.config.starterdb.enableRecovery=true 325. 326. #------------------------------------------------------------------------------- 327. # Specify the type of storage to use for the database. 328. # It can be one of the following: 329. # - FILE_SYSTEM_STORAGE 330. # - ASM_STORAGE 331. #------------------------------------------------------------------------------- 332. oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGE 333. 334. #------------------------------------------------------------------------------- 335. # Specify the database file location which is a directory for datafiles, control 336. # files, redo logs. 337. # 338. # Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE 339. #------------------------------------------------------------------------------- 340. oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=/u01/oradata/ 341. 342. #------------------------------------------------------------------------------- 343. # Specify the recovery location. 344. # 345. # Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE 346. #------------------------------------------------------------------------------- 347. oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=/u01/oradata/rcv_area 348. 349. #------------------------------------------------------------------------------- 350. # Specify the existing ASM disk groups to be used for storage. 351. # 352. # Applicable only when oracle.install.db.config.starterdb.storageType=ASM_STORAGE 353. #------------------------------------------------------------------------------- 354. oracle.install.db.config.asm.diskGroup= 355. 356. #------------------------------------------------------------------------------- 357. # Specify the password for ASMSNMP user of the ASM instance. 358. # 359. # Applicable only when oracle.install.db.config.starterdb.storage=ASM_STORAGE 360. #------------------------------------------------------------------------------- 361. oracle.install.db.config.asm.ASMSNMPPassword= 362. 363. #------------------------------------------------------------------------------ 364. # Specify the My Oracle Support Account Username. 365. # 366. # Example : MYORACLESUPPORT_USERNAME=abc@oracle.com 367. #------------------------------------------------------------------------------ 368. MYORACLESUPPORT_USERNAME= 369. 370. #------------------------------------------------------------------------------ 371. # Specify the My Oracle Support Account Username password. 372. # 373. # Example : MYORACLESUPPORT_PASSWORD=password 374. #------------------------------------------------------------------------------ 375. MYORACLESUPPORT_PASSWORD= 376. 377. #------------------------------------------------------------------------------ 378. # Specify whether to enable the user to set the password for 379. # My Oracle Support credentials. The value can be either true or false. 380. # If left blank it will be assumed to be false. 381. # 382. # Example : SECURITY_UPDATES_VIA_MYORACLESUPPORT=true 383. #------------------------------------------------------------------------------ 384. SECURITY_UPDATES_VIA_MYORACLESUPPORT=false 385. 386. #------------------------------------------------------------------------------ 387. # Specify whether user doesn't want to configure Security Updates. 388. # The value for this variable should be true if you don't want to configure 389. # Security Updates, false otherwise. 390. # 391. # The value can be either true or false. If left blank it will be assumed 392. # to be true. 393. # 394. # Example : DECLINE_SECURITY_UPDATES=false 395. #------------------------------------------------------------------------------ 396. DECLINE_SECURITY_UPDATES=true 397. 398. #------------------------------------------------------------------------------ 399. # Specify the Proxy server name. Length should be greater than zero. 400. # 401. # Example : PROXY_HOST=proxy.domain.com 402. #------------------------------------------------------------------------------ 403. PROXY_HOST= 404. 405. #------------------------------------------------------------------------------ 406. # Specify the proxy port number. Should be Numeric and at least 2 chars. 407. # 408. # Example : PROXY_PORT=25 409. #------------------------------------------------------------------------------ 410. PROXY_PORT= 411. 412. #------------------------------------------------------------------------------ 413. # Specify the proxy user name. Leave PROXY_USER and PROXY_PWD 414. # blank if your proxy server requires no authentication. 415. # 416. # Example : PROXY_USER=username 417. #------------------------------------------------------------------------------ 418. PROXY_USER= 419. 420. #------------------------------------------------------------------------------ 421. # Specify the proxy password. Leave PROXY_USER and PROXY_PWD 422. # blank if your proxy server requires no authentication. 423. # 424. # Example : PROXY_PWD=password 425. #------------------------------------------------------------------------------ 426. PROXY_PWD= 427. 428. #------------------------------------------------------------------------------ 429. # Specify the Oracle Support Hub URL. 430. # 431. # Example : COLLECTOR_SUPPORTHUB_URL=https://orasupporthub.company.com:8080/ 432. #------------------------------------------------------------------------------ 433. COLLECTOR_SUPPORTHUB_URL=
附件二:dbca.rsp
1. ############################################################################## 2. ## ## 3. ## DBCA response file ## 4. ## ------------------ ## 5. ## Copyright(c) Oracle Corporation 1998,2017. All rights reserved. ## 6. ## ## 7. ## Specify values for the variables listed below to customize ## 8. ## your installation. ## 9. ## ## 10. ## Each variable is associated with a comment. The comment ## 11. ## can help to populate the variables with the appropriate ## 12. ## values. ## 13. ## ## 14. ## IMPORTANT NOTE: This file contains plain text passwords and ## 15. ## should be secured to have read permission only by oracle user ## 16. ## or db administrator who owns this installation. ## 17. ############################################################################## 18. #------------------------------------------------------------------------------- 19. # Do not change the following system generated value. 20. #------------------------------------------------------------------------------- 21. responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v12.2.0 22. 23. #----------------------------------------------------------------------------- 24. # Name : gdbName 25. # Datatype : String 26. # Description : Global database name of the database 27. # Valid values : <db_name>.<db_domain> - when database domain isn't NULL 28. # <db_name> - when database domain is NULL 29. # Default value : None 30. # Mandatory : Yes 31. #----------------------------------------------------------------------------- 32. gdbName=orcl.localdomain 33. 34. #----------------------------------------------------------------------------- 35. # Name : sid 36. # Datatype : String 37. # Description : System identifier (SID) of the database 38. # Valid values : Check Oracle12c Administrator's Guide 39. # Default value : <db_name> specified in GDBNAME 40. # Mandatory : No 41. #----------------------------------------------------------------------------- 42. sid=orcl 43. 44. #----------------------------------------------------------------------------- 45. # Name : databaseConfigType 46. # Datatype : String 47. # Description : database conf type as Single Instance, Real Application Cluster or Real Application Cluster One Nodes database 48. # Valid values : SI\RAC\RACONENODE 49. # Default value : SI 50. # Mandatory : No 51. #----------------------------------------------------------------------------- 52. databaseConfigType=SI 53. 54. #----------------------------------------------------------------------------- 55. # Name : RACOneNodeServiceName 56. # Datatype : String 57. # Description : Service is required by application to connect to RAC One 58. # Node Database 59. # Valid values : Service Name 60. # Default value : None 61. # Mandatory : No [required in case DATABASECONFTYPE is set to RACONENODE ] 62. #----------------------------------------------------------------------------- 63. RACOneNodeServiceName= 64. 65. #----------------------------------------------------------------------------- 66. # Name : policyManaged 67. # Datatype : Boolean 68. # Description : Set to true if Database is policy managed and 69. # set to false if Database is admin managed 70. # Valid values : TRUE\FALSE 71. # Default value : FALSE 72. # Mandatory : No 73. #----------------------------------------------------------------------------- 74. policyManaged= 75. 76. 77. #----------------------------------------------------------------------------- 78. # Name : createServerPool 79. # Datatype : Boolean 80. # Description : Set to true if new server pool need to be created for database 81. # if this option is specified then the newly created database 82. # will use this newly created serverpool. 83. # Multiple serverpoolname can not be specified for database 84. # Valid values : TRUE\FALSE 85. # Default value : FALSE 86. # Mandatory : No 87. #----------------------------------------------------------------------------- 88. createServerPool= 89. 90. #----------------------------------------------------------------------------- 91. # Name : serverPoolName 92. # Datatype : String 93. # Description : Only one serverpool name need to be specified 94. # if Create Server Pool option is specified. 95. # Comma-separated list of Serverpool names if db need to use 96. # multiple Server pool 97. # Valid values : ServerPool name 98. 99. # Default value : None 100. # Mandatory : No [required in case of RAC service centric database] 101. #----------------------------------------------------------------------------- 102. serverPoolName= 103. 104. #----------------------------------------------------------------------------- 105. # Name : cardinality 106. # Datatype : Number 107. # Description : Specify Cardinality for create server pool operation 108. 109. # Valid values : any positive Integer value 110. # Default value : Number of qualified nodes on cluster 111. # Mandatory : No [Required when a new serverpool need to be created] 112. #----------------------------------------------------------------------------- 113. cardinality= 114. 115. #----------------------------------------------------------------------------- 116. # Name : force 117. # Datatype : Boolean 118. # Description : Set to true if new server pool need to be created by force 119. # if this option is specified then the newly created serverpool 120. # will be assigned server even if no free servers are available. 121. # This may affect already running database. 122. # This flag can be specified for Admin managed as well as policy managed db. 123. # Valid values : TRUE\FALSE 124. # Default value : FALSE 125. # Mandatory : No 126. #----------------------------------------------------------------------------- 127. force= 128. 129. #----------------------------------------------------------------------------- 130. # Name : pqPoolName 131. # Datatype : String 132. # Description : Only one serverpool name needs to be specified 133. # if create server pool option is specified. 134. # Comma-separated list of serverpool names if use 135. # server pool. This is required to 136. # create Parallel Query (PQ) database. Applicable to Big Cluster 137. # Valid values : Parallel Query (PQ) pool name 138. # Default value : None 139. # Mandatory : No [required in case of RAC service centric database] 140. #----------------------------------------------------------------------------- 141. pqPoolName= 142. 143. #----------------------------------------------------------------------------- 144. # Name : pqCardinality 145. # Datatype : Number 146. # Description : Specify Cardinality for create server pool operation. 147. # Applicable to Big Cluster 148. # Valid values : any positive Integer value 149. # Default value : Number of qualified nodes on cluster 150. # Mandatory : No [Required when a new serverpool need to be created] 151. #----------------------------------------------------------------------------- 152. pqCardinality= 153. 154. #----------------------------------------------------------------------------- 155. # Name : createAsContainerDatabase 156. # Datatype : boolean 157. # Description : flag to create database as container database 158. # Valid values : Check Oracle12c Administrator's Guide 159. # Default value : false 160. # Mandatory : No 161. #----------------------------------------------------------------------------- 162. createAsContainerDatabase= 163. 164. #----------------------------------------------------------------------------- 165. # Name : numberOfPDBs 166. # Datatype : Number 167. # Description : Specify the number of pdb to be created 168. # Valid values : 0 to 4094 169. # Default value : 0 170. # Mandatory : No 171. #----------------------------------------------------------------------------- 172. numberOfPDBs=1 173. 174. #----------------------------------------------------------------------------- 175. # Name : pdbName 176. # Datatype : String 177. # Description : Specify the pdbname/pdbanme prefix if one or more pdb need to be created 178. # Valid values : Check Oracle12c Administrator's Guide 179. # Default value : None 180. # Mandatory : No 181. #----------------------------------------------------------------------------- 182. pdbName=pdb1 183. 184. #----------------------------------------------------------------------------- 185. # Name : useLocalUndoForPDBs 186. # Datatype : boolean 187. # Description : Flag to create local undo tablespace for all PDB's. 188. # Valid values : TRUE\FALSE 189. # Default value : TRUE 190. # Mandatory : No 191. #----------------------------------------------------------------------------- 192. useLocalUndoForPDBs=TRUE 193. 194. #----------------------------------------------------------------------------- 195. # Name : pdbAdminPassword 196. # Datatype : String 197. # Description : PDB Administrator user password 198. # Valid values : Check Oracle12c Administrator's Guide 199. # Default value : None 200. # Mandatory : No 201. #----------------------------------------------------------------------------- 202. 203. pdbAdminPassword= 204. 205. #----------------------------------------------------------------------------- 206. # Name : nodelist 207. # Datatype : String 208. # Description : Comma-separated list of cluster nodes 209. # Valid values : Cluster node names 210. # Default value : None 211. # Mandatory : No (Yes for RAC database-centric database ) 212. #----------------------------------------------------------------------------- 213. nodelist= 214. 215. #----------------------------------------------------------------------------- 216. # Name : templateName 217. # Datatype : String 218. # Description : Name of the template 219. # Valid values : Template file name 220. # Default value : None 221. # Mandatory : Yes 222. #----------------------------------------------------------------------------- 223. templateName=General_Purpose.dbc 224. 225. #----------------------------------------------------------------------------- 226. # Name : sysPassword 227. # Datatype : String 228. # Description : Password for SYS user 229. # Valid values : Check Oracle12c Administrator's Guide 230. # Default value : None 231. # Mandatory : Yes 232. #----------------------------------------------------------------------------- 233. sysPassword=Oracle#2022 234. 235. #----------------------------------------------------------------------------- 236. # Name : systemPassword 237. # Datatype : String 238. # Description : Password for SYSTEM user 239. # Valid values : Check Oracle12c Administrator's Guide 240. # Default value : None 241. # Mandatory : Yes 242. #----------------------------------------------------------------------------- 243. systemPassword=Oracle#2022 244. 245. #----------------------------------------------------------------------------- 246. # Name : oracleHomeUserPassword 247. # Datatype : String 248. # Description : Password for Windows Service user 249. # Default value : None 250. # Mandatory : If Oracle home is installed with windows service user 251. #----------------------------------------------------------------------------- 252. oracleHomeUserPassword= 253. 254. #----------------------------------------------------------------------------- 255. # Name : emConfiguration 256. # Datatype : String 257. # Description : Enterprise Manager Configuration Type 258. # Valid values : CENTRAL|DBEXPRESS|BOTH|NONE 259. # Default value : NONE 260. # Mandatory : No 261. #----------------------------------------------------------------------------- 262. emConfiguration= 263. 264. #----------------------------------------------------------------------------- 265. # Name : emExpressPort 266. # Datatype : Number 267. # Description : Enterprise Manager Configuration Type 268. # Valid values : Check Oracle12c Administrator's Guide 269. # Default value : NONE 270. # Mandatory : No, will be picked up from DBEXPRESS_HTTPS_PORT env variable 271. # or auto generates a free port between 5500 and 5599 272. #----------------------------------------------------------------------------- 273. emExpressPort=5500 274. 275. #----------------------------------------------------------------------------- 276. # Name : runCVUChecks 277. # Datatype : Boolean 278. # Description : Specify whether to run Cluster Verification Utility checks 279. # periodically in Cluster environment 280. # Valid values : TRUE\FALSE 281. # Default value : FALSE 282. # Mandatory : No 283. #----------------------------------------------------------------------------- 284. runCVUChecks= 285. 286. #----------------------------------------------------------------------------- 287. # Name : dbsnmpPassword 288. # Datatype : String 289. # Description : Password for DBSNMP user 290. # Valid values : Check Oracle12c Administrator's Guide 291. # Default value : None 292. # Mandatory : Yes, if emConfiguration is specified or 293. # the value of runCVUChecks is TRUE 294. #----------------------------------------------------------------------------- 295. dbsnmpPassword= 296. 297. #----------------------------------------------------------------------------- 298. # Name : omsHost 299. # Datatype : String 300. # Description : EM management server host name 301. # Default value : None 302. # Mandatory : Yes, if CENTRAL is specified for emConfiguration 303. #----------------------------------------------------------------------------- 304. omsHost= 305. 306. #----------------------------------------------------------------------------- 307. # Name : omsPort 308. # Datatype : Number 309. # Description : EM management server port number 310. # Default value : None 311. # Mandatory : Yes, if CENTRAL is specified for emConfiguration 312. #----------------------------------------------------------------------------- 313. omsPort= 314. 315. #----------------------------------------------------------------------------- 316. # Name : emUser 317. # Datatype : String 318. # Description : EM Admin username to add or modify targets 319. # Default value : None 320. # Mandatory : Yes, if CENTRAL is specified for emConfiguration 321. #----------------------------------------------------------------------------- 322. emUser= 323. 324. #----------------------------------------------------------------------------- 325. # Name : emPassword 326. # Datatype : String 327. # Description : EM Admin user password 328. # Default value : None 329. # Mandatory : Yes, if CENTRAL is specified for emConfiguration 330. #----------------------------------------------------------------------------- 331. emPassword= 332. 333. #----------------------------------------------------------------------------- 334. # Name : dvConfiguration 335. # Datatype : Boolean 336. # Description : Specify "True" to configure and enable Oracle Database vault 337. # Valid values : True/False 338. # Default value : False 339. # Mandatory : No 340. #----------------------------------------------------------------------------- 341. dvConfiguration= 342. 343. #----------------------------------------------------------------------------- 344. # Name : dvUserName 345. # Datatype : String 346. # Description : DataVault Owner 347. # Valid values : Check Oracle12c Administrator's Guide 348. # Default value : None 349. # Mandatory : Yes, if DataVault option is chosen 350. #----------------------------------------------------------------------------- 351. dvUserName= 352. 353. #----------------------------------------------------------------------------- 354. # Name : dvUserPassword 355. # Datatype : String 356. # Description : Password for DataVault Owner 357. # Valid values : Check Oracle12c Administrator's Guide 358. # Default value : None 359. # Mandatory : Yes, if DataVault option is chosen 360. #----------------------------------------------------------------------------- 361. dvUserPassword= 362. 363. #----------------------------------------------------------------------------- 364. # Name : dvAccountManagerName 365. # Datatype : String 366. # Description : DataVault Account Manager 367. # Valid values : Check Oracle12c Administrator's Guide 368. # Default value : None 369. # Mandatory : No 370. #----------------------------------------------------------------------------- 371. dvAccountManagerName= 372. 373. #----------------------------------------------------------------------------- 374. # Name : dvAccountManagerPassword 375. # Datatype : String 376. # Description : Password for DataVault Account Manager 377. # Valid values : Check Oracle12c Administrator's Guide 378. # Default value : None 379. # Mandatory : No 380. #----------------------------------------------------------------------------- 381. dvAccountManagerPassword= 382. 383. #----------------------------------------------------------------------------- 384. # Name : olsConfiguration 385. # Datatype : Boolean 386. # Description : Specify "True" to configure and enable Oracle Label Security 387. # Valid values : True/False 388. # Default value : False 389. # Mandatory : No 390. #----------------------------------------------------------------------------- 391. olsConfiguration= 392. 393. #----------------------------------------------------------------------------- 394. # Name : datafileJarLocation 395. # Datatype : String 396. # Description : Location of the data file jar 397. # Valid values : Directory containing compressed datafile jar 398. # Default value : None 399. # Mandatory : No 400. #----------------------------------------------------------------------------- 401. datafileJarLocation= 402. 403. #----------------------------------------------------------------------------- 404. # Name : datafileDestination 405. # Datatype : String 406. # Description : Location of the data file's 407. # Valid values : Directory for all the database files 408. # Default value : $ORACLE_BASE/oradata 409. # Mandatory : No 410. #----------------------------------------------------------------------------- 411. datafileDestination= 412. 413. #----------------------------------------------------------------------------- 414. # Name : recoveryAreaDestination 415. # Datatype : String 416. # Description : Location of the data file's 417. # Valid values : Recovery Area location 418. # Default value : $ORACLE_BASE/flash_recovery_area 419. # Mandatory : No 420. #----------------------------------------------------------------------------- 421. recoveryAreaDestination= 422. 423. #----------------------------------------------------------------------------- 424. # Name : storageType 425. # Datatype : String 426. # Description : Specifies the storage on which the database is to be created 427. # Valid values : FS (CFS for RAC), ASM 428. # Default value : FS 429. # Mandatory : No 430. #----------------------------------------------------------------------------- 431. storageType= 432. 433. #----------------------------------------------------------------------------- 434. # Name : diskGroupName 435. # Datatype : String 436. # Description : Specifies the disk group name for the storage 437. # Default value : DATA 438. # Mandatory : No 439. #----------------------------------------------------------------------------- 440. diskGroupName= 441. 442. #----------------------------------------------------------------------------- 443. # Name : asmsnmpPassword 444. # Datatype : String 445. # Description : Password for ASM Monitoring 446. # Default value : None 447. # Mandatory : No 448. #----------------------------------------------------------------------------- 449. asmsnmpPassword= 450. 451. #----------------------------------------------------------------------------- 452. # Name : recoveryGroupName 453. # Datatype : String 454. # Description : Specifies the disk group name for the recovery area 455. # Default value : RECOVERY 456. # Mandatory : No 457. #----------------------------------------------------------------------------- 458. recoveryGroupName= 459. 460. #----------------------------------------------------------------------------- 461. # Name : characterSet 462. # Datatype : String 463. # Description : Character set of the database 464. # Valid values : Check Oracle12c National Language Support Guide 465. # Default value : "US7ASCII" 466. # Mandatory : NO 467. #----------------------------------------------------------------------------- 468. characterSet= 469. 470. #----------------------------------------------------------------------------- 471. # Name : nationalCharacterSet 472. # Datatype : String 473. # Description : National Character set of the database 474. # Valid values : "UTF8" or "AL16UTF16". For details, check Oracle12c National Language Support Guide 475. # Default value : "AL16UTF16" 476. # Mandatory : No 477. #----------------------------------------------------------------------------- 478. nationalCharacterSet= 479. 480. #----------------------------------------------------------------------------- 481. # Name : registerWithDirService 482. # Datatype : Boolean 483. # Description : Specifies whether to register with Directory Service. 484. # Valid values : TRUE \ FALSE 485. # Default value : FALSE 486. # Mandatory : No 487. #----------------------------------------------------------------------------- 488. registerWithDirService= 489. 490. 491. #----------------------------------------------------------------------------- 492. # Name : dirServiceUserName 493. # Datatype : String 494. # Description : Specifies the name of the directory service user 495. # Mandatory : YES, if the value of registerWithDirService is TRUE 496. #----------------------------------------------------------------------------- 497. dirServiceUserName= 498. 499. #----------------------------------------------------------------------------- 500. # Name : dirServicePassword 501. # Datatype : String 502. # Description : The password of the directory service user. 503. # You can also specify the password at the command prompt instead of here. 504. # Mandatory : YES, if the value of registerWithDirService is TRUE 505. #----------------------------------------------------------------------------- 506. dirServicePassword= 507. 508. #----------------------------------------------------------------------------- 509. # Name : walletPassword 510. # Datatype : String 511. # Description : The password for wallet to created or modified. 512. # You can also specify the password at the command prompt instead of here. 513. # Mandatory : YES, if the value of registerWithDirService is TRUE 514. #----------------------------------------------------------------------------- 515. walletPassword= 516. 517. #----------------------------------------------------------------------------- 518. # Name : listeners 519. # Datatype : String 520. # Description : Specifies list of listeners to register the database with. 521. # By default the database is configured for all the listeners specified in the 522. # $ORACLE_HOME/network/admin/listener.ora 523. # Valid values : The list should be comma separated like "listener1,listener2". 524. # Mandatory : NO 525. #----------------------------------------------------------------------------- 526. listeners= 527. 528. #----------------------------------------------------------------------------- 529. # Name : variablesFile 530. # Datatype : String 531. # Description : Location of the file containing variable value pair 532. # Valid values : A valid file-system file. The variable value pair format in this file 533. # is <variable>=<value>. Each pair should be in a new line. 534. # Default value : None 535. # Mandatory : NO 536. #----------------------------------------------------------------------------- 537. variablesFile= 538. 539. #----------------------------------------------------------------------------- 540. # Name : variables 541. # Datatype : String 542. # Description : comma separated list of name=value pairs. Overrides variables defined in variablefile and templates 543. # Default value : None 544. # Mandatory : NO 545. #----------------------------------------------------------------------------- 546. variables= 547. 548. #----------------------------------------------------------------------------- 549. # Name : initParams 550. # Datatype : String 551. # Description : comma separated list of name=value pairs. Overrides initialization parameters defined in templates 552. # Default value : None 553. # Mandatory : NO 554. #----------------------------------------------------------------------------- 555. initParams= 556. 557. #----------------------------------------------------------------------------- 558. # Name : sampleSchema 559. # Datatype : Boolean 560. # Description : Specifies whether or not to add the Sample Schemas to your database 561. # Valid values : TRUE \ FALSE 562. # Default value : FASLE 563. # Mandatory : No 564. #----------------------------------------------------------------------------- 565. sampleSchema= 566. 567. #----------------------------------------------------------------------------- 568. # Name : memoryPercentage 569. # Datatype : String 570. # Description : percentage of physical memory for Oracle 571. # Default value : None 572. # Mandatory : NO 573. #----------------------------------------------------------------------------- 574. memoryPercentage= 575. 576. #----------------------------------------------------------------------------- 577. # Name : databaseType 578. # Datatype : String 579. # Description : used for memory distribution when memoryPercentage specified 580. # Valid values : MULTIPURPOSE|DATA_WAREHOUSING|OLTP 581. # Default value : MULTIPURPOSE 582. # Mandatory : NO 583. #----------------------------------------------------------------------------- 584. databaseType= 585. 586. #----------------------------------------------------------------------------- 587. # Name : automaticMemoryManagement 588. # Datatype : Boolean 589. # Description : flag to indicate Automatic Memory Management is used 590. # Valid values : TRUE/FALSE 591. # Default value : TRUE 592. # Mandatory : NO 593. #----------------------------------------------------------------------------- 594. automaticMemoryManagement= 595. 596. #----------------------------------------------------------------------------- 597. # Name : totalMemory 598. # Datatype : String 599. # Description : total memory in MB to allocate to Oracle 600. # Valid values : 601. # Default value : 602. # Mandatory : NO 603. #----------------------------------------------------------------------------- 604. totalMemory=
参考:
Oracle Database 12.2 静默安装 - bret_chen - 博客园 (cnblogs.com)