Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ip address of the instance?
On Tue, 16 Mar 2004 10:34:11 -0500, Dom <roqetman_at_hotmail.com> wrote:
>Hi,
>
>Is there anyway in pl/sql to determine the ip address of the machine
>that runs the oracle instance you're connected to?
>The reason I need this is that I have an instance running an a machine
>that gets it's ip address via DHCP, and it could change, but I want a
>scheduled job to run within the database that tells me if the ip address
> has changed.
>
>Thanks,
> - Dom
A database server should *NEVER EVER* have a DHCP address.
-- Sybrand Bakker, Senior Oracle DBAReceived on Tue Mar 16 2004 - 11:31:49 CST