Re: find out os from pl/sql

From: Terry Dykstra <tddykstra_at_forestoil.ca>
Date: Thu, 19 Oct 2006 14:39:56 GMT
Message-ID: <07MZg.20267$P7.9050@edtnps90>

"joel garry" <joel-garry_at_home.com> wrote in message news:1161215326.600841.166480_at_f16g2000cwb.googlegroups.com...

Mark D Powell wrote:
> On Oct 18, 11:22 am, DA Morgan <damor..._at_psoug.org> wrote:
> > Radoulov, Dimitre wrote:
> > > "Loial" <a..._at_loial.co.uk> wrote in message
> > >news:1161173211.505459.159290_at_e3g2000cwe.googlegroups.com...
> > >> Is there any table I can query to find out the operating
> > >> system(Linux/AIX etc) from pl/sql?
> >
> > > Check dbms_utility.port_string.
> >
> > > On RH:
> >
> > > SQL> select dbms_utility.port_string from dual;
> >
> > > PORT_STRING
> > > --------------------------------------------------------------------------------
> > > Linuxi386/Linux-2.0.34-8.1.0
> >
> > > On Solaris:
> >
> > > SQL> select dbms_utility.port_string from dual;
> >
> > > PORT_STRING
> > > --------------------------------------------------------------------------------
> > > SVR4-be-64bit-8.1.0
> >
> > > Regards
> > > DimitreAlso:
> > SELECT * FROM gv$version;
> > --
> > Daniel A. Morgan
> > University of Washington
> > damor..._at_x.washington.edu
> > (replace x with u to respond)
> > Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -- Show
> > quoted text -

> Warning - depending on your Oracle version and platform neither command
> will provide the actual OS level

> On AIX 5.2L running EE 9.2.0.6 RAC you get

> Oracle Port String is IBM AIX64/RS6000 V4 - 8.1.0

> While a UNIX uname command showd the OS is AIX 5.2
> $ uname -svr
> AIX 2 5

> Release level appears before version in output when ever both are
> requested on AIX.

>
> HTH -- Mark D Powell --

SQL> connect / as sysdba
Connected.
SQL> select dbms_utility.port_string from dual;

HP9000/800-64.0.8.1.0

SQL> SELECT * FROM gv$version;

1 Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production

         1 PL/SQL Release 9.2.0.6.0 - Production
         1 CORE 9.2.0.6.0       Production
         1 TNS for HPUX: Version 9.2.0.6.0 - Production
         1 NLSRTL Version 9.2.0.6.0 - Production

SQL> !uname -svr
HP-UX B.11.11 U

The above was cut and pasted.

I guess it depends on what you want to know about the operating system.

SQL> / INST_ID BANNER

1 Oracle Database 10g Express Edition Release 10.2.0.1.0 - Beta

1 PL/SQL Release 10.2.0.1.0 - Beta

1 CORE 10.2.0.1.0 Beta

1 TNS for 32-bit Windows: Version 10.2.0.1.0 - Beta

1 NLSRTL Version 10.2.0.1.0 - Beta

SQL> edit
Wrote file afiedt.buf

1* select * from gv$version
SQL>
SQL> / INST_ID BANNER

1 Oracle Database 10g Express Edition Release 10.2.0.1.0 - Beta

1 PL/SQL Release 10.2.0.1.0 - Beta

1 CORE 10.2.0.1.0 Beta

1 TNS for 32-bit Windows: Version 10.2.0.1.0 - Beta

1 NLSRTL Version 10.2.0.1.0 - Beta

SQL> edit
Wrote file afiedt.buf

1* select dbms_utility.port_string from dual SQL> / PORT_STRING

IBMPC/WIN_NT-8.1.0 SQL> host ver

[said Microsoft Windows 2000, but not in spool file]

--
@home.com is bogus.
Yay scientists!
http://www.signonsandiego.com/uniontrib/20061018/news_1n18video.html


Testing with Oracle XE On Windows XP you get the same "IBMPC/WIN_NT-8.1.0". 
You really have to wonder who is dreaming up these codes.

-- 
Terry Dykstra

Received on Thu Oct 19 2006 - 09:39:56 CDT