ora-30678 two many connections are open
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ora-30678 two many connections are open

  1. #1
    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

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    Shutdown MTS.
    Use dedicated server connection.
    And then try again.

    Tamil

Posting Permissions

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



Click Here to Expand Forum to Full Width