| Listener JDBC Connection Problem [message #248679] |
Sat, 30 June 2007 06:29  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
