Newsgroups: comp.databases.oracle
Subject: Re: Whacko SQL*Net errors
References: <3169E34A.1CF5@its.csiro.au>
(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: www.arikaplan.com <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Steve Green writes:
>Greetings,
>I am a newbie Oracle person who is trying to setup a system called "AutoSys" thta uses Oracle to
store
>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
>itak)(USER=autosys)))(ADDRESS_LIST=(ADDRESS=(PROTOCOL=ipc)(KEY=alnitak))(address
>=(protocol=tcp)(host=alnitak)(port=1521))))
> VERSION INFORMATION:
> TNS for SVR4: Version 2.0.15.0.0 - Production
> Unix Domain Socket IPC NT Protocol Adaptor for SVR4: Version 2.0.15.0.0
>- Production
> Oracle Bequeath NT Protocol Adapter for SVR4: Version 2.0.15.0.0 - Produ
>ction
> TCP/IP NT Protocol Adapter for SVR4: Version 2.0.15.0.0 - 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
and
>codes manual.
>So I'm kinda stuck!
>Anybody got any ideas?
>Thanks in advance.
>Steve
Back to Ari Kaplan's Home Page