ORACLE修改IP地址後如何能夠使用

ORACLE修改IP地址後如何能夠使用

oracle數據庫服務器IP改變後，監聽進程無法啟動，需要修改相應的配置文件：

1、服務器端$ORACLE_HOME/network/admin/listener.ora修改address的host即可。監聽進程負責監聽網絡上發來請求，然後響應，修改後重新啟動LISTENER。即：

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.178.40.196)(PORT = 1521))
)
)

2、客戶端tnsnames.ora修改address的host即可，客戶端無需重啟。路徑C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN，這個路徑會隨版本和安裝點變化。即：

DL580 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.178.41.253)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)