Errors trying to connect from 8.1.7 client to 7.3.2 server

From: Schauss, Peter <SCHAUPE_at_mail.northgrum.com>
Date: Thu, 25 Jul 2002 13:38:22 -0800
Message-ID: <F001.004A2D8E.20020725133822@fatcity.com>

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).

Received on Thu Jul 25 2002 - 16:38:22 CDT