Re: End of TNS Data Channel

On Mon, 24 Feb 2003 11:00:38 +0100, "s Lehaire" <s.lehaire_at_meilleuregestion.com> wrote:

>Hi,
>I'm using Windows 2k, oracle 9i and tomcat 3.2 with jdbc:thin driver
>I can connect to my database with sqlplus, toad, visual studio or sqlplusw
>and get 1 or 20 connection without any problems.
>But when I load tomcat it can't connect to my database i'v got a "End of
>TNS Data Channel"
>I have onfigure my oracle whith MTS like this :
>mts_dispatchers="(PROTOCOL=TCP)(DISPATCHERS=3)"
>mts_service=MPHP
>mts_max_dispatchers=5
>mts_servers = 5
>mts_max_servers = 20
>
>It was working before friday (I don't know what it change on the config of
>tomcat but nothing have change on my oracle config) but now it's impossible
>to connet my tomcat to my oracle and i've got no idea to where looking for.
>When I look to the alrt log i've got :
>found dead shared server 'S000', pid = (9, 4)
>
>so what can I do,
>I'm lost
>so please help me !!
>
>
>Thx for any help
>

The dead shared server could hardly be the cause, as they restart themselves, and client connections get in touch with the dispatcher.

I would first try to assure you can not using a dedicated server connection, which you can easily enforce by putting use_dedicated_server = true
in sqlnet.ora
That file you would also need to modify to enable tracing at support level, as is documented in the chapter on troubleshooting in the net8 manual, and as I have posted many, many, many times before.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Feb 24 2003 - 11:54:15 CST