How can I check and change the server IP address monitored by the Oracle database

Publication Date:  2016-11-21 Views:  209 Downloads:  0
Issue Description
How can I check and change the server IP address monitored by the Oracle database
Solution
Log in to the Linux operating system as the oracle user.

Change the IP of server in the file listener.ora and tnsnames.ora.

vi /opt/oracle/product/11.2.0/db_1/network/admin/listener.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.





SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = esight)
(SID_NAME = esight)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = REGISTER))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.137.59.87)(PORT = 31521))
)
)

SECURE_REGISTER_LISTENER=(IPC)



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

END