> IT面试 >

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

将oracle 安装目录下的Network/admin/listener.ora文件中的 (PROGRAM = extproc)注释掉
# listener.ora Network Configuration File: D:Oracleproduct11.2.0dbhome_1networkadminlistener.ora

# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME =ORACLE) #这里的SID要以自己的SID一致
(ORACLE_HOME = D:Oracleproduct11.2.0dbhome_1)
#(PROGRAM = extproc)
(ENVS = “EXTPROC_DLLS=ONLY:D:Oracleproduct11.2.0dbhome_1binoraclr11.dll”)
)
)

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

ADR_BASE_LISTENER = D:Oracle

(责任编辑:IT)