centos 中listener无法启动

flyabout

各位有搞过centos的没有,我这里有一套,装了10g后,曾经配过域名,后来把域名取消了,但是listenerr怎么都起不来,不知道为何.

TNSLSNR for Linux: Version 10.2.0.3.0 - Production
System parameter file is /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /opt/oracle/product/10.2.0/db_1/network/log/listener.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.166.100)(PORT=1521)))
TNS-12560: TNS:protocol adapter error
TNS-00583: Valid node checking: unable to parse configuration parameters


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

#listener.ora
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = orcl100)
      (ORACLE_HOME = /opt/oracle/product/10.2.0/db_1)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.166.100)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )

#tnnsnames.ora

ORCL100 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.166.100)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl100)
    )
  )

#/etc/hosts# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1       localhost   loopback
192.168.166.100   dev100

blue_stone

删除listener.ora, 重新运行netca试一下, 可能是你的配置文件有问题.