Re: Oracle SQL*Net v1 Connect problem

Chris Southern wrote:
>
> I have been try to get SQL*Net v1 listener setup to accecpt connections
> from clients. The server is alread configure to accept SQL*Net v2 connection and
> works.
>
> The listener is running, 'tcpctl start', and from the log file it accepts
> connection. But after the connection is made it is dropped and the client receives
> the error 'ORA-03113: Connect error, can't get error text'. Does anyone
> have any advice one solving this problem?

Ahhh, the famous ORA-03113 "We don't know what the problem is, but here is an error message anyway".

Well, ORA-03113 is usually associated with some other error. Check your alert.log files and/or turn on SQL*Net and SQL tracing to see if you can find the problem. Try SQL*Net 1 connections from another unix box as well since those damn PCees sometimes lock up or crash before closing file handles.

Do the standard stuff, try V1 connections on the unix box through the loopback and through the V1 connect string. And along with the "error text" message, make sure all of the environment variables are set connectly.

What is your environment configuration? PCees, Unix machines, versions, etc., etc.

• Neil Greene