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 Maximum Number of Oracle Database Connections

How Do I Check and Change the Maximum Number of Oracle Database Connections

Question

How do I check and modify the maximum number of oracle database connections in the scenario where the SUSE Linux is deployed in a single-node system?

Answer

  1. Log in to the Linux operating system as the root user.

    NOTE:
    • The following operations only apply to the single-node scenario.
    • Remotely log in to the server as the ossuser and switch to the root user if the SUSE Linux is hardened.

  2. Connect to the Oracle database.

    # su - oracle

    $ sqlplus / as sysdba

  3. Check the maximum number of Oracle database connections.

    > select value from v$parameter where name = 'processes';

  4. Change the maximum number of Oracle database connections to 500.

    > alter system set processes = 500 scope = spfile;

    NOTE:

    eSight requires maximum number of Oracle database connections to be greater than or equal to 500. You can set processes to a value greater than 500.

  5. Restart the Oracle database.
Download
Updated: 2019-05-17

Document ID: EDOC1100011860

Views: 92859

Downloads: 138

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