OraFAQ Forum: Server Administration » Web server hangs after exceeding number of connection

Home » RDBMS Server » Server Administration » Web server hangs after exceeding number of connection

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

Web server hangs after exceeding number of connection [message #213589]

Thu, 11 January 2007 06:25

dbasif
Messages: 35
Registered: March 2006
Location: Bangalore, India

Member

Hi DBAs,

Our webserver hands after exceeding a number of connections and we need to restart again the server.

please find the following details :-

We are maintaining one DB server and 4 webserver .
---------------------------------------------------------------
OS Platform (for DB and Webserver)
: Sun Microsystems Inc. SunOS 5.9
Web server : SunONE 6.1
Database Version : Oracle Database 10g Release 10.1.0.2.0 - 64bit
Physical RAM (for DB server) : 8Gb.
Physical RAM (for Web server):4 web server each of 4 GB

Connect descriptor used in webserver to connect to oracle:

We use JDBC connection pooling that comes with the web server(SunONE)
The details of the configuration are:

<JDBCCONNECTIONPOOL name="wbol-pool" datasourceclassname="oracle.jdbc.pool.OracleDataSource" steadypoolsize="8" maxpoolsize="100"
poolresizequantity="2" idletimeout="300" maxwaittime="180000" connectionvalidationrequired="off"
connectionvalidationmethod="auto-commit" validationtablename="" failallconnections="off" transactioniso
lationlevel="read-committed" isolationlevelguaranteed="on">
<PROPERTY name="URL"
value="jdbc:oracle:thin:@{server ip}:1521:wborcle"/>
<PROPERTY name="User" value="username"/>
<PROPERTY name="Password" value="password"/>
</JDBCCONNECTIONPOOL>

Database is running in Shared mode(with 4 dispatchers) but clients are connected through dedicated mode.

max_process = 810
cur_process = 349

in alert.log file i have seen below error :-
Process q000 started up but failed with error = 20
-----------------------------------------------------------------
user not able to stablish a connection through sqlplus also when web server hangs .

Hope you can help me to identify the problem based on above information, if any thing else u wanted to know plz let me know..

Asif

Attachment: Sessions.txt
(Size: 167.41KB, Downloaded 1808 times)

Report message to a moderator

Re: Web server hangs after exceeding number of connection [message #213596 is a reply to message #213589]

Thu, 11 January 2007 06:54

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

What is tha value of AQ_TM_PROCESSES and PROCESSES ?

Also do a search on Metalink.

Report message to a moderator

Re: Web server hangs after exceeding number of connection [message #213694 is a reply to message #213596]

Thu, 11 January 2007 22:50

dbasif
Messages: 35
Registered: March 2006
Location: Bangalore, India

Member

AQ_TM_PROCESSES =1
process = 810

Report message to a moderator

Re: Web server hangs after exceeding number of connection [message #213696 is a reply to message #213694]

Thu, 11 January 2007 22:52

dbasif
Messages: 35
Registered: March 2006
Location: Bangalore, India

Member

one more thing server hangs with following error message

ORA-12500, TNS:listener failed to start a dedicated server process

Report message to a moderator

Re: Web server hangs after exceeding number of connection [message #213735 is a reply to message #213696]

Fri, 12 January 2007 02:12

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

Do a search on Metalink for the issue.

Still I wonder what will happen if you set
AQ_TM_PROCESSES=0 and PROCESSES=1000

About the listner check the listner.log and see if you can find
anything there.

Report message to a moderator

Re: Web server hangs after exceeding number of connection [message #213951 is a reply to message #213696]

Fri, 12 January 2007 22:52

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,

ORA-12500, TNS:listener failed to start a dedicated server process
can you post your listener.log files.

regards
Taj

Report message to a moderator

Previous Topic:	oracle prevent
Next Topic:	Server Client connection with sysdba

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 11 02:59:39 CST 2025