[转]使用Oracle SQL Developer 17410 提示无法从套接字获取更多数据如何解决

本文转自：http://m.educity.cn/ite/1121475.html

将oracle?安装目录下的Network/admin/listener.ora文件中的 (PROGRAM = extproc)注释掉

# listener.ora Network Configuration File: D:\Oracle\product\11.2.0\dbhome_1\network\admin\listener.ora

# Generated by?Oracle?configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME =ORACLE) #这里的SID要以自己的SID一致
(ORACLE_HOME = D:\Oracle\product\11.2.0\dbhome_1)
#(PROGRAM = extproc)
(ENVS = “EXTPROC_DLLS=ONLY:D:\Oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll”)
)
)

 

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)

 

ADR_BASE_LISTENER = D:\Oracle