Re: OS version

Re: OS version

 

  


v$version (The TNS entry) can tell you if its Windows NT, Solaris, HP-UX,
etc.. But not the version numbers and patch levels.

Raj





"Michael
Porter" To: "LazyDBA.com Discussion" <[Email Address Removed]
<[Email Address Removed] cc:
q.com> Subject: Re: OS version

March 29,
2002 09:40 AM






Oops, didn't see your requirement for only OS version... V$VERSION will
obviously NOT do that...

>>> "Michael Porter" <[Email Address Removed] 03/29/02 09:36AM >>>
select * from v$version maybe...

>>> Celoiu Manuel <Manuel.[Email Address Removed] 03/29/02 07:32AM >>>
Hi DBAs

It's there, in Oracle Dictionary, a table that contains the OS version
?

I would like to get the same information as in the trace file wich
result
after executing this statement :

ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

EX., in the header :

Dump file C:\ORACLE\admin\INASS\udump\ORA00193.TRC
Thu Mar 28 11:32:29 2002
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows NT Version 4.0 Service Pack 4, CPU type 586
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Windows NT Version 4.0 Service Pack 4, CPU type 586 <----- this is
the
information that I need

Thanks,
Manuel


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html





Oracle LazyDBA home page