OraFAQ Forum: SQL & PL/SQL » How to check open http connections in the database

Home » SQL & PL/SQL » SQL & PL/SQL » How to check open http connections in the database (oracle 10g - 10.2.0.4 , Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to check open http connections in the database [message #550914]

Fri, 13 April 2012 08:49

sanei05
Messages: 104
Registered: September 2008

Senior Member

Hi ,

How to check the open http connections in the database as I am getting.

ORA-29270: too many open HTTP requests

Report message to a moderator

Re: How to check open http connections in the database [message #550915 is a reply to message #550914]

Fri, 13 April 2012 08:51

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

netstat -a

bcm@bcm-laptop:~$ oerr ora 29270
29270, 00000, "too many open HTTP requests"
// *Cause: Too many HTTP requests were opened.
// *Action: End some HTTP requests and retry the HTTP request.

[Updated on: Fri, 13 April 2012 08:52]

Report message to a moderator

Re: How to check open http connections in the database [message #550916 is a reply to message #550915]

Fri, 13 April 2012 08:55

sanei05
Messages: 104
Registered: September 2008

Senior Member

Did not get you.. Can you please elaborate more..

Report message to a moderator

Re: How to check open http connections in the database [message #550917 is a reply to message #550916]

Fri, 13 April 2012 08:57

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

at OS command line issue following command

netstat -a

Report message to a moderator

Re: How to check open http connections in the database [message #550918 is a reply to message #550917]

Fri, 13 April 2012 09:03

sanei05
Messages: 104
Registered: September 2008

Senior Member

i tried with netsat -ntu .
I get the following

Proto Recv-Q Send-Q Local Address Foreign Address State
tcp 0 0 127.0.0.1:58049 127.0.0.1:6113 ESTABLISHED
tcp 0 0 10.100.0.51:1522 10.100.0.61:35343 ESTABLISHED

How to find which is the http connections.. can you please guide me on this..

Report message to a moderator

Re: How to check open http connections in the database [message #550919 is a reply to message #550918]

Fri, 13 April 2012 09:04

sanei05
Messages: 104
Registered: September 2008

Senior Member

also, is there any way to find from db side ??

Report message to a moderator

Re: How to check open http connections in the database [message #550921 is a reply to message #550919]

Fri, 13 April 2012 09:12

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>How to find which is the http connections.. can you please guide me on this..
what part of
netstat -a
do you NOT understand?

>also, is there any way to find from db side ??
implement you own "netstat" PL/SQL procedure using UTL_TCP;
or host out & use OS netstat.

Report message to a moderator

Re: How to check open http connections in the database [message #550922 is a reply to message #550921]

Fri, 13 April 2012 09:12

sanei05
Messages: 104
Registered: September 2008

Senior Member

thanks a lot.. I got it..

netstat -an | grep :80 | sort -nr. .It worked..

Report message to a moderator

Previous Topic:	Issues with Oracle Directory when loading xml file into clob data type.
Next Topic:	Equi Join and Inner Join

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 24 08:34:06 CST 2026