今天遇到个小问题,我自己电脑上有安装oracle11g服务端(win7 64位系统),自己本地访问都OK,但是同事(下称小A)访问就不行,报ora-12541错(TNS:无监听)
小A自己本机配置的TNS如下:
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 我的局域网IP)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
最后一番折腾解决方案如下:
1. 关闭防火墙(汗。。。)
2. 本机新增1522端口(可自行百度)
3. 我自己的机器上的监听新增一条如下:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 我的局域网IP)(PORT = 1522))
)
)
4. 重启监听
5. 小A的TNS修改为
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 我的局域网IP)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
至此解决此问题 :)