服务器Centos7 静默安装Oracle Database 12.2(下)

简介: 服务器Centos7 静默安装Oracle Database 12.2(下)

六.创建 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)


七.创建数据目录


官方:为 Oracle 数据库文件创建目录

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)

oracle12c数据库安装(静默安装)_下雨天的太阳的博客-CSDN博客_oracle12c

https://blog.csdn.net/qq_39839075/article/details/89965348

目录
相关文章
|
13天前
|
SQL Oracle 关系型数据库
WARNING: Too Many Parse Errors With error=911 When Running a JDBC Application Connected to an Oracle 19c database
WARNING: Too Many Parse Errors With error=911 When Running a JDBC Application Connected to an Oracle 19c database (
19 2
|
4天前
|
SQL Oracle 关系型数据库
Connect to Autonomous Database Using Oracle Database Tools
Connect to Autonomous Database Using Oracle Database Tools
11 1
|
13天前
|
Linux 数据安全/隐私保护 Docker
在centos7虚拟机上安装docker oracle11g
在centos7虚拟机上安装docker oracle11g
33 0
|
13天前
|
网络协议 物联网 Linux
你不能不知道的:无公网IP,SSH远程连接CentOS服务器【内网穿透】
你不能不知道的:无公网IP,SSH远程连接CentOS服务器【内网穿透】
|
13天前
|
存储 安全 网络协议
云服务器 Centos7 部署 Elasticsearch 8.0 + Kibana 8.0 指南
云服务器 Centos7 部署 Elasticsearch 8.0 + Kibana 8.0 指南
41 0
|
13天前
|
Linux 网络安全 数据库
linux centos系统搭建samba文件服务器 NetBIOS解析 (超详细)
linux centos系统搭建samba文件服务器 NetBIOS解析 (超详细)
|
13天前
|
人工智能 Oracle 关系型数据库
一篇文章弄懂Oracle和PostgreSQL的Database Link
一篇文章弄懂Oracle和PostgreSQL的Database Link
|
13天前
|
安全 Linux 网络安全
记录_centos搭建ftp服务器
记录_centos搭建ftp服务器
21 0
|
13天前
|
运维 Apache 数据安全/隐私保护
CentOS6.5搭建SVN服务器(Apache+SVN)
CentOS6.5搭建SVN服务器(Apache+SVN)
|
Oracle 安全 关系型数据库
oracle10~11g在centos5~6版本上安装整体总结如下
1,oracle10g在centos/RedHat5~6主要的安装步骤,我主要记录核心的,别的在此就不多说了,都是些linux基本维护指令,关闭iptables,selinux,或是放行相应的端口,本地及互联网yum配置.
1068 0