Re: Solaris 2.x and Oracle 7.1.x problem

In article <3u58j0$jpr_at_sirio.cineca.it>, Christian Righi <crighi_at_sun10.inf.unitn.it> writes:
> We are installing sqlnet Version 1 (tcp-ip) on a sparc-station20 with
> solaris 2.3.
> All seems to go well except for this strange message
>
> ERROR: ORA-03113: end-of-file on communication channel
>
> When we try to connect to oracle from a client macchine with the
> command sqlplus username/password_at_t:macchine:dbsid
> The very strange thing is that the statistic on the orasrv seems
> to be ok.
>
> this is the output for the command : tcpctl status
>
> tcputl: Status summary follows
> Server is running:
> Started : 14-JUL-95 09:07:38
> Last connection : 14-JUL-95 09:52:20
> Total connections : 4
> Total rejections : 3
> Active subprocesses : 4
> ORACLE SIDs : db1
> Default SID : (null)
>

                                                                             |

We had exactly the same problem and it did not matter if it was SQL*Net V1 or V2. Worked on it for 4 days with Oracle Tech support (was that painfull) and got no where!

Finally another site in Telecom Australia with the same problem rang the same Tech support team but got a different Oracle staff and solved the problem.

You have to relink you Oracle binaries using the orainst program as the sqlnet libraries was not linked in. :-(

ta
tony

-- 
 _____       ________ / ___ |Tony Jambu, Database Consultant
  /_  _        /_ __ /      |Wizard Consulting,Aust (ACN 065934778)
 /(_)/ )(_/ \_/(///(/_)/_(  |CIS: 100250.2003_at_compuserve.com FAX: +61-3-4163559
 \_______/                  |EMAIL:TJambu_at_wizard.com.au PHONE: +61-3-4122905

******************************** W a r n i n g ******************************
Microsoft Network is prohibited from redistributing this work in any form, in
whole or in part, without the express written consent of the original author.