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



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.

Leave a Reply