listener问题1:监听状态:
C:\>lsnrctl statusLSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 27-7月 -2007 21:39:24Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
TNS-12541: TNS:无监听器
TNS-12560: TNS: 协议适配器错误
TNS-00511: 无监听器
32-bit Windows Error: 2: No such file or directory
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=lsc)(PORT=1521)))
TNS-12560: TNS: 协议适配器错误
TNS-00530: 协议适配器错误
32-bit Windows Error: 57: Unknown errorC:\>
2.我看了是windows下listerner的服务没有启动
3.我手工启动,但是提示如下错误
本地计算机事实能够的OracleOraHome92TNSListener服务启动后又停止了。一些服务自动停止,如果它们没有什么可做的,例如“性能日志和警报”服务。
4.我检查注册表中ImagePath的值是正确的.大家帮我看看怎么回事啊??
C:\>lsnrctl statusLSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 27-7月 -2007 21:39:24Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
TNS-12541: TNS:无监听器
TNS-12560: TNS: 协议适配器错误
TNS-00511: 无监听器
32-bit Windows Error: 2: No such file or directory
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=lsc)(PORT=1521)))
TNS-12560: TNS: 协议适配器错误
TNS-00530: 协议适配器错误
32-bit Windows Error: 57: Unknown errorC:\>
2.我看了是windows下listerner的服务没有启动
3.我手工启动,但是提示如下错误
本地计算机事实能够的OracleOraHome92TNSListener服务启动后又停止了。一些服务自动停止,如果它们没有什么可做的,例如“性能日志和警报”服务。
4.我检查注册表中ImagePath的值是正确的.大家帮我看看怎么回事啊??
解决方案 »
- oracle查询表空间问题
- oracle 10g express edition启动问题
- linux redhat 4 安装了oracle9.2.0.4 数据库表信息为乱码
- 求sql 在线等
- oracle long raw
- oracle developer访问数据库问题
- ORACLE的session方面的问题,大家指点
- ORACLE 参数的设置问题(在线等)
- sql/plus语句问题求教
- 根据身份证号,性别查询查女性年龄超过55周岁的,男性年龄超过60周岁的
- dos 下创建表空间 为啥在enterprise manager console 里看不到啊?
- 大家好,请问两个sql查询语句问题。谢谢
# Generated by Oracle configuration tools.BCSWT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bluecard-7cc1a4)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = BCSWT)
)
)BC7.93 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.93)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = bscheck)
)
)INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bluecard-7cc1a4)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
listener 的配置文件是 listener.ora ,上面也报错“No such file or directory ”,请你检查下这个文件是否存在。如果存在,试试 lsnrctl start listenr_name
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bluecard-7cc1a4)(PORT = 1521))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = BCSWT)
(ORACLE_HOME = E:\oracle\ora92)
(SID_NAME = BCSWT)
)
)