Oracle连接错误如下:An error occurred while establishing the connection:
Type: java.sql.SQLException Error Code: 17002
应该是listener出问题了,我以为是昨天我查看listener.ora文件时不小心改动了,于是我通过Net configuration Assistant删掉了listener然后重建了一个,重建后listener.ora文件内容如下,但是还是连接不上,报同样的错误,这个有什么问题吗?
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\orcale10g)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
Type: java.sql.SQLException Error Code: 17002
应该是listener出问题了,我以为是昨天我查看listener.ora文件时不小心改动了,于是我通过Net configuration Assistant删掉了listener然后重建了一个,重建后listener.ora文件内容如下,但是还是连接不上,报同样的错误,这个有什么问题吗?
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\orcale10g)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
解决方案 »
- 麻烦大家推荐一本 经典的oracle olap 开发方面的书籍!谢谢大家
- 程序包或函数处于无效状态
- merge into的问题
- 请问有oracle漏洞扫描工具吗?
- 通过内连接得到的结果集,用where限制了时间段,为什么在group by后会出现where条件之外的时间
- oracle中用户的表的删除与新增
- 求助 ORA-271000:shared memory realm already exists(已有答案)的解决方法
- 关于两台服务器上的trigger问题?请大家帮帮忙
- 请问怎样将NULL字段转换为数字字段?
- 请问关于Long型
- ORA-01552: 非系统表空间 'USERS' 不能使用系统回退段
- 【原创】【最详细】Oracle在RHEL4或5下安装指南 下载
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)把localhost 换成你的计算机全名试试