Re: How to find out what version of Oracle you have ?
Date: 1996/08/02
Message-ID: <32025E7D.2183_at_teldta.com>#1/1
Atif Ahmad Khan wrote:
>
> After downloading the trial version of Oracle for Solaris x86 I noticed
> that the tar file hasn't been changed since Apr 1995. I am now curious
> and would like to find out how to check version number of Oracle I have.
> When reboot the machine I get a message saying something like version
> 7.1.XXX (I am not sure if that is the version of Oracle or one of its
> utilities).
>
> I do know from postings in this group that the latest version is 7.3.X.
> I am beginning to think that Oracle is distributing an old version of
> Oracle workgroup server for Solaris x86, that happens to have tonnes of
> bugs in it too.
>
> Atif Khan
> aak2_at_ra.msstate.edu
If the DB has been built then issue the following:
SQL> select * from v$version;
BANNER
Oracle7 Server Release 7.2.3.0.0 - Production Release PL/SQL Release 2.2.3.0.0 - Production CORE Version 3.4.3.0.0 - Production
TNS for IBM/AIX RISC System/6000: Version 2.2.3.0.0 - Production NLSRTL Version 3.1.4.6.0 - Production
or "vi $ORACLE_HOME/rdbms/doc/README.doc" and it will have a header at the top, something like:
...
... $Header: README.doc 7020300.1.1120.1 95/11/01 09:47:50 rdhoopar Generic<unix> $
...
-------------------------------------------------------------------------
Oracle7 Server
Release 7.2.3
-------------------------------------------------------------------------
Copyright (C) Oracle Corporation 1993, 1994, 1995
Primary Author: Jas....
brian.maclean_at_teldta.com
"The secret to creativity is knowing how to hide your sources."
Albert Einstein Received on Fri Aug 02 1996 - 00:00:00 CEST