Last updated on September 11th, 2016 at 12:10 pm
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. |