我怀疑你有些概念不清楚:运行tnsping localhost提示没有监听器。也不能连接其他的Oracle数据库
1、tnsping 的是连接串,非localhoist.
2、TNSPING 本机监听器与本机的SQLPLUS能否连接别的数据库没有关系。
你首先需要检查要连接的数据库的监听器的状态:
F:\oracle\product\10.2.0\db_1\BIN>lsnrctl status listener10
LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 17-APR-2007 15:33:31
Copyright (c) 1991, 2006, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=cit-zhang-hf)(PORT=1529)))
STATUS of the LISTENER
------------------------
Alias listener10
Version TNSLSNR for 32-bit Windows: Version 10.2.0.3.0 - Production
Start Date 17-APR-2007 15:11:29
Uptime 0 days 0 hr. 22 min. 2 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File F:\oracle\product\10.2.0\db_1\network\admin\listener.ora
Listener Log File F:\oracle\product\10.2.0\db_1\network\log\listener10.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cit-zhang-hf.chinatelling.com)(PORT=1529)))
Services Summary...
Service "BTB" has 1 instance(s).
Instance "BTB", status UNKNOWN, has 1 handler(s) for this service...
Service "DOMAINUSER" has 1 instance(s).
Instance "DOMAINUSER", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
然后再TNSPING,最后再尝试连接数据库。