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.
Next topic: Accessing LIQUENT Online Help

© 2000-2021 PAREXEL International Corporation and its affiliates. All rights reserved.