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 Date 25-JUL-02 15:28:34
Uptime 0 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 other information (like subscribing).
