出现了ORA-12170: TNS: 连接超时的情况.
通过SQL*PLUS, TOAD等Oracle客户端连接Oracle Server时出错的解决步骤:
1> Ping Oracle_Server_IP
The ping utility is used to test the connectivity to a remote machine.
2> Tnsping / tnsping Oracle_Server_IP
The tnsping utility is used to determine whether or not an Oracle service can be successfully reached.
3> netstat -na
查看下端口,一般监听端口为1521
4> 查看是否有防火墙开启
[@more@]Reference:http://www.oracleutilities.com/OSUtil/ping.html
http://www.builder.com.cn/2007/0915/507188.shtml
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12472709/viewspace-1036756/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/12472709/viewspace-1036756/