Search This Blog

Thursday, July 31, 2008

How to find Oracle Version?


My Signature Article





Tips:
Oracle Certification - Tips

DBA Preparation - Tips

Practical DBA - Tips


There is many way to find out.
1. Through SQLPLUS.
C:\app\m.taj\product\11.1.0\db_1\BIN>sqlplus /nolog
SQL*Plus: Release 11.1.0.6.0 - Production on Thu Jul 31 12:23:54 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.


2. Through Data dictionary view
SQL> select * from v$version;
BANNER

------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
PL/SQL Release 11.1.0.6.0 - ProductionCORE 11.1.0.6.0 Production
TNS for 32-bit Windows: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production
3. opatch lsinventory
1. Set ORACLE_HOME variable
2. go to OPATCH directory
3. run opatch lsinventory
C:\>set oracle_home=c:\app\m.taj\product\11.1.0\db_1
C:\>cd %ORACLE_HOME%\opatch
C:\app\m.taj\product\11.1.0\db_1\OPatch>opatch lsinventory

Invoking OPatch 11.1.0.6.0
[output cut]

Installed Top-level Products (1):
Oracle Database 11g 11.1.0.6.0

There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.

OPatch succeeded.
4. check SQLNET.LOG file
check SQLNET.LOG file in ORACLE_HOME\network\log
you will find below entries
VERSION INFORMATION:
TNS for 32-bit Windows: Version 11.1.0.6.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit
Windows: Version 11.1.0.6.0 - Production

8 comments:

RAJESHKUMAR GOVINDARAJAN said...

we can also find the oracle version by

strings $ORACLE_HOME/bin/oracle | grep NLSRTL

[oracle@rac1 udump]$ strings $ORACLE_HOME/bin/oracle | grep NLSRTL
NLSRTL Version 10.2.0.1.0 - Production

from OTN forum answered by sb92075

Anonymous said...

thanks it helps

halimdba said...

also can find the oracle version by ....

SQL> SELECT VERSION FROM v$instance;

or

SQL> select * from product_component_version;


regards
Halim

Mohammed Taj said...

Thank you everyone.

nonuday said...

select * from v$version where banner like 'Oracle%';

or

select banner from v$version;

Anonymous said...

I am regular ѵiѕitοr, how are you еverybody?
Τhіs pіece of writing pоsted аt this web site іs genuinelу goоd.



Μy homeрage - desarrollo web

Anonymous said...

Hi there friends, itѕ fantаstic articlе about teachingand entігely
еxplаineԁ, κeeρ it up all the time.


my раge; creare ѕito COME СREARE UΝ SITO Creаre Un Sito ()

Anonymous said...

Thanks a lot Rajesh..really saved my few hours
- karthic