ORA-12170:TNS:Connect timeout occurred

(都是自己踩过的坑,希望能帮助到大家)

使用PLSQL Developer工具连接Oracle时,报错ORA-12170:TNS:Connect timeout occurred

ORA-12170:TNS:Connect timeout occurred

我的Oracle是通过虚拟机安装到win xp系统上的

1.检查Oracle服务是否开启

ORA-12170:TNS:Connect timeout occurred

2.找到安装目录,打开listener和tnsnames文件,检查ip地址是否和虚拟机ip地址一致

ORA-12170:TNS:Connect timeout occurred

ORA-12170:TNS:Connect timeout occurred

ORA-12170:TNS:Connect timeout occurred

3.在本机ping一下虚拟机ip,看看能否连接

ORA-12170:TNS:Connect timeout occurred

4.检查虚拟机上防火墙是否关闭,最终发现防火墙未关闭,所以连接失败

点击关闭

ORA-12170:TNS:Connect timeout occurred