使用sqldeveloper远程访问oracle

Question

我已经用Oracle Enterprise Linux安装了VirtualBox image。它包含已安装的Oracle Database 12.1.0。

在虚拟机网络设置中，我选择“Bridget Adapter”。接下来Linux我配置了连接设置：静态IP地址：192.168.0.110

现在我可以使用ping 192.168.0.110 ping到虚拟机。

虚拟机上的文件：

tnsnames。ora：

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )
pdb1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = pdb1)
    )
  )

监听器。ora：

# listener.ora Network Configuration File: /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
 (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP) (HOST = 0.0.0.0) (PORT = 80))
      (PROTOCOL_STACK = (PRESENTATION = HTTP) (SESSION = RAW))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP) (HOST = 0.0.0.0) (PORT = 21))
      (PROTOCOL_STACK = (PRESENTATION = FTP) (SESSION = RAW))
    )


    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )

  )

现在，我尝试使用以下连接属性从主机（Windows）连接数据库：用户名：系统密码：oracle主机名：192.168.0.110端口：1521服务名称：orcl

出现以下错误：网络适配器无法建立连接

Answer 1

检查oracle企业linux防火墙中的端口1521是否打开，或者这是否只是一个测试系统禁用防火墙。

如果主机上有telnet可用，您可以在端口1521上telnet到来宾并查看您得到的响应-对调试很有用