hi everyone:
    I have a problem about Oracle 10g and a patched bug 1377901.
    Our system using Oracle 10g Win64 version and running a windows 2003 64bit HP.

When I using this system, it sometimes report ora-12519 error, and when this error

occurred, users can not connect to DB Server. This error occurred randomly not

always.  After I analyze the alter_log file, i found many PMON process died when ora

-12519 occur. And, then system will re-spawn a new PMON process, as the time pass by,

system will reached the 150 process limited. And when many users connect to system,

this error occurred frequently.
   I googled this ora-12519 error and hope to find a way to solve this problem. The

error message of ora-12519 is:TNS:no appropriate service handler found , oracle said

the cause of this error is:The listener could not find any available service handlers

that are appropriate for the client connection . But I found another thread said it's

is a oracle's bug, to solve this problem just change the following line in

tnsnames.ora file to another:
…
(CONNECT_DATA =
 (SID = nsapwebt)
 (SERVER = DEDICATED)
)
to
(CONNECT_DATA =
 (SERVICE_NAME = nsapwebt)
 (SERVER = DEDICATED)
)

Just replace SID with SERVICE_NAME! Really?! I'm changed right now. Then the problem

seems solved. Now the 10g haven't report this error til now. It's very strange!!  And

this bug number is 1377901 and have been fixed on Oracle 8.1.7.1, but re-occured on

10g?!
The url explain this fixed problem is:
http://oracle-docs.dartmouth.edu/dba-docs/patchset_8.1.7.2.htm#1377901

Is it true?! Have you or your friends who using 10g have been puzzled with this

problem? Can u share with me and other persons?  I known u are a Master of Oracle,

Can u help me?

Thank you.

Havel