How to check Exadata Image Version, Grid Software Version and Database Software Version in Oracle ?

Till now, Remote DBA needs to keep track of Oracle GRID software version, Oracle Database software version only, but with Introduction of Exadata a DBA have to check for Exadata image version or Exadata software version as well. Here I am listing method of getting all the versions at one place.Let's start with Database Software version,

 Exadata Software or Image version Details:


To find Exadata image version, we need to login to exadata cell server and execute "imageinfo" , but if direct login to cell server is not possible. So, we can go through DB server.

Login to DB server and list /etc/hosts. This will give IP address and Name of cell servers in  Exadata. under "### Cell Node Private Interface details"

-bash-4.1$ cat /etc/hosts

 Now ssh to cell server using root user. Suppose cell server IP is 192.168.4.40.
 -bash-4.1$ ssh -l root 192.168.4.40
root@192.168.4.40's password:
Last login: Sat Apr 20 10:34:33 2013 from cellserver.remote_dba.com 

[root@remote_dbacell1 ~]# imageinfo

Kernel version: 2.6.32-400.11.1.el5uek #1 SMP Thu Nov 11 03:00:09 PST 2012 x86_64
Cell version: OSS_11.2.3.2.1_LINUX.X64_130109
Cell rpm version: cell-11.2.3.2.1_LINUX.X64_130109-1

Active image version: 11.2.3.2.1.130109
Active image activated: 2012-01-10 11:03:00 -0400
Active image status: success
Active system partition on device: /dev/md4
Active software partition on device: /dev/md6

In partition rollback: Impossible

Cell boot usb partition: /dev/sdm1
Cell boot usb version: 11.2.3.2.1.130109

Inactive image version: undefined
Rollback to the inactive partitions: Impossible
Here, this is easy for a DBA to identify current image version, listed with "Active image version" which is 11.2.3.2.1. In Exadata it is possible to go back to previous version of Exadata and that is listed in "Inactive image version" and "In partition rollback". In this case which is not possible due to some reasons. 

Database Software version Details:

Login to Database Server using oracle s/w owner and execute.

# opatch lsinventory -detail -oh {Oracle Home}

On execution of above command DBA may face following issues.

-bash-4.1$ opatch
-bash: opatch: command not found

To solve this, go to $ORACLE_HOME/OPatch then execute above command. If you are not able to find ORACLE_HOME use  http://www.dbas-oracle.com/2011/05/what-is-oraclehomename-and-how-to-find.html
-bash-4.1$ cd /u01/app/oracle/product/11.2.0.3/dbhome_1
-bash-4.1$ cd OPatch/
-bash-4.1$ ./opatch lsinventory -detail -oh /u01/app/oracle/product/11.2.0.3/dbhome_1
Oracle Interim Patch Installer version 11.2.0.3.3
Copyright (c) 2012, Oracle Corporation.  All rights reserved.
Oracle Home       : /u01/app/oracle/product/11.2.0.3/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0.3/dbhome_1/oraInst.loc
OPatch version    : 11.2.0.3.3
OUI version       : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/opatch2012-02-20_00-32-20AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/lsinvlsinventory2012-02-20_00-32-20AM_1.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database11g             11.2.0.3.0
There are 1 products installed in this Oracle Home.
Installed Products (135):
Agent Required Support Files           10.2.0.4.3
Assistant Common Files     11.2.0.3.0
BaliShare     1.1.18.0.0
Buildtools Common Files   &nb  11.2.0.3.0
 ---------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------- 
SSL Required Support Files for InstantClient                 11.2.0.3.0
Sun JDK       1.5.0.30.03
XDK Required Support Files                   11.2.0.3.0
XML Parser for Java  &nbsp       11.2.0.3.0
XML Parser for Oracle JVM       &nbsp       1.2.0.3.0
There are 135 products installed in this Oracle Home.
Interim patches (3) :
Patch  14307915     : applied on Tue Mar 13 12:04:55 GMT-05:00 2013
Unique Patch ID:  15848868
Patch description:  "DISKMON PATCH FOR EXADATA (FEB 2013 - 11.2.0.3.15) : (14307915)"

Created on 29 Jan 2013, 09:30:38 hrs UTC
Bugs fixed:
14307915, 14050993, 13688022, 13350234, 14184077, 13513982
Files Touched:
diskmon.bin --> ORACLE_HOME/bin/diskmon.bin
Patch Location in Inventory:/app/oracle/product/11.2.0.3/dbhome_1/inventory/oneoffs/14307915
Patch Location in Storage area:/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/14307915_Jan_29_2013_09_30_38
Patch  16355082&nbsp : applied on Tue Mar 12 14:04:37 GMT-05:00 2013
Unique Patch ID:  15848868
Patch description:  "CRS PATCH FOR EXADATA (FEB 2013 - 11.2.0.3.15) : (16355082)"

   Created on 16 Feb 2013, 06:04:25 hrs PST8PDT
   Bugs fixed:
     15876003, 14275572, 13919095, 13696251, 13348650, 12659561, 13039908
     14277586, 13987807, 14625969, 13938166, 13825231, 13036424, 12794268
     13011520, 13569812, 12758736, 13000491, 13498267, 13077654, 13001901
     13550689, 13430715, 13806545, 13634583, 11675721, 14082976, 14271305
This command will give a huge list of things, but Version of Oracle S/W for a remote DBA to look at is given under "Interim patches" is 11.2.0.3.15. This means Oracle s/w version is 11.2.0.3 with Bundle Patch 15.

Grid Software version Details:

Login using grid owner user, it might be oracle or grid and execute same command by replacing ORACLE_HOME with GRID_HOME path.

# opatch lsinventory -detail -oh {Grid home}

To find GRID_HOME use http://www.dbas-oracle.com/2013/04/how-to-find-grid-home-location-in-oracle.html.
-bash-4.1$ ./opatch lsinventory -detail -oh /u01/app/11.2.0.3/grid  
Oracle Interim Patch Installer version 11.2.0.3.3
Copyright (c) 2012, Oracle Corporation.  All rights reserved.
Oracle Home       : /u01/app/11.2.0.3/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/11.2.0.3/grid/oraInst.loc
OPatch version    : 11.2.0.3.3
OUI version       : 11.2.0.3.0
Log file location : /u01/app/11.2.0.3/grid/cfgtoollogs/opatch/opatch2012-02-20_00-32-20AM_1.log
Lsinventory Output file location : /u01/app/11.2.0.3/grid/cfgtoollogs/opatch/lsinv/lsinventory2012-02-20_00-32-20AM_1.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Grid Infrastructure                                           11.2.0.3.0
There are 1 products installed in this Oracle Home.
Installed Products (88):
Agent Required Support Files            10.2.0.4.3
Assistant Common Files                  11.2.0.3.0
Automatic Storage Management Assistant  11.2.0.3.0
Bali Share                              1.1.18.0.0
Buildtools Common Files                 11.2.0.3.0
Character Set Migration Utility         11.2.0.3.0
Cluster Ready Services Files            11.2.0.3.0
Cluster Verification Utility Common Files11.2.0.3.0
Cluster Verification Utility Files      11.2.0.3.0
Database SQL Scripts                    11.2.0.3.0
Deinstallation Tool                     11.2.0.3.0
-------------------------------------------------------------------------------------------------------------------------- 
SQL*Plus Files for Instant Client       11.2.0.3.0
SQL*Plus Required Support Files         11.2.0.3.0
SSL Required Support Files for InstantClient  11.2.0.3.0
Sun JDK                                 1.5.0.30.03
Universal Storage Manager Files         11.2.0.3.0
XDK Required Support Files              11.2.0.3.0
XML Parser for Java                     11.2.0.3.0
There are 88 products installed in this Oracle Home.

Interim patches (3) :

Patch  14307915     : applied on Tue Mar 12 13:26:37 GMT-05:00 2013
Unique Patch ID:  15848868
Patch description:  "DISKMON PATCH FOR EXADATA (FEB 2013 - 11.2.0.3.15) : (14307915)"
   Created on 29 Jan 2013, 09:30:38 hrs UTC
   Bugs fixed:
     14307915, 14050993, 13688022, 13350234, 14184077, 13513982
   Files Touched:
     diskmon.bin --> ORACLE_HOME/bin/diskmon.bin
   Patch Location in Inventory:
     /u01/app/11.2.0.3/grid/inventory/oneoffs/14307915
   Patch Location in Storage area:
     /u01/app/11.2.0.3/grid/.patch_storage/14307915_Jan_29_2013_09_30_38

Patch  16355082     : applied on Tue Mar 12 13:26:14 GMT-05:00 2013
Unique Patch ID:  15848868
Patch description:  "CRS PATCH FOR EXADATA (FEB 2013 - 11.2.0.3.15) : (16355082)"
   Created on 16 Feb 2013, 06:04:25 hrs PST8PDT
   Bugs fixed:
     15876003, 14275572, 13919095, 13696251, 13348650, 12659561, 13039908
     14277586, 13987807, 14625969, 13938166, 13825231, 13036424, 12794268
     13011520, 13569812, 12758736, 13000491, 13498267, 13077654, 13001901
     

Here again, This gives a huge list, important thing for a remote dba to look at is "Interim patches". This clearly shows 11.2.0.3.15 is the patch version. This means GRID S/W has Oracle 11.2.0.3 S/W with Bundle patch 15 Installed.

Please share your views about this article. 

No comments:

Post a Comment