Increase Oracle Connections for InSight Manager
Refer to your Oracle Connection Settings Established when setting up your Calyx RIM Database instance for the actual Max-Pool-Size settings used.
Attention: Please consult with your DBA before making any changes described in this section.
- Navigate to the directory <installation drive>:\InSightManager\server\all\deploy and open the file oracle-ds.xml file in Notepad.
-
Add the following lines to the two sections specified:
<jndi-name>ManagerDS</jndi-name> <min-pool-size>1</min-pool-size> <max-pool-size>500</max-pool-size>and
<jndi-name>DefaultDS</jndi-name> <min-pool-size>1</min-pool-size> <max-pool-size>500</max-pool-size> - Save and close the file.
- Navigate to the directory X:\InSightManager\server\all\deploy\hornetq and open the jms-ds.xml file in Notepad.
-
Change the max pool size value to
500.
<tx-connection-factory> <jndi-name>JmsXA</jndi-name> <xa-transaction/> <rar-name>jms-ra.rar</rar-name> <connection-definition>org.hornetq.ra.HornetQRAConnectionFactory</connection-definition> <config-property name="SessionDefaultType" type="java.lang.String">javax.jms.Topic</config-property> <config-property name="JmsProviderAdapterJNDI" type="java.lang.String">java:/DefaultJMSProvider</config-property> <max-pool-size>500</max-pool-size> <security-domain-and-application>JmsXARealm</security-domain-and-application> </tx-connection-factory> - Save and close the file.
- Navigate to the directory <installation drive>:\InSightManager\server\all\deploy\jbossweb.sar and open the file server.xml in Notepad.
-
Change the values for max threads to
1000.
<Connector protocol="HTTP/1.1" address="${jboss.bind.address}" port="${jboss.web.http.port}" redirectPort="${jboss.web.https.port}" maxPostSize="150000000" maxThreads="1000" maxHttpHeaderSize="8192" acceptCount="100" enableLookups="false" connectionTimeout="20000" disableUploadTimeout="true" URIEncoding="UTF-8" compression="on" compressableMimeType= "text/html,text/xml,text/javascript,text/css" /> - Save and close the file.
- Navigate to the directory <installation drive>:\InSightManager\server\all\deploy\ and open the file jca-jboss-beans.xml file in Notepad.
-
Change the debug attribute to
false:
<!-- Whether to track unclosed connections and close them --> <property name="debug">false</property> - Save and close the file.