请高手指导！！！TNS-01150: oracle监听启动失败，在线等！！！！！

yinian9826

请高手指导一下！！！！

# LISTENER.ORA Network Configuration File: /opt/oracle/product/9.2/network/admin/listener.ora
# Generated by Oracle configuration tools.
ORA92 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.26)(PORT = 1521)
)
      )
    )
  )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = ora92)
      (ORACLE_HOME = /opt/oracle/product/9.2)
    )
  )
LOGGING_LISTENER = OFF


目前情况是：
双机启动是oracle listener资源启动失败，
显示[SUNWscor.oracle_listener.start]ra_rgra_listener: [ID 847065 user.error] Failed to start listener ORA92.

报错如下：
TNSLSNR for Solaris: Version 9.2.0.8.0 - Production
System parameter file is /opt/oracle/product/9.2/network/admin/listener.ora
Log messages written to /opt/oracle/product/9.2/network/log/ora92.log
TNS-01150: The address of the specified listener name is incorrect

Listener failed to start. See the error message(s) above...

但这个时候监听确实可用的：
lsnrctl status
LSNRCTL for Solaris: Version 9.2.0.8.0 - Production on 07-5月 -2008 18:18:10

Copyright (c) 1991, 2006, Oracle Corporation.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 9.2.0.8.0 - Production
Start Date                07-5月 -2008 16:52:08
Uptime                    0 days 1 hr. 26 min. 1 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /opt/oracle/product/9.2/network/admin/listener.ora
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.26)(PORT=1521)))
Services Summary...
Service "ora92" has 2 instance(s).
  Instance "ora92", status UNKNOWN, has 1 handler(s) for this service...
  Instance "ora92", status READY, has 1 handler(s) for this service...
The command completed successfully

blue_stone

为什么有：

1. 
   
2. ORA92 =
   

复制代码

默认不是LISTENER么？

yinian9826

这个应该没关系的啊。

lrx

The address of the specified listener name is incorrect

把 ORA92= 改成 LISTENER= 會怎樣?

feiyun22

或者把SID_LIST_LISTENER 改成SID_LIST_ORA92

flutter

我补充整理一下，listener.ora里创建的每个listener对应2个部分，分别是：

NAME=

和

SID_LIST_NAME=

     两个部分名称name必须一致，LZ估计是手工修改了名称。