查看Exadata的版本

可以通过imagehistory和imageinfo2个命令查看Exadata的dbserver和cellnode的版本, 例如:

 

DBSERVER:

[root@db01 ~]# imagehistory
Version : 11.2.2.4.2.111221
Image activation date : 2012-08-09 15:08:29 -0400
Imaging mode : fresh
Imaging status : success

Version : 11.2.3.1.1.120607
Image activation date : 2012-08-14 19:16:01 -0400
Imaging mode : patch
Imaging status : success

[root@db01 ~]# imageinfo

Kernel version: 2.6.18-274.18.1.0.1.el5 #1 SMP Thu Feb 9 19:07:16 EST 2012 x86_64
Image version: 11.2.3.1.1.120607
Image activated: 2012-08-14 19:16:01 -0400
Image status: success
System partition on device: /dev/mapper/VGExaDb-LVDbSys1
[root@cel01 ~]# imagehistory
Version : 11.2.2.4.2.111221
Image activation date : 2012-08-09 15:36:25 -0400
Imaging mode : fresh
Imaging status : success

Version : 11.2.3.1.1.120607
Image activation date : 2012-08-13 18:00:09 -0400
Imaging mode : out of partition upgrade
Imaging status : success

[root@cel01 ~]# imageinfo

Kernel version: 2.6.18-274.18.1.0.1.el5 #1 SMP Thu Feb 9 19:07:16 EST 2012 x86_64
Cell version: OSS_11.2.3.1.1_LINUX.X64_120607
Cell rpm version: cell-11.2.3.1.1_LINUX.X64_120607-1

Active image version: 11.2.3.1.1.120607
Active image activated: 2012-08-13 18:00:09 -0400
Active image status: success
Active system partition on device: /dev/md6
Active software partition on device: /dev/md8

In partition rollback: Impossible

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

Inactive image version: 11.2.2.4.2.111221
Inactive image activated: 2012-08-09 15:36:25 -0400
Inactive image status: success
Inactive system partition on device: /dev/md5
Inactive software partition on device: /dev/md7

Boot area has rollback archive for the version: 11.2.2.4.2.111221
Rollback to the inactive partitions: Possible

 

 

 

Exadata上的DB版本诊断,还可以参考下面的脚本:

 

 

{ case `uname` in \
Linux ) ILOM="/usr/bin/ipmitool sunoem cli" ;; \
SunOS ) ILOM="/opt/ipmitool/bin/ipmitool sunoem cli" ;; \
esac ; ImageInfo="/opt/oracle.cellos/imageinfo" ; \
uname -srm ; head -1 /etc/*release ; uptime | cut -d, -f1 ; \
$ILOM "show /SP system_description system_identifier" | grep = ; \
$ImageInfo -activated -node -status -ver | grep -v ^$ ; \
} | tee /tmp/ExaInfo.log

Next, as oracle, run: 
$GRID_HOME/OPatch/opatch lsinv -all -oh $GRID_HOME | tee /tmp/OPatchInv.log
$ORACLE_HOME/OPatch/opatch lsinv -all | tee -a /tmp/OPatchInv.log

 

 

Linux 2.6.18-274.18.1.0.1.el5 x86_64
==> /etc/enterprise-release <==
Enterprise Linux Enterprise Linux Server release 5.7 (Carthage)

==> /etc/oracle-release <==
Oracle Linux Server release 5.7

==> /etc/redhat-release <==
Red Hat Enterprise Linux Server release 5.7 (Tikanga)
00:45:26 up 16 days
system_description = SUN FIRE X4270 M2 SERVER, ILOM v3.0.16.10, r65138
system_identifier = Exadata Database Machine X2-2 AK00012260
Active image version: 11.2.3.1.1.120607
Active image activated: 2012-08-13 18:00:09 -0400
Active image status: success
Active node type: STORAGE
Inactive image version: 11.2.2.4.2.111221
Inactive image activated: 2012-08-09 15:36:25 -0400
Inactive image status: success
Inactive node type: STORAGE

关注dbDao.com的新浪微博

扫码关注dbDao.com 微信公众号:

沪公网安备 31010802001379号

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569