Expand my Community achievements bar.

SOLVED

Oracle Database Connection Pool Issues

Avatar

Level 4

We're seeing an issue with our connection pooling and i just wanted to see if anyone else had ever run into this problem. The first few people to log in in the morning receive error messages when trying to open a page because it appears that our database connections in the pool seem to expire or die overnight. When the users hit them in the morning they throw messages such as -

 

No more data to read from socket

IO Error: Broken pipe

Listener refused the connection with the following error: ORA-12516, TNS:listener could not find available handler with matching protocol stack

 

However, it looks like when they do try to use a dead connection it is cleared out of the pool. After enough page refreshes the pool clears itself of all faulty connections and the site begins to work normally. Has anyone ever heard of or experienced anything like this? It doesn't appear to be an issue with our database machine as other non-cq applications have no trouble.

Thanks

1 Accepted Solution

Avatar

Correct answer by
Level 10

It looks at oracle configured maximum number of processes limitation being reached.  Your DBA can help to increase the processes and sessions value to allow the listener to spawn more server process as required in your environment. Does not looks like client side issue. 

View solution in original post

1 Reply

Avatar

Correct answer by
Level 10

It looks at oracle configured maximum number of processes limitation being reached.  Your DBA can help to increase the processes and sessions value to allow the listener to spawn more server process as required in your environment. Does not looks like client side issue.