Innovation releases have shorter support periods ie. They are terming some versions as innovation releases and some as Long term releases. The latest version right now is 21c released in 2021. So 2018 was 18c Release, 2019 was 19c Release, and so on. After that, they continued year-wise starting in 2018.
![how to check oracle database version how to check oracle database version](https://database.guide/wp-content/uploads/2021/07/Check-Oracle-Version-in-SQL-Developer-2-1024x196.png)
Then they release Oracle 12c in 2013 where “c” stands for the cloud. They release Oracle 10g in 2003 where “g” stands for grid. They release Oracle 8i in 1998 where “i” stand for the internet. Oracle has released various versions of the Oracle database starting in 1979.
HOW TO CHECK ORACLE DATABASE VERSION PATCH
When different platforms require the equivalent patch set, this digit will be the same across the affected platforms. Platform-Specific Release Number The fifth digit identifies a platform-specific release. Different components can have different numbers in this position depending upon, for example, component patch sets or interim releases. Component-Specific Release Number The fourth digit identifies a release level specific to a component. Application Server Release Number The third digit reflects the release level of the Oracle Application Server (OracleAS). Database Maintenance Release Number The second digit represents a maintenance release level. It represents a major new version of the software that contains significant new functionality. Some Explanation about Version Major Database Release Number The first digit is the most general identifier. Under About Your Database, click Version Banner.Under Data Dictionary Reports, expand About Your Database.In the Reports navigator, expand Data Dictionary Reports.(If this tab is not visible, click View, then Reports.) In SQL Developer, click the Reports tab on the left, near the Connections navigator.
HOW TO CHECK ORACLE DATABASE VERSION HOW TO
SQL*Plus: Release 10.1.0.5.0 - Production How to find the version of expdp expdpĮxport: Release 11.2.0.4.0 - Production on Saturday, 11 October, 2015 0:22:44 How to find the version of nid utility $nidĭBNEWID: Release 11.2.0.4.0 - Production on Saturday, 11 October, 2015 0:22:44 How to find the version of exp $expĮxport: 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 Or select version from v$instance How to find client sqlplus version in use sqlplus -v You could use opatch also $ORACLE_HOME/OPatch/opatch lsinventory TNS for 32-bit Windows: Version 11.2.0.4.0 - Production Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Prod