How can I use the IP address after ORACLE modifies the IP address?
Author: iamlaosong
After the IP address of the oracle database server changes, the listening process cannot be started. You need to modify the corresponding configuration file:
1. Modify the address host on the server side $ ORACLE_HOME/network/admin/listener. ora. The listening process is responsible for listening to requests sent from the network, then responding, modifying the changes, and restarting LISTENER. That is:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1 ))
(ADDRESS = (PROTOCOL = TCP) (HOST = 10.178.40.196) (PORT = 1521 ))
)
)
2. Modify the address host on the client tnsnames. ora without restarting the client. Path C: \ oracle \ product \ 10.2.0 \ client_1 \ NETWORK \ ADMIN. The path varies with the version and decoration. That is:
DL580 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 10.178.40.196) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)