oracle新手求救，监听启动失败，请各位大侠帮帮忙（已解决）

achangmm

各位大侠，我的oracle9i的监听启动不了，提示如下：

[oracle@zqclinux admin]$ lsnrctl start

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 13-JUL-2008 17:11:34

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

Starting /opt/oracle/product/9.2.0/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 9.2.0.4.0 - Production
System parameter file is /opt/oracle/product/9.2.0/network/admin/listener.ora
Log messages written to /opt/oracle/product/9.2.0/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zqclinux)(PORT=1521)))
TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA
NL-00303: syntax error in NV string

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



listener.ora内容如下：

# LISTENER.ORA Network Configuration File: /opt/oracle/product/9.2.0/network/admin/listener
.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC4))
     )
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = zqclinux)(PORT = 1521))
     )
    )
   )
SID_LIST_LISTENER =
   (SID_LIST =
    (SID_DESC =
      (SID_NAME = ora9i)
      (ORACLE_HOME = /opt/oracle/product/9.2.0)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = oracle.zqc)
      (ORACLE_HOME = /opt/oracle/product/9.2.0)
      (SID_NAME = ora9i)
    )
   
帮帮我啊，先谢过了

[ 本帖最后由 achangmm 于 2008-7-14 17:55 编辑 ]

flutter

错误很明显,LISTENER.ORA文件有错误.估计是你手工修改过了.

   重新生成一个吧.

blue_stone

删除listener.ora文件, 看可否正常启动.

如果可以正常启动, 运行netca生成一个新的listener.ora文件
然后用netmgr增加新的需要监听的sid.

bty: 好像不应该是GLOBAL_DBNAME, 而应该是SID_NAME. GLOBAL_DBNAME应该在数据库的初始化参数文件中设置.

luffy.deng

改成如下
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC4))
     )
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = zqclinux)(PORT = 1521))
     )
    )
   )
SID_LIST_LISTENER =
   (SID_LIST =
    (SID_DESC =
      (SID_NAME = ora9i)
      (ORACLE_HOME = /opt/oracle/product/9.2.0)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = oracle.zqc)
      (ORACLE_HOME = /opt/oracle/product/9.2.0)
      (SID_NAME = ora9i)
    )
----------------------
注意 一个
LISTENERNAME
(
......
)
对应一个
SID_LIST_LISTENERNAME
(
....
)

flutter

LS说的对，标准格式,所以我要他 netca自己再创建一个

achangmm

谢谢楼上的各位大侠，已经解决，4楼的大哥说的对啊，我犯了个很明显错误，就是没有对应

再次感谢各位的帮助！