OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Oracle Version

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Version [message #59351]

Thu, 13 November 2003 02:54

Srinivas
Messages: 138
Registered: June 2000

Senior Member

Hi DBA Gurus:

I want to know the version of the oracle 8i or 9i (With out logging into the oracle database) which has already installed in the system.

Is there any way of finding the version of oracle by checking the registry or file structure?

Please help me in this regard..Its an urgent issue for me.

TIA
Srinivas

Report message to a moderator

Re: Oracle Version [message #59354 is a reply to message #59351]

Thu, 13 November 2003 03:37

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Log on to SQL*Plus and it will display something like:

SQL*Plus: Release 8.0.5.0.0 - Production on Thu Nov 13 11:49:10 2003

(c) Copyright 1998 Oracle Corporation.  All rights reserved.

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production

Or you can perform the following select:

SQL> Select banner
  2    From v$version;

BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
PL/SQL Release 8.1.7.4.0 - Production
CORE    8.1.7.0.0       Production
TNS for IBM/AIX RISC System/6000: Version 8.1.7.4.0 - Production
NLSRTL Version 3.4.1.0.0 - Production

MHE

Report message to a moderator

Re: Oracle Version [message #59358 is a reply to message #59354]

Thu, 13 November 2003 06:10

Srinivas
Messages: 138
Registered: June 2000

Senior Member

Thank you maaher for your quick response.
But, there is no database on that.
Thats y i mentioned in my question that "With out logging into the oracle database".

Hope u got the point..

TIA
Srinivas

Report message to a moderator

Re: Oracle Version [message #59362 is a reply to message #59351]

Thu, 13 November 2003 09:27

Mike
Messages: 417
Registered: September 1998

Senior Member

could you please specify which OS it is. Also are the DB files located in the Oracle home directory or on a seperate directory?

Report message to a moderator

Re: Oracle Version [message #59370 is a reply to message #59351]

Thu, 13 November 2003 11:29

Thiru
Messages: 1089
Registered: May 2002

Senior Member

On Unix, Check $ORACLE_HOME/install/unix.rgs
On Windows, check in the registry at HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE

there are other ways too(like checking installation logs etc)

-Thiru

Report message to a moderator

Re: Oracle Version [message #59377 is a reply to message #59370]

Fri, 14 November 2003 05:17

Srinivas
Messages: 138
Registered: June 2000

Senior Member

Thanks Gurus..

But, i am not able to locate key in registry which gives version value.
I had verified the entire "Hkey_Local_Machinesoftwareoracle" key, but i did't get the version value.
Problem is i need to get version value programetically.

Can anybody please help me in this regard ?

TIA
Srinivas

Report message to a moderator

Re: Oracle Version [message #59382 is a reply to message #59377]

Fri, 14 November 2003 07:56

Thiru
Messages: 1089
Registered: May 2002

Senior Member

I dont think there is 'version value' stored as a registry entry. You will have to parse the version information from either the registry entries(Oracle_Home etc) or from the Inventory/installation log files.

For eg)
In HLKMSoftwareOracle , you find a key called inst_loc which is set to say C:Program FilesOracleInventory.

Get this directory location and go to C:Program FilesOracleInventoryComponentsoracle.rdbms.
Under here you find sub directories for the Oracle versions installed (say 9.2.0.1.0 ) . Thats your version. But again if there are multiple ORACLE_HOME's you will need to locate the ORACLE_HOME for your ORACLE_SID , from the registry again(ie HKLMSoftwareOracle)

-Thiru

Report message to a moderator

Re: Oracle Version [message #59388 is a reply to message #59382]

Fri, 14 November 2003 21:14

Srinivas
Messages: 138
Registered: June 2000

Senior Member

Thanks Tiru sir for providing me the solution..

I got it.

Thank You very much.

Srinivas

Report message to a moderator

Previous Topic:	Database Name!
Next Topic:	SQL Worksheet Character Problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 11:28:39 CDT 2024