访问本机的oracle 11g,sqldeveloper中Connection Type选Advanced,JDBC URL写成jdbc:oracle:thin:@localhost:1521/myoracle 可以连接,写成jdbc:oracle:thin:@192.168.1.77:1521/myoracle (192.168.1.77是主机的IP地址,手动指定的)
调试欢乐多
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.77)(PORT = 1521))
)
)
)
192.168.1.77为主机IP地址。