关于Oracle 12c静默创建DBCA实例时会提示问题:
[oracle@localhost ~]$ dbca -silent -createDatabase -responseFile /home/oracle/oradb/database/response/dbca.rsp
[FATAL] [DBT-07505] 所选监听程序 (LISTENER) 不存在。
操作: 指定现有监听程序。
[oracle@localhost ~]$ lsnrctl
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 19-4月 -2020 11:54:58
Copyright (c) 1991, 2016, Oracle. All rights reserved.
欢迎来到LSNRCTL, 请键入"help"以获得信息。
LSNRCTL> status
正在连接到 (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
LISTENER 的 STATUS
------------------------
别名 LISTENER
版本 TNSLSNR for Linux: Version 12.2.0.1.0 - Production
启动日期 19-4月 -2020 11:04:55
正常运行时间 0 天 0 小时 50 分 5 秒
跟踪级别 off
安全性 ON: Local OS Authentication
SNMP OFF
监听程序日志文件 /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
监听端点概要...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
监听程序不支持服务
命令执行成功
LSNRCTL>
需要查一下netca.rsp文件是否正确配置了:
[oracle@localhost ~]$ vim /home/oracle/oradb/database/response/netca.rsp
# Datatype : Boolean
# Description: This variable controls appearance/suppression of the NetCA GUI,
# Pre-req : N/A
# Default : TRUE
# Note:
# This must be set to false in order to run NetCA in silent mode.
# This is a substitute of "/silent" flag in the NetCA command line.
# The command line flag has precedence over the one in this response file.
# This feature is present since 10.1.0.3.
45 #-------------------------------------------------------------------------------
46 SHOW_GUI=false
47
48 #-------------------------------------------------------------------------------
51 # Description: If present, NetCA will log output to this file in addition to the
52 # standard out.
53 # Pre-req : N/A
56 # This is a substitute of "/log" in the NetCA command line.
57 # The command line argument has precedence over the one in this response file.
58 # This feature is present since 10.1.0.3.
59 #-------------------------------------------------------------------------------
60 LOG_FILE=""/u01/app/oralnventory/listener_logs/netca.log""
61
62 [oracle.net.ca]
63 #INSTALLED_COMPONENTS;StringList;list of installed components
64 # The possible values for installed components are:
65 # "net8","server","client","aso", "cman", "javavm"
66 INSTALLED_COMPONENTS={"server","net8","javavm"}
67
68 #INSTALL_TYPE;String;type of install
69 # The possible values for install type are:
70 # "typical","minimal" or "custom"
71 INSTALL_TYPE=""typical""
72
73 #LISTENER_NUMBER;Number;Number of Listeners
74 # A typical install sets one listener
75 LISTENER_NUMBER=1
76
77 #LISTENER_NAMES;StringList;list of listener names
78 # The values for listener are:
79 # "LISTENER","LISTENER1","LISTENER2","LISTENER3", ...
80 # A typical install sets only "LISTENER"
81 LISTENER_NAMES={"LISTENER"}
82
84 # The possible values for listener protocols are:
85 # "TCP;1521","TCPS;2484","NMP;ORAPIPE","IPC;IPCKEY","VI;1521"
86 # For multiple listeners, separate them with commas ex "TCP;1521","TCPS;2484"
88 # A typical install sets only "TCP;1521"
89 LISTENER_PROTOCOLS={"TCP;1521"}
90
93
96 # LDAP, TNSNAMES, ONAMES, HOSTNAME, NOVELL, NIS, DCE
97 # A typical install sets only: "TNSNAMES","ONAMES","HOSTNAMES"
98 # or "LDAP","TNSNAMES","ONAMES","HOSTNAMES" for LDAP
99 NAMING_METHODS={"TNSNAMES","ONAMES","HOSTNAME"}
100
101 #NOVELL_NAMECONTEXT;String;Novell Directory Service name context, in double quotes
102 # A typical install does not use this variable.
103 #NOVELL_NAMECONTEXT = ""NAMCONTEXT""
104
105 #SUN_METAMAP;String; SUN meta map, in double quotes
106 # A typical install does not use this variable.
107 #SUN_METAMAP = ""MAP""
108
109 #DCE_CELLNAME;String;DCE cell name, in double quotes
110 # A typical install does not use this variable.
111 #DCE_CELLNAME = ""CELL""
112
113 #NSN_NUMBER;Number;Number of NetService Names
114 # A typical install sets one net service name
115 NSN_NUMBER=1
116
117 #NSN_NAMES;StringList;list of Net Service names
118 # A typical install sets net service name to "EXTPROC_CONNECTION_DATA"
119 NSN_NAMES={"EXTPROC_CONNECTION_DATA"}
120
121 #NSN_SERVICE;StringList;Oracle12c database's service name
122 # A typical install sets Oracle12c database's service name to "PLSExtProc"
123 NSN_SERVICE={"PLSExtProc"}
124
125 #NSN_PROTOCOLS;StringList;list of coma separated strings of Net Service Name protocol par ameters
126 # The possible values for net service name protocol parameters are:
127 # "TCP;HOSTNAME;1521","TCPS;HOSTNAME;2484","NMP;COMPUTERNAME;ORAPIPE","VI;HOSTNAME;1521", "IPC;IPCKEY"
128 # A typical install sets parameters to "IPC;EXTPROC"
129 NSN_PROTOCOLS={"TCP;HOSTNAME;1521"}
130
131 #SERVICEUSERPASSWORD;String;Windows service user password
132 # If the oracle home is installed as secure user, supply the password
133 #SERVICEUSERPASSWORD=""svcpassword""
134
配置新数据库后一定要执行netca文件:
[oracle@localhost ~]$ netca -silent -responseFile /home/oracle/oradb/database/response/netca.rsp
Sun Apr 19 12:13:52 CST 2020 Oracle Net Configuration Assistant
正在对命令行参数进行语法分析:
参数"silent" = true
参数"responsefile" = /home/oracle/oradb/database/response/netca.rsp
参数"log" = /u01/app/oralnventory/listener_logs/netca.log
完成对命令行参数进行语法分析。
Oracle Net Services 配置:
完成概要文件配置。
Oracle Net 监听程序启动:
正在运行监听程序控制:
/u01/app/oracle/product/12/db_1/bin/lsnrctl start LISTENER
监听程序控制完成。
监听程序已成功启动。
监听程序配置完成。
成功完成 Oracle Net Services 配置。退出代码是0
[oracle@localhost ~]$
完成netca后 再执行静默安装Oracle12C这篇文章里的dbca实例执行操作就可以正常执行DBCA文件了:
[oracle@localhost ~]$ dbca -silent -createDatabase -responseFile /home/oracle/oradb/database/response/dbca.rsp
[WARNING] [DBT-11209] 当前的可用物理内存低于创建数据库所需的物理内存 (796MB)。
[WARNING] [DBT-06801] 指定的快速恢复区大小 (8,340 MB) 小于建议值。
原因: 快速恢复区大小至少应为数据库大小 (3,571 MB) 的三倍。
操作: 指定的快速恢复区大小至少应为数据库大小的三倍。
复制数据库文件
1%已完成
13%已完成
25%已完成
正在创建并启动 Oracle 实例
26%已完成
30%已完成
31%已完成
35%已完成
38%已完成
当然我这里的小于恢复区大小可以再改。