HELP with SQL*Net V1 on SunSPARC with Solaris 2
Date: 1996/06/18
Message-ID: <4q5t60$qov_at_btmpjg.god.bel.alcatel.be>#1/1
Recently, we have installed another Oracle server in our network. Apparently, the existing SQL*Net V1 clients cannot connect to this new server.
Original network :
Oracle server RDBMS 7.0.15.4 SQL*Net TCP/IP V1 orasrv 1.2.7.7.1, listening on port 1525 Oracle client SQL*Plus 3.1.3.2.1
Server and clients run on SunSPARCs with SunOS 4.1.3_U1
The network is upgraded with :
Oracle server RDBMS 7.1.4.1
SQL*Net TCP/IP V1 orasrv 1.2.7.8.1, listening on port 1525
SQL*Net TCP/IP V2 tnslsnr 2.1.4.1.0, listening on port 1521
Oracle client SQL*Plus 3.1.3.5.1
Server and clients run on SunSPARCs with SunOS 5.4
All servers and clients are in the same TCP/IP community.
The current situation :
The new clients can connect to the new server with SQL*Net V2. The new clients can connect to the old server with SQL*Net V1. The old clients can connect to the old server with SQL*Net V1.The old clients cannot connect to the new server with SQL*Net V1.
I have used checkTCP to verify the correct installation of SQL*Net V1 on the new server.
The client reports :
ERROR: ORA-03113: end-of-file on communication channel
I have started orasrv with the debug=6 option.
This is the relevant part of the log file :
execute server (oraclell1 T:I,,7) pid = 5850
waiting for connection request...
reaping child...
wait returns pid 5850 errno 0 status 1
PID 5850 died with status=1
Apparently, the server process exits immediatly.
Any suggestion will be greatly appreciated.
Frans Janssens
frans_at_sebb.bel.alcatel.be
Received on Tue Jun 18 1996 - 00:00:00 CEST