Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: is there a way to get the server MAC address through sql statement ?

Re: is there a way to get the server MAC address through sql statement ?

From: srivenu <srivenu_at_hotmail.com>
Date: 29 Feb 2004 23:43:22 -0800
Message-ID: <1a68177.0402292343.2e4f7ce0@posting.google.com>


> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US