Many times question is being asked about how to find the Oracle database version and version of various Oracle utilities
Table of Contents
how to check oracle database version in Linux or any OS
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
or
you could use opatch also
opatch lsinventory
or
select version from v$instance;
How to find client sqlplus version in use
sqlplus -v
SQL*Plus: Release 10.1.0.5.0 - Production
How to find the version of expdp
expdp
Export: Release 11.2.0.4.0 - Production on Saturday, 11 October, 2015 0:22:44
How to find the version of nid utility
$nid DBNEWID: Release 11.2.0.4.0 - Production on Saturday, 11 October, 2015 0:22:44
How to find the version of exp
$exp Export: Release 11.2.0.4.0 - Production on Saturday, 11 October, 2015 0:22:44
How to find the version of rman
$rman
how to check oracle version in sql developer
- In SQL Developer, click the Reports tab on the left, near the Connections navigator. (If this tab is not visible, click View, then Reports.)
- In the Reports navigator, expand Data Dictionary Reports.
- Under Data Dictionary Reports, expand About Your Database.
- Under About Your Database, click Version Banner.
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. |
Also reads
Oracle database cloning : Check this page for Oracle database cloning which is important role of a oracle DBA. See steps by steps instruction with explanation
DBMS_REDEFINITION :Online table redefinition allows to modify the table structure definition without significantly affecting the availability of the table.
CPU vs Core Vs Socket :Find out what is CPU vs Core Vs Socket, difference and how to find them in windows using different command in easy manner,
clone database from cold backup : This post consists of step by step detailed instruction to clone the oracle database using cold backup database cloning method
dbms_metadata.get_ddl materialized view : Check out how to get table definition in oracle, oracle show index definition, get ddl of materialized view in oracle, get the query of a view in oracle
Recommended Courses
The following are some of the recommended courses you can buy if you want to get a step further
Given below are the links to some of the courses
Oracle DBA 11g/12c – Database Administration for Junior DBA : This course is good for the people who are starting as Junior DBA or aspire to be Oracle DBA. This will provide a good understanding on backup & recovery and General administration tasks
Oracle Database: Oracle 12C R2 RAC Administration : This course covers the installation, administration of Oracle RAC. A good course for Oracle DBA who want to upgrade his skills for Oracle RAC
Oracle Data Guard: Database Administration for Oracle 12C R2 :This course covers the installation, administration of Oracle Dataguard. A good course for Oracle DBA who want to upgrade his skills for Oracle Dataguard
Leave a Reply