Increasing the Oracle connection limit

Applies to: On premises

In clustered environments, you must increase the number of users who can connect to the database instance.

Procedure

  1. Log on to the database server as a user with administrative privileges.
  2. To start the Oracle Enterprise Manager Database Express console, open a web browser and type https://<oracle_server_name>:<oracle_port>/em
  3. Log on to the Oracle Enterprise Manager Database Express console by using the following syntax: sys/\"<password>\"@sysdba.
    1. For the User Name, enter sys.
    2. Enter the password for the sys user.
    3. From the Connect As list, select SYSDBA.
  4. On the home page, click the Server tab.
  5. Under Database Configuration, click Initialization Parameters.
  6. On the Initialization Parameters page, click the SPFile tab.
  7. Locate the Processes parameter.

    If necessary, use the search function by entering Processes in the Name field and then clicking Go.

  8. Enter a value in the Processes field.

    In a clustered environment, for best performance allocate sufficient processes for each IBM OpenPages® application instance and each corresponding Cognos® instance.

    For a two-node OpenPages environment, use the following settings:

    OpenPages
    Configure 75 processes for each OpenPages instance.
    Reporting
    Configure 80 processes for each OpenPages Reporting instance.
    Database processing usage
    Configure 60 processes for database connection processing and background processes.
    By default, this setting is 250 processes and 280 sessions for a two-node OpenPages environment. If you have two or more application servers, increase the number of processes.
  9. Click Apply.

    You are prompted to restart the server.

  10. To restart the server, select Immediate.