TNS Ping Utility for 32-bit Windows: Version 11.1.0.6.0 - Production on 12-11月- 2009 17:01:56Copyright (c) 1997, 2007, Oracle. All rights reserved.已使用的参数文件: F:\app\wangdong\product\11.1.0\db_1\network\admin\sqlnet.ora 已使用 TNSNAMES 适配器来解析别名 Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.104)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ORCL))) TNS-12541: TNS: 无监听程序
监听是已启动.. C:\Documents and Settings\Administrator>lsnrctl startLSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 12-11月-2009 17:0 8:04Copyright (c) 1991, 2007, Oracle. All rights reserved.启动tnslsnr: 请稍候...Service OracleOraDb11g_home1TNSListener already running. TNS-12560: TNS: 协议适配器错误 TNS-00530: 协议适配器错误
lsnrctl stop lsnrctl start
我试下,说协议有错. C:\Documents and Settings\Administrator>lsnrctl stopLSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 12-11月-2009 17: 3:38Copyright (c) 1991, 2007, Oracle. All rights reserved.正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.104)(PORT=1521))TNS-12541: TNS: 无监听程序 TNS-12560: TNS: 协议适配器错误 TNS-00511: 无监听程序 32-bit Windows Error: 61: Unknown errorC:\Documents and Settings\Administrator>lsnrctl startLSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 12-11月-2009 17: 3:46Copyright (c) 1991, 2007, Oracle. All rights reserved.启动tnslsnr: 请稍候...Service OracleOraDb11g_home1TNSListener already running. TNS-12560: TNS: 协议适配器错误 TNS-00530: 协议适配器错误
ORA-12541 : NTS : NO LISTENER 监听启动没有?
# Generated by Oracle configuration tools.ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.104)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)# listener.ora Network Configuration File: F:\app\wangdong\product\11.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = PC-200901052256)(PORT = 1521))
)
)
能否ping通
TNS Ping Utility for 32-bit Windows: Version 11.1.0.6.0 - Production on 12-11月-
2009 17:01:56Copyright (c) 1997, 2007, Oracle. All rights reserved.已使用的参数文件:
F:\app\wangdong\product\11.1.0\db_1\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 192.168.1.104)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ORCL)))
TNS-12541: TNS: 无监听程序
C:\Documents and Settings\Administrator>lsnrctl startLSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 12-11月-2009 17:0
8:04Copyright (c) 1991, 2007, Oracle. All rights reserved.启动tnslsnr: 请稍候...Service OracleOraDb11g_home1TNSListener already running.
TNS-12560: TNS: 协议适配器错误
TNS-00530: 协议适配器错误
lsnrctl start
C:\Documents and Settings\Administrator>lsnrctl stopLSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 12-11月-2009 17:
3:38Copyright (c) 1991, 2007, Oracle. All rights reserved.正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.104)(PORT=1521))TNS-12541: TNS: 无监听程序
TNS-12560: TNS: 协议适配器错误
TNS-00511: 无监听程序
32-bit Windows Error: 61: Unknown errorC:\Documents and Settings\Administrator>lsnrctl startLSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 12-11月-2009 17:
3:46Copyright (c) 1991, 2007, Oracle. All rights reserved.启动tnslsnr: 请稍候...Service OracleOraDb11g_home1TNSListener already running.
TNS-12560: TNS: 协议适配器错误
TNS-00530: 协议适配器错误