Re: ip address of the instance?

On Tue, 16 Mar 2004 13:52:10 -0500, Dom <roqetman_at_hotmail.com> wrote:

>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.

I don't think this is 'flexible'. It is just plain stupid. How do you deal with changes in DNS? Or do you change your tnsnames.ora everytime the IP-address changes?

--
Sybrand Bakker, Senior Oracle DBA