How Oracle Check Database Version

  • by

Database Version

Sometimes, you would like to determine what release of Oracle database you are operating on in order to take some other action you need to perform, for example, downloading proper patches for your database.

1. Top-Level Version

Top-level version is the one you initially installed. To check current database version, we can query V$VERSION for sure.

SQL> select banner from v$version;

Oracle Database 11g Enterprise Edition Release - 64bit Production
PL/SQL Release - Production
CORE      Production
TNS for Linux: Version - Production
NLSRTL Version - Production

By the way, for Oracle 11g, almost every release has its own full installer pack, for instances,,, Therefore, release does not necessarily upgrade from or Please check Oracle eDelivery for more software variations.

For Oracle database 19c, it's a little shorter.

SQL> select banner from v$version;

Oracle Database 19c Enterprise Edition Release - Production

As you can see, the base version is 19.0, although what I installed is 19.3 for Linux.

Please note that, if you didn't see Enterprise Edition in the result, it must be a Standard Edition. For databases in Standard Edition, some functions may need licenses to be used. For example, AWR report.

2. Software Patched Level

On the software-side, its patch history can be found by OPatch utility. Here we issue opatch lsinventory.

[oracle@ora19c1 ~]$ $ORACLE_HOME/OPatch/opatch lsinventory | grep "Patch description"
Patch description: "Database Release Update : (31771877)"
Patch description: "OCW RELEASE UPDATE (29585399)"

As you can see, the database software is patched up to, Oracle ClusterWare (OCW) is not updated.

3. SQL Patched Level

On the data-side, we can query DBA_REGISTRY_SQLPATCH for sure.

SQL> select description from dba_registry_sqlpatch order by action_time desc;

Database Release Update : (31771877)
Database Release Update : (29517242)

As you can see, the SQL patch version is updated to, it's the same as the Oracle Database's.

Leave a Reply

Your email address will not be published. Required fields are marked *