How can I use the IP address modified by ORACLE?
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.41.253) (PORT = 1521) (CONNECT_DATA = (SERVICE_NAME = orcl )))