Wednesday, September 7, 2011

How to Check Oracle Version?

we can find oracle database installed version from two way . see follow

1) From inside oracle

----------------------

a) CMD> sqlplus /nolog

b) SQL> SELECT * FROM v$version ;

C) SQL> SELECT VERSION FROM v$instance;

d) SQL> select * from product_component_version;

2) from OS

a)

G:\app\Administrator\product\11.1.0\db_1\OPatch> set Oracle_home=G:\app\Administrator\product\11.1.0\db_1

G:\app\Administrator\product\11.1.0\db_1\OPatch>opatch lsinventory


B) $ORACLE_HOME/bin/svrmgrl command=exit | grep "Release"

c) $ORACLE_HOME/bin/oracle | grep NLSRTL

d) from “sqlnet.log’ file .

1 comment:

Anonymous said...

It works! many thanks