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.
1 comment:
oraversion -compositeVersion;oraversion -baseVersion;oraversion -majorVersion;oraversion -buildDescription
18.12.0.0.0
18.0.0.0.0
18
Release_Update
Post a Comment