※ [本文转录自 Database 看板 #1KH9I2YS ]
作者: sabreur (无奈) 看板: Database
标题: [讨论] 怎么连VM(CentOS7)内的 Oracle?
时间: Mon Oct 20 12:50:07 2014
各位先进好
在下参考了下面两篇文章 在CentOS7 中安装了Oracle database
http://ppt.cc/bt8y
http://ppt.cc/CPIt
CentOS7 是VM 的Guest 将之固定IP设定为 192.168.56.101
Host 是 Win8
$ORACLE_HOME/network/admin/listener.ora 修改如下
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.101)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /ora01/app/oracle
$ORACLE_HOME/network/admin/tnsnames.ora 修改如下
ORA11G =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.101)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORA11G)
)
)
防火墙情况
[oracle@localhost admin]$ service iptables status
Redirecting to /bin/systemctl status iptables.service
iptables.service - IPv4 firewall with iptables
Loaded: loaded (/usr/lib/systemd/system/iptables.service; disabled)
Active: inactive (dead)
情况是
1. 用SSH 连线到192.168.56.101 -> OK
2. ping 192.168.56.101 -> OK
3. 用SQL Developer 连 192.168.56.101 -> 失败
失败原因:
执行要求的作业时发生错误:
IO 错误: The Network Adapter could not establish the connection
厂商代码 17002
各位先进们 我想从Host连Guest的数据库 我还少了哪里没设定麻?
谢谢各位