Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!news-out.visi.com!hermes.visi.com!uunet!ash.uu.net!news.boulder.noaa.gov!not-for-mail From: Thomas Gaines Newsgroups: comp.databases.oracle.server,comp.databases.oracle.misc,comp.databases.oracle.tools Subject: Re: How to find the Database version without opening the Database Date: Thu, 10 Oct 2002 13:03:39 -0600 Organization: NOAA Boulder Lines: 86 Message-ID: <3DA5CF0A.602E322D@noaa.gov> References: NNTP-Posting-Host: tg2k.ngdc.noaa.gov Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="------------4D3A3CE655EE5C8D92EB5CE4" X-Trace: mwrns.noaa.gov 1034276699 8783 192.149.148.31 (10 Oct 2002 19:04:59 GMT) X-Complaints-To: usenet@news.boulder.noaa.gov NNTP-Posting-Date: Thu, 10 Oct 2002 19:04:59 +0000 (UTC) X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U) X-Accept-Language: en Xref: newsfeed1.easynews.com comp.databases.oracle.server:163768 comp.databases.oracle.misc:87680 comp.databases.oracle.tools:54100 X-Received-Date: Thu, 10 Oct 2002 12:10:45 MST (news.easynews.com) --------------4D3A3CE655EE5C8D92EB5CE4 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Although this probably isn't officially supported by Oracle, I've always found the output from the "strings" command on Unix to be very interesting. If your platform is something other than Unix, the other suggestions in this thread are much better obviously. Just for fun, here is my output from my "strings" command when run against the "oracle" executable. From this, can you guess what my version is? [oracle@cougar bin]$ strings oracle | grep "9\.0" 9.0.2 9.0.1.1 9.0.1 9.0.0 9.0 Materialized Views 9.0 Partitioning Methods 9.0.0 9.0.1.1 ORACLE PL/SQL V9.0.1.0.0 - Production prvtrmns09.00.0008.00.0408.00.0508.01.0308.01.05 Oracle XML Parser version 9.0.1.0.0 Production V9.0.0.0 9.0.1.0.0 NLSRTL Version 9.0.1.0.0 - Production Bye, TG Yasin wrote: > Hi: I am intresting in knowing if there is way to know the version of > the Database without opening it, or even putting it in mount state. > > Many thanks. --------------4D3A3CE655EE5C8D92EB5CE4 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Although this probably isn't officially supported by Oracle, I've
always found the output from the "strings" command on Unix to
be very interesting. If your platform is something other than Unix,
the other suggestions in this thread are much better obviously.

Just for fun, here is my output from my "strings" command when
run against the "oracle" executable. From
this, can you guess what my version is?

[oracle@cougar bin]$ strings oracle | grep "9\.0"
9.0.2
9.0.1.1
9.0.1
9.0.0
9.0 Materialized Views
9.0 Partitioning Methods
9.0.0
9.0.1.1
ORACLE PL/SQL V9.0.1.0.0 - Production
prvtrmns09.00.0008.00.0408.00.0508.01.0308.01.05
Oracle XML Parser version 9.0.1.0.0 Production
V9.0.0.0
9.0.1.0.0
NLSRTL Version 9.0.1.0.0 - Production

Bye,
TG

Yasin wrote:

Hi: I am intresting in knowing if there is way to know the version of
the Database without opening it, or even putting it in mount state.
Many thanks.

--------------4D3A3CE655EE5C8D92EB5CE4--