Re: Caused by: java.sql.SQLException: ORA-03135: connection lostcontact - Websphere

This is a discussion on Re: Caused by: java.sql.SQLException: ORA-03135: connection lostcontact - Websphere ; I found this in the logs [28/11/09 00:54:04:702 GMT] 0000006e DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: The property 'connectionAttribute' does not exist on the DataSource class oracle.jdbc.pool.OracleConnectionPoolDataSource. [28/11/09 00:54:04:915 GMT] 0000006e InternalOracl I DSRA8203I: Database product name : Oracle ...

+ Reply to Thread
Results 1 to 5 of 5

Thread: Re: Caused by: java.sql.SQLException: ORA-03135: connection lostcontact

  1. Re: Caused by: java.sql.SQLException: ORA-03135: connection lostcontact

    I found this in the logs

    [28/11/09 00:54:04:702 GMT] 0000006e DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: The property 'connectionAttribute' does not exist on the DataSource class oracle.jdbc.pool.OracleConnectionPoolDataSource.
    [28/11/09 00:54:04:915 GMT] 0000006e InternalOracl I DSRA8203I: Database product name : Oracle
    [28/11/09 00:54:04:917 GMT] 0000006e InternalOracl I DSRA8204I: Database product version : Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
    With the Partitioning, Real Application Clusters, OLAP and Data Mining options
    [28/11/09 00:54:04:918 GMT] 0000006e InternalOracl I DSRA8205I: JDBC driver name : Oracle JDBC driver
    [28/11/09 00:54:04:918 GMT] 0000006e InternalOracl I DSRA8206I: JDBC driver version : 10.2.0.3.0
    [28/11/09 00:54:04:919 GMT] 0000006e InternalOracl I DATA_STORE_HELPER_NAME
    [28/11/09 00:54:04:919 GMT] 0000006e WSRdbDataSour I DSRA8208I: JDBC driver type : ""
    [28/

  2. Re: Caused by: java.sql.SQLException: ORA-03135: connection lostcontact

    3LKWAITNOTIFY "wpsDefaultWorkManager.Alarm Pool : 0" (C2316B8)
    3LKWAITNOTIFY "wpsDefaultWorkManager.Alarm Pool : 1" (B474AE0)
    2LKMONINUSE sys_mon_t:0x0B2E90A8 infl_mon_t: 0x0B05D890:
    3LKMONOBJECT com.ibm.ws.util.BoundedBuffer@580E42B8/580E42C0:
    3LKNOTIFYQ Waiting to be notified:
    3LKWAITNOTIFY "SoapConnectorThreadPool : 0" (D92B228)
    3LKWAITNOTIFY "SoapConnectorThreadPool : 1" (D92C808)
    2LKMONINUSE sys_mon_t:0x0B2E9E88 infl_mon_t: 0x0B05D998:
    3LKMONOBJECT com.ibm.ws.util.BinaryHeap@45543E48/45543E50:
    2LKMONINUSE sys_mon_t:0x0B05EBB0 infl_mon_t: 0x0B05DD60:
    3LKMONOBJECT java.lang.Object@85E36658/85E36660:
    3LKNOTIFYQ Waiting to be notified:
    3LKWAITNOTIFY "java.lang.ThreadGroup[name=icmciWorkManager: icmjcrear,maxpri=10]" (9C0D8760)
    3LKWAITNOTIFY "java.lang.ThreadGroup[name=icmciWorkManager: icmjcrear,maxpri=10]" (9C0D8DB8)
    3LKWAITNOTIFY "java.lang.ThreadGroup[name=icmciWorkManager: icmjcrear,maxpri=10]" (9C0D5C38)
    3LKWAITNOTIFY "java.lang.ThreadGroup[name=icmciWorkManager: icmjcrear,maxpri=10]" (9C0D5680)
    3LKWAITNOTIFY "java.lang.ThreadGroup[name=icmciWorkManager: icmjcrear,maxpri=10]" (9C0D67A8)
    3LKWAITNOTIFY "java.lang.ThreadGroup[name=icmciWorkManager: icmjcrear,maxpri=10]" (9C0D61F0)
    3LKWAITNOTIFY "java.lang.ThreadGroup[name=icmciWorkManager: icmjcrear,maxpri=10]" (9C0D7458)
    3LKWAITNOTIFY "java.lang.ThreadGroup[name=icmciWorkManager: icmjcrear,maxpri=10]" (9C0D6E00)
    3LKWAITNOTIFY "java.lang.ThreadGroup[name=icmciWorkManager: icmjcrear,maxpri=10]" (9C0D8108)
    3LKWAITNOTIFY "java.lang.ThreadGroup[name=icmciWorkManager: icmjcrear,maxpri=10]" (9C0D7AB0)
    2LKMONINUSE sys_mon_t:0x0B05F330 infl_mon_t: 0x0B05E0D0:
    3LKMONOBJECT com.ibm.ws.util.BinaryHeap@8BBB4E38/8BBB4E40:
    2LKMONINUSE sys_mon_t:0x99F466B8 infl_mon_t: 0x99B7C1B0:
    3LKMONOBJECT com.ibm.ws.util.BinaryHeap@48623B88/48623B90:
    3LKNOTIFYQ Waiting to be notified:
    3LKWAITNOTIFY "pznRuleeventsWorkManager:AlarmManager" (9C811C88)
    2LKMONINUSE sys_mon_t:0x0D0C55B0 infl_mon_t: 0x99B7CCDC:
    3LKMONOBJECT com.ibm.ws.util.BoundedBuffer@6F11B188/6F11B190:
    3LKNOTIFYQ Waiting to be notified:
    3LKWAITNOTIFY "WorkManager.wpsDefaultWorkManager : 6" (B3C2EC0)
    2LKMONINUSE sys_mon_t:0x0DA76588 infl_mon_t: 0x99B7DA18:
    3LKMONOBJECT org.apache.log4j.helpers.BoundedFIFO@713BD420/713BD428:
    3LKNOTIFYQ Waiting to be notified:
    3LKWAITNOTIFY "Dispatcher-Thread-101" (A288CF40)
    2LKMONINUSE sys_mon_t:0x9DE2AC08 infl_mon_t: 0x9DE2D418:
    3LKMONOBJECT com.ibm.ws.util.BinaryHeap@6E90F128/6E90F130:
    3LKNOTIFYQ Waiting to be notified:
    3LKWAITNOTIFY "SchedulerWorkManager:AlarmManager" (E0811E8)
    2LKMONINUSE sys_mon_t:0x98BF4268 infl_mon_t: 0x9DE2DF44:
    3LKMONOBJECT java.lang.Object@523995F8/52399600:
    3LKNOTIFYQ Waiting to be notified:
    3LKWAITNOTIFY "PoolScavenger0" (E05D448)
    2LKMONINUSE sys_mon_t:0x98BF4DA8 infl_mon_t: 0x9DE2E46C:
    3LKMONOBJECT org.apache.log4j.helpers.BoundedFIFO@4C2ADF78/4C2ADF80:
    3LKNOTIFYQ Waiting to be notified:
    3LKWAITNOTIFY "Dispatcher-Thread-76" (9C8FB148)
    2LKMONINUSE sys_mon_t:0x98BF5C48 infl_mon_t: 0x9DE2EB20:
    3LKMONOBJECT org.apache.log4j.helpers.BoundedFIFO@439CB7A0/439CB7A8:
    3LKNOTIFYQ Waiting to be notified:
    3LKWAITNOTIFY "Dispatcher-Thread-69" (9EEBEB58)
    2LKMONINUSE sys_mon_t:0x9DE30F68 infl_mon_t: 0x9DE2F3E4:
    3LKMONOBJECT java.util.TaskQueue@6E63C298/6E63C2A0:
    3LKNOTIFYQ Waiting to be notified:
    3LKWAITNOTIFY "Thread-98" (A23A9148)
    2LKMONINUSE sys_mon_t:0x9DE31988 infl_mon_t: 0x9DE2F888:
    3LKMONOBJECT java.util.TaskQueue@6E4B92E8/6E4B92F0:
    3LKNOTIFYQ Waiting to be notified:
    3LKWAITNOTIFY "Thread-96" (A23A6F30)
    2LKMONINUSE sys_mon_t:0x9DE32708 infl_mon_t: 0x9DE2FEB8:
    3LKMONOBJECT java.lang.Object@4BBDFC70/4BBDFC78:
    3LKNOTIFYQ Waiting to be notified:
    3LKWAITNOTIFY "PoolScavenger0" (E62D390)
    2LKMONINUSE sys_mon_t:0x9DE32EE8 infl_mon_t: 0x9DE30254:
    3LKMONOBJECT java.lang.Object@6CF1F7F8/6CF1F800:
    3LKNOTIFYQ Waiting to be notified:
    3LKWAITNOTIFY "PoolScavenger0" (9EE3CEC8)
    2LKMONINUSE sys_mon_t:0x0E008AA0 infl_mon_t: 0x090BDD74:
    3LKMONOBJECT com.volantis.mcs.repository.jdbc.ConnectionPool$Ba ckgroundThread@409E4AF0/409E4AF8:
    3LKNOTIFYQ Waiting to be notified:
    3LKWAITNOTIFY "Thread-90" (A0496480)
    2LKMONINUSE sys_mon_t:0x0D48E660 infl_mon_t: 0x090BDF84:
    3LKMONOBJECT java.lang.Object@59880120/59880128:
    3LKNOTIFYQ Waiting to be notified:
    3LKWAITNOTIFY "PoolScavenger0" (9D16F5E8)
    2LKMONINUSE sys_mon_t:0x9CD613E0 infl_mon_t: 0x090BE740:
    3LKMONOBJECT com.ibm.ws.util.BoundedBuffer@45577A90/45577A98:
    3LKNOTIFYQ Waiting to be notified:
    3LKNOTIFYQ Waiting to be notified:
    3LKWAITNOTIFY "pznLikemindsWorkManager.Alarm Pool : 0" (B8F42A8)
    2LKMONINUSE sys_mon_t:0x99F17578 infl_mon_t: 0x090C023C:
    3LKMONOBJECT java.util.TaskQueue@6254E168/6254E170:
    3LKNOTIFYQ Waiting to be notified:
    3LKWAITNOTIFY "Thread-91" (A11E4948)
    2LKMONINUSE sys_mon_t:0x99F182F8 infl_mon_t: 0x090C086C:
    3LKMONOBJECT com.ibm.ws.util.BoundedBuffer@528C09B8/528C09C0:
    3LKNOTIFYQ Waiting to be notified:
    3LKWAITNOTIFY "WebContainer : 1" (CE170A8)
    3LKWAITNOTIFY "WebContainer : 0" (D30CAD8)
    2LKMONINUSE sys_mon_t:0x0D55B838 infl_mon_t: 0x0B2F9514:
    3LKMONOBJECT java.lang.Object@65F077A0/65F077A8:
    3LKNOTIFYQ Waiting to be notified:
    3LKWAITNOTIFY "PoolScavenger0" (E36EF48)
    2LKMONINUSE sys_mon_t:0x0D5DF0B8 infl_mon_t: 0x0B2F95C4:
    3LKMONOBJECT java.util.TaskQueue@6E5D12D0/6E5D12D8:
    3LKNOTIFYQ Waiting to be notified:
    3LKWAITNOTIFY "Thread-97" (A23A8138)
    2LKMONINUSE sys_mon_t:0x0D55C4B8 infl_mon_t: 0x0B2F95F0:
    3LKMONOBJECT java.lang.Object@52A60920/52A60928:
    3LKNOTIFYQ Waiting to be notified:
    3LKWAITNOTIFY "java.lang.ThreadGroup[name=SchedulerWorkManager: WM Service Group,maxpri=10]" (9EEC2688)
    2LKMONINUSE sys_mon_t:0x0B0CB988 infl_mon_t: 0x0B2FA6C8:
    3LKMONOBJECT com.ibm.ws.util.BoundedBuffer@52B3DDD8/52B3DDE0:
    3LKNOTIFYQ Waiting to be notified:
    3LKWAITNOTIFY "SchedulerWorkManager.Alarm Pool : 0" (E281848)
    3LKWAITNOTIFY "SchedulerWorkManager.Alarm Pool : 1" (E2A35F0)
    NULL
    1LKREGMONDUMP JVM System Monitor Dump (registered monitors):
    2LKREGMON JITC MCC_PDATA lock (0x9550ECD8):
    2LKREGMON JITC PIC Lock (0x081DD2E8):
    2LKREGMON JITC CHA lock (0x081DD288): owner "Signal dispatcher" (8164A58), entry count 1
    2LKREGMON JITC MB UPDATE lock (0x954EA088):
    2LKREGMON JITC Global_Compile lock (0x954EA020):
    2LKREGMON JITC W_POOL lock (0x081DD228):
    2LKREGMON JITC M_BLOCK lock (0x081DD1C8):
    2LKREGMON Free Class Loader Cache Entry lock (0x08085360):
    2LKREGMON IO lock (0x08085300):
    2LKREGMON Evacuation Region lock (0x08085240):
    2LKREGMON Heap Promotion lock (0x080851E0):
    2LKREGMON Sleep lock (0x08085180):

  3. Re: Caused by: java.sql.SQLException: ORA-03135: connection lostcontact

    1LKREGMONDUMP JVM System Monitor Dump (registered monitors):
    2LKREGMON JITC MCC_PDATA lock (0x9550ECD8):
    2LKREGMON JITC PIC Lock (0x081DD2E8):
    2LKREGMON JITC CHA lock (0x081DD288): owner "Signal dispatcher" (8164A58), entry count 1
    2LKREGMON JITC MB UPDATE lock (0x954EA088):
    2LKREGMON JITC Global_Compile lock (0x954EA020):
    2LKREGMON JITC W_POOL lock (0x081DD228):
    2LKREGMON JITC M_BLOCK lock (0x081DD1C8):
    2LKREGMON Free Class Loader Cache Entry lock (0x08085360):
    2LKREGMON IO lock (0x08085300):
    2LKREGMON Evacuation Region lock (0x08085240):
    2LKREGMON Heap Promotion lock (0x080851E0):
    2LKREGMON Sleep lock (0x08085180):
    3LKNOTIFYQ Waiting to be notified:
    3LKWAITNOTIFY "Watchdog" (9D789DE0)
    3LKWAITNOTIFY "Watchdog" (BC74FC0)
    3LKWAITNOTIFY "Watchdog" (9E5225F8)
    3LKWAITNOTIFY "Watchdog" (9F03B5B8)
    3LKWAITNOTIFY "StatusCacheTimedThread:true" (9F635EF0)
    3LKWAITNOTIFY "Thread-12" (AC91DD0)
    3LKWAITNOTIFY "Thread-13" (AC925B8)
    3LKWAITNOTIFY "Watchdog" (9CD1AB90)
    3LKWAITNOTIFY "WorkManager.wpsDefaultWorkManager : 1" (9DAA6888)
    3LKWAITNOTIFY "Thread-92" (A1139700)
    3LKWAITNOTIFY "Thread-50" (9E4D3EF0)
    3LKWAITNOTIFY "Thread-93" (A1CB0AA8)
    3LKWAITNOTIFY "Thread-94" (A1D94BF8)
    3LKWAITNOTIFY "Thread-57" (9D9D4788)
    3LKWAITNOTIFY "Thread-95" (A2242E30)
    3LKWAITNOTIFY "Thread-100" (A2898C18)
    3LKWAITNOTIFY "LogMonitorThread" (BC76A70)
    3LKWAITNOTIFY "Thread-28" (9817D758)
    3LKWAITNOTIFY "Thread-70" (9EEED0E8)
    3LKWAITNOTIFY "LogMonitorThread" (9E5233B8)
    3LKWAITNOTIFY "Thread-77" (9C8C3C58)
    3LKWAITNOTIFY "LogMonitorThread" (9F07D3C8)
    3LKWAITNOTIFY "LogMonitorThread" (9CD16D38)
    3LKWAITNOTIFY "UpstreamPing" (9F630B60)
    3LKWAITNOTIFY "StatusCacheTimedThread:false" (9F6364A8)
    3LKWAITNOTIFY "SLAServiceActivator" (9D352718)
    3LKWAITNOTIFY "LogMonitorThread" (9D78B708)
    2LKREGMON Method trace lock (0x08085120):
    2LKREGMON Heap lock (0x08084FA0): owner "Signal dispatcher" (8164A58), entry count 1
    2LKREGMON Monitor Cache lock (0x08084EE0): owner "Signal dispatcher" (8164A58), entry count 1
    2LKREGMON JNI Pinning lock (0x08085000):

  4. Re: Caused by: java.sql.SQLException: ORA-03135: connection lostcontact

    this is other error related with "ORA-03135: connection lost contact"

    wps.out_09.11.30_00.00.00.log:[29/11/09 20:48:09:443 GMT] 00000065 AlarmListener E SCHD0063E: A task with ID 6401 failed to run on Scheduler WPSTaskScheduler (wps/Scheduler) because of an exception: com.ibm.websphere.scheduler.SchedulerNotAvailableE xception: java.sql.SQLException: ORA-03135: connection lost contact
    wps.out_09.11.30_00.00.00.log:[29/11/09 20:48:16:971 GMT] 000000da SchedulerDaem E SCHD0104E: The Scheduler poll daemon WPSTaskScheduler (wps/Scheduler) failed to load tasks from the database due to an exception: com.ibm.websphere.scheduler.SchedulerNotAvailableE xception: java.sql.SQLException: ORA-03135: connection lost contact

  5. Re: Caused by: java.sql.SQLException: ORA-03135: connection lostcontact

    Please see if APAR pk82971 helps your issue.

    *Matt Munse*

    The postings on this site are my own and do not necessarily represent the positions, strategies, or opinions of IBM.

+ Reply to Thread