困扰两天的一个连接问题,以为是ssh连接出了问题,最后发现是litsener.ora的ip没配
找到C:\app\用户名\product\11.2.0\dbhome_1\NETWORK\ADMIN目录下的litsener.ora文件,多加一行,如下
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.72)(PORT = 1521))
)
)
重启服务OracleOraDb11g_home2TNSListener 即可