How to Check your Exadata Version » Oracle Exadata Patching
Although patching an Oracle Database is a common task for most DBAs, Exadata Patching can be a more intricate process, as it incorporates the complexity of patching a number of components in the Exadata Systems.
Oracle Offers free, Exadata patching to their Exadata customers under Oracle Platinum Services. However, there are many times when patches need to be applied to your Exadata Machine that won’t work on Oracle’s schedule, needing between 8-12 prior notice.
In a traditional Database Environment, a Database Administrator would use patch GRID_HOME and ORACLE_HOME and patching is done, but in Exadata Patching you must consider the following components.
- Exadata Storage Server
- Database server
- InfiniBand switch
- Additional components, ex. Ethernet
Patches can be divided in 3 different parts:
Exadata Storage Cell Software Version
# 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_184.108.40.206.1_LINUX.X64_130109 Cell rpm version: cell-220.127.116.11.1_LINUX.X64_130109-1 Active image version: 18.104.22.168.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/md
Exadata Database Software Version
$ cd /u01/app/oracle/product/22.214.171.124/dbhome_1 $ cd OPatch/ $ ./opatch lsinventory -detail -oh /u01/app/oracle/product/126.96.36.199/dbhome_1 Oracle Interim Patch Installer version 188.8.131.52.3 Copyright (c) 2012, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/184.108.40.206/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/220.127.116.11/dbhome_1/oraInst.loc OPatch version : 18.104.22.168.3 OUI version : 22.214.171.124.0
Exadata Grid (CRS) Software Version
$ ./opatch lsinventory -detail -oh /u01/app/126.96.36.199/grid Oracle Interim Patch Installer version 188.8.131.52.3 Copyright (c) 2012, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/184.108.40.206/grid Central Inventory : /u01/app/oraInventory from : /u01/app/220.127.116.11/grid/oraInst.loc OPatch version : 18.104.22.168.3 OUI version : 22.214.171.124.0