Subject: Re: Whacko SQL*Net errors
References: <>

(Original article included after my comments).

In my documentation, I have a description of your errors:

TNS-12204:"TNS:Received data refused from an application"
// *Case: The application using the Interchange refused the connection
// at the listener.
// *Action: Make sure that the application listener at the destination is
// functioning correctly. If it is and the problem persists, contact
// Worldwide Customer Support.

TNS-12564:"TNS:connection refused"
// *Cause:The connect request was denied by the remote user (or TNS software).
// *Action: Not normally visible to the user. For further details, turn on
// tracing and reexecute the operation.

Information on tracing is in the Oracle Network Products Messages Manual.

Good luck, Steve.

-Ari Kaplan
Independent Oracle DBA Consultant

<-> Visit my Web Page:                          <->
<->             email:                    <->

Steve Green  writes:


>I am a newbie Oracle person who is trying to setup a system called "AutoSys" thta uses Oracle to
>it's data.

>I'm pretty certian I've got the Oracle/SQL*Net stuff working correctly.

>TNSPING, SQLPLUS, etc works just fine.

>However, when I run one of the AutoSys applications ( gatekeeper ) I get the following:

>Fatal OSN connect error 12500, connecting to:
> (description=(connect_data=(sid=asys)(server=dedicated)(CID=(PROGRAM=)(HOST=aln

>        TNS for SVR4: Version - Production
>        Unix Domain Socket IPC NT Protocol Adaptor for SVR4: Version
>- Production
>        Oracle Bequeath NT Protocol Adapter for SVR4: Version - Produ
>        TCP/IP NT Protocol Adapter for SVR4: Version - Production
>  Time: 09-APR-96 15:08:26
>  Tracing not turned on.
>  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

>I cannot find any error 12204 or 12564 in the SQL*Net manual and certainly not in the main errors
>codes manual.

>So I'm kinda stuck!

>Anybody got any ideas?

>Thanks in advance.


Back to Ari Kaplan's Home Page width="16" height="18">Back to Ari Kaplan's Home Page