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: SQL to get IP and OS

Re: SQL to get IP and OS

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Thu, 05 Jul 2007 16:42:12 -0400
Message-ID: <gplq83hppm7drevags24f7nf5hddrs1tme@4ax.com>


On Thu, 05 Jul 2007 11:54:51 -0700, Jeff B <jbisch1_at_yahoo.com> wrote:

>Hello,
>
> I am using Oracle 10gR2 on Windows 2003 Server. Is it possible to
>retrieve the host's IP address and its OS version using a sql
>statement? I know that I can get the host_name from v$instance, and I
>can get the OS from the v$version, but I need more that just "Windows"
>for the OS. I'm looking for something like "Windows 2003 Server".
>

Is that client's IP or db IP? db IP and OS are static, u can just store it in some table.
.......
We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc) remove NSPAM to email Received on Thu Jul 05 2007 - 15:42:12 CDT

Original text of this message

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