My Signature ArticleTips:
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:
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
thanks it helps
also can find the oracle version by ....
SQL> SELECT VERSION FROM v$instance;
or
SQL> select * from product_component_version;
regards
Halim
Thank you everyone.
select * from v$version where banner like 'Oracle%';
or
select banner from v$version;
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
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 ()
Thanks a lot Rajesh..really saved my few hours
- karthic
Post a Comment