"OracleOraDb10g_Home1TNSListener服务启动后又停止了。一些服务自动停止，如果它们没有什么可做的“性能日志和警报”"问题解决办法

[问题]出现这个问题应该是listener.ora 里面配置的IP地址变了，所以无法启动该服务。listener.ora里面的ip地址要和你 hosts表中的本地ip地址一致,否则listener 是起不来的。其实也可以不用Ip地址，直接用主机名，这样就不怕ip地址改变了。

# listener.ora Network Configuration File: F:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = F:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
  )

-------------------------------------------------------------------------------------------------------------

#Address:C:\WINDOWS\system32\drivers\etc\hosts

# Copyright (c) 1993-1999 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
#      102.54.94.97     rhino.acme.com          # source server
#       38.25.63.10     x.acme.com              # x client host

127.0.0.1       localhost

本文转载自：http://x.iny.a.blog.163.com/blog/static/12702573220107293414914/

我的问题是将listener.ora文件中host由127.0.0.1改为主机名解决的，打开hosts文件后发现127.0.0.1       localhost这行是被注释掉的。将注释去掉让其生效应该也能解决此问题(未测试)。