Oracle version info via oraversion

oraversion - Oracle Version tool 

Oracle version info via oraversion

SQL> Disconnected from Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0


[oracle@ORA-18C]$ oraversion -help

This program prints release version information.
These are its possible arguments:
-compositeVersion: Print the full version number: a.b.c.d.e.
-baseVersion: Print the base version number: a.0.0.0.0.
-majorVersion: Print the major version number: a.
-buildStamp: Print the date/time associated with the build.
-buildDescription: Print a description of the build.
-help: Print this message.



cd $ORACLE_HOME/bin/


oraversion -compositeVersion
oraversion -baseVersion
oraversion -majorVersion
oraversion -buildStamp
oraversion -buildDescription


[oracle@ORA-18C]$ oraversion -compositeVersion
18.3.0.0.0

[oracle@ORA-18C]$ oraversion -baseVersion
18.0.0.0.0

[oracle@ORA-18C]$ oraversion -majorVersion
18

[oracle@ORA-18C]$ oraversion -buildStamp
180628094320

[oracle@ORA-18C]$ oraversion -buildDescription
Release_Update


Run this command on unix prompt ..

cd $ORACLE_HOME/bin/

echo "CompositeVersion:- `oraversion -compositeVersion`" ; echo "BaseVersion:- `oraversion -baseVersion`" ;echo "MajorVersion:- `oraversion -majorVersion`" ;echo "BuildStamp :- `oraversion -buildStamp`";echo "BuildDescription :- `oraversion -buildDescription`"

output !!

CompositeVersion:- 18.12.0.0.0
BaseVersion:- 18.0.0.0.0
MajorVersion:- 18
BuildStamp :- 201003042812
BuildDescription :- Release_Update

from Grid

 id
uid=54322(grid) gid=54321(oinstall) groups=54321(oinstall),599(ssh_access),54322(dba),54323(asmdba),54324(asmadmin),54325(asmoper)

echo "CompositeVersion:- `oraversion -compositeVersion`" ; echo "BaseVersion:- `oraversion -baseVersion`" ;echo "MajorVersion:- `oraversion -majorVersion`" ;echo "BuildStamp :- `oraversion -buildStamp`";echo "BuildDescription :- `oraversion -buildDescription`"

Output !!

CompositeVersion:- 18.6.0.0.0
BaseVersion:- 18.0.0.0.0
MajorVersion:- 18
BuildStamp :- 190319010234
BuildDescription :- Release_Update

In 12.1  we have two different types of patches – Bundle patch /PSU patches and interim patches (non bundles) :

  The versioning scheme up until 12.2.0.1 splits the patch metadata into 2 places :

The XML patch descriptor found under $ORACLE_HOME/sqlpatch/bug id/bug uid/bug id.xml  
bundledata_.xml found under $ORACLE_HOME/rdbms/admin.

check xml file 
cd /u01/app/oracle/product/18.0.0/dbhome_1/rdbms/admin


ls -ltr *xml
-rw-r--r-- 1 oracle oinstall 52007 Oct  5 12:01 sqlfiles.xml
-rw-r--r-- 1 oracle oinstall  4130 Oct  5 12:01 bundlefcp_DBBP.xml


[oracle@ORA-18C-DR admin]$ cat bundlefcp_DBBP.xml|more
 


Bundle patches are marked with ‘B’ in the flags column of dba_registry_sqlpatch.