Enocly 2015-10-13 02:31
浏览 1266

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/oracle

tns如下:
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
看了网上很多解决方式,一一验证都是不行,求大神帮忙,感激不尽_

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 有赏,i卡绘世画不出
    • ¥15 如何用stata画出文献中常见的安慰剂检验图
    • ¥15 c语言链表结构体数据插入
    • ¥40 使用MATLAB解答线性代数问题
    • ¥15 COCOS的问题COCOS的问题
    • ¥15 FPGA-SRIO初始化失败
    • ¥15 MapReduce实现倒排索引失败
    • ¥15 ZABBIX6.0L连接数据库报错,如何解决?(操作系统-centos)
    • ¥15 找一位技术过硬的游戏pj程序员
    • ¥15 matlab生成电测深三层曲线模型代码