Re: tnsping

tnsping DOES get IP address. In this case, a default connection descriptor is used
instead of tnsnames.ora.

In case IP address or hostname is given, tnsping try to connect to TNS listener on port 1521
(this is the default). If listener is not using this port, the 'no listener' message will be displayed.
In this case, either use a TNS alias (from tnsnames.ora) or an explicit connection descriptor
such as:

tnsping '(ADDRESS=(PROTOCOL=TCP)(HOST=myhost)(PORT=1526))'

I hope this help...

Taka Kamiya wrote in message ...
>tnsping does not care about the ip address.... when you do tnsping
><something>, it will first look at tnsnames.ora file in
orant/network/admin.
>Looks for the name, resolves it into sid name and *now* ip address or host
>name. Then on the rdbms server side, it will go to listener.ora file and
do
>something very similar.
>
>so.... why don't you look into the tnsnames.ora file, then use the alias
and
>try tnsping. I'd bet it will work for you.
>
>
>
>In article <7ltudk$qig$1_at_nnrp1.deja.com>, lauracampos_at_yahoo.com says...
>>
>>I am running Oracle8 Enterprise Edition 8.0.5.0.0 on Windows NT 4.0
>>(service pack 4). I can't tnsping80 any ip address, only service names.
>>This used to work before. I used to be able to tnsping80 ip addresses
>>as well as service names. I can do a tnsping80 on a couple of ip
>>addresses on my client machine but, I can't tnsping80 any ip addresses
>>on the server. Does anyone know how I can resolve this?
>>
>>
>>Sent via Deja.com http://www.deja.com/
>>Share what you know. Learn what you don't.
>
Received on Sun Jul 25 1999 - 11:24:49 CDT