lsnrctl stat 不能启动

XUWENCHAO

$ lsnrctl stat

LSNRCTL for HPUX: Version 9.2.0.1.0 - Production on 04-JUL-2004 09:55:11

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   HPUX Error: 239: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rbtest)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   HPUX Error: 239: Connection refused

XUWENCHAO

数据库可以启动！就是监听不行！

singledream

listener.ora 是怎么配的?

realsun

我觉得可能是协议的原因，我们一般只需要TCP协议，可以把其他协议去掉，然后再试一下！

XUWENCHAO

listener.ora  配置

# LISTENER.ORA Network Configuration File: /u01/OraHome1/network/admin/listener.
ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = rbtest)(PORT = 1521))
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/OraHome1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = snow)
      (ORACLE_HOME = /u01/OraHome1)
      (SID_NAME = snow)
    )
  )

jwen

端口没有被占吧？

pearaep

lsnrctl start 时出什么错误？？？

hecm23

执行lsnrctl start

XUWENCHAO

晕！自己又好了！不知道怎么回事！我什么操作都没有做！
错误提示如下：请各大家帮忙分析一下！
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
HPUX Error: 239: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rbtest)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
HPUX Error: 239: Connection refused

realsun

这个问题应该就是协议的问题你把前两个不用的协议删掉就可以了！