How Oracle can use the IP address after modifying it

Iamlaosong

After the Oracle database server IP changes, the listening process fails to start and the corresponding configuration file needs to be modified:

1, the server side $oracle_home/network/admin/listener.ora modify the address of the host can. The listening process is responsible for listening for requests sent on the network, then responding, and then restarting listener after modification. namely:

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

2, the client Tnsnames.ora modify the address of the host, the client does not need to restart. Path C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN, this path will change with the version and installation point. That

DL580 =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 10.178.41.253) (PORT = 1521))
)
(Connect_data =
(service_name = ORCL)
)
)

How Oracle can use the IP address after modifying it