【简单的案例分享,停机10分钟】10204升级CRS&DB的PSU至102044
时间:2022-03-14 02:40
发现一个现象,AIX5.3+HACMP+10.2.0.4RAC+RAW的环境,运行五六年的数据库crsd.log都会报以下错误:
-------------------------------------------
CAAMonitorHandler :: 0:Action Script /opt/oracle/product/crs/bin/racgwrap(check) timed out for ora.harac1.vip! (timeout=60)
CheckResource error for ora.harac1.vip error code = -2
CAAMonitorHandler :: 0:Could not join /opt/oracle/product/crs/bin/racgwrap(check)
category: 1234, operation: scls_process_join, loc: childcrash, OS error: 0,
other: Abnormal termination of the child
-------------------------------------------
以上错误发生时,vip1无法响应应用连接,持续时间由2-10分钟不等,影响范围很大。
以上错误其实是BUG,对于BUG的描述请看:
由此可见,只要将CRS版本升级至10.2.0.4.2或该版本以上即可。
以下粘出打补丁的测试全过程,测试环境为RedHat5.5+ASM+10204RAC
此次打补丁采用滚动升级方式进行,最后一步需要START UPGRADE独占方式启库操作,将中止数据库对外服务,将影响范围降至最低。
提醒:打补丁前一定要仔细查看README.txt,并严格按照README.txt里的步骤逐一操作,而且打丁前切记备份数据库和安装目录,做好回退方案,以免不时之需。
1.1.1 preinstall requickment
[oracle@dwdb1 ~]$ cd $ORA_CRS_HOME/OPatch [oracle@dwdb1 OPatch]$ ./opatch lsinventory -detail Invoking OPatch 10.2.0.4.2
Oracle Interim Patch Installer version 10.2.0.4.2 Copyright (c) 2007, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/product/11.1.0/db_1 Central Inventory : /oracle/oraInventory from : /etc/oraInst.loc OPatch version : 10.2.0.4.2 OUI version : 10.2.0.4.0 OUI location : /oracle/product/11.1.0/db_1/oui Log file location : /oracle/product/11.1.0/db_1/cfgtoollogs/opatch/opatch2014-11-10_10-21-55AM.log
Lsinventory Output file location : /oracle/product/11.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2014-11-10_10-21-55AM.txt
-------------------------------------------------------------------------------- Installed Top-level Products (2):
Oracle Database 10g 10.2.0.1.0 Oracle Database 10g Release 2 Patch Set 3 10.2.0.4.0 There are 2 products installed in this Oracle Home.
Installed Products (191):
Agent Required Support Files 10.2.0.1.0 Agent Required Support Files Patch 10.2.0.4.0 Assistant Common Files 10.2.0.1.0 Assistant Common Files Patch 10.2.0.4.0 Bali Share 1.1.18.0.0 Buildtools Common Files 10.2.0.1.0 Character Set Migration Utility 10.2.0.1.0 Character Set Migration Utility Patch 10.2.0.4.0 Database Configuration and Upgrade Assistants 10.2.0.1.0 Database Configuration and Upgrade Assistants Patch 10.2.0.4.0 Database SQL Scripts 10.2.0.1.0 Database SQL Scripts Patch 10.2.0.4.0 Database Workspace Manager 10.2.0.1.0 Database Workspace Manager 10.2.0.4.0 DBJAVA Required Support Files 10.2.0.1.0 DBJAVA Required Support Files Patch 10.2.0.4.0 Enterprise Edition Options 10.2.0.1.0 Enterprise Manager Agent Core 10.2.0.1.0 Enterprise Manager Agent Core Patch 10.2.0.4.0a Enterprise Manager Agent DB 10.2.0.1.0 Enterprise Manager Agent DB 10.2.0.4.0 Enterprise Manager Baseline 10.2.0.1.0 Enterprise Manager Baseline 10.2.0.4.0 Enterprise Manager Common Core Patch 10.2.0.4.0a Enterprise Manager Common Files 10.2.0.1.0 Enterprise Manager Minimal Integration 10.2.0.1.0 Enterprise Manager plugin Common Files 10.2.0.1.0 Enterprise Manager plugin Common Files 10.2.0.1.0 Enterprise Manager plugin Common Files Patch 10.2.0.4.0 Enterprise Manager Repository Core 10.2.0.1.0 Enterprise Manager Repository Core patch 10.2.0.4.0a Enterprise Manager Repository DB 10.2.0.1.0 Enterprise Manager Repository DB 10.2.0.4.0 Generic Connectivity Common Files 10.2.0.1.0 Generic Connectivity Common Files Patch 10.2.0.4.0 HAS Common Files 10.2.0.1.0 HAS Common Files Patch 10.2.0.4.0 HAS Files for DB 10.2.0.1.0 HAS Files for DB Patch 10.2.0.4.0 Installation Common Files 10.2.0.1.0 Installation Common Files Patch 10.2.0.4.0 Installer SDK Component 10.2.0.4.0 iSQL*Plus 10.2.0.1.0 iSQL*Plus 10.2.0.4.0 Java Runtime Environment 1.4.2.14.0 JDBC Common Files 10.2.0.1.0 JDBC Common Files 10.2.0.4.0 LDAP Required Support Files 10.2.0.1.0 LDAP Required Support Files Patch 10.2.0.4.0 OLAP SQL Scripts 10.2.0.1.0 OLAP SQL Scripts Patch 10.2.0.4.0 Oracle Advanced Security 10.2.0.1.0 Oracle Advanced Security Patch 10.2.0.4.0 Oracle Call Interface (OCI) 10.2.0.1.0 Oracle Call Interface (OCI) Patch 10.2.0.4.0 Oracle Clusterware RDBMS Files 10.2.0.1.0 Oracle Clusterware RDBMS Files Patch 10.2.0.4.0 Oracle Code Editor 1.2.1.0.0I Oracle Configuration Manager 10.2.7.1.0 Oracle Containers for Java 10.2.0.1.0 Oracle Containers for Java 10.2.0.4.0 Oracle Core Required Support Files 10.2.0.1.0 Oracle Core Required Support Files Patch 10.2.0.4.0 Oracle Data Mining RDBMS Files 10.2.0.1.0 Oracle Data Mining RDBMS Files Patch 10.2.0.4.0 Oracle Database 10g 10.2.0.1.0 Oracle Database 10g 10.2.0.1.0 Oracle Database 10G 32 bit 10.2.0.1.0 Oracle Database 10g interMedia Files 10.2.0.1.0 Oracle Database 10g interMedia Files Patch 10.2.0.4.0 Oracle Database 10g Patch 10.2.0.4.0 Oracle Database 10g Patch 10.2.0.4.0 Oracle Database 10g Release 2 Patch Set 3 10.2.0.4.0 Oracle Database User Interface 2.2.13.0.0 Oracle Database Utilities 10.2.0.1.0 Oracle Database Utilities Patch 10.2.0.4.0 Oracle Display Fonts 9.0.2.0.0 Oracle Enterprise Manager Console DB 10.2.0.1.0 Oracle Enterprise Manager Console DB 10.2.0.4.0 Oracle Extended Windowing Toolkit 3.4.38.0.0 Oracle Globalization Support 10.2.0.1.0 Oracle Globalization Support Patch 10.2.0.4.0 Oracle Help For Java 4.2.6.1.0 Oracle Help for the Web 1.1.10.0.0 Oracle Ice Browser 5.2.3.6.0 Oracle interMedia 10.2.0.1.0 Oracle interMedia Annotator 10.2.0.1.0 Oracle interMedia Client Option 10.2.0.1.0 Oracle interMedia Client Option Patch 10.2.0.4.0 Oracle interMedia Java Advanced Imaging 10.2.0.1.0 Oracle interMedia Java Advanced Imaging Patch 10.2.0.4.0 Oracle interMedia Locator 10.2.0.1.0 Oracle interMedia Locator Patch 10.2.0.4.0 Oracle interMedia Locator RDBMS Files 10.2.0.1.0 Oracle interMedia Locator RDBMS Files Patch 10.2.0.4.0 Oracle interMedia Patch 10.2.0.4.0 Oracle Internet Directory Client 10.2.0.1.0 Oracle Internet Directory Client Patch 10.2.0.4.0 Oracle Java Client 10.2.0.1.0 Oracle Java Client Patch 10.2.0.4.0 Oracle JDBC Thin Driver for JDK 1.2 10.2.0.1.0 Oracle JDBC Thin Driver for JDK 1.2 Patch 10.2.0.4.0 Oracle JDBC Thin Driver for JDK 1.4 10.2.0.1.0 Oracle JDBC Thin Driver for JDK 1.4 Patch 10.2.0.4.0 Oracle JDBC/OCI Instant Client 10.2.0.1.0 Oracle JDBC/OCI Instant Client Patch 10.2.0.4.0 Oracle JFC Extended Windowing Toolkit 4.2.33.0.0 Oracle JVM 10.2.0.1.0 Oracle JVM Patch 10.2.0.4.0 Oracle LDAP administration 10.2.0.1.0 Oracle LDAP administration patch 10.2.0.4.0 Oracle Locale Builder 10.2.0.1.0 Oracle Message Gateway Common Files 10.2.0.1.0 Oracle Message Gateway Common Files Patch 10.2.0.4.0 Oracle Net 10.2.0.1.0 Oracle Net Listener 10.2.0.1.0 Oracle Net Listener Patch 10.2.0.4.0 Oracle Net Patch 10.2.0.4.0 Oracle Net Required Support Files 10.2.0.1.0 Oracle Net Required Support Files Patch 10.2.0.4.0 Oracle Net Services 10.2.0.1.0 Oracle Notification Service 10.1.0.3.0 Oracle Notification Service Patch 10.2.0.4.0 Oracle ODBC Driver 10.2.0.1.0 Oracle ODBC Driver Patch 10.2.0.4.0 Oracle OLAP 10.2.0.1.0 Oracle OLAP API 10.2.0.1.0 Oracle OLAP API Patch 10.2.0.4.0 Oracle OLAP Patch 10.2.0.4.0 Oracle OLAP RDBMS Files 10.2.0.1.0 Oracle OLAP RDBMS Files Patch 10.2.0.4.0 Oracle One-Off Patch Installer 10.2.0.4.0 Oracle Partitioning 10.2.0.1.0 Oracle Partitioning Patch 10.2.0.4.0 Oracle Programmer 10.2.0.1.0 Oracle RAC Required Support Files-HAS 10.2.0.1.0 Oracle RAC Required Support Files-HAS Patch 10.2.0.4.0 Oracle Real Application Testing 10.2.0.4.0 Oracle Recovery Manager 10.2.0.1.0 Oracle Recovery Manager Patch 10.2.0.4.0 Oracle Required Support Files 32 bit 10.2.0.0.0 Oracle Required Support Files 32 bit Patch 10.2.0.4.0 Oracle Spatial 10.2.0.1.0 Oracle Starter Database 10.2.0.1.0 Oracle Starter Database Patch 10.2.0.4.0 Oracle Text 10.2.0.1.0 Oracle Text Patch 10.2.0.4.0 Oracle UIX 2.1.22.0.0 Oracle Universal Installer 10.2.0.4.0 Oracle Wallet Manager 10.2.0.1.0 Oracle Wallet Manager Patch 10.2.0.4.0 Oracle XML Development Kit 10.2.0.1.0 Oracle XML Development Kit Patch 10.2.0.4.0 Parser Generator Required Support Files 10.2.0.1.0 Perl Interpreter 5.8.3.0.2 PL/SQL 10.2.0.1.0 PL/SQL 10.2.0.4.0 PL/SQL Embedded Gateway 10.2.0.1.0 PL/SQL Embedded Gateway Patch 10.2.0.4.0 Platform Required Support Files 10.2.0.1.0 Platform Required Support Files 10.2.0.4.0 Precompiler Common Files 10.2.0.1.0 Precompiler Common Files Patch 10.2.0.4.0 Precompiler Required Support Files 10.2.0.1.0 Precompiler Required Support Files Patch 10.2.0.4.0 RDBMS Required Support Files 10.2.0.1.0 RDBMS Required Support Files for Instant Client 10.2.0.1.0 RDBMS Required Support Files for Instant Client Patch 10.2.0.4.0 RDBMS Required Support Files Patch 10.2.0.4.0 regexp 2.1.9.0.0 Required Support Files 10.2.0.1.0 Sample Schema Data 10.2.0.1.0 Sample Schema Data Patch 10.2.0.4.0 Secure Socket Layer 10.2.0.1.0 Secure Socket Layer Patch 10.2.0.4.0 SQL*Plus 10.2.0.1.0 SQL*Plus 10.2.0.4.0 SQL*Plus Required Support Files 10.2.0.1.0 SQL*Plus Required Support Files Patch 10.2.0.4.0 SQLJ Runtime 10.2.0.1.0 SQLJ Runtime Patch 10.2.0.4.0 SSL Required Support Files for InstantClient 10.2.0.1.0 SSL Required Support Files for InstantClient Patch 10.2.0.4.0 Sun JDK 1.4.2.14.0 Sun JDK extensions 10.1.2.0.0 XDK Required Support Files 10.2.0.1.0 XDK Required Support Files Patch 10.2.0.4.0 XML Parser for Java 10.2.0.1.0 XML Parser for Java Patch 10.2.0.4.0 XML Parser for Oracle JVM 10.2.0.1.0 XML Parser for Oracle JVM Patch 10.2.0.4.0 There are 191 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
Rac system comprising of multiple nodes Local node = dwdb1 Remote node = dwdb2
--------------------------------------------------------------------------------
OPatch succeeded. |
[oracle@dwdb1 orainst]$ ls –lrt total 2299108 drwxr-xr-x 10 oracle oinstall 4096 Oct 23 2005 clusterware drwxr-xr-x 6 oracle oinstall 4096 Oct 23 2005 database drwxr-xr-x 5 oracle oinstall 4096 Mar 12 2008 Disk1 -rwxr-xr-x 1 oracle oinstall 171882 Mar 17 2008 README.html drwxr-xr-x 7 oracle oinstall 4096 Nov 3 2010 OPatch -rw-r--r-- 1 oracle oinstall 316486815 Nov 3 22:19 10201_clusterware_linux_x86_64.cpio.gz -rw-r--r-- 1 oracle oinstall 758433170 Nov 3 22:20 10201_database_linux_x86_64.cpio.gz -rw-r--r-- 1 oracle oinstall 1195551830 Nov 6 22:59 p6810189_10204_Linux-x86-64.zip -rw-r--r-- 1 oracle oinstall 0 Nov 6 23:03 a -rw-r--r-- 1 oracle oinstall 20035 Nov 10 10:45 p9294403_CRS-PSU_102044_README.txt -rw-r--r-- 1 oracle oinstall 53853693 Nov 10 10:45 p9294403_CRS-PSU_102044_Linux-x86-64.zip -rw-r--r-- 1 oracle oinstall 27412455 Nov 10 10:59 p6880880_102000_Linux-x86-64.zip [oracle@dwdb1 orainst]$ ./OPatch/opatch version Invoking OPatch 10.2.0.5.1
OPatch Version: 10.2.0.5.1
OPatch succeeded. |
[oracle@dwdb1 orainst]$ mv $ORA_CRS_HOME/OPatch $ORA_CRS_HOME/OPatch_bak [oracle@dwdb1 orainst]$ cp -rp OPatch/ /oracle/product/11.1.0/crs_1/ [oracle@dwdb1 orainst]$ mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch_bak [oracle@dwdb1 orainst]$ cp -rp OPatch/ $ORACLE_HOME/ |
[oracle@dwdb1 orainst]$ unzip p9294403_CRS-PSU_102044_Linux-x86-64.zip [oracle@dwdb1 orainst]$ cd 9294403 |
1.1.2 stop instance and CRS (11:07 – 五分钟)
[oracle@dwdb1 orainst]$ srvctl stop instance -i odsptdb1 -d odsptdb [root@dwdb1 crs_1]# /etc/init.d/init.crs stop Shutting down Oracle Cluster Ready Services (CRS): Nov 10 11:08:20.377 | INF | daemon shutting down Stopping resources. This could take several minutes. Successfully stopped CRS resources. Stopping CSSD. Shutting down CSS daemon. Shutdown request successfully issued. Shutdown has begun. The daemons should exit soon. |
1.1.3 unlock protected files<root>
# export ORA_CRS_HOME=/oracle/product/11.1.0/crs_1 [root@dwdb1 9294403]# /orainst/9294403/custom/scripts/prerootpatch.sh -crshome $ORA_CRS_HOME -crsuser oracle Checking to see if Oracle CRS stack is down... Oracle CRS stack is down now. |
1.1.4 save important configuration setting<oracl>
[oracle@dwdb1 orainst]$ /orainst/9294403/custom/scripts/prepatch.sh -crshome $ORA_CRS_HOME /orainst/9294403/custom/scripts/prepatch.sh completed successfully. [oracle@dwdb1 orainst]$ [oracle@dwdb1 orainst]$ [oracle@dwdb1 orainst]$ /orainst/9294403/custom/server/9294403/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME Unable to determine value for ORACLE_BASE. Ignoring... /orainst/9294403/custom/server/9294403/custom/scripts/prepatch.sh completed successfully. |
1.1.5 Patch the CRS home files
1.1.5.1 to CRS_HOME
[oracle@dwdb1 orainst]$ export PATH=$ORA_CRS_HOME/OPatch:$PATH [oracle@dwdb1 orainst]$ opatch napply -local -oh $ORA_CRS_HOME -id 9294403 Invoking OPatch 10.2.0.5.1
Oracle Interim Patch Installer version 10.2.0.5.1 Copyright (c) 2010, Oracle Corporation. All rights reserved.
UTIL session
Oracle Home : /oracle/product/11.1.0/crs_1 Central Inventory : /oracle/oraInventory from   相关推荐
电脑软件热门排行今日推荐热门手游 |