UCP connection pool logging

From: Martin Bach <development_at_the-playground.de>
Date: Mon, 08 Mar 2010 17:12:03 +0000
Message-ID: <4B952FE3.7050101_at_the-playground.de>

Dear list members,

I am currently experimenting with the UCP for RAC 11.2 using tomcat 6 as the "application server". I have configured a datasource and can connect quite happily to the database service. FAN and FCF do work as advertised,and so does runtime load balancing.

The documentation states that there are various log levels for UCP, beginning from INTERNAL_ERROR over SEVERE to FINEST:
-> http://www.oracle.sh.cn/java.112/e12265/dgn_conpool.htm

However it seems that the code is instrumented only to emit traces for FINE and FINEST, which is a bit too verbose for my liking

My setup:

• tomcat 6.0.24
• JDK 1.6_18 64bit
• ant 1.8.0

ls -l $CATALINA_HOME/lib:

total 9120
-rw-r--r-- 1 mbach root 15119 Jan 19 13:42 annotations-api.jar
-rw-r--r-- 1 mbach root 53459 Jan 19 13:42 catalina-ant.jar
-rw-r--r-- 1 mbach root 128412 Jan 19 13:42 catalina-ha.jar
-rw-r--r-- 1 mbach root 234845 Jan 19 13:42 catalina-tribes.jar
-rw-r--r-- 1 mbach root 1180908 Jan 19 13:42 catalina.jar
-rw-r--r-- 1 mbach root 32126 Jan 19 13:42 el-api.jar
-rw-r--r-- 1 mbach root 107431 Jan 19 13:42 jasper-el.jar
-rw-r--r-- 1 mbach root 1408152 Jan 19 13:42 jasper-jdt.jar
-rw-r--r-- 1 mbach root 522568 Jan 19 13:42 jasper.jar
-rw-r--r-- 1 mbach root 76644 Jan 19 13:42 jsp-api.jar
-rw-r--r-- 1 mbach root 2111220 Mar 4 09:02 ojdbc6.jar
-rw-r--r-- 1 mbach root 63590 Mar 4 09:03 ons.jar
-rw-r--r-- 1 mbach root 1656280 Mar 4 09:02 orai18n.jar
-rw-r--r-- 1 mbach root 88199 Jan 19 13:42 servlet-api.jar
-rw-r--r-- 1 mbach root 758225 Jan 19 13:42 tomcat-coyote.jar
-rw-r--r-- 1 mbach root 232785 Jan 19 13:42 tomcat-dbcp.jar
-rw-r--r-- 1 mbach root 69862 Jan 19 13:42 tomcat-i18n-es.jar
-rw-r--r-- 1 mbach root 51791 Jan 19 13:42 tomcat-i18n-fr.jar
-rw-r--r-- 1 mbach root 54850 Jan 19 13:42 tomcat-i18n-ja.jar
-rw-r--r-- 1 mbach root 447280 Mar 4 09:03 ucp.jar

all Oracle JARs are from an 11.2 64bit client which I installed locally on the tomcat machine.

Now I don't pretend I am a java developer so maybe I'm doing something wrong here? My logging.conf in my src/ directory of my webapp contains the following lines (and it generates the debugging info in $CATALINA_HOME/logs); whenever I try to set anything less than FINE no output is generated even if I relocate/start/stop services which should generate FAN events.

handlers = org.apache.juli.FileHandler, java.util.logging.ConsoleHandler

org.apache.juli.FileHandler.level = ALL
org.apache.juli.FileHandler.directory = ${catalina.base}/logs
org.apache.juli.FileHandler.prefix = ucp.
org.apache.juli.FileHandler.formatter = oracle.ucp.util.logging.UCPFormatter

java.util.logging.ConsoleHandler.level = SEVERE

.level = CONFIG

# FCF classes
oracle.ucp.common.FailoverEventHandlerThreadBase.level = ALL

oracle.ucp.jdbc.oracle.ONSDatabaseFailoverEvent.level = ALL
oracle.ucp.jdbc.oracle.ONSRuntimeLBEventHandlerThread.level = ALL
oracle.ucp.jdbc.oracle.ONSOracleRuntimeLBEventSubscriber.level = ALL
oracle.ucp.jdbc.oracle.ONSRuntimeLoadBalancingEvent.level = ALL
oracle.ucp.jdbc.oracle.ONSOracleFailoverEventSubscriber.level = ALL
oracle.ucp.jdbc.oracle.ONSDatabaseEventHandlerThread.level = ALL
oracle.ucp.jdbc.oracle.OracleFailoverEvent.level = ALL
oracle.ucp.jdbc.oracle.OracleFailoverEventSubscriber.level = ALL
oracle.ucp.jdbc.oracle.OracleFailoverEventImpl.level = ALL
oracle.ucp.jdbc.oracle.OracleFailoverEventNotification.level = ALL
oracle.ucp.jdbc.oracle.OracleFailoverHandler.level = ALL
oracle.ucp.jdbc.oracle.OracleFailoverablePooledConnection.level = ALL

oracle.ucp.jdbc.oracle.OraclePooledConnectionConnectionPool.level = ALL
oracle.ucp.jdbc.oracle.OracleConnectionConnectionPool.level = ALL

oracle.ucp.jdbc.oracle.OracleXAConnectionConnectionPool.level = ALL oracle.ucp.jdbc.oracle.OracleJDBCConnectionPool.level = ALL

oracle.ucp.jdbc.oracle.OracleDatabaseInstanceInfo.level = ALL oracle.ucp.jdbc.oracle.OracleDatabaseInstanceInfoList.level = ALL

# RCLB classes

oracle.ucp.jdbc.oracle.ONSRuntimeLBEventHandlerThread.level = ALL
oracle.ucp.jdbc.oracle.ONSOracleRuntimeLBEventSubscriber.level = ALL
oracle.ucp.jdbc.oracle.OracleRuntimeLoadBalancingHandler.level = ALL
oracle.ucp.jdbc.oracle.ONSRuntimeLoadBalancingEvent.level = ALL

Anyone have any ideas?

Thanks a lot in advance!

Martin
--

Martin Bach
OCM 10g
http://martincarstenbach.wordpress.com
http://www.linkedin.com/in/martincarstenbach
--

http://www.freelists.org/webpage/oracle-l Received on Mon Mar 08 2010 - 11:12:03 CST