| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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 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 Date 25-JUL-02 15:28:34 Uptime 0 days 20 hr. 5 min. 9 sec Trace Level off Security OFF SNMP OFF
-----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
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-LReceived on Fri Jul 26 2002 - 12:24:49 CDT
(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: Waleed.Khedr_at_FMR.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: 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).
 |
 |