hoohee.com - Oracle 10g XE TNS Listener JDBC problem

Tuesday, May 30, 2006

If you run a process that opens and closes connections very fast, the Oracle 10g XE listener fails with the following error:

Connection refused(DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12519)(ERROR_STACK=(ERROR=(CODE=12519)(EMFI=4))))

To fix this problem, simple change the number of processes in the SPFILE to a large number (see example below).

ALTER SYSTEM SET PROCESSES=250 SCOPE=SPFILE

The alter command requires a DB restart.

This seems to have fixed my problem... or delays the error from occuring.

5/30/2006 11:16:41 AM (AUS Eastern Standard Time, UTC+10:00)

Comments [4] Oracle |

9/12/2006 11:55:55 PM (AUS Eastern Standard Time, UTC+10:00)

Thanks, that was very useful..

piotr

10/18/2006 10:33:33 AM (AUS Eastern Standard Time, UTC+10:00)

Thanks!

I was having the same problem and after about 7 hours of blindly searching the net and wading through useless 'ASK Tom' articles the answer is right here in 2 sentences, no less.

Thanks for posting the solution to my problem!

Dave M

11/8/2007 10:45:44 AM (AUS Eastern Daylight Time, UTC+11:00)

Thank you so much.
I was in such a dead line, if it wasn't for that
I could even have lost my job.

May God bless you!
=)

Eduardo Rodrigues |ietsiraAT NOSPAMyahoo dot fr

12/5/2007 2:15:32 PM (AUS Eastern Daylight Time, UTC+11:00)

I finally found your solution after many hours of
struggling. Thanks for posting this solution!

During my web searching, I found another trying to
work through this. I posted the link to this page.
(hope you don't mind)

Here's the link to where I posted your link:
http://forums.oracle.com/forums/thread.jspa?threadID=488140&tstart=0

Jerry Jones

Name
E-mail
Home page

	Remember Me
Comment (HTML not allowed)
Enter the code shown (prevents robots):