灿烂的阳光,苦涩的生活,认真做,你能行!
连接数据库报错
上一篇 /
下一篇 2008-12-16 16:26:00
/ 个人分类:数据库
连接数据库报错
java.sql.SQLException: The Network Adapter could not establish the connection
用sqlplus 连接数据库可以连上
java连接时报错。
用ip地址作连接,防火墙以关/
管理工具--> 服务 中启动OracleOraDb10g_home1TNSListener服务后再刷新看该服务是否还显示为“已启动”。
9i2我把C:\oracle\ora92\network\admin目录下的listener.ora和tnsnames.ora文件中的HOST全部改为:HOST = 127.0.0.1 就好了,我以前遇见过这种情况。
# LISTENER.ORA Network Configuration File: C:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DEscrīptION_LIST =
(DEscrīptION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = tfpc)
(ORACLE_HOME = C:\oracle\ora92)
(SID_NAME = tfpc)
)
)
**********************
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
TFPC =
(DEscrīptION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tfpc)
)
)
INST1_HTTP =
(DEscrīptION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA =
(DEscrīptION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
telnet localhost 1521
然后什么都不显示
lz这样:开始--> 运行--> cmd--> netstat -na
找找里面有没有如下一行:
TCP 127.0.0.1:1521 0.0.0.0:0 LISTENING
嗯,不错,换成ip地址就没错了!
真不明白是自己的ip地址和localhost或127.0.0.1有什么区别?
相关阅读:
- Oracle SQL 性能优化技巧 (51testing, 2007-4-13)
- 一道经典的数据库的笔试题目 (m_r3326, 2008-12-08)
- 如何对Oracle进行健康检查 (fishy, 2008-12-08)
- 拓宽思路,几道经典的SQL笔试题目 (m_r3326, 2008-12-09)
- MaxDB数据库和MySQL数据库的主要差别 (fishy, 2008-12-09)
- Oracle数据库设计要做到五戒 (fishy, 2008-12-10)
- 实例之Visual C#中实现DB2数据库的编程 (fishy, 2008-12-11)
- SQL Server 2008 中数据收集器和管理数据仓库 (fishy, 2008-12-12)
- 〔转贴〕Oracle SQL性能优化 (yangmei1985, 2008-12-15)
- Oracle SQL性能优化 (fishy, 2008-12-16)
收藏
举报
TAG:
数据库