How can I check and change the server IP address monitored by the Oracle database
Log in to the Linux operating system as the oracle user.
Change the IP of server in the file listener.ora and tnsnames.ora.
The listening file listener.ora is used as an example to describe how to change the IP, for example, 10.137.59.87 to a new listening IP.
(GLOBAL_DBNAME = esight)
(SID_NAME = esight)
(ADDRESS = (PROTOCOL = IPC)(KEY = REGISTER))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.137.59.87)(PORT = 31521))
Press Esc. Run the :wq command to save the settings and exit.
Run the following command to restart the listening service for the Oracle database.
$ lsnrctl stop esightlistener
$ lsnrctl start esightlistener