Re: Errors trying to connect from 8.1.7 client to 7.3.2 server
Not sure about AIX, but on some platforms the format of tnsnames.ora can be quite picky. Have also experienced odd errors connecting from 8x to 7x databases. You might try reformatting it like this: test1.world = (DESCRIPTION = (ADDRESS = (PROTOCOL=TCP)(HOST=mfgad11)(PORT=1521)) (CONNECT_DATA = (SID = test1)) ) If that doesn't work, try using netasst to add the tnsnames.ora entry. Suzy Schauss, Peter wrote: Here is the tnsnames.ora entry. As I mentioned in my previous note, this is a direct copy from tnsnames.ora on my W2k client which has no problem connecting to this database. test1.world= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP )(HOST = mfgad11)(PORT=1521)) ) (CONECT_DATA = (SID = test1) ) ) Thanks for all of the suggestions so far. 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).
RE: Errors trying to connect from 8.1.7 client to 7.3.2 server
Peter, Sorry for repeating but: Can your AIX client ping this host: mfgad11.atdc.northgrum.com ? Is your domain: atdc.northgrum.com or northgrum.com ? Waleed -Original Message- Sent: Friday, July 26, 2002 1:25 PM To: Multiple recipients of list ORACLE-L I should have added that I can ping the host and tnsping works also. Tracing on the server shows that listener is receiving the connection but gives no hint of why the connection failed. $ lsnrctl status (on the server): LSNRCTL for SVR4: Version 2.3.2.1.0 - Production on 26-JUL-02 11:33:41 Copyright (c) Oracle Corporation 1994. All rights reserved. Connecting to (address=(protocol=tcp)(host=mfgad11.)(port=1521 )) STATUS of the LISTENER Alias LISTENER Version TNSLSNR for SVR4: Version 2.3.2.1.0 - Production Start Date25-JUL-02 15:28:34 Uptime0 days 20 hr. 5 min. 9 sec Trace Level off Security OFF SNMP OFF Listener Parameter File /usr/app/oracle/product/7.3.2/network/admin/listener.o ra Listener Log File /usr/app/oracle/product/7.3.2/network/log/listener.log Services Summary... test1 has 1 service handler(s) The command completed successfully -- -Original Message- Sent: Friday, July 26, 2002 10:53 AM To: Multiple recipients of list ORACLE-L Peter, Can you ping the remote host from AIX? Can you tnsping the remote database from AIX? What do you get when you run this: lsnrctl status (on the host running the database server)? I mean which host the listener is defined to listen on. Also you may need to trace the client and look at the output. Waleed -Original Message- Sent: Friday, July 26, 2002 9:43 AM To: Multiple recipients of list ORACLE-L Here is the tnsnames.ora entry. As I mentioned in my previous note, this is a direct copy from tnsnames.ora on my W2k client which has no problem connecting to this database. test1.world= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP )(HOST = mfgad11)(PORT=1521)) ) (CONECT_DATA = (SID = test1) ) ) Thanks for all of the suggestions so far. 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: Khedr, Waleed 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: 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: Khedr, Waleed 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
RE: Errors trying to connect from 8.1.7 client to 7.3.2 server
I should have added that I can ping the host and tnsping works also. Tracing on the server shows that listener is receiving the connection but gives no hint of why the connection failed. $ lsnrctl status (on the server): LSNRCTL for SVR4: Version 2.3.2.1.0 - Production on 26-JUL-02 11:33:41 Copyright (c) Oracle Corporation 1994. All rights reserved. Connecting to (address=(protocol=tcp)(host=mfgad11.atdc.northgrum.com)(port=1521 )) STATUS of the LISTENER Alias LISTENER Version TNSLSNR for SVR4: Version 2.3.2.1.0 - Production Start Date25-JUL-02 15:28:34 Uptime0 days 20 hr. 5 min. 9 sec Trace Level off Security OFF SNMP OFF Listener Parameter File /usr/app/oracle/product/7.3.2/network/admin/listener.o ra Listener Log File /usr/app/oracle/product/7.3.2/network/log/listener.log Services Summary... test1 has 1 service handler(s) The command completed successfully -- -Original Message- Sent: Friday, July 26, 2002 10:53 AM To: Multiple recipients of list ORACLE-L Peter, Can you ping the remote host from AIX? Can you tnsping the remote database from AIX? What do you get when you run this: lsnrctl status (on the host running the database server)? I mean which host the listener is defined to listen on. Also you may need to trace the client and look at the output. Waleed -Original Message- Sent: Friday, July 26, 2002 9:43 AM To: Multiple recipients of list ORACLE-L Here is the tnsnames.ora entry. As I mentioned in my previous note, this is a direct copy from tnsnames.ora on my W2k client which has no problem connecting to this database. test1.world= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP )(HOST = mfgad11)(PORT=1521)) ) (CONECT_DATA = (SID = test1) ) ) Thanks for all of the suggestions so far. 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: Khedr, Waleed 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: 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).
RE: Errors trying to connect from 8.1.7 client to 7.3.2 server
Title: RE: Errors trying to connect from 8.1.7 client to 7.3.2 server What does the tnsnames.ora entry on the client machines look like? In the CONNECT_DATA entry, do you have SID= (connect_data = (sid = AAA)) or service_name = and instance_name = ? (connect_data = (service_name = BBB.CCC.DDD) (instance_name = BBB)) -Original Message- From: Schauss, Peter [mailto:[EMAIL PROTECTED]] 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?
Re: Errors trying to connect from 8.1.7 client to 7.3.2 server
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).
