Home » RDBMS Server » Networking and Gateways » Listener JDBC Connection Problem
Listener JDBC Connection Problem [message #248679] Sat, 30 June 2007 06:29 Go to next message
pra_dbaquery
Messages: 6
Registered: June 2007
Location: Jamnagar
Junior Member
can anybody help me for solving following problem.

We have Oracle9i - 9.2.0.1installed in Database server. And OS is Windows Server 2003 enterprise edition.

In this server, from application side there are lot of JDBC connections established regularly, and the problem is it will create 12 connections per second as per I observed in listener.log.

I have converted this database from dedicated to shared server with 10 dispatchers. But also sometimes listener failed and not able to manage the applications connection.

So as per my knowledge, we should tune both application and database listener. So I wanted to enable the Connection Pooling feature for managing the idle connections.

so can u guide me solve this problem, becuase it is production server.



LSNRCTL> services
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=JGSRVR05)(PORT=1521)))
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 55: Unknown error
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "atsdb" has 1 instance(s).
Instance "atsdb", status READY, has 11 handler(s) for this service...
Handler(s):
"D009" established:863152 refused:0 current:23 max:1002 state:ready
DISPATCHER <machine: JGSRVR05, pid: 3472>
(ADDRESS=(PROTOCOL=tcp)(HOST=JGSRVR05.pdc_rpl2.jg.ril.com)(PORT=1073))
"D008" established:948202 refused:0 current:2 max:1002 state:ready
DISPATCHER <machine: JGSRVR05, pid: 3440>
(ADDRESS=(PROTOCOL=tcp)(HOST=JGSRVR05.pdc_rpl2.jg.ril.com)(PORT=1072))
"D007" established:982245 refused:0 current:23 max:1002 state:ready
DISPATCHER <machine: JGSRVR05, pid: 3428>
(ADDRESS=(PROTOCOL=tcp)(HOST=JGSRVR05.pdc_rpl2.jg.ril.com)(PORT=1071))
"D006" established:967578 refused:0 current:24 max:1002 state:ready
DISPATCHER <machine: JGSRVR05, pid: 3424>
(ADDRESS=(PROTOCOL=tcp)(HOST=JGSRVR05.pdc_rpl2.jg.ril.com)(PORT=1070))
"D005" established:754406 refused:0 current:23 max:1002 state:ready
DISPATCHER <machine: JGSRVR05, pid: 3404>
(ADDRESS=(PROTOCOL=tcp)(HOST=JGSRVR05.pdc_rpl2.jg.ril.com)(PORT=1068))
"D004" established:941637 refused:0 current:23 max:1002 state:ready
DISPATCHER <machine: JGSRVR05, pid: 3396>
(ADDRESS=(PROTOCOL=tcp)(HOST=JGSRVR05.pdc_rpl2.jg.ril.com)(PORT=1069))
"D003" established:1056539 refused:0 current:23 max:1002 state:ready
DISPATCHER <machine: JGSRVR05, pid: 3384>
(ADDRESS=(PROTOCOL=tcp)(HOST=JGSRVR05.pdc_rpl2.jg.ril.com)(PORT=1067))
"D002" established:1091197 refused:0 current:23 max:1002 state:ready
DISPATCHER <machine: JGSRVR05, pid: 3372>
(ADDRESS=(PROTOCOL=tcp)(HOST=JGSRVR05.pdc_rpl2.jg.ril.com)(PORT=1066))
"D001" established:827730 refused:0 current:23 max:1002 state:ready
DISPATCHER <machine: JGSRVR05, pid: 3360>
(ADDRESS=(PROTOCOL=tcp)(HOST=JGSRVR05.pdc_rpl2.jg.ril.com)(PORT=1065))
"D000" established:1143192 refused:0 current:2 max:1002 state:ready
DISPATCHER <machine: JGSRVR05, pid: 3348>
(ADDRESS=(PROTOCOL=tcp)(HOST=JGSRVR05.pdc_rpl2.jg.ril.com)(PORT=1064))
"DEDICATED" established:1 refused:0 state:ready
LOCAL SERVER
The command completed successfully
LSNRCTL>




Regards
Prashant Atri - DBA,
Server Admin Section,
MCN, Reliance Greens.
Re: Listener JDBC Connection Problem [message #248693 is a reply to message #248679] Sat, 30 June 2007 10:47 Go to previous message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>So I wanted to enable the Connection Pooling feature for managing the idle connections.
Connection pooling is done by the client application & is independent of the database server.
Previous Topic: Oracle Connection
Next Topic: Removing Dynamic Registered service name from the default listner
Goto Forum:
  


Current Time: Sat Dec 03 05:39:26 CST 2016

Total time taken to generate the page: 0.09771 seconds