异常java.sql.SQLException: Io exception:The Network Adapter could not establish connection
作者: 来源:网络文章
时间:2005-12-15 20:55:48
异常java.sql.SQLException: Io exception:The Network Adapter could not establish connection(1)
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: