Oracle oraversion

Since Oracle 18c after you successfully apply the patches on the database binaries you will notice that when you invoke sqlplus after that…the version is immediately changed/reflected:

In 19c, after patching the database binaries sqlplus is referencing 19.4 version number

Picture1

This is due to changes being reflected in a file called “oraversion” under $ORACLE_HOME/bin directory

Picture2

For example:

$ORACLE_HOME/bin/oraversion -baseVersion

Picture3

$ORACLE_HOME/bin/oraversion -compositeVersion

Picture4

 

 

 

 

 

 

 

 

 

 

 

 

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s