How do I check and change the maximum number of Oracle database connections

Publication Date:  2016-11-21 Views:  182 Downloads:  0
Issue Description
How do I check and change the maximum number of Oracle database connections?
Solution
1. Log in to the Linux operating system as the root user.

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 300

> alter system set processes = 300 scope = spfile;

NOTE:
eSight requires maximum number of Oracle database connections to be larger than or equal to 300. You can set processes to a value larger than 300.

5. Restart the Oracle database.

END