win7(64位)SQLDeveloper工具连接数据库提示:IO错误:The Network Adapter could not establish the connection
SQLDeveloper工具是个免安装的软件,直接解压运行sqldeveloper.exe即可。
连接数据库时提示错误
“IO错误:The Network Adapter could not establish the connection ”
解决方法:
查询oracle 11g 安装路径XXXX\network\admin里面有个文件tnsnames.ora的配置。
发现配置连接中的端口号是1522,tnsnames.ora中配置和SQLDeveloper的保持一致端口即可连接正常。我的操作是将SQLDeveloper中连接设置端口改为1522。
tnsnames.ora中配置:
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.microdone.cn)
)
)