SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

UTL_SMTP. ORA-30678: too many open connections. Why?

554899Jan 6 2009 — edited Sep 22 2011

Hi,

I'm using UTL_SMTP for sending email to support staff in some scenarios. it all worked fine untill today we got following error in Java logs. I searched and found one similar post at [http://asktom.oracle.com/pls/asktom/f/f?p=100:11:0::::P11_QUESTION_ID:255615160805#611756800346679486]

- Caused By (java.sql
.SQLException: ORA-20005: prc_my_sp - ORA-30678: too many open connections
ORA-06512: at "SYS.UTL_TCP", line 28
ORA-06512: at "SYS.UTL_TCP", line 257
ORA-06512: at "SYS.UTL_SMTP", line 115
ORA-06512
ORA-06512: at "MY_PKG", line 1378
{code}Still, I'm not able to make out how to resolve this error.

We use 
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
"CORE	10.2.0.4.0	Production"
TNS for Solaris: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

Please throw some light on cause and resolution.



Thanks,
Sam

This post has been answered by rajasekhar_n on Jan 6 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 20 2011

Added on Jan 6 2009

5 comments

18,739 views