做dblink连接时,using '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS =(PROTOCOL = TCP)(HOST = 11.39.22.66)(PORT = 9900)))(CONNECT_DATA =(SERVICE_NAME = orcl)))'
using里的连接字符串,是直接复制tnsnames.ora里的,plsql能访问到,可dblink显示“tns连接超时”
using里的连接字符串,是直接复制tnsnames.ora里的,plsql能访问到,可dblink显示“tns连接超时”
2、确认两个服务器之间没有防火墙等网络上的限制
private static final String URL="jdbc:oracle:thin:@localhost:1521:xe";
private static final String USERNAME="system";
private static final String PASSWORD="sun";
public static Connection getConnection(){
Connection conn=null;
try {
Class.forName(DRIVER);
conn=DriverManager.getConnection(URL,USERNAME,PASSWORD);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}