Blog Home  Home RSS 2.0 Atom 1.0 CDF  
 
hoohee.com - Technical|Oracle
 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  | 
Copyright © 2008 Emile Bassil. All rights reserved.