No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>

Reminder

To have a better experience, please upgrade your IE browser.

upgrade
MENU

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

Publication Date:  2016-11-21 Views:  358 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