OS name

[SANJAY_G]

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

Sanjay

[Tatyana]

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

[pwoneill]

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.

[rsonnathi]

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

[pwoneill]

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.

[pwoneill]

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?

[pando]

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

[oradbadmin]

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.

[arshiah]

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]