关于新数据库配置DBCA后无法静默执行DBCA提示监听程序问题

关于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%已完成

当然我这里的小于恢复区大小可以再改。

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值