Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL to get IP and OS
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