what OS oracle is running on ?

Printable View

09-23-2003, 07:41 AM
bang_dba

what OS oracle is running on ?

Hi,
Is there any dictionary view/or any way by which i can find out whether my Oracle is running on which operating system.
I have access to all the data dictionary tables; but not to the OS. I use some third party tool to connect to many remote servers.
Could somebody tell me about this...

Regards
09-23-2003, 07:47 AM
pando

try v$version
09-23-2003, 02:21 PM
sysdba

pando,

I could not see os from V$version:

SQL> select * from V$version;

BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
PL/SQL Release 8.1.7.2.0 - Production
CORE 8.1.7.0.0 Production
TNS for Solaris: Version 8.1.7.2.0 - Production
NLSRTL Version 3.4.1.0.0 - Production

SQL>
09-23-2003, 02:25 PM
adewri

Quote:

Originally posted by sysdba
pando,

I could not see os from V$version:

SQL> select * from V$version;

BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
PL/SQL Release 8.1.7.2.0 - Production
CORE 8.1.7.0.0 Production
TNS for Solaris: Version 8.1.7.2.0 - Production
NLSRTL Version 3.4.1.0.0 - Production

SQL>

Its Solaris.
09-23-2003, 03:32 PM
sysdba

I meant os vesion: Solaris 2.7 for example?
09-23-2003, 05:07 PM
davey23uk

just out of interest, if you dont haev access to the physical server - what does it matter?
09-23-2003, 09:56 PM
wengyan

yes.You can get details of OS via saloris commands

Hi.

Try this:



SQL> SELECT DBMS_UTILITY.port_string FROM dual;



PORT_STRING

---------------------------------------------

DEC Alpha OSF/1, r1.1-8.1.0



1 row selected.



SQL>

Cheers

09-24-2003, 04:18 AM
abhaysk
Quote:
Originally posted by TimHall
Hi.

Try this:

SQL> SELECT DBMS_UTILITY.port_string FROM dual;

PORT_STRING
---------------------------------------------
DEC Alpha OSF/1, r1.1-8.1.0

1 row selected.

SQL>

Cheers
I am afraid, i aint getting it for WIN 2K, rather getting it as WIN_NT

PS

Code:

Microsoft Windows 2000 [Version 5.00.2195] (C) Copyright 1985-2000 Microsoft Corp. C:\>sqlplus abhay/abhay SQL*Plus: Release 9.2.0.1.0 - Production on Wed Sep 24 13:49:20 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production USER_ID USER_NAME ---------- ------------------------------ 21 ABHAY DB_NAME -------------------------------------------------------------------------------- TEST TEST:ABHAY> SELECT DBMS_UTILITY.port_string FROM dual; PORT_STRING ---------------------------------------------------------------------------------- IBMPC/WIN_NT-8.1.0

Abhay.
09-24-2003, 04:24 AM
pando

dont think thats very usefull

Code:

ttd$oracle7@E73GC04>!uname -a SunOS SSESMADT001 5.6 Generic_105181-26 sun4u sparc SUNW,Ultra-Enterprise ttd$oracle7@E73GC04>select dbms_utility.port_string OS from dual; OS ------------------------------ SVR4-be-7.0.0

doesnt say Solaris 5.6 anywhere :o
09-24-2003, 04:29 AM
adewri

Win2k is nothing but a upgraded NT OS.

Actual NT(SP6) OS Version 4.00.1381
Actual Win2K Prof(SP4) Version 5.00.2195

And XP is also an upgraded Win2K Prof.
09-24-2003, 10:58 AM
abhaysk

Quote:

Originally posted by adewri
Win2k is nothing but a upgraded NT OS.

Actual NT(SP6) OS Version 4.00.1381
Actual Win2K Prof(SP4) Version 5.00.2195

And XP is also an upgraded Win2K Prof.

This is what every one knows ( You may guess even I know :-) ), but does that mean instead of saying WIN2k to Win2K is it ok if i call it NT?

huh?
09-25-2003, 04:27 AM
adewri

Why, yes you can call Windows 2000 as WINNT Version 5.00.2195 (That would be the actual technical name and any one familiar with the technical term can make out that its win2k.) Win2K is the general name.

Now don't ask me why it shows WIN_NT-8.1.0 and not WIN_NT-5.00.2195 :) though i can tell you why its called IBMPC ;).
09-25-2003, 05:15 AM
DaPi

Just to complete the list: my XP Pro client thinks it is NT 5.1.26
09-25-2003, 09:46 AM
Mr.Hanky

I am herby officially re-naming this as "The thread that wouldn't die"
Kinda has a 50's B horror movie sound to it huh?

MH
09-25-2003, 11:26 AM
marist89

Quote:

Originally posted by abhaysk
This is what every one knows ( You may guess even I know :-) ), but does that mean instead of saying WIN2k to Win2K is it ok if i call it NT?

huh?

I just call it DOS 12.1
09-25-2003, 11:41 AM
DaPi

Jeff, did you start counting from 360/DOS?
09-25-2003, 12:35 PM
adewri

May be he started counting from the days when it was QDOS (Quick and Dirty Operating System) or may be after Tim Paterson sold QDos to Bill Gates for $50,000 to be renamed as MS-DOS. :)
09-25-2003, 02:11 PM
marist89

Quote:

Originally posted by DaPi
Jeff, did you start counting from 360/DOS?

Windows 1.x and 3.x ran on MS-DOS 4.x or higher, so that was just an application.

The last version of MS-DOS was 6.something.

The first time MS started calling Windows an OS was with Windows 95. (DOS 7).

98 (DOS 8).

NT (DOS 9)

ME/2K (DOS 10.0/10.1)

XP (DOS 11)

2003 (DOS 12)
09-26-2003, 02:35 AM
DaPi

. . . in 1969 I was using something called DOS on an IBM 360/44 . . . come to think of it, it was a bit like a 50's horror movie.
09-26-2003, 02:42 AM
abhaysk

Quote:

Originally posted by adewri
Why, yes you can call Windows 2000 as WINNT Version 5.00.2195 (That would be the actual technical name and any one familiar with the technical term can make out that its win2k.) Win2K is the general name.

I think Jeff is now more precise now...:D

Quote:

I just call it DOS 12.1

:rolleyes:

Quote:

Now don't ask me why it shows WIN_NT-8.1.0 and not WIN_NT-5.00.2195

i wud like an logical ans atleast..
:rolleyes: :rolleyes:

Abhay.