Home » RDBMS Server » Server Administration » Web server hangs after exceeding number of connection
icon8.gif  Web server hangs after exceeding number of connection [message #213589] Thu, 11 January 2007 06:25 Go to next message
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 643 times)
Re: Web server hangs after exceeding number of connection [message #213596 is a reply to message #213589] Thu, 11 January 2007 06:54 Go to previous messageGo to next message
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.
Re: Web server hangs after exceeding number of connection [message #213694 is a reply to message #213596] Thu, 11 January 2007 22:50 Go to previous messageGo to next message
dbasif
Messages: 35
Registered: March 2006
Location: Bangalore, India
Member

AQ_TM_PROCESSES =1
process = 810
Re: Web server hangs after exceeding number of connection [message #213696 is a reply to message #213694] Thu, 11 January 2007 22:52 Go to previous messageGo to next message
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

Re: Web server hangs after exceeding number of connection [message #213735 is a reply to message #213696] Fri, 12 January 2007 02:12 Go to previous messageGo to next message
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.
Re: Web server hangs after exceeding number of connection [message #213951 is a reply to message #213696] Fri, 12 January 2007 22:52 Go to previous message
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
Previous Topic: oracle prevent
Next Topic: Server Client connection with sysdba
Goto Forum:
  


Current Time: Mon Dec 05 19:14:57 CST 2016

Total time taken to generate the page: 0.11795 seconds