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: - determine Operating system using pl/sql??

Re: - determine Operating system using pl/sql??

From: Dusan Bolek <pagesflames_at_usa.net>
Date: 3 May 2004 02:14:57 -0700
Message-ID: <1e8276d6.0405030114.2d78afe6@posting.google.com>


"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<408f5dcf$0$439$afc38c87_at_news.optusnet.com.au>...
> And if you did, how do you account for this:
>
> SQL> select dbms_utility.port_string from dual;
>
> PORT_STRING
> ----------------------------------------------------------------
>
> IBMPC/WIN_NT-8.1.0
> Now I realise that, regardless of version, the string is telling you
> that you're running on Windows NT (although this particular example
> happens to come from Windows 2000), which might be all that the original
> poster requires, but the wrong version number there is a bit of a worry,
> and makes me unconvinced that this is always going to be a reliable
> mechanism. Indeed, it reports "8.1.0" on 8.1.7, 9.2.0 and 10g, on both
> Windows and Linux.
>
> Regards
> HJR
Few tests, interesting results:

8.1.7 Solaris 8 64-bit: SVR4-be-64bit-8.1.0
9.2.0.5 AIX 5L: IBM AIX64/RS6000 V4 - 8.1.0
9.2.0.5 Linux: Linuxi386/Linux-2.0.34-8.1.0
10G Solaris 8 64-bit: SVR4-be-64bit-8.1.0

So it seems to me that Oracle part is utterly useless, but OS specification looks correct.
However, it would be nice to know what is the meaning of SVR4-be for Solaris and the meaning of "2.0.34" for Linux (kernel version is 2.4.20).

--
Dusan Bolek

Email: spambin_at_seznam.cz
Pls add "Not Guilty" to the subject, otherwise your email is going to
be burnt as a SPAM.
Received on Mon May 03 2004 - 04:14:57 CDT

Original text of this message

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