连接到oracle数据库19c时失败

lsmepo6l  于 2021-07-05  发布在  Java
关注(0)|答案(0)|浏览(931)

我试图通过java代码手动连接到oracle数据库,但是我遇到了这个错误。
java代码

  1. public static void main(String[] args) throws Exception {
  2. //database info
  3. Class.forName("oracle.jdbc.driver.OracleDriver");
  4. String url = "jdbc:oracle:thin:@//HOST:1521/SERVICE"
  5. String username = "*******";
  6. String password = "*******";
  7. //Connect
  8. try{
  9. Connection conn = DriverManager.getConnection(url, username, password);
  10. } catch (Exception e){
  11. System.out.println("convertStackTraceToString(e---------------------------------------");
  12. System.out.println(convertStackTraceToString(e));
  13. System.out.println("printStackTrace(e---------------------------------------");
  14. Thread.sleep(100); // Avoids timing side effect with println and printStackTrace
  15. e.printStackTrace();
  16. }

java堆栈跟踪

  1. java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
  2. at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:858)
  3. at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793)
  4. at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:57)
  5. at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:747)
  6. at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:562)
  7. at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
  8. at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
  9. at Main.main(Main.java:33)
  10. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  11. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  12. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  13. at java.base/java.lang.reflect.Method.invoke(Method.java:566)
  14. at jdk.compiler/com.sun.tools.javac.launcher.Main.execute(Main.java:404)
  15. at jdk.compiler/com.sun.tools.javac.launcher.Main.run(Main.java:179)
  16. at jdk.compiler/com.sun.tools.javac.launcher.Main.main(Main.java:119)
  17. Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
  18. at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:571)
  19. at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:548)
  20. at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:682)
  21. at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:661)
  22. at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:202)
  23. at oracle.net.ns.NSProtocol.connect(NSProtocol.java:340)
  24. at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1600)
  25. at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:591)
  26. ... 14 more
  27. Caused by: java.io.IOException: Connection refused, socket connect lapse 2 ms. /SCRUB.SCRUB.SCRUB.SCRUB 1521 0 1 true
  28. at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:233)
  29. at oracle.net.nt.ConnOption.connect(ConnOption.java:174)
  30. at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:510)
  31. ... 21 more
  32. Caused by: java.net.ConnectException: Connection refused
  33. at java.base/sun.nio.ch.Net.connect0(Native Method)
  34. at java.base/sun.nio.ch.Net.connect(Net.java:482)
  35. at java.base/sun.nio.ch.Net.connect(Net.java:474)
  36. at java.base/sun.nio.ch.SocketChannelImpl.connect(SocketChannelImpl.java:694)
  37. at java.base/java.nio.channels.SocketChannel.open(SocketChannel.java:194)
  38. at oracle.net.nt.TimeoutSocketChannel.connect(TimeoutSocketChannel.java:99)
  39. at oracle.net.nt.TimeoutSocketChannel.<init>(TimeoutSocketChannel.java:77)
  40. at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:192)
  41. ... 23 more

我已经检查了凭据和url,它们似乎在另一个系统/网络上工作。我没有访问实际数据库本身的权限,只有要使用的凭据和url。我还可以确认服务器和端口之间的连接。
太好了!

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题