OS name

Hi,

Is there any view I can use to know the OS name on which the Oracle Server is running ?

RS

type 'uname -a' on unix machines

select username, osuser
from v$session
where username is not null

or type: hostname

There's obviously some confusion as to what you are looking for. Could you elaborate?

Jeff Hunter ,

What I mean is If I want to find OS name programatic way, is there any dictionary view to find that info.I have window 4.0.Can I get that info ?

The following query gives domain name but not the OS name

select username, osuser
from v$session
where username is not null

Thanks.

RS

v$session is as close as you can get, as far as I know.

Hi

Select host_name from v$instance;


Santosh

Hi

One More

Select * from v$version


Santosh

Maybe you can do somthing with :

select banner from v$version
where banner like 'TNS%' ;

on NT i get : TNS for 32-bit Windows: Version 2.3.4.0.0 - Production
on AIX i get : TNS for IBM/AIX RISC System/6000: Version 2.3.4.0.0 - Production

Regards
Gert

You can't see the OS name and version from Database (SVRMGRL or SQLPLUS).
Should consult your DBA or use OS commands.

Sanjay

If you want see OS name from svrmgrl then
SVRMGR>host hostname

When you say OS name, what do you want returned?

The hostname of the machine (eg, machine1)? Or the Operating system name and version (eg SunOS 5.6).

If it's the former you can get it out of v$instance.

If it's the latter you will probably need to use a host command. 'uname -a' will give that and some other information, 'uname -sr' will give just the OS and Version.

Hi Pwoneill,

I need to get the operating system name. Like "windows 4.0"
Could you explain how to use the host command ? That would be very helpful.

Thanks.

---RS

Well, are you on windows? If so then I can't think of a DOS command off the top of my head that will give you that information, maybe I'll remember one or someone else knows.

I know you can install unix packages for WinNT and Windows that include normal unix command, maybe uname is included.

If you're on a unix machine you can use what I told you before, "uname -sr" is the command to execute to show you just the operating system and version.

Also, where do you need this information?

Are you in a SQL or PL/SQL script and it needs to print out the version? Or is it some other application that is pulling data from the database that needs to know the OS it's running on? Or does it need to know the OS the Database is running on?

Or are you just sitting at a machine and need to know what OS and version it is?

select * from v$version

BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
PL/SQL Release 8.1.6.0.0 - Production
CORE 8.1.6.0.0 Production
TNS for 32-bit Windows: Version 8.1.6.0.0 - Production
NLSRTL Version 3.4.1.0.0 - Production





BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.6.0.0, 64 bit - Production
PL/SQL Release 8.1.6.0.0 - Production
CORE 8.1.6.0.0 Production
TNS for HPUX: Version 8.1.6.0.0 - Production
NLSRTL Version 3.4.0.0.0 - Production



First is from WinNT 4.0
Second from HP-UX 64 Bits

And I deduced it from TNS entry in v$version

Regards

If you are using Oracle 8 or above you can query the V$INSTANCE system view which also contain information about the oracle serve name in the HOST_NAME file.
I hope this is what can hel you.
Bye.

Select hostname from v$instance will give you the machine name and not the OS version. Also in V$VERSION you cannot see the OS version anywhere, it has only the versions for the Oracle products installed. You will have to get it from an operating system command like

for UNIX: $uname -sr.
for Windows: c:\>ver

[Edited by arshiah on 12-19-2000 at 01:03 PM]