TNS-12547: TNS:lost contact

[JtheRipper]

Hi there,

I am getting the following error message when connecting from a client pc (PC-A) (8.1.7) Win 2003 to a 8.1.7 database running on Unix. TNS-12547: TNS:lost contact

I have another client pc (PC-B) (also Win 2003) which I can use to successfully connect to the database. The sqlnet.ora and tnsnames.ora files are exactly the same on both client pc's. Perform a tnsping from PC-A fails with the error. The only difference is that PC-A is connecting through a firewall and PC-B is not, but we opened the firewall for testing purposes and it did not work. We even reinstalled the Oracle client but it did not work.

Any ideas on this?

Thanks,
J.

 

[sem]

we opened the firewall

In both directions?

Regards, Dima

http://seminihin.narod.ru

 

[JtheRipper]

Hi,

I did not speak to the person who opened the firewall, but out NT administrator said he changed the firewall to "any to any". I suspect that means he opened it both ways, but I am no firewall expert so I might be wrong.

Thanks,
J.

 

[sem]

Can you telnet listener port from PC-A at least? BTW I'm sure that 8.1.7 is not supported on 2003, can you try to install 9.2 or later?

Regards, Dima

http://seminihin.narod.ru

 

[JtheRipper]

Hi,

Thanks for the feedback. I will try loading 9i client PC-A. What bugs me is that PC-B and PC-A has the same OS and Oracle client. I monitored the listener.log file while doing a tnsping from PC-A and it does not even get registered, BUT I can telnet to the listener port successfully.

Weird...

Thanks,
J.

 

[JtheRipper]

I found the problem to this...

The server has 2 network cards and incidently the client is on the same subnet as one of the network cards. When we switched off the second network card it worked fine.

J.