Sybrand Bakker wrote:
> 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.
>
Lighten up will you!
It's a test database, but I need to know if it is assigned a different
ip. I agree that all development and production databases should have a
fixed ip, but an experimental database can be more flexible.
Received on Tue Mar 16 2004 - 12:52:10 CST
