java - 在 Oracle 本地主机中连接

Question

Oracle 是 IP: ps-server-dom

端口:1521

Usado o adaptador HOSTNAME para resolver o apelido
Tentativa de contatar (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTO
COL=TCP)(HOST=192.168.0.101)(PORT=1521)))
OK (10 ms)

错误:

java.sql.SQLException: Exceção de E/S: The Network Adapter could not establish the connection

代码:

Class.forName("oracle.jdbc.OracleDriver").newInstance();;
    conn = DriverManager.getConnection("jdbc:oracle:thin:@ps-server-dom:1521:PSYS", "psyst", "psyst");

Answer 1

检查listener.ora、tnsnames.ora是否有正确的设置。如果您想使用“ps-server-dom”访问它，那么这些文件应该具有这个特定的主机名而不是IP地址。

下面显示了这些文件对于 oracle xe 的可能设置。

tnsnames.ora

XE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ps-server-dom)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )

监听器.ora

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = ps-server-dom)(PORT = 1521))
    )
  )

注意:如果您位于某个域中，则 HOST=ps-server-dom.yourdomain.com。这些文件位于“oraclexe\app\oracle\product\<version>\server\network\ADMIN”下' 在 Windows 中。