1. Log into the Web Server, often the same server as the application server.
2. Go to the JBOSS log folder which is usually at:
cd $APPS_HOME/server/$APPS_PART/log
3. Open the server log file which is usually called "server.log".
view server.log
4. Search for errors such as:
Caused by: javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout
org.jboss.util.NestedSQLException: Unable to get managed connection for OracleDS
5. If any of the previous errors are present then review the oracle-ds.xml file to determine the connection pool size.
cd $APPS_HOME/server/$APPS_PART/deploy/
6. Search for the oracle-ds.xml
ls -ltr oracle-ds*
7. Open the oracle-ds.xml file and search for the xml tag <max-pool-size>. If it is non existent or commented then the default size of the pool is 10.
8. If the system is used by a considerable amount of users at a single time then it is recommended to increase the max-pool-size. Follow these steps:
A) Stop JBOSS, this can be done through appcontrol option "Shut down web client app server"
B) If the tag does not exist, it is recommended to be placed at the end just after the <query-timeout> and before the <metadata> as shown below.
Example:
<query-timeout>300</query-timeout>
<max-pool-size>100</max-pool-size>
<metadata>
<type-mapping>Oracle9i</type-mapping>
</metadata>
C) Start JBOSS, this can be done through appcontrol option "Start up web client app server" |
