LIQUENT InSight 6.2 Installation Guide

Increasing the Oracle Connections for InSight Manager

Refer to your Oracle Connection Settings Established when setting up your LIQUENT InSight Database instance for the actual Max-Pool-Size settings used.

Attention: Please consult with your DBA before making any changes described in this section.
  1. Navigate to the directory <installation drive>:\InSightManager\server\all\deploy and open the file oracle-ds.xml file in Notepad.
  2. 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>
  3. Save and close the file.
  4. Navigate to the directory <installation drive>:\InSightManager\server\all\deploy\hornetq and open the jms-ds.xml file in Notepad.
  5. 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>
  6. Save and close the file.
  7. Navigate to the directory <installation drive>:\InSightManager\server\all\deploy\jbossweb.sar and open the file server.xml in Notepad.
  8. 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" 
  />
  9. Save and close the file.
  10. Navigate to the directory <installation drive>:\InSightManager\server\all\deploy\ and open the file jca-jboss-beans.xml file in Notepad.
  11. Change the debug attribute to false: 
    
<!-- Whether to track unclosed connections and close them -->
   <property name="debug">false</property>
  12. Save and close the file.