Oracle connection parameters
Run your Oracle database in "dedicated server" mode where you need one database connection (that are Oracle process) for each application connection (user process). In Oracle databases, the maximum number of connections that are allowed by the database is set by using the PROCESSES parameter in the initsid.ora file where sid is the system ID of your database.
Example
If you have only one InfoSphere® Master Data Management Collaboration Server - Collaborative Edition instance that is connected to your database and the instance needs a maximum of 133 connections, then ensure that the PROCESSES parameter is set to at least 143, which is 10 more than your required maximum. You need 10 extra connections to account for Oracle background processes and some SQL PLUS connections. In addition, if you add another InfoSphere Master Data Management Collaboration Server - Collaborative Edition instance, which also requires 133 connections to the same database, then you should set the PROCESSES parameter to at least 276, where 143 accounts for the first instance and an extra 133 connections account for the second InfoSphere Master Data Management Collaboration Server - Collaborative Edition instance.