Sybrand Bakker wrote:
> 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?
>
the tnsnames.ora file has the name of the machine, not the ip address,
which is fine if I'm connected to the network directly; but if I log in
remotely, I need the ip.
Anyway, the why's and hows of my connection are not the issue. Thanks
for the lecture on good networking etiquette, but what I really want to
know is... Is it possible to get the ip address of the machine that the
instance is installed on via pl/sql?
Received on Tue Mar 16 2004 - 13:06:04 CST