DB Lost TNSPing and RDP simultaneousely on wire. Wifi works great.

It could be a lot of different things.  Options will depend on your network structure.  To start you need to identify if it is just one machine or all wired machines having the issue? 

If all (or if more than one) then check firewalls especially for port 1521 which is typical Oracle DB port. 

If just one machine, can that machine access anything else using wired?  If not check the cable and ports.

All wired machines trying to connect have the issue, all wireless machines attempting to connect do not. Same host (laptop) wired does not work, wireless it does. Other Servers on the same network/vlan do not have the issue. I can RDP into any of them from a wire no issue.

So in that case, as noted, I’d start by looking at the firewall(s) both on the server and in-between that and the clients. Chances are that your wifi and wired networks are independent, with some security set up on the wired infra that doesn’t allow port 1521 (assuming you have Oracle on the default port) to/from that DB server.

Netstat -na says listening on 1521 with several established.

setup a Inside Any to Inside DB filter in the firewall. No change.

Please check the Oracle listener file on the DB server for any entries using host name or IP address of the server. If there is an entry, make sure you can ping it from a client using wired connection. 

If your able to connect to db using wifi, it means your ports are open fine and listener at db side is listening ok for incoming connection requests. I am guessing you are able to tnsping and ping from client using wifi (as DNS is resolving your “hostname” fine with wifi).

BUT when you switch to wired connection you are not able tnsping or ping (because hostname is not resolving through DNS while wired) . To check that use ip of host instead of hostname , see if you can ping/tnsping/rdp to host. You need to find tnsnames.ora file on client and replace hostname to ip . May be something is wrong with DNS.

Cheers.

Hostname and IP Address do the same thing.

Srikanth

New to this. Where is this...listener file you speak of?

I can ping by IP and Hostname on wire, but cannot TNSPing either from wire.

Can be found under ORACLE_HOME\network\admin directory, same place as TNSNAME.ORA file. The file is called LISTENER.ORA

Thanks for the assist, I appologize for my ignorance, A) but I do a windows search for ORACLE_HOME and get nothing. I am on the IFSDB Server. B) If I were to need help from IFS Support how do I establish a connection with them and what are the rates?