与oracle的jdbc连接错误

Question

我无法使用jdbc连接到oracle数据库。

错误：无法连接到jdbc:oracle:thin:@localhost上的数据库。localdomain:1521:orcl（用户名：system，密码：tiger）

但是，我可以使用sqlplus命令连接它。

以下是日志：

java version "1.6.0_45"
Java(TM) SE Runtime Environment (build 1.6.0_45-b06)
Java HotSpot(TM) 64-Bit Server VM (build 20.45-b01, mixed mode)
Version = Sun GlassFish Enterprise Server v2.1
Testing Database Connection ...
  -- Failure! java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

这是听众。奥拉：

 LISTENER =
 (DESCRIPTION_LIST =
 (DESCRIPTION =
   (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
   (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /home/oracle/app/oracle

lsnrctl的输出：

Listening Endpoints Summary...
 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=::1)(PORT=1521)))
 Services Summary...
 Service "orcl" has 1 instance(s).
 Instance "orcl", status READY, has 1 handler(s) for this service...
 Service "orclXDB" has 1 instance(s).
 Instance "orcl", status READY, has 1 handler(s) for this service...
 The command completed successfully

tnsnames的内容。奥拉：

 ORCL =
   (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

我使用的是Oracle 11g，glassfish服务器2.1，Redhat linux企业版6。

任何帮助都将不胜感激。

--山姆

Answer 1

测试：

 telnet localhost 1521

如果它不起作用呢

设置iptables：

https://exploringspatial.wordpress.com/2013/06/08/installing-oracle-sql-developer/

Answer 2

尝试替换localhost。localdomain与连接字符串中的localhost，即。

jdbc:oracle:thin:@localhost:1521:orcl

我也得到了一个网络适配器无法建立连接错误，如果我使用localhost. localfield作为地址，它会消失，如果我只使用localhost。