Verify the client tnsnames.ora is using SID and not SERVICE_NAME for
CONNECT_DATA.
"Schauss, Peter" wrote:
>
> Environment:
>
> Client - 8.1.7 running on AIX 4.3.3
> Server - 7.3.2 on SGI IRIX64 version 6.5
>
> I can connect from SQLPlus Worksheet on Windows 2000
> (also 8.1.7), but when I try to connect from sqplus (command line)
> on the AIX machine I get ORA-12504.
>
> I can connect to other 8.1.7 systems from the AIX client and the
> tnsnames.ora file entry for my 7.3.2 server is a direct copy from
> tnsnames.ora on my W2k box.
>
> My sqlnet.log file shows:
>
> ***********************************************************************
> Fatal NI connect error 12504, connecting to:
>
> (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mfgad11)(PORT=1521))(CONECT_DATA=(
> SID
> _NAME=test1))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=bemwi755)(USER=oracle))))
>
> VERSION INFORMATION:
> TNS for IBM/AIX RISC System/6000: Version 8.1.7.0.0 - Development
> TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version
> 8.1.7.0
> .0 - Development
> Time: 25-JUL-2002 16:09:03
> Tracing to file: /opt/oracle/cli.trc
> Tns error struct:
> nr err code: 0
> 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
>
> Any suggestions?
>
> Thanks in advance,
>
> Peter Schauss
> Northrop Grumman Corporation
> schaupe_at_mail.northgrum.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Schauss, Peter
> INET: SCHAUPE_at_mail.northgrum.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Suzy Vordos
INET: lvordos_at_qwest.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Jul 25 2002 - 19:13:25 CDT
