Re: How to find the Database version without opening the Database

From: Thomas Gaines <Thomas.Gaines_at_noaa.gov>
Date: Thu, 10 Oct 2002 13:03:39 -0600
Message-ID: <3DA5CF0A.602E322D@noaa.gov>

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_at_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.
Received on Thu Oct 10 2002 - 14:03:39 CDT