用oracle 11g时遇到一下问题，我是xp系统的，监听器我已经启动，请问该如何解决，麻烦说详细点

Question

2011-10-22 11:16:53 oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
配置: ORA-12541: TNS: 无监听程序

oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-12541: TNS: 无监听程序

at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeSql(SQLEngine.java:1903)
at oracle.sysman.emcp.ParamsManager.checkListenerStatusForDBControl(ParamsManager.java:3230)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:204)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:158)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:590)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1453)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522)
2011-10-22 11:16:53 oracle.sysman.emcp.EMConfig perform
严重: 监听程序未启动或数据库服务未注册到该监听程序。启动该监听程序并注册数据库服务, 然后重新运行 EM Configuration Assistant。
有关详细资料, 请参阅 D:\app\Administrator\cfgtoollogs\emca\orcl\emca_2011_10_22_11_16_21.log 中的日志文件。
2011-10-22 11:16:53 oracle.sysman.emcp.EMConfig perform
配置: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: 监听程序未启动或数据库服务未注册到该监听程序。启动该监听程序并注册数据库服务, 然后重新运行 EM Configuration Assistant。
at oracle.sysman.emcp.ParamsManager.checkListenerStatusForDBControl(ParamsManager.java:3245)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:204)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:158)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:590)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1453)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522)
2011-10-22 11:16:53 oracle.sysman.emcp.EMConfig restoreOuiLoc
配置: Restoring oracle.installer.oui_loc to D:\app\Administrator\product\11.2.0\dbhome_1\oui

Answer 1

登录pl/sql出现错误：ORA-12541:TNS:无监听程序。
解决办法
1. 检查oracleproduct10.1.0db_1NETWORKloglistener.log：
TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Production on 04-1月 -2010 13:38:34

Copyright (c) 1991, 2004, Oracle. All rights reserved.

系统参数文件为D:oracleproduct10.1.0db_1networkadminlistener.ora
写入D:oracleproduct10.1.0db_1networkloglistener.log的日志信息
写入D:oracleproduct10.1.0db_1networktracelistener.trc的跟踪信息
跟踪级别当前为0

以 pid=7180 开始
监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.pipeEXTPROCipc)))
监听该对象时出错: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=pc-xxx.mail.yyy.cn)(PORT=1521)))
TNS-12542: TNS: 地址已被占用
TNS-12560: TNS: 协议适配器错误
TNS-00512: 地址已在使用
32-bit Windows Error: 48: Unknown error
不再监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.pipeEXTPROCipc)))
2. Oracle的listener已经启动。
3. 查看oracleproduct10.1.0db_1NETWORKADMINlistener.ora
# listener.ora Network Configuration File: D:oracleproduct10.1.0db_1networkadminlistener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:oracleproduct10.1.0db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = pc-xxx.mail.yyy.cn)(PORT = 1521))
)
)
)

把(ADDRESS = (PROTOCOL = TCP)(HOST = pc-xxx.mail.yyy.cn)(PORT = 1521))
改为(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
pc-xxx.mail.yyy.cn是计算机名
127.0.0.1也就是目前数据库正在用的ip地址。
4. 查看oracleproduct10.1.0db_1NETWORKADMINtnsnames.ora
找到下列语句：
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = pc-xxx.mail.yyy.cn)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
将(ADDRESS = (PROTOCOL = TCP)(HOST = pc-xxx.mail.yyy.cn)(PORT = 1521))
改为(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
5. 关闭后再启动listener
运行->cmd启动dos窗口，执行lsnrctl stop关闭，lsnrctl start启动。

Answer 2

TNS:无监听程序。
该问题无非就是一下几个原因
1、监听是否启动
2、监听配置是否正确
3、端口是否被占用
以下这个是我遇到的，你可以看看
http://hi.baidu.com/songyl525/blog/item/f3a891081a124acd63d986b3.html

Answer 3

lsnrctl status
lsnrctl start

输出是什么

Answer 4

xp可以安装么？应该要换别的系统吧。