how to find the Oracle database version and version of various Oracle utilities

Many times question is being asked about how to find the Oracle database version and version of various Oracle utilities

1) How to find Oracle database version

SQL> select * from v$version;

BANNER
—————————————————————-
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – Prod
PL/SQL Release 11.2.0.4.0 – Production
CORE 11.2.0.4.0 Production
TNS for 32-bit Windows: Version 11.2.0.4.0 – Production
NLSRTL Version 11.2.0.4.0 – Production
2) How to find client sqlplus vesion in use

sqlplus -v
SQL*Plus: Release 10.1.0.5.0 – Production
3)How to find the version of expdp
expdp

Export: Release 11.2.0.4.0 – Production on Saturday, 11 October, 2015 0:22:44

3)How to find the version of nid utility
4) nid

DBNEWID: Release 11.2.0.4.0 – Production on Saturday, 11 October, 2015 0:22:44

5) How to find the version of exp
exp

Export: Release 11.2.0.4.0 – Production on Saturday, 11 October, 2015 0:22:44
6) How to find the version of rman

rman

Some Explanation about VersionĀ 

 

Major Database Release Number The first digit is the most general identifier. It represents a major new version of the software that contains significant new functionality.
Database Maintenance Release Number The second digit represents a maintenance release level. Some new features may also be included.
Application Server Release Number The third digit reflects the release level of the Oracle Application Server (OracleAS).
Component-Specific Release Number The fourth digit identifies a release level specific to a component. Different components can have different numbers in this position depending upon, for example, component patch sets or interim releases.

 

Platform-Specific Release Number The fifth digit identifies a platform-specific release. Usually this is a patch set. When different platforms require the equivalent patch set, this digit will be the same across the affected platforms.