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 > [EMAIL PROTECTED] > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Schauss, Peter > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
