![]() |
|
||||||||||||||
| | 网站首页 | 数据库教程 | web编程 | 服务器 | 程序设计 | | ||
|
||
|
|||||
| 异常java.sql.sqlexception: io exception:the network adapter could not establish connection | |||||
作者:佚名 文章来源:不详 点击数: 更新时间:2007-7-7 ![]() |
|||||
|
正在装载数据…… Oracle Database Connection (from oracle.com)PROBLEM You are attempting to connect to an Oracle instance using JDBC and you are receiving the following error. java.sql.SQLException: Io exception: The Network Adapter could not establish connection SQLException: SQLState (null) vendor code (17002) Any or all of the following conditions may also apply: 1) You are able to establish a SQL*Plus connection from the same client to the same Oracle instance. 2) You are able to establish a JDBC OCI connection, but not a Thin connection from the same client to the same Oracle instance. 3) The same JDBC application is able to connect from a different client to the same Oracle instance. 4) The same behavior applies whether the initial JDBC connection string specifies a hostname or an IP address. REDISCOVERY To verify whether you are hitting this problem, verify whether the Oracle instance is configured for Multithreaded Server (MTS). If the Oracle instance is not configured for MTS, you are probably encountering a different problem. Otherwise, continue. Try forcing the JDBC connection to use a dedicated server instead of a shared server. This can be accomplished in several ways. For JDBC OCI or Thin, this can be done by reconfiguring the server for dedicated connections only. This approach, however, may not be feasible in many cases. In such cases, the following options apply: For JDBC OCI: 1) Add the (SERVER=DEDICATED) property to the TNS connect string stored in the tnsnames.ora file on the client. 2) Set the user_dedicated_server=ON in sqlnet.ora on the client.
|
|||||
| 文章录入:admin 责任编辑:admin | |||||
| 【发表评论】【加入收藏】【告诉好友】【打印此文】【关闭窗口】 | |||||
| 网友评论:(只显示最新10条。评论内容只代表网友观点,与本站立场无关!) |
| | 设为首页 | 加入收藏 | 联系站长 | 友情链接 | 版权申明 | 网站公告 | 网站地图 | 管理登录 | | |||
|