Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Discrepancy observed in Database minor version in Oracle 19c with 19.16.0.0.0 patch

user3737270Sep 1 2022 — edited Sep 1 2022

Hi all,
I have 2 servers both installed with Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production.
Server 1 has 19.14.0.0.0 patch applied while Server 2 has the latest recommended 19.16.0.0.0 patch applied.
In my application, I fetch the DB major & minor versions via JDBC(ojdbc8.jar) to do some checks.
Server 1: Major: 19, Minor: 0
Server 2: Major: 19, Minor: 1
I went over the DB release number explanation @ https://docs.oracle.com/en/database/oracle/oracle-database/12.2/upgrd/about-oracle-database-release-numbers.html
My question is why is the DB Minor version is changing with a mere patch application? If that's expected, it must be shown in the version query. But both servers return 19.0.0.0.0 when queried v$version table.
TIA.
SL~

Comments
Post Details
Added on Sep 1 2022
1 comment
1,169 views