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

Thread: TNS connection

  1. #1
    Join Date
    Feb 2001
    Posts
    83
    Hi,

    When i perform batch inserts thru java procedures into Oracle DB, i get the following error

    TNS-12612 TNS:connection is busy

    What may be reason for this??


    with regards
    Prasanna S

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Check the $ORACLE_HOME/network/log//listener.log and
    $ORACLE_BASE/admin/sid/bdump/alert_sid.log for detail on the cause of the error. It could be some of the following reasons, you are running out of sessions, you are running out of java_poo_size or other java parameters, or you are running out of other common shared resources. the logs would explaing things in detail

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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