Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: is there a way to get the server MAC address through sql statement ?
> The problem with this code is that it returns the wrong answer even if you
> added extra code to extract the MAC address from the output stream. The
> "arp -a" command may return some or all of the MAC addresses of the server's
> neighbours on a LAN segment but not the MAC address of its interface card.
> If you want to use this method, employ the "ipconfig /all" command for
> Windows, or the "ifconfig -a" command for Linux.
Douglas,
I think ifconfig -a on Solaris will return the MAC address only if run as root.
i think you can use arp `hostname` to get the MAC for the server.
regards
Srivenu
Received on Mon Mar 01 2004 - 01:43:22 CST