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 fo
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
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))
(CONNE
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
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
