sqlException : End of TNS data channel
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: sqlException : End of TNS data channel

  1. #1
    Join Date
    Dec 2001
    Posts
    120

    sqlException : End of TNS data channel

    hi all,

    "End of TNS data channel" is getting generated very often in our application server. we are using pramati application server and oracle 9i version 0.1.1. Everything was running smooth till we changed over to oracle 9i from oracle 8i. The trace file only shows
    the following errors:
    -----------------------------------------------
    Thu May 22 15:47:07 2003
    found dead shared server 'S000', pid = (8, 5)
    found dead shared server 'S002', pid = (15, 18)
    Thu May 22 15:47:23 2003
    found dead shared server 'S000', pid = (8, 6)
    found dead shared server 'S001', pid = (15, 19)
    found dead shared server 'S003', pid = (17, 3)
    Thu May 22 15:48:15 2003
    found dead shared server 'S000', pid = (8, 7)
    Thu May 22 15:49:07 2003
    found dead shared server 'S000', pid = (8, 8)
    Thu May 22 15:49:35 2003
    found dead shared server 'S000', pid = (8, 9)
    Thu May 22 15:50:20 2003
    found dead shared server 'S000', pid = (8, 10)
    Thu May 22 15:50:22 2003
    ------------------------------------------------

    could any one pls mention whats going wrong and how to rectify the error ?

    thanks a lot

    Parijat Paul

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434

    Re: sqlException : End of TNS data channel

    Originally posted by parijat67
    hi all,

    oracle 9i version 0.1.1.

    Parijat Paul
    I have had heard from my collegue ( Dunno how far its true )...

    That version 9.0.1.x has some ( can say significant number ) bugs...and are fixed in 9.2.0.x...

    Well, i dont directly suggest to upgrade to 9.2.x...
    Moderaters here can help you...more..

    Hrishy, Amar, Pando wat do u guys tell?

    Abhay.

    ( Please note this is not my suggestion, but beleving my collegues and telling you )..
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

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