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).
Creating a Listener File and a Service Name File

Creating a Listener File and a Service Name File

To allow the external systems to access the Oracle database, you must create a listener file and a service name file.

Context

The Oracle listener is a process used by one or more databases to listen to external requests. The service name is used for web listening.

External systems can access the database only after a listener is created and enabled.

Creating a Listener File

  1. Log in to the Oracle database server as the root user.
  2. Set the environment variable.

    1. View the value of the environment variable DISPLAY.

      # echo $DISPLAY

      The following information is displayed:

      :0.0     
    2. Disable the access control.

      # xhost +

      access control disabled, clients can connect from any host
    3. Switch to the oracle user

      # su - oracle

    4. Set the value of the environment variable DISPLAY.

      > export DISPLAY=:0.0

      The value following = is the output of command echo $DISPLAY. Here :0.0 is used as an example.

    NOTE:

    If you use a graphical terminal, such as Xshell, to remotely log in to the server and perform installation, run the following command:

    > export DISPLAY=IP address of the graphical terminal:0.0

  3. Configure the listener service.

    > netca

  4. Select Listener configuration and click Next.

  5. Select Add and click Next.

  6. Set the listener name as planned (here, ESIGHTLISTENER is used as an example). Click Next.

  7. Select a web protocol used by the listening program based on the actual network environments (here, TCP is used as an example). Click Next.

  8. Select Use another port number and set the port number to 31521, and click Next.

  9. Select No and click Next.

  10. Click Next.

  11. Click Finish to complete the listener configuration.

    After the listener is configured, the listener.ora file is automatically generated in $ORACLE_HOME/network/admin.

  12. Modify the listener.ora file and restart the listener.

    > cd $ORACLE_HOME/network/admin

    > vi listener.ora

    Change KEY = EXTPROC31521 to KEY = REGISTER. Change eSightServer.site behind HOST to 127.0.0.1. If the database is deployed remotely, set HOST to the Oracle database server IP address. And add the following content in bold:

    Spaces cannot be placed at the beginning of the first line.

    # listener.ora Network Configuration File: /opt/oracle/product/11.2.0/db_1/network/admin/listener.ora 
    # Generated by Oracle configuration tools. 
     
     
    ESIGHTLISTENER = 
      (DESCRIPTION_LIST = 
        (DESCRIPTION = 
          (ADDRESS = (PROTOCOL = IPC)(KEY = REGISTER)) 
          (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 31521)) 
        ) 
      ) 
     
     
    SECURE_CONTROL_ESIGHTLISTENER=(TCPS,IPC) 
    SECURE_PROTOCOL_ESIGHTLISTENER=(TCPS,IPC) 
    SECURE_REGISTER_ESIGHTLISTENER=(TCPS,IPC) 
    DYNAMIC_REGISTRATION_ESIGHTLISTENER=OFF 
    ADMIN_RESTRICTIONS_ESIGHTLISTENER=ON 
    LOGGING_ESIGHTLISTENER=ON 
    LOGGING_LISTENER=ON 
    SECURE_REGISTER_ESIGHTLISTENER_PROD = (IPC) 
     
     
    SID_LIST_ESIGHTLISTENER = 
      (SID_LIST = 
        (SID_DESC = 
          (GLOBAL_DBNAME = esight) 
          (SID_NAME = esight) 
        ) 
      ) 
    INBOUND_CONNECT_TIMEOUT_ESIGHTLISTENER = 1800  
    
    ADR_BASE_ESIGHTLISTENER = /opt/oracle     

    Run the following commands to restart the listener.

    > lsnrctl stop ESIGHTLISTENER

    > lsnrctl start ESIGHTLISTENER

Creating a Service Name File

  1. Configure the database service name.

    > netca

  2. Select Local Net Service Name configuration and click Next.

  3. Select Add and click Next.

  4. Set the database service name as planned (here, esight is used as an example). Click Next.

  5. Select a web protocol for accessing the Oracle database based on the actual network environments (here, TCP is used as an example). Click Next.

  6. In the Host name text box, enter the IP address of the Oracle server. Select Use another port number and set the port number to 31521, and click Next.

  7. Select No, do not test and click Next.

  8. Retain the default service name and click Next.

  9. Select No and click Next.

  10. Click Next.

  11. Click Finish to complete the database service name configuration.

    After the service name is configured, the tnsnames.ora file is automatically generated in $ORACLE_HOME/network/admin.

Download
Updated: 2019-05-17

Document ID: EDOC1100011860

Views: 92690

Downloads: 138

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