DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ora-30678 two many connections are open

  1. 05-13-2004, 07:24 AM #1
    sendilbabu
    sendilbabu is offline Junior Member
    Join Date
    Apr 2004
    Posts
    3

    ora-30678 two many connections are open

    we have getting error while running the particular procedure for sending the mail using the utl_smtp packages.
    Detail of the applications Front end application VB6 backend oracle 9.2,write now oracle server is configured in MTS,while executing procedures ,that procedure use to send the mail .It pick the data from table,send it using the oracle package utl_smtp.When we calling the procedure from front end we have getting the ora-30678 two many connections are open,At max the session opened will be 200.I am awaiting for Reply's

    Thanks in advance

    Babu
    Reply With Quote Reply With Quote
  2. 05-13-2004, 11:47 AM #2
    tamilselvan
    tamilselvan is offline Senior Advisor
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Shutdown MTS.
    Use dedicated server connection.
    And then try again.

    Tamil
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width