10、升级后的检查：
检查系统的image版本：
[root@dm02db01 onecommand]# dcli -g all_group -l root "imagehistory" dm02db01: Version : 11.2.3.1.1.120607 dm02db01: Image activation date : 2012-08-08 15:03:41 +0800 dm02db01: Imaging mode : fresh 刷机的（有时候出厂介质也是这个状态） dm02db01: Imaging status : success dm02db01: dm02db01: Version : 11.2.3.2.1.130302 dm02db01: Image activation date : 2013-05-23 13:55:40 +0800 dm02db01: Imaging mode : patch 打patch的 dm02db01: Imaging status : success dm02db01: .... dm02cel13: dm02cel14: Version : 11.2.3.1.1.120607 dm02cel14: Image activation date : 2012-08-08 14:13:24 +0800 dm02cel14: Imaging mode : fresh dm02cel14: Imaging status : success dm02cel14: dm02cel14: Version : 11.2.3.2.1.130109 dm02cel14: Image activation date : 2013-05-23 13:20:51 +0800 dm02cel14: Imaging mode : out of partition upgrade dm02cel14: Imaging status : success dm02cel14:
可以看见操作系统已经是UEK内核，版本是2.6.32
[root@dm02db01 onecommand]# dcli -g all_group -l root "uname -a" dm02db01: Linux dm02db01.hrss 2.6.32-400.21.1.el5uek #1 SMP Wed Feb 20 01:35:01 PST 2013 x86_64 x86_64 x86_64 GNU/Linux dm02db02: Linux dm02db02.hrss 2.6.32-400.21.1.el5uek #1 SMP Wed Feb 20 01:35:01 PST 2013 x86_64 x86_64 x86_64 GNU/Linux ... dm02cel13: Linux dm02cel13.hrss 2.6.32-400.11.1.el5uek #1 SMP Thu Nov 22 03:29:09 PST 2012 x86_64 x86_64 x86_64 GNU/Linux dm02cel14: Linux dm02cel14.hrss 2.6.32-400.11.1.el5uek #1 SMP Thu Nov 22 03:29:09 PST 2012 x86_64 x86_64 x86_64 GNU/Linux [root@dm02db01 onecommand]#
Oracle Linux Server版本升级为 5.8(以前是5.7)：
[root@dm02db01 onecommand]# dcli -g all_group -l root "cat /etc/oracle-release" dm02db01: Oracle Linux Server release 5.8 dm02db02: Oracle Linux Server release 5.8 。。。 dm02cel13: Oracle Linux Server release 5.8 dm02cel14: Oracle Linux Server release 5.8 [root@dm02db01 onecommand]#
检查 Infiniband：
[root@dm02db01 oracle.SupportTools]# ./CheckSWProfile.sh -I IS_SPINEdm02sw-ib1,dm02sw-ib2,dm02sw-ib3
Checking if switch dm02sw-ib1 is pingable...
Checking if switch dm02sw-ib2 is pingable...
Checking if switch dm02sw-ib3 is pingable...
Use the default password for all switches? (y/n) [n]:
Use same password for all switches? (y/n) [n]: y
Enter admin or root password for All_Switches:
Confirm password:
[INFO] SUCCESS Switch dm02sw-ib1 has correct software and firmware version:
SWVer: 1.3.3-2
[INFO] SUCCESS Switch dm02sw-ib1 has correct opensm configuration:
controlled_handover=TRUE polling_retry_number=5 routing_engine=ftree sminfo_polling_timeout=1000 sm_priority=8
[INFO] SUCCESS Switch dm02sw-ib2 has correct software and firmware version:
SWVer: 1.3.3-2
[INFO] SUCCESS Switch dm02sw-ib2 has correct opensm configuration:
controlled_handover=TRUE polling_retry_number=5 routing_engine=ftree sminfo_polling_timeout=1000 sm_priority=5
[INFO] SUCCESS Switch dm02sw-ib3 has correct software and firmware version:
SWVer: 1.3.3-2
[INFO] SUCCESS Switch dm02sw-ib3 has correct opensm configuration:
controlled_handover=TRUE polling_retry_number=5 routing_engine=ftree sminfo_polling_timeout=1000 sm_priority=5
[INFO] SUCCESS All switches have correct software and firmware version:
SWVer: 1.3.3-2
[INFO] SUCCESS All switches have correct opensm configuration:
controlled_handover=TRUE polling_retry_number=5 routing_engine=ftree sminfo_polling_timeout=1000 sm_priority=5 for non spine and 8 for spine switch5
[root@dm02db01 oracle.SupportTools]#
检查数据库的版本信息：
SQL> select * from dba_registry_history; ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS ------------------------------ ------ ---------- ------------- ---------- --------------- ------------------------- 2012-09-04 18:41:36.254667 APPLY SERVER 11.2.0.3 0 PSU Patchset 11.2.0.2.0 2013-05-24 20:55:49.220036 APPLY SERVER 11.2.0.3 16 EXA BP16 2013-05-24 20:58:59.272651 APPLY SERVER 11.2.0.3 16 EXA BP16 2013-05-24 21:28:07.498157 APPLY SERVER 11.2.0.3 16 EXA BP16
检查opatch的信息：
[grid@dm02db01 ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME
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/opatch2013-05-26_12-12-39PM_1.log
Lsinventory Output file location : /u01/app/11.2.0.3/grid/cfgtoollogs/opatch/lsinv/lsinventory2013-05-26_12-12-39PM.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 Files 11.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
Enterprise Manager Common Core Files 10.2.0.4.4
Enterprise Manager Common Files 10.2.0.4.3
Enterprise Manager plugin Common Files 11.2.0.3.0
Expat libraries 2.0.1.0.1
HAS Common Files 11.2.0.3.0
HAS Files for DB 11.2.0.3.0
Installation Common Files 11.2.0.3.0
Installation Plugin Files 11.2.0.3.0
Installer SDK Component 11.2.0.3.0
LDAP Required Support Files 11.2.0.3.0
OLAP SQL Scripts 11.2.0.3.0
Oracle Clusterware RDBMS Files 11.2.0.3.0
Oracle Configuration Manager Deconfiguration 10.3.1.0.0
Oracle Containers for Java 11.2.0.3.0
Oracle Core Required Support Files 11.2.0.3.0
Oracle Database 11g 11.2.0.3.0
Oracle Database 11g Multimedia Files 11.2.0.3.0
Oracle Database Deconfiguration 11.2.0.3.0
Oracle Database User Interface 2.2.13.0.0
Oracle Database Utilities 11.2.0.3.0
Oracle DBCA Deconfiguration 11.2.0.3.0
Oracle Extended Windowing Toolkit 3.4.47.0.0
Oracle Globalization Support 11.2.0.3.0
Oracle Globalization Support 11.2.0.3.0
Oracle Grid Infrastructure 11.2.0.3.0
Oracle Help For Java 4.2.9.0.0
Oracle Ice Browser 5.2.3.6.0
Oracle Internet Directory Client 11.2.0.3.0
Oracle Java Client 11.2.0.3.0
Oracle JDBC/OCI Instant Client 11.2.0.3.0
Oracle JDBC/THIN Interfaces 11.2.0.3.0
Oracle JFC Extended Windowing Toolkit 4.2.36.0.0
Oracle JVM 11.2.0.3.0
Oracle LDAP administration 11.2.0.3.0
Oracle Locale Builder 11.2.0.3.0
Oracle Multimedia 11.2.0.3.0
Oracle Multimedia Client Option 11.2.0.3.0
Oracle Multimedia Java Advanced Imaging 11.2.0.3.0
Oracle Multimedia Locator 11.2.0.3.0
Oracle Multimedia Locator RDBMS Files 11.2.0.3.0
Oracle Net 11.2.0.3.0
Oracle Net Listener 11.2.0.3.0
Oracle Net Required Support Files 11.2.0.3.0
Oracle Netca Client 11.2.0.3.0
Oracle Notification Service 11.2.0.3.0
Oracle Notification Service (eONS) 11.2.0.3.0
Oracle One-Off Patch Installer 11.2.0.1.7
Oracle Quality of Service Management (Client) 11.2.0.3.0
Oracle Quality of Service Management (Server) 11.2.0.3.0
Oracle RAC Deconfiguration 11.2.0.3.0
Oracle RAC Required Support Files-HAS 11.2.0.3.0
Oracle Recovery Manager 11.2.0.3.0
Oracle Security Developer Tools 11.2.0.3.0
Oracle Text Required Support Files 11.2.0.3.0
Oracle Universal Installer 11.2.0.3.0
Oracle USM Deconfiguration 11.2.0.3.0
Oracle Wallet Manager 11.2.0.3.0
Parser Generator Required Support Files 11.2.0.3.0
Perl Interpreter 5.10.0.0.2
Perl Modules 5.10.0.0.1
PL/SQL 11.2.0.3.0
PL/SQL Embedded Gateway 11.2.0.3.0
Platform Required Support Files 11.2.0.3.0
Precompiler Required Support Files 11.2.0.3.0
RDBMS Required Support Files 11.2.0.3.0
RDBMS Required Support Files for Instant Client 11.2.0.3.0
RDBMS Required Support Files Runtime 11.2.0.3.0
Required Support Files 11.2.0.3.0
Secure Socket Layer 11.2.0.3.0
SQL*Plus 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 16401300 : applied on Thu May 23 20:45:22 CST 2013
Unique Patch ID: 15963835
Patch description: "DISKMON PATCH FOR EXADATA (MAR 2013 - 11.2.0.3.16) : (16401300)"
Created on 26 Feb 2013, 03:30:34 hrs PST8PDT
Bugs fixed:
13513982, 13688022, 14050993, 14307915, 13350234, 16401300, 14184077
Files Touched:
diskmon.bin --> ORACLE_HOME/bin/diskmon.bin
Patch Location in Inventory:
/u01/app/11.2.0.3/grid/inventory/oneoffs/16401300
Patch Location in Storage area:
/u01/app/11.2.0.3/grid/.patch_storage/16401300_Feb_26_2013_03_30_34
Patch 16355082 : applied on Thu May 23 20:44:29 CST 2013
Unique Patch ID: 15963835
Patch description: "CRS PATCH FOR EXADATA (MAR 2013 - 11.2.0.3.16) : (16355082)"
Created on 12 Mar 2013, 19:07:31 hrs PST8PDT
......
Rac system comprising of multiple nodes
Local node = dm02db01
Remote node = dm02db02
Remote node = dm02db03
Remote node = dm02db04
Remote node = dm02db05
Remote node = dm02db06
Remote node = dm02db07
Remote node = dm02db08
--------------------------------------------------------------------------------
OPatch succeeded.
[grid@dm02db01 ~]$ exit
logout
[oracle@dm02db01 ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME
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/opatch2013-05-26_12-13-17PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2013-05-26_12-13-17PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.3.0
There are 1 products installed in this Oracle Home.
Installed Products (136):
Agent Required Support Files 10.2.0.4.3
Assistant Common Files 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 Verification Utility Common Files 11.2.0.3.0
Database Configuration and Upgrade Assistants 11.2.0.3.0
Database SQL Scripts 11.2.0.3.0
Database Workspace Manager 11.2.0.3.0
Deinstallation Tool 11.2.0.3.0
Enterprise Edition Options 11.2.0.3.0
Enterprise Manager Agent 10.2.0.4.3
Enterprise Manager Agent Core Files 10.2.0.4.4
Enterprise Manager Common Core Files 10.2.0.4.4
Enterprise Manager Common Files 10.2.0.4.3
Enterprise Manager Database Plugin -- Agent Support 11.2.0.3.0
Enterprise Manager Database Plugin -- Repository Support 11.2.0.3.0
Enterprise Manager Grid Control Core Files 10.2.0.4.4
Enterprise Manager plugin Common Files 11.2.0.3.0
Enterprise Manager Repository Core Files 10.2.0.4.4
Exadata Storage Server 11.2.0.1.0
Expat libraries 2.0.1.0.1
Generic Connectivity Common Files 11.2.0.3.0
HAS Common Files 11.2.0.3.0
HAS Files for DB 11.2.0.3.0
Installation Common Files 11.2.0.3.0
Installation Plugin Files 11.2.0.3.0
Installer SDK Component 11.2.0.3.0
JAccelerator (COMPANION) 11.2.0.3.0
LDAP Required Support Files 11.2.0.3.0
OLAP SQL Scripts 11.2.0.3.0
Oracle 11g Warehouse Builder Required Files 11.2.0.3.0
Oracle Advanced Security 11.2.0.3.0
Oracle Application Express 11.2.0.3.0
Oracle Call Interface (OCI) 11.2.0.3.0
Oracle Clusterware RDBMS Files 11.2.0.3.0
Oracle Code Editor 1.2.1.0.0I
Oracle Configuration Manager 10.3.5.0.1
Oracle Configuration Manager Client 10.3.2.1.0
Oracle Configuration Manager Deconfiguration 10.3.1.0.0
Oracle Containers for Java 11.2.0.3.0
Oracle Core Required Support Files 11.2.0.3.0
Oracle Data Mining RDBMS Files 11.2.0.3.0
Oracle Database 11g 11.2.0.3.0
Oracle Database 11g 11.2.0.3.0
Oracle Database 11g Multimedia Files 11.2.0.3.0
Oracle Database Deconfiguration 11.2.0.3.0
Oracle Database Gateway for ODBC 11.2.0.3.0
Oracle Database User Interface 2.2.13.0.0
Oracle Database Utilities 11.2.0.3.0
Oracle Database Vault J2EE Application 11.2.0.3.0
Oracle Database Vault option 11.2.0.3.0
Oracle DBCA Deconfiguration 11.2.0.3.0
Oracle Display Fonts 9.0.2.0.0
Oracle Enterprise Manager Console DB 11.2.0.3.0
Oracle Extended Windowing Toolkit 3.4.47.0.0
Oracle Globalization Support 11.2.0.3.0
Oracle Globalization Support 11.2.0.3.0
Oracle Help For Java 4.2.9.0.0
Oracle Help for the Web 2.0.14.0.0
Oracle Ice Browser 5.2.3.6.0
Oracle Internet Directory Client 11.2.0.3.0
Oracle Java Client 11.2.0.3.0
Oracle JDBC Server Support Package 11.2.0.3.0
Oracle JDBC/OCI Instant Client 11.2.0.3.0
Oracle JDBC/THIN Interfaces 11.2.0.3.0
Oracle JFC Extended Windowing Toolkit 4.2.36.0.0
Oracle JVM 11.2.0.3.0
Oracle Label Security 11.2.0.3.0
Oracle LDAP administration 11.2.0.3.0
Oracle Locale Builder 11.2.0.3.0
Oracle Message Gateway Common Files 11.2.0.3.0
Oracle Multimedia 11.2.0.3.0
Oracle Multimedia Annotator 11.2.0.3.0
Oracle Multimedia Client Option 11.2.0.3.0
Oracle Multimedia Java Advanced Imaging 11.2.0.3.0
Oracle Multimedia Locator 11.2.0.3.0
Oracle Multimedia Locator RDBMS Files 11.2.0.3.0
Oracle Net 11.2.0.3.0
Oracle Net Listener 11.2.0.3.0
Oracle Net Required Support Files 11.2.0.3.0
Oracle Net Services 11.2.0.3.0
Oracle Netca Client 11.2.0.3.0
Oracle Notification Service 11.2.0.3.0
Oracle Notification Service (eONS) 11.2.0.3.0
Oracle ODBC Driver 11.2.0.3.0
Oracle ODBC Driverfor Instant Client 11.2.0.3.0
Oracle OLAP 11.2.0.3.0
Oracle OLAP API 11.2.0.3.0
Oracle OLAP RDBMS Files 11.2.0.3.0
Oracle One-Off Patch Installer 11.2.0.1.7
Oracle Partitioning 11.2.0.3.0
Oracle Programmer 11.2.0.3.0
Oracle Quality of Service Management (Client) 11.2.0.3.0
Oracle RAC Deconfiguration 11.2.0.3.0
Oracle RAC Required Support Files-HAS 11.2.0.3.0
Oracle Real Application Testing 11.2.0.3.0
Oracle Recovery Manager 11.2.0.3.0
Oracle Security Developer Tools 11.2.0.3.0
Oracle Spatial 11.2.0.3.0
Oracle SQL Developer 11.2.0.3.0
Oracle Starter Database 11.2.0.3.0
Oracle Text 11.2.0.3.0
Oracle Text Required Support Files 11.2.0.3.0
Oracle UIX 2.2.24.6.0
Oracle Universal Connection Pool 11.2.0.3.0
Oracle Universal Installer 11.2.0.3.0
Oracle USM Deconfiguration 11.2.0.3.0
Oracle Wallet Manager 11.2.0.3.0
Oracle XML Development Kit 11.2.0.3.0
Oracle XML Query 11.2.0.3.0
Parser Generator Required Support Files 11.2.0.3.0
Perl Interpreter 5.10.0.0.2
Perl Modules 5.10.0.0.1
PL/SQL 11.2.0.3.0
PL/SQL Embedded Gateway 11.2.0.3.0
Platform Required Support Files 11.2.0.3.0
Precompiler Common Files 11.2.0.3.0
Precompiler Required Support Files 11.2.0.3.0
Provisioning Advisor Framework 10.2.0.4.3
RDBMS Required Support Files 11.2.0.3.0
RDBMS Required Support Files for Instant Client 11.2.0.3.0
RDBMS Required Support Files Runtime 11.2.0.3.0
regexp 2.1.9.0.0
Required Support Files 11.2.0.3.0
Sample Schema Data 11.2.0.3.0
Secure Socket Layer 11.2.0.3.0
SQL*Plus 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
SQLJ Runtime 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 11.2.0.3.0
XML Parser for Oracle JVM 11.2.0.3.0
There are 136 products installed in this Oracle Home.
Interim patches (3) :
Patch 16401300 : applied on Thu May 23 20:37:10 CST 2013
Unique Patch ID: 15963835
Patch description: "DISKMON PATCH FOR EXADATA (MAR 2013 - 11.2.0.3.16) : (16401300)"
Created on 26 Feb 2013, 03:30:34 hrs PST8PDT
Bugs fixed:
13513982, 13688022, 14050993, 14307915, 13350234, 16401300, 14184077
Files Touched:
diskmon.bin --> ORACLE_HOME/bin/diskmon.bin
Patch Location in Inventory:
/u01/app/oracle/product/11.2.0.3/dbhome_1/inventory/oneoffs/16401300
Patch Location in Storage area:
/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/16401300_Feb_26_2013_03_30_34
Patch 16355082 : applied on Thu May 23 20:36:52 CST 2013
Unique Patch ID: 15963835
Patch description: "CRS PATCH FOR EXADATA (MAR 2013 - 11.2.0.3.16) : (16355082)"
Created on 12 Mar 2013, 19:07:31 hrs PST8PDT
Bugs fixed:
15876003, 14275572, 13919095, 13696251, 13348650, 12659561, 13039908
14277586, 13987807, 14625969, 13938166, 13825231, 13036424, 12794268
........
/u01/app/oracle/product/11.2.0.3/dbhome_1/inventory/oneoffs/16233552
Patch Location in Storage area:
/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/16233552_Mar_8_2013_02_05_30
Rac system comprising of multiple nodes
Local node = dm02db01
Remote node = dm02db02
Remote node = dm02db03
Remote node = dm02db04
Remote node = dm02db05
Remote node = dm02db06
Remote node = dm02db07
Remote node = dm02db08
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@dm02db01 ~]$ exit
