问题描述
- pl/sql登录报ORA-12170连接超时,求帮助
- 环境:服务器:宿主机win7 + VMware虚拟机Redhat oracle 11.2.0.3
注:服务器、客户机及宿主机防火墙已全部关闭,虚拟机网络方式选择桥接
描述:宿主机(本地)可以通过pl/sql登录oracle,同时tnsping和telent都正常,但在局域网的其他客户端机器中,可以ping通虚拟机中的服务器,但是telnet不通且tnsping操作超时
listener.ora如下:
SID_LIST_LISTENER =(SID_LIST =
(SID_DESC =
(SID_NAME = cbhb) (ORACLE_HOME = /u01/app/oracle/product/11.2.0.3/db_1) (PROGRAM = extproc) )
(SID_DESC = (GLOBAL_DBNAME = xx) (ORACLE_HOME = /u01/app/oracle/product/11.2.0.3/db_1) (SID_NAME = xx) ) )
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT =1521)) ) )
ADR_BASE_LISTENER = /u01/app/oracletns如下:
XXX=
(DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = XX.XX.XX.XX)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = XX) ) )
sqlnet.ora如下:
NAMES.DIRECTORY_PATH= (TNSNAMES EZCONNECT)
ADR_BASE = /u01/app/oracle
hosts如下:
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4::1 localhost localhost.localdomain localhost6 localhost6.localdomain6xx.xx.xx.xx localhost
看了网上很多解决方式,一一验证都是不行,求大神帮忙,感激不尽_