Re: How to find out what version of Oracle you have ?
Date: 1996/08/07
Message-ID: <4u8vki$fje_at_news.iag.net>#1/1
In article <Dvnz3p.3z3_at_csc.liv.ac.uk>, rkl_at_csc.liv.ac.uk
says...
>
>In article <aak2.838972740_at_ra.msstate.edu>,
>aak2_at_Ra.MsState.Edu (Atif Ahmad Khan) writes:
>>I am now curious
>>and would like to find out how to check version number
of Oracle I have.
>
>Run the script:
>
>$ORACLE_HOME/orainst/inspdver
>
>This outputs info like this:
>
>4.0.0 Oracle Unix Installer and
Documentation Viewer
>7.3.2.1.0 ORACLE Common Libraries and
Utilities
>2.3.2.1.0 SQL*Net (V2)
>etc. etc.
>
>Of course, I assume you have inspdver included in your
distribution !
>
>Richard K. Lloyd, E-mail: rkl_at_csc.liv.ac.uk
>Connect, WWW:
http://www.csc.liv.ac.uk/users/rkl/
>5-31, Great Newton St,
>Liverpool University,
>Merseyside, UK. L69 3BX
>
This program only comes with 7.3.* so will not be with the Workgroup Sever distribution.
You can get the version in several ways.
- When you run svrmgrl, sqldba or sqlplus the version comes up in the banner.
- grep -i rdbms $ORACLE_HOME/orainst/unix.rgs
- Workgroup Sever only comes in 7.1.4 or 7.1.6 depending on the Operating system. So if you have 7.1.6, you have the latest version. 7.1.6 was a fairly stable release and if there is problems, most likely support has come across it already and there is a fix.