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>Search

Reminder

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

upgrade

eSight V300R009C00 Single-Node System Software Installation Guide (SUSE Linux) 09

Rate and give feedback :
Huawei uses machine translation combined with human proofreading to translate this document to different languages in order to help you better understand the content of this document. Note: Even the most advanced machine translation cannot match the quality of professional translators. Huawei shall not bear any responsibility for translation accuracy and it is recommended that you refer to the English document (a link for which has been provided).
How Do I Check and Change the Server IP Address of the Oracle Database Listener

How Do I Check and Change the Server IP Address of the Oracle Database Listener

Question

If the IP address of the eSight server changes, the Oracle database may fail to be connected. How do I change the server IP address of the Oracle database listener?

Answer

NOTE:
  • This operation supports only the scenario where eSight and the Oracle database are deployed on the same server.
  • If the IP address of the Oracle database listener is 127.0.0.1, do not change the server IP address of the Oracle database listener.
  • In a local HA system, the new IP address of the listener is the floating IP address of eSight.
  • In other scenarios, the new IP address of the listener is the system IP address of eSight.
  1. Log in to the Linux operating system as the oracle user.
  2. Check and change the IP address of the Oracle database listener.

    1. Open the listener.ora file. In the following example, 10.137.59.87 is the current IP address of the Oracle database listener. Change 10.137.59.87 to a new one.
      vi /opt/oracle/product/11.2.0/db_1/network/admin/listener.ora
      ... 
       
      ESIGHTLISTENER = 
        (DESCRIPTION_LIST = 
          (DESCRIPTION = 
            (ADDRESS = (PROTOCOL = IPC)(KEY = REGISTER)) 
            (ADDRESS = (PROTOCOL = TCP)(HOST = 10.137.59.87)(PORT = 31521)) 
          ) 
        ) 
      ...

      Press Esc and enter :wq to save the settings and exit.

    2. Open the tnsnames.ora file. In the following example, 10.137.59.87 is the current IP address of the Oracle database listener. Change 10.137.59.87 to a new one.
      vi /opt/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
      ESIGHTLINK=( 
      DESCRIPTION=( 
      ADDRESS_LIST=( 
      ADDRESS=(PROTOCOL=TCP) 
      (HOST=10.137.59.87) 
      (PORT=31521) 
      ) 
      ) 
      (CONNECT_DATA=(SERVER=DEDICATED) 
      (SERVICE_NAME=esight) 
      ) 
      ) 
      ...

      Press Esc and enter :wq to save the settings and exit.

  3. Run the following commands to restart the listening service of the Oracle database:

     
    $ lsnrctl stop esightlistener 
    $ lsnrctl start esightlistener

Download
Updated: 2019-05-17

Document ID: EDOC1100011860

Views: 92124

Downloads: 138

Average rating:
This Document Applies to these Products
Related Documents
Related Version
Share
Previous Next