在一个SAP业务的应用中,数据库正常重启后,发现监听无法启动。报如题的错误。
bfbwapp3:orabwd 4> lsnrctl start
LSNRCTL for HPUX: Version 11.2.0.3.0 - Production on 11-JAN-2014 23:21:54
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Starting /oracle/BWD/11203/bin/tnslsnr: please wait...
TNSLSNR for HPUX: Version 11.2.0.3.0 - Production
System parameter file is /oracle/BWD/11203/network/admin/listener.ora
Log messages written to /oracle/BWD/saptrace/diag/tnslsnr/bfbwapp3/listener/alert/log.xml
TNS-01150: The address of the specified listener name is incorrect
Listener failed to start. See the error message(s) above...
从错误信息看,监听的名称不正确。
检查一下是否有其他监听启动
bfbwapp3:orabwd 5>
bfbwapp3:orabwd 5> ps -ef | grep tns
orabwd 5940 4928 0 23:22:13 pts/1 0:00 grep tns
没有其他的监听启动,进一步的检查监听的配置文件
################^M
# Filename......: listener.ora^M
# Created.......: created by SAP AG, R/3 Rel. >= 6.10^M
# Name..........:^M
# Date..........:^M
# @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $^M
################^M
ADMIN_RESTRICTIONS_LISTENER = on^M
LISTENER =^M (ADDRESS_LIST =^M (ADDRESS =^M (PROTOCOL = IPC)^M (KEY = BWD.WORLD)^M )^M (A