Finding IP address for a linked Oracle server 1

[NBVC]

I am trying to find out the ip address of a linked server that my predecessor created. The server is linked using OraOLEDB.Oracle provider. If I test the connection it is successful.

Currently there is a Server Name... but I can't figure out where it points to.

I tried to ping it through command prompt but it didn't find anything.

I tried the select * from sys.servers query, but it doesn't give me a clue of the ip address.

 

[fredericofonseca]

oracle names will use normally a tnsnames.ora file located on the server (or on a share if so defined)
inside it there will be an entry associated to the servername defined on the linked server

see http://www.dba-oracle.com/t_windows_tnsnames.ora_file_location.htm for indication of how to find the tnsnames.ora file


Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[NBVC]

Great. I think I found it. Thanks very much.