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

[问题]出现这个问题应该是listener.ora 里面配置的IP地址变了，所以无法启动该服务。[b]listener.ora里面的ip地址要和你 hosts表中的本地ip地址一致,否则listener 是起不来的。[/b]其实也可以不用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这行是被注释掉的。将注释去掉让其生效应该也能解决此问题(未测试)。