Re: SQL*Net V2

From: Jayasree Surya <jayasree_at_quake.Stanford.EDU>
Date: 1 Apr 1993 18:17:38 GMT
Message-ID: <1pfbk2INNo23_at_morrow.stanford.edu>

In article <1993Mar15.173043_at_ldds4.london.chevron.com>, eccmr_at_ldds4.london.chevron.com (Marcus Collins) writes:
> Path:

morrow.stanford.edu!decwrl!decwrl!uunet!lhdsy1!nntpserver.chevron.com!ld ds4.london.chevron.com!eccmr
> From: eccmr_at_ldds4.london.chevron.com (Marcus Collins)
> Newsgroups: comp.databases.oracle
> Subject: SQL*Net V2
> Message-ID: <1993Mar15.173043_at_ldds4.london.chevron.com>
> Date: 15 Mar 93 17:30:43 GMT
> Sender: news_at_nntpserver.chevron.com (USENET News System)
> Organization: Chevron
> Lines: 57
>
> 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.
>

I'm having the same kind of error on my Sun running O/S v4.1.2. But the error number I get
is

        Error: ora-12504: (cncterr, can't get err txt, See Servr Msgs & Codes Manual)

I've tried everything possible, including calling Oracle Support but they couldn't help
so far. BTW I used the Config tool to create the listener.ora and tnsnames.ora files.

I would appreciate any help.

Jayasree Received on Thu Apr 01 1993 - 20:17:38 CEST