Oracle RDBMS Version
SELECT * FROM V$VERSION;
Version of OPATCH
$ perl $ORACLE_HOME/OPatch/opatch.pl version
Listener Version
$ lsnrctl version
Check Database 32-bit or 64-bit?
select length(addr)*4 '-bits' word_length from v$process where ROWNUM =1;
HOME > Trick and Tips > How to find Oracle Database Components version
Post a Comment