解決辦法:修改 Oracle安裝目錄下的oracle\product\10.2.0\db_2\network\ADMIN\listener.ora文件:
Windows變更了內網IP后,Oracle的listener.ora配置文件中HOST的IP地址還是原內網IP,需要更改為新IP,或者這里直接設置為127.0.0.1。
示例:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)

