在一个SAP业务的应用中，数据库正常重启后，发现监听无法启动。报如题的错误。

bfbwapp3:orabwd 4> lsnrctl start

LSNRCTL for HPUX: Version 11.2.0.3.0 - Production on 11-JAN-2014 23:21:54

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 (ADDRESS=^M (PROTOCOL = IPC)^M (KEY = BWD)^M )^M (ADDRESS =^M (COMMUN
ITY = SAP.WORLD)^M (PROTOCOL = TCP)^M (HOST = bfbwapp3)^M (PORT = 1527)^M )^M )^M
(ADDRESS_LIST =^M
        (ADDRESS =^M
          (PROTOCOL = IPC)^M
          (KEY = BWD.WORLD)^M
        )^M
        (ADDRESS=^M
          (PROTOCOL = IPC)^M
          (KEY = BWD)^M
        )^M
        (ADDRESS =^M
          (COMMUNITY = SAP.WORLD)^M
          (PROTOCOL = TCP)^M
          (HOST = bfbwapp3)^M
          (PORT = 1527)^M
        )^M
)^M
STARTUP_WAIT_TIME_LISTENER = 0^M
CONNECT_TIMEOUT_LISTENER = 10^M
TRACE_LEVEL_LISTENER = OFF^M
SID_LIST_LISTENER =^M (SID_LIST =^M (SID_DESC =^M (SID_NAME = BWD)^M (ORACLE_HOME = /oracle/BWD/11203)^M )^M )^M
(SID_LIST =^M
    (SID_DESC =^M
      (SID_NAME = BWD)^M
      (ORACLE_HOME = /oracle/BWD/11203)^M
    )^M
)^M
/

这个监听文件好乱啊，仔细检查发现几个问题

1）首先去掉^M这个符号

使用vi 然后输入 :%s/^M/ /g （这里要说明的是 ^M的输入是 Ctrl+V+M输入^M）

2）检查 listener name 和 sid_list_name 中两个名字是否一致

检查发现name一致

3）仔细检查监听文件

发现这段存在问题

SID_LIST_LISTENER =^M (SID_LIST =^M (SID_DESC =^M (SID_NAME = BWD)^M (ORACLE_HOME = /oracle/BWD/11203)^M )^M )^M
(SID_LIST =^M
    (SID_DESC =^M
      (SID_NAME = BWD)^M
      (ORACLE_HOME = /oracle/BWD/11203)^M
    )^M
)^M

两端SID_LIST内容完全一致，删除其中一部分，这个问题就解决了。

修改后的配置文件

bfbwapp3:orabwd 35> cat listener.ora
################
# Filename......: listener.ora
# Created.......: created by SAP AG, R/3 Rel. >= 6.10
# Name..........:
# Date..........:
# @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $
################
ADMIN_RESTRICTIONS_LISTENER = on
LISTENER =
(ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC) (KEY = BWD.WORLD) )
        (ADDRESS= (PROTOCOL = IPC) (KEY = BWD) ) (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = bfbwapp3) (PORT = 1527) )
)
(ADDRESS_LIST =
        (ADDRESS =
          (PROTOCOL = IPC)
          (KEY = BWD.WORLD)
        )
        (ADDRESS=
          (PROTOCOL = IPC)
          (KEY = BWD)
        )
        (ADDRESS =
          (COMMUNITY = SAP.WORLD)
          (PROTOCOL = TCP)
          (HOST = bfbwapp3)
          (PORT = 1527)
        )
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = BWD) (ORACLE_HOME = /oracle/BWD/11203) ) )
ADR_BASE_LISTENER = /oracle/BWD/saptrace
#----ADDED BY TNSLSNR 03-JAN-2014 11:14:44---
# PASSWORDS_LISTENER =   REMOVED BY TNSLSNR 03-JAN-2014 11:17:14
#--------------------------------------------

启动后的状态

bfbwapp3:orabwd 33> lsnrctl start

LSNRCTL for HPUX: Version 11.2.0.3.0 - Production on 11-JAN-2014 23:36:14

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
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=BWD.WORLD)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=BWD)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bfbwapp3)(PORT=1527)))

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=BWD.WORLD))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for HPUX: Version 11.2.0.3.0 - Production
Start Date                11-JAN-2014 23:36:17
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/BWD/11203/network/admin/listener.ora
Listener Log File         /oracle/BWD/saptrace/diag/tnslsnr/bfbwapp3/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=BWD.WORLD)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=BWD)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bfbwapp3)(PORT=1527)))
Services Summary...
Service "BWD" has 1 instance(s).
Instance "BWD", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

启动监听报TNS-01150错误处理