Conference orarep::nomahs::sql_services

2209.0. "SQLNET4RDB ORA-12537 when exiting application" by CHSR36::JSUBRI (Focus on Open/Rdb++) Fri May 23 1997 10:12

Hello,

	SQL/Services V7.1 + SQL*Net for Rdb in now installed on my machine.
I just noticied an ORA-12537 when exiting from SQLPLUS.

12537, 00000, "TNS:connection closed"
// *Cause: "End of file" condition has been reached; partner has disconnected.
// *Action: None needed; this is an information message.

Why reporting %SQLSRV-E-TNSFAILURE...  as Error when O7 report it as
informationnal ?

/Jean-Luc

------------EVENT BEGIN:  EVENT_LOG at Fri May 23 1997 09:16:52.470-------------
%SQLSRV-I-EVENT_LOG, event logged at line 1690 in file COM_TNS.C;1
%SQLSRV-E-TNSFAILURE, Oracle SQL*Net TNS nsrecv() service has failed
%SQLSRV-E-TNSEXTENDED, Oracle SQL*Net TNS error codes: primary (12537) secondary
 (0)
------------EVENT END  :  EVENT_LOG at Fri May 23 1997 09:16:52.471-------------

------------EVENT BEGIN:  EVENT_LOG at Fri May 23 1997 09:16:52.725-------------
%SQLSRV-I-EVENT_LOG, event logged at line 284 in file DISP.C;1
%SQLSRV-W-EXCEPTION_RAISE, Exception raised: DBS_TNSFAILED
%SQLSRV-I-CONNECTNAME, Connect : CONNECT_0000015
%SQLSRV-I-CONNECTSTATE, Connect state: 4
%SQLSRV-I-USERNAME, User name: jsubri
%SQLSRV-I-NODENAME, Node : unknown
%SQLSRV-I-APPLNAME, Application : $2$DKA500:[ROOT7323.][SQLPLUS]SQLPLUS.EXE
%SQLSRV-I-SERVICENAME, Service : MF_PERS70_OCI
------------EVENT END  :  EVENT_LOG at Fri May 23 1997 09:16:52.735-------------
    

Did your client see an error, or are you just talking about what's in
the log?  We actually document this error as being something that you
can ignore in this version.  It should not result in an error on the
client side.

See secion 3.10 in the Oracle Rdb Guide to SQL*Net for Rdb.

- Ray

    Ray,
    
    	I got no error from client appli.
    It was just about the contents of the log file, ie ( -E- when expected 
    -I- )    
    
    -)
    /Jean-Luc