Re: can not tnsping from window client to linux oracle server

From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: 24 Jun 2004 09:34:27 -0700
Message-ID: <d4d6f278.0406240834.625295dc@posting.google.com>

Tnsping while useful at times is not nearly as good as a complete command line connection all the way into the database by sqlplus. sqlplus scott_at_servicename or similar is a better way of debugging connection issues.

To solve something like this you should probably have tnsnames.ora and sqlnet.ora from both machines, along with the output ipconfig /all (windows) or ifconfig interface example "ifconfig lan1" (unix) (think its "ifconfig -a interface" on linux"). Other diagnostic output needed is a command level ping and nslookup against the server you are going to connect into and include those results.

From the server side include the listener.ora and the results of a "lsnrctl status" command.

Then try sqlplus (or tnsping if you insist) and capture the results from both machines ... then we probably have enough info to help. Received on Thu Jun 24 2004 - 11:34:27 CDT