I'm trying to isolate SQL commands sent from another PC on the same subnet using WireShark. I know the PC's local IP address (first three numbers are the same as my PC's) but when I start the capture and perform a function on the app that sends and receives data from the Oracle server, zero packets are captured for that PC. No packets appear even when I just browse the web on that PC. I see packets from other PCs I'm not interested in. Any idea why the PC I'm interested in is invisible to WireShark? Thanks!
Insert a hub between the PC you want to capture the packets of and also connect yourself to that hub. A hub causes packets to be broadcast to all ports. But beware the wrath of your NetAdmin. In other words you really shouldn't be doing this without their consent/help.
Or get a PC with two network cards and bridge them together. Plug one end to the PC and the other to the server, Make sure you set Wireshark to promiscuous mode.