java、jdbc操作oracle数据库问题、求助啊!! 本帖最后由 wang920824 于 2011-11-02 12:59:46 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 把 localhost 换成 127.0.0.1 试下 看下product\11.1.0\db_1\NETWORK\ADMIN中的tnsnames.ora中配置ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )SERVICE_NAME 估计你写错了 SERVICE_NAME = orcl 没错的 你就写个url,你的驱动的名字driver name :oracle.jdbc.driver.OracleDriver这个天写了吗 哥曾经也遇到过,我还怀疑是myeclipse的问题,后来不了了之,求解释 看报的错误 是监听器没有监听到localhost的1521...检查你的oracle监听配置:listener.ora文件,看看监听配置是否正确LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST = WIN-BS0A72TT11V)(PORT = 1521)) ) )host最好配置为本机机器名防止你的系统的hosts里面对localhost或127.0.0.1做了映射监听器检查如果没有异常:那么就ping一下localhost看看指向的ip,然后查看对应ip地址的机器有没有开启1521端口一步步排查 这是我对应的tnsnames.ora的配置:SYSTEMOR = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = WIN-BS0A72TT11V)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SystemOral) ) )可以确定你的是监听的问题要看监听有没有启动,或者监听到你的localhost上面 我重新配置监听器 ,提示端口被占用了、可是我服务停了 netstat -an 也没看见1521啊 下面是我的listener.ora,# listener.ora Network Configuration File: D:\Software\Study\Oracle\app\Lin\product\11.2.0\dbhome_1\network\admin\listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = D:\Software\Study\Oracle\app\Lin\product\11.2.0\dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:D:\Software\Study\Oracle\app\Lin\product\11.2.0\dbhome_1\bin\oraclr11.dll") ) )LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = Lin-PC)(PORT = 1521)) ) )ADR_BASE_LISTENER = D:\Software\Study\Oracle\app\Lin 这是tnsnames.org# tnsnames.ora Network Configuration File: D:\Software\Study\Oracle\app\Lin\product\11.2.0\dbhome_1\network\admin\tnsnames.ora# Generated by Oracle configuration tools.ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) )ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Lin-PC)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) 以前也碰到过这样的问题,你是不是设置了Ipv6,设置了Ipv6会使得localhost解析出错 问题解决、原因 监听问题 、对于监听我没解决到,重装oracle 无法解决、 只有用了最狠的一招重装了系统 装了oracle 好了!! 哪位好心人有web上的文本、图片编辑控件啊 向数据库中放一张图片的问题 Form 提交方式get Url长度 急~~~ssh部署到Apache不能访问 急~~~~~jsp里如何在上传文件之前获得文件的大小呢? 救急! 关于jsp页面显示查询结果的问题。 急啊!!!一个菜鸟问题昨天提了没人回答!再发一遍,摆托!!!一定要帮忙啊!!! 如何从SERVLET中设置参数,在JSP中获得??? 是JSP的错还是JAVABEAN的错? 数据表中的内容包含回车换行符,如何显示内容时执行换行? 做软件是不是只要实现功能就好了,设计太复杂是不是也不好? 中文乱码啊 求助
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
SERVICE_NAME 估计你写错了
检查你的oracle监听配置:
listener.ora文件,看看监听配置是否正确
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = WIN-BS0A72TT11V)(PORT = 1521))
)
)host最好配置为本机机器名防止你的系统的hosts里面对localhost或127.0.0.1做了映射监听器检查如果没有异常:那么就ping一下localhost看看指向的ip,然后查看对应ip地址的机器有没有开启1521端口
一步步排查
SYSTEMOR =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = WIN-BS0A72TT11V)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SystemOral)
)
)可以确定你的是监听的问题要看监听有没有启动,或者监听到你的localhost上面
# listener.ora Network Configuration File: D:\Software\Study\Oracle\app\Lin\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\Software\Study\Oracle\app\Lin\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\Software\Study\Oracle\app\Lin\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = Lin-PC)(PORT = 1521))
)
)ADR_BASE_LISTENER = D:\Software\Study\Oracle\app\Lin
这是tnsnames.org
# tnsnames.ora Network Configuration File: D:\Software\Study\Oracle\app\Lin\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Lin-PC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)