Re: SQLNET V2 TCP/IP - erratic behaviour during connection
Date: 8 Sep 1994 06:28:31 GMT
Message-ID: <34mauf$clt_at_dcsun4.us.oracle.com>
gopi_t1_at_verifone.com (T.K. GOPIKRISHNA, software,BLR,01191812-269920) writes:
|> Hello,
|>
|> We have been experiencing pretty randomly the problem of not being able to
|> connect to the oracle database using the sqlnet V2 on TCP/IP on a unix box.
|> The message I get when I try to connect looks something like "end-of-file on
|> communication channel". I checked up that the listener is running on the
|> configured TCP port. The problem clears up if I stop the listener and
|> restart again. I am able to connect thereafter and use the database.
|>
|> I am not able to get the exact sequence that can reproduce
|> this problem. Has anyone out there got this kind of problem? What is the
|> workaround or is there something in configuration which i have missed out.
|> Please help me out in getting over this problem.
|>
|> Thanks
|> gopi
|>
Interesting... can you tell us the exact platform and version of Oracle
you are running? The fact that you are getting "EOF on ..." (aka ORA-3113)
generally means you are at least reaching the listener. I can only guess
that it's failing to spawn a shadow server for you or redirecting you to
a non-existent dispatcher if you are configured for MTS. Neither of these
ring a bell for me.
Roderick Manalac