SQL*Net V2

From: Marcus Collins <eccmr_at_ldds4.london.chevron.com>
Date: 15 Mar 93 17:30:43 GMT
Message-ID: <1993Mar15.173043_at_ldds4.london.chevron.com>

I am having problems using SQL*Net v2, against a dedicated server.

Platform Sun SPARCstation SunOS 4.1.3

Oracle 7.0.12.1.0
SQL*Net 2.0.12.1.0

Accessing a multi-threaded server works OK but the connection to the dedicated server fails with the following error.

>sqlplus user/pswd_at_ldtapsdd < dedicated server>

SQL*Plus: Release 3.1.1.9.1 - Production on Mon Mar 15 17:18:27 1993

Copyright (c) Oracle Corporation 1979, 1992. All rights reserved.

ERROR: ORA-12500: (Cnct err, can't get err txt. See Servr Msgs & Codes Manual)

~ >oerr ora 12500
12500, 00000, "TNS:Listener failed to bequeath connection." // *Cause: The nsbequeath() API failed to pass handle to child. // *Action: Check the sid and privileges for the user.

The sqlnet.log file shows  

• Call was refused, with errstring: (DESCRIPTION=(ERR=12500))

Fatal OSN connect error 12500, connecting to:  (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = ldss53.londo n.chevron.com) (PORT = 1521))) ( CONNECT_DATA = (SID = ldtapsd) (SERVER = DEDICA TED)))   VERSION INFORMATION:

        TNS for SunOS: Version 2.0.12.1.0 - Developer's Release
        TCP/IP NT Protocol Adapter for SunOS: Version 2.0.12.1.0 - Developer's R

elease
  Time: 11-MAR-93 17:50:59
  Tracing to file: /local/lfs0/oracle/network/trace/client_trace.trc   Tns error struct:
    nr err code: 12204
    TNS-12204: TNS:received data refused from an application     ns main err code: 12564
    TNS-12564: TNS:connection refused
    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

Has anybody encountered the same problem and got a fix.  

--
 Marcus Collins                     Internet: eccmr_at_london.chevron.com
 Technical Applications.            Profs: CCMR
 Chevron (UK) Ltd.                  Phone: +44 71 487 8875
 2, Portman Street, London W1H 0AN.

Received on Mon Mar 15 1993 - 18:30:43 CET