打补丁前,查看DB实例状态
[oracle@beihangedw05 ~]$ srvctl status database -d odd
Instance odd1 is running on node beihangedw05
Instance odd2 is running on node beihangedw06
Instance odd3 is running on node beihangedw07
Instance odd4 is running on node beihangedw08
odd为4个节点的RAC
1.对ODD集群各节点grid与oracle家目录备份
备份目录
[root@beihangedw05 backup]# pwd
/u01/app/backup
节点1:
[root@beihangedw05 backup]#
[root@beihangedw05 backup]# nohup tar -cvf db_1.tar /u01/app/oracle/product/11.2.0/db_1/ &
[root@beihangedw05 backup]# nohup tar -cvf 11.2.0.tar /u01/app/11.2.0/ &
其它剩余3个节点,进行如上备份.
2.更新OPatch utility
grid用户下
grid与oracle用户下,备份先前opatch目录.
更新前
[grid@beihangedw05 OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.4
OPatch succeeded.
其它剩余3个节点检查更新
更新后
[grid@beihangedw05 OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.17
OPatch succeeded.
oracle用户下
更新前
[oracle@beihangedw05 OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.4
OPatch succeeded
更新后
[oracle@beihangedw05 OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.17
OPatch succeeded.
其它剩余3个节点检查更新
3.OCM Configuration
节点1:
[grid@beihangedw05 bin]$ pwd
/u01/app/11.2.0/grid/OPatch/ocm/bin
[grid@beihangedw05 bin]$ ll -athr
total 20K
-rwxr-x--- 1 grid oinstall 8.9K Nov 27 2009 emocmrsp
drwxr-x--- 5 grid oinstall 4.0K Oct 11 02:16 ..
drwxr-x--- 2 grid oinstall 4.0K Oct 11 02:16 .
[grid@beihangedw05 bin]$
[grid@beihangedw05 bin]$ ./emocmrsp
OCM Installation Response Generator 10.3.7.0.0 - Production
Copyright (c) 2005, 2012, Oracle and/or its affiliates. All rights reserved.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y
The OCM configuration response file (ocm.rsp) was successfully created.
[grid@beihangedw05 bin]$ ll -athr
total 24K
-rwxr-x--- 1 grid oinstall 8.9K Nov 27 2009 emocmrsp
drwxr-x--- 5 grid oinstall 4.0K Oct 11 02:16 ..
drwxr-x--- 2 grid oinstall 4.0K Nov 24 21:28 .
-rw-r--r-- 1 grid oinstall 621 Nov 24 21:28 ocm.rsp
[grid@beihangedw05 bin]$
[grid@beihangedw05 bin]$ chmod 775 ocm.rsp
[grid@beihangedw05 bin]$ ll -athr ocm.rsp
-rwxrwxr-x 1 grid oinstall 621 Nov 24 21:28 ocm.rsp
剩余3个节点进行如上操作,产生ocm.rsp,且进行权限755赋值.
4. Validation of Oracle Inventory
grid用户下:
[grid@beihangedw05 OPatch]$ ./opatch lsinventory -detail -oh /u01/app/11.2.0/grid
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: beihangedw05
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Grid Infrastructure 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
Installed Products (89):
Agent Required Support Files 10.2.0.4.5
Assistant Common Files 11.2.0.4.0
Automatic Storage Management Assistant 11.2.0.4.0
Bali Share 1.1.18.0.0
Buildtools Common Files 11.2.0.4.0
Character Set Migration Utility 11.2.0.4.0
Cluster Ready Services Files 11.2.0.4.0
Cluster Verification Utility Common Files 11.2.0.4.0
Cluster Verification Utility Files 11.2.0.4.0
Database SQL Scripts 11.2.0.4.0
Deinstallation Tool 11.2.0.4.0
Enterprise Manager Common Core Files 10.2.0.4.5
Enterprise Manager Common Files 10.2.0.4.5
Enterprise Manager plugin Common Files 11.2.0.4.0
Expat libraries 2.0.1.0.1
HAS Common Files 11.2.0.4.0
HAS Files for DB 11.2.0.4.0
Installation Common Files 11.2.0.4.0
Installation Plugin Files 11.2.0.4.0
Installer SDK Component 11.2.0.4.0
Java Development Kit 1.5.0.51.10
LDAP Required Support Files 11.2.0.4.0
OLAP SQL Scripts 11.2.0.4.0
Oracle Advanced Security 11.2.0.4.0
Oracle Clusterware RDBMS Files 11.2.0.4.0
Oracle Configuration Manager Deconfiguration 10.3.1.0.0
Oracle Containers for Java 11.2.0.4.0
Oracle Core Required Support Files 11.2.0.4.0
Oracle Database 11g 11.2.0.4.0
Oracle Database 11g Multimedia Files 11.2.0.4.0
Oracle Database Deconfiguration 11.2.0.4.0
Oracle Database User Interface 2.2.13.0.0
Oracle Database Utilities 11.2.0.4.0
Oracle DBCA Deconfiguration 11.2.0.4.0
Oracle Extended Windowing Toolkit 3.4.47.0.0
Oracle Globalization Support 11.2.0.4.0
Oracle Globalization Support 11.2.0.4.0
Oracle Grid Infrastructure 11g 11.2.0.4.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.4.0
Oracle Java Client 11.2.0.4.0
Oracle JDBC/OCI Instant Client 11.2.0.4.0
Oracle JDBC/THIN Interfaces 11.2.0.4.0
Oracle JFC Extended Windowing Toolkit 4.2.36.0.0
Oracle JVM 11.2.0.4.0
Oracle LDAP administration 11.2.0.4.0
Oracle Locale Builder 11.2.0.4.0
Oracle Multimedia 11.2.0.4.0
Oracle Multimedia Client Option 11.2.0.4.0
Oracle Multimedia Java Advanced Imaging 11.2.0.4.0
Oracle Multimedia Locator 11.2.0.4.0
Oracle Multimedia Locator RDBMS Files 11.2.0.4.0
Oracle Net 11.2.0.4.0
Oracle Net Listener 11.2.0.4.0
Oracle Net Required Support Files 11.2.0.4.0
Oracle Netca Client 11.2.0.4.0
Oracle Notification Service 11.2.0.3.0
Oracle Notification Service (eONS) 11.2.0.4.0
Oracle One-Off Patch Installer 11.2.0.3.4
Oracle Quality of Service Management (Client) 11.2.0.4.0
Oracle Quality of Service Management (Server) 11.2.0.4.0
Oracle RAC Deconfiguration 11.2.0.4.0
Oracle RAC Required Support Files-HAS 11.2.0.4.0
Oracle Recovery Manager 11.2.0.4.0
Oracle Security Developer Tools 11.2.0.4.0
Oracle Text Required Support Files 11.2.0.4.0
Oracle Universal Installer 11.2.0.4.0
Oracle USM Deconfiguration 11.2.0.4.0
Oracle Wallet Manager 11.2.0.4.0
Parser Generator Required Support Files 11.2.0.4.0
Perl Interpreter 5.10.0.0.2
Perl Modules 5.10.0.0.1
PL/SQL 11.2.0.4.0
PL/SQL Embedded Gateway 11.2.0.4.0
Platform Required Support Files 11.2.0.4.0
Precompiler Required Support Files 11.2.0.4.0
RDBMS Required Support Files 11.2.0.4.0
RDBMS Required Support Files for Instant Client 11.2.0.4.0
RDBMS Required Support Files Runtime 11.2.0.4.0
Required Support Files 11.2.0.4.0
Secure Socket Layer 11.2.0.4.0
SQL*Plus 11.2.0.4.0
SQL*Plus Files for Instant Client 11.2.0.4.0
SQL*Plus Required Support Files 11.2.0.4.0
SSL Required Support Files for InstantClient 11.2.0.4.0
Universal Storage Manager Files 11.2.0.4.0
XDK Required Support Files 11.2.0.4.0
XML Parser for Java 11.2.0.4.0
There are 89 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.
其它剩余3个点,如上操作.
oracle用户下
[oracle@beihangedw05 OPatch]$ ./opatch lsinventory -detail -oh /u01/app/oracle/product/11.2.0/db_1
Oracle Interim Patch Installer version 11.2.0.3.17
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version : 11.2.0.3.17
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2017-11-25_00-38-42AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-11-25_00-38-42AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: beihangedw05
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
Installed Products (136):
Agent Required Support Files 10.2.0.4.5
Assistant Common Files 11.2.0.4.0
Bali Share 1.1.18.0.0
Buildtools Common Files 11.2.0.4.0
Character Set Migration Utility 11.2.0.4.0
Cluster Verification Utility Common Files 11.2.0.4.0
Database Configuration and Upgrade Assistants 11.2.0.4.0
Database SQL Scripts 11.2.0.4.0
Database Workspace Manager 11.2.0.4.0
Deinstallation Tool 11.2.0.4.0
Enterprise Edition Options 11.2.0.4.0
Enterprise Manager Agent 10.2.0.4.5
Enterprise Manager Agent Core Files 10.2.0.4.5
Enterprise Manager Common Core Files 10.2.0.4.5
Enterprise Manager Common Files 10.2.0.4.5
Enterprise Manager Database Plugin -- Agent Support 11.2.0.4.0
Enterprise Manager Database Plugin -- Repository Support 11.2.0.4.0
Enterprise Manager Grid Control Core Files 10.2.0.4.5
Enterprise Manager plugin Common Files 11.2.0.4.0
Enterprise Manager Repository Core Files 10.2.0.4.5
Exadata Storage Server 11.2.0.1.0
Expat libraries 2.0.1.0.1
Generic Connectivity Common Files 11.2.0.4.0
HAS Common Files 11.2.0.4.0
HAS Files for DB 11.2.0.4.0
Installation Common Files 11.2.0.4.0
Installation Plugin Files 11.2.0.4.0
Installer SDK Component 11.2.0.4.0
JAccelerator (COMPANION) 11.2.0.4.0
Java Development Kit 1.5.0.51.10
LDAP Required Support Files 11.2.0.4.0
OLAP SQL Scripts 11.2.0.4.0
Oracle 11g Warehouse Builder Required Files 11.2.0.4.0
Oracle Advanced Security 11.2.0.4.0
Oracle Application Express 11.2.0.4.0
Oracle Call Interface (OCI) 11.2.0.4.0
Oracle Clusterware RDBMS Files 11.2.0.4.0
Oracle Code Editor 1.2.1.0.0I
Oracle Configuration Manager 10.3.8.1.0
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.4.0
Oracle Core Required Support Files 11.2.0.4.0
Oracle Data Mining RDBMS Files 11.2.0.4.0
Oracle Database 11g 11.2.0.4.0
Oracle Database 11g 11.2.0.4.0
Oracle Database 11g Multimedia Files 11.2.0.4.0
Oracle Database Deconfiguration 11.2.0.4.0
Oracle Database Gateway for ODBC 11.2.0.4.0
Oracle Database User Interface 2.2.13.0.0
Oracle Database Utilities 11.2.0.4.0
Oracle Database Vault J2EE Application 11.2.0.4.0
Oracle Database Vault option 11.2.0.4.0
Oracle DBCA Deconfiguration 11.2.0.4.0
Oracle Display Fonts 9.0.2.0.0
Oracle Enterprise Manager Console DB 11.2.0.4.0
Oracle Extended Windowing Toolkit 3.4.47.0.0
Oracle Globalization Support 11.2.0.4.0
Oracle Globalization Support 11.2.0.4.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.4.0
Oracle Java Client 11.2.0.4.0
Oracle JDBC Server Support Package 11.2.0.4.0
Oracle JDBC/OCI Instant Client 11.2.0.4.0
Oracle JDBC/THIN Interfaces 11.2.0.4.0
Oracle JFC Extended Windowing Toolkit 4.2.36.0.0
Oracle JVM 11.2.0.4.0
Oracle Label Security 11.2.0.4.0
Oracle LDAP administration 11.2.0.4.0
Oracle Locale Builder 11.2.0.4.0
Oracle Message Gateway Common Files 11.2.0.4.0
Oracle Multimedia 11.2.0.4.0
Oracle Multimedia Annotator 11.2.0.4.0
Oracle Multimedia Client Option 11.2.0.4.0
Oracle Multimedia Java Advanced Imaging 11.2.0.4.0
Oracle Multimedia Locator 11.2.0.4.0
Oracle Multimedia Locator RDBMS Files 11.2.0.4.0
Oracle Net 11.2.0.4.0
Oracle Net Listener 11.2.0.4.0
Oracle Net Required Support Files 11.2.0.4.0
Oracle Net Services 11.2.0.4.0
Oracle Netca Client 11.2.0.4.0
Oracle Notification Service 11.2.0.3.0
Oracle Notification Service (eONS) 11.2.0.4.0
Oracle ODBC Driver 11.2.0.4.0
Oracle ODBC Driverfor Instant Client 11.2.0.4.0
Oracle OLAP 11.2.0.4.0
Oracle OLAP API 11.2.0.4.0
Oracle OLAP RDBMS Files 11.2.0.4.0
Oracle One-Off Patch Installer 11.2.0.3.4
Oracle Partitioning 11.2.0.4.0
Oracle Programmer 11.2.0.4.0
Oracle Quality of Service Management (Client) 11.2.0.4.0
Oracle RAC Deconfiguration 11.2.0.4.0
Oracle RAC Required Support Files-HAS 11.2.0.4.0
Oracle Real Application Testing 11.2.0.4.0
Oracle Recovery Manager 11.2.0.4.0
Oracle Security Developer Tools 11.2.0.4.0
Oracle Spatial 11.2.0.4.0
Oracle SQL Developer 11.2.0.4.0
Oracle Starter Database 11.2.0.4.0
Oracle Text 11.2.0.4.0
Oracle Text Required Support Files 11.2.0.4.0
Oracle UIX 2.2.24.6.0
Oracle Universal Connection Pool 11.2.0.4.0
Oracle Universal Installer 11.2.0.4.0
Oracle USM Deconfiguration 11.2.0.4.0
Oracle Wallet Manager 11.2.0.4.0
Oracle XML Development Kit 11.2.0.4.0
Oracle XML Query 11.2.0.4.0
Parser Generator Required Support Files 11.2.0.4.0
Perl Interpreter 5.10.0.0.2
Perl Modules 5.10.0.0.1
PL/SQL 11.2.0.4.0
PL/SQL Embedded Gateway 11.2.0.4.0
Platform Required Support Files 11.2.0.4.0
Precompiler Common Files 11.2.0.4.0
Precompiler Required Support Files 11.2.0.4.0
Provisioning Advisor Framework 10.2.0.4.3
RDBMS Required Support Files 11.2.0.4.0
RDBMS Required Support Files for Instant Client 11.2.0.4.0
RDBMS Required Support Files Runtime 11.2.0.4.0
regexp 2.1.9.0.0
Required Support Files 11.2.0.4.0
Sample Schema Data 11.2.0.4.0
Secure Socket Layer 11.2.0.4.0
SQL*Plus 11.2.0.4.0
SQL*Plus Files for Instant Client 11.2.0.4.0
SQL*Plus Required Support Files 11.2.0.4.0
SQLJ Runtime 11.2.0.4.0
SSL Required Support Files for InstantClient 11.2.0.4.0
XDK Required Support Files 11.2.0.4.0
XML Parser for Java 11.2.0.4.0
XML Parser for Oracle JVM 11.2.0.4.0
There are 136 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.
5. unzip patch/
[grid@beihangedw05 ~]$ cd /u01/app/patch/
[grid@beihangedw05 patch]$ ll
总用量 757020
-rwxrw-rw- 1 grid oinstall 775179252 11月 3 10:22 p26635745_112040_Linux-x86-64.zip
[grid@beihangedw05 patch]$
[grid@beihangedw05 patch]$unzip p26635745_112040_Linux-x86-64.zip
[grid@beihangedw05 patch]$chmod -R 755 26635745
[grid@beihangedw05 patch]$chmod 775 26635745
6.stop dbconsole
$ <ORACLE_HOME>/bin/emctl stop dbconsole
7. opatch
节点1:
关闭打补丁节点的实例与监听
[oracle@beihangedw08 ~]$ srvctl stop instance -d odd -n beihangedw08
[oracle@beihangedw08 ~]$ srvctl stop listener -n beihangedw08
ps -ef |grep ora
kill oracle进程
[root@beihangedw06 ~]# ps -ef |grep ora
grid 61283 1 0 Aug18 ? 00:58:43 /u01/app/11.2.0/grid/jdk/bin/java -server -Xcheck:jni -Xms128M -Xmx384M -Djava.awt.headless=true -Ddisable.checkForUpdate=true -Dstdstream.filesize=100 -Dstdstream.filenumber=10 -DTRACING.ENABLED=false -Doracle.wlm.dbwlmlogger.logging.level=INFO -Dport.rmi=23792 -jar /u01/app/11.2.0/grid/oc4j/j2ee/home/oc4j.jar -config /u01/app/11.2.0/grid/oc4j/j2ee/home/OC4J_DBWLM_config/server.xml -out /u01/app/11.2.0/grid/oc4j/j2ee/home/log/oc4j.out -err /u01/app/11.2.0/grid/oc4j/j2ee/home/log/oc4j.err
root 63184 55377 0 11:05 pts/3 00:00:00 grep ora
root 82129 1 0 May15 ? 05:44:00 /u01/app/11.2.0/grid/jdk/jre/bin/java -Xms64m -Xmx256m -classpath /u01/app/11.2.0/grid/tfa/beihangedw06/tfa_home/jar/RATFA.jar:/u01/app/11.2.0/grid/tfa/beihangedw06/tfa_home/jar/je-4.0.103.jar:/u01/app/11.2.0/grid/tfa/beihangedw06/tfa_home/jar/ojdbc6.jar oracle.rat.tfa.TFAMain /u01/app/11.2.0/grid/tfa/beihangedw06/tfa_home
grid 85971 1 0 May15 ? 08:40:11 /u01/app/11.2.0/grid/bin/oraagent.bin
root 86625 1 0 May15 ? 10:47:35 /u01/app/11.2.0/grid/bin/orarootagent.bin
grid 87585 1 0 May15 ? 00:00:00 oracle+ASM2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 87748 1 0 May15 ? 00:00:29 oracle+ASM2_ocr (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 87752 1 0 May15 ? 00:12:19 oracle+ASM2_asmb_+asm2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 87881 1 0 May15 ? 05:39:27 /u01/app/11.2.0/grid/bin/oraagent.bin
root 87885 1 0 May15 ? 15:20:55 /u01/app/11.2.0/grid/bin/orarootagent.bin
grid 87915 1 0 May15 ? 00:00:36 oracle+ASM2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
patrol 140179 111008 0 Nov01 ? 00:05:02 /opt/bmc/Patrol3/Linux-2-6-x86-64-nptl/../oracle/alreader -p 60
patrol 176227 111008 0 Nov24 ? 00:00:00 /u01/app/oracle/product/11.2.0/db_1/bin/sqlplus -s
grid 178656 178654 0 Nov24 ? 00:00:00 oracle+ASM2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 180670 180663 0 Nov24 ? 00:00:00 oracle+ASM2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
[root@beihangedw06 ~]#
[root@beihangedw06 ~]#
[root@beihangedw06 ~]# kill -9 61283
[root@beihangedw06 ~]# kill -9 82129
[root@beihangedw06 ~]# kill -9 140179
[root@beihangedw06 ~]# kill -9 176227
[root@beihangedw06 ~]#
[root@beihangedw06 ~]# ps -ef |grep ora
root 63460 55377 0 11:05 pts/3 00:00:00 grep ora
grid 85971 1 0 May15 ? 08:40:12 /u01/app/11.2.0/grid/bin/oraagent.bin
root 86625 1 0 May15 ? 10:47:35 /u01/app/11.2.0/grid/bin/orarootagent.bin
grid 87585 1 0 May15 ? 00:00:00 oracle+ASM2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 87748 1 0 May15 ? 00:00:29 oracle+ASM2_ocr (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 87752 1 0 May15 ? 00:12:19 oracle+ASM2_asmb_+asm2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 87881 1 0 May15 ? 05:39:27 /u01/app/11.2.0/grid/bin/oraagent.bin
root 87885 1 0 May15 ? 15:20:55 /u01/app/11.2.0/grid/bin/orarootagent.bin
grid 87915 1 0 May15 ? 00:00:36 oracle+ASM2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 178656 178654 0 Nov24 ? 00:00:00 oracle+ASM2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 180670 180663 0 Nov24 ? 00:00:00 oracle+ASM2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
[root@beihangedw06 ~]#
查询当前系统LANG变量为中文
[root@beihangedw05 ~]# echo $LANG
en_US.UTF-8
设置系统变量为英文
[root@newrac1 ~]# export LANG=en_US
oracle与grid用户环境变量先设置
$export LANG=en_US
[root@newrac1 ~]# export LANG=en_US
[root@beihangedw08 ~]# export PATH=$PATH:/u01/app/11.2.0/grid/OPatch
[root@beihangedw08 ~]# /u01/app/11.2.0/grid/OPatch/opatch auto /u01/app/patch/26635745 -ocmrf /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp
Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /u01/app/patch -patchn 26635745 -ocmrf /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params
This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2017-11-07_15-11-56.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2017-11-07_15-11-56.report.log
2017-11-07 15:11:56: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Stopping RAC /u01/app/oracle/product/11.2.0/db_1 ...
Stopped RAC /u01/app/oracle/product/11.2.0/db_1 successfully
patch /u01/app/patch/26635745/26392168 apply successful for home /u01/app/oracle/product/11.2.0/db_1
patch /u01/app/patch/26635745/26609929/custom/server/26609929 apply successful for home /u01/app/oracle/product/11.2.0/db_1
Stopping CRS...
Stopped CRS successfully
patch /u01/app/patch/26635745/26392168 apply successful for home /u01/app/11.2.0/grid
patch /u01/app/patch/26635745/26609929 apply successful for home /u01/app/11.2.0/grid
patch /u01/app/patch/26635745/22502505 apply successful for home /u01/app/11.2.0/grid
Starting CRS...
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.
Starting RAC /u01/app/oracle/product/11.2.0/db_1 ...
Started RAC /u01/app/oracle/product/11.2.0/db_1 successfully
opatch auto succeeded.
查询打补丁节点的实例与监听是否运行.
[oracle@beihangedw05 ~]$ srvctl status database -d odd
Instance odd1 is running on node beihangedw05
Instance odd2 is running on node beihangedw06
Instance odd3 is running on node beihangedw07
Instance odd4 is running on node beihangedw08
[oracle@beihangedw05 ~]$ srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): beihangedw06,beihangedw08,beihangedw05,beihangedw07
8. LOAD MODIFY SQL INTO DB.
The following steps load modified SQL files into the database. For an Oracle RAC environment, perform these steps on only one node.
[oracle@newrac1 ~]$ cd /u01/app/oracle/product/11.2.0/db_1/rdbms/admin/
[oracle@newrac1 admin]$ sqlplus / as sysdba
sql>@catbundle.sql psu apply
sql>@utlrp.sql;
SQL> select * from dba_registry_history;
ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS
------------------------------ ---------- ---------- --------------- ---------- --------------- ------------------------------
24-AUG-13 12.03.45.119862 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
16-MAY-17 03.36.59.213458 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
25-NOV-17 11.48.23.639345 AM APPLY SERVER 11.2.0.4 171017 PSU PSU 11.2.0.4.171017
遇到异常时可rollback补丁:
9. rollback patch
[root@beihangedw08 ~]# /u01/app/11.2.0/grid/OPatch/opatch auto /u01/app/patch/26635745/ -rollback -ocmrf /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp
Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /u01/app/patch -patchn 26635745 -rollback -ocmrf /u01/app/patch/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params
This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2017-11-07_11-42-59.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2017-11-07_11-42-59.report.log
2017-11-07 11:42:59: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Stopping RAC /u01/app/oracle/product/11.2.0/db_1 ...
Stopped RAC /u01/app/oracle/product/11.2.0/db_1 successfully
The patch 26392168 does not exist in /u01/app/oracle/product/11.2.0/db_1
The patch 26609929 does not exist in /u01/app/oracle/product/11.2.0/db_1
Stopping CRS...
Stopped CRS successfully
patch 26392168 rollback successful for home /u01/app/11.2.0/grid
patch 26609929 rollback successful for home /u01/app/11.2.0/grid
patch 22502505 rollback successful for home /u01/app/11.2.0/grid
Starting CRS...
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.
Starting RAC /u01/app/oracle/product/11.2.0/db_1 ...
Started RAC /u01/app/oracle/product/11.2.0/db_1 successfully
opatch auto succeeded.
遇到问题:
OUI-67073:UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed
查询为有相关oracle进程存在,关闭RAC当前实例与监听后,ps -ef |grep ora查询ora还有没有相关进程存在,如果存在kill -9杀掉进程.
[oracle@beihangedw05 ~]$ srvctl status database -d odd
Instance odd1 is running on node beihangedw05
Instance odd2 is running on node beihangedw06
Instance odd3 is running on node beihangedw07
Instance odd4 is running on node beihangedw08
odd为4个节点的RAC
1.对ODD集群各节点grid与oracle家目录备份
备份目录
[root@beihangedw05 backup]# pwd
/u01/app/backup
节点1:
[root@beihangedw05 backup]#
[root@beihangedw05 backup]# nohup tar -cvf db_1.tar /u01/app/oracle/product/11.2.0/db_1/ &
[root@beihangedw05 backup]# nohup tar -cvf 11.2.0.tar /u01/app/11.2.0/ &
其它剩余3个节点,进行如上备份.
2.更新OPatch utility
grid用户下
grid与oracle用户下,备份先前opatch目录.
更新前
[grid@beihangedw05 OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.4
OPatch succeeded.
其它剩余3个节点检查更新
更新后
[grid@beihangedw05 OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.17
OPatch succeeded.
oracle用户下
更新前
[oracle@beihangedw05 OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.4
OPatch succeeded
更新后
[oracle@beihangedw05 OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.17
OPatch succeeded.
其它剩余3个节点检查更新
3.OCM Configuration
节点1:
[grid@beihangedw05 bin]$ pwd
/u01/app/11.2.0/grid/OPatch/ocm/bin
[grid@beihangedw05 bin]$ ll -athr
total 20K
-rwxr-x--- 1 grid oinstall 8.9K Nov 27 2009 emocmrsp
drwxr-x--- 5 grid oinstall 4.0K Oct 11 02:16 ..
drwxr-x--- 2 grid oinstall 4.0K Oct 11 02:16 .
[grid@beihangedw05 bin]$
[grid@beihangedw05 bin]$ ./emocmrsp
OCM Installation Response Generator 10.3.7.0.0 - Production
Copyright (c) 2005, 2012, Oracle and/or its affiliates. All rights reserved.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y
The OCM configuration response file (ocm.rsp) was successfully created.
[grid@beihangedw05 bin]$ ll -athr
total 24K
-rwxr-x--- 1 grid oinstall 8.9K Nov 27 2009 emocmrsp
drwxr-x--- 5 grid oinstall 4.0K Oct 11 02:16 ..
drwxr-x--- 2 grid oinstall 4.0K Nov 24 21:28 .
-rw-r--r-- 1 grid oinstall 621 Nov 24 21:28 ocm.rsp
[grid@beihangedw05 bin]$
[grid@beihangedw05 bin]$ chmod 775 ocm.rsp
[grid@beihangedw05 bin]$ ll -athr ocm.rsp
-rwxrwxr-x 1 grid oinstall 621 Nov 24 21:28 ocm.rsp
剩余3个节点进行如上操作,产生ocm.rsp,且进行权限755赋值.
4. Validation of Oracle Inventory
grid用户下:
[grid@beihangedw05 OPatch]$ ./opatch lsinventory -detail -oh /u01/app/11.2.0/grid
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: beihangedw05
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Grid Infrastructure 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
Installed Products (89):
Agent Required Support Files 10.2.0.4.5
Assistant Common Files 11.2.0.4.0
Automatic Storage Management Assistant 11.2.0.4.0
Bali Share 1.1.18.0.0
Buildtools Common Files 11.2.0.4.0
Character Set Migration Utility 11.2.0.4.0
Cluster Ready Services Files 11.2.0.4.0
Cluster Verification Utility Common Files 11.2.0.4.0
Cluster Verification Utility Files 11.2.0.4.0
Database SQL Scripts 11.2.0.4.0
Deinstallation Tool 11.2.0.4.0
Enterprise Manager Common Core Files 10.2.0.4.5
Enterprise Manager Common Files 10.2.0.4.5
Enterprise Manager plugin Common Files 11.2.0.4.0
Expat libraries 2.0.1.0.1
HAS Common Files 11.2.0.4.0
HAS Files for DB 11.2.0.4.0
Installation Common Files 11.2.0.4.0
Installation Plugin Files 11.2.0.4.0
Installer SDK Component 11.2.0.4.0
Java Development Kit 1.5.0.51.10
LDAP Required Support Files 11.2.0.4.0
OLAP SQL Scripts 11.2.0.4.0
Oracle Advanced Security 11.2.0.4.0
Oracle Clusterware RDBMS Files 11.2.0.4.0
Oracle Configuration Manager Deconfiguration 10.3.1.0.0
Oracle Containers for Java 11.2.0.4.0
Oracle Core Required Support Files 11.2.0.4.0
Oracle Database 11g 11.2.0.4.0
Oracle Database 11g Multimedia Files 11.2.0.4.0
Oracle Database Deconfiguration 11.2.0.4.0
Oracle Database User Interface 2.2.13.0.0
Oracle Database Utilities 11.2.0.4.0
Oracle DBCA Deconfiguration 11.2.0.4.0
Oracle Extended Windowing Toolkit 3.4.47.0.0
Oracle Globalization Support 11.2.0.4.0
Oracle Globalization Support 11.2.0.4.0
Oracle Grid Infrastructure 11g 11.2.0.4.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.4.0
Oracle Java Client 11.2.0.4.0
Oracle JDBC/OCI Instant Client 11.2.0.4.0
Oracle JDBC/THIN Interfaces 11.2.0.4.0
Oracle JFC Extended Windowing Toolkit 4.2.36.0.0
Oracle JVM 11.2.0.4.0
Oracle LDAP administration 11.2.0.4.0
Oracle Locale Builder 11.2.0.4.0
Oracle Multimedia 11.2.0.4.0
Oracle Multimedia Client Option 11.2.0.4.0
Oracle Multimedia Java Advanced Imaging 11.2.0.4.0
Oracle Multimedia Locator 11.2.0.4.0
Oracle Multimedia Locator RDBMS Files 11.2.0.4.0
Oracle Net 11.2.0.4.0
Oracle Net Listener 11.2.0.4.0
Oracle Net Required Support Files 11.2.0.4.0
Oracle Netca Client 11.2.0.4.0
Oracle Notification Service 11.2.0.3.0
Oracle Notification Service (eONS) 11.2.0.4.0
Oracle One-Off Patch Installer 11.2.0.3.4
Oracle Quality of Service Management (Client) 11.2.0.4.0
Oracle Quality of Service Management (Server) 11.2.0.4.0
Oracle RAC Deconfiguration 11.2.0.4.0
Oracle RAC Required Support Files-HAS 11.2.0.4.0
Oracle Recovery Manager 11.2.0.4.0
Oracle Security Developer Tools 11.2.0.4.0
Oracle Text Required Support Files 11.2.0.4.0
Oracle Universal Installer 11.2.0.4.0
Oracle USM Deconfiguration 11.2.0.4.0
Oracle Wallet Manager 11.2.0.4.0
Parser Generator Required Support Files 11.2.0.4.0
Perl Interpreter 5.10.0.0.2
Perl Modules 5.10.0.0.1
PL/SQL 11.2.0.4.0
PL/SQL Embedded Gateway 11.2.0.4.0
Platform Required Support Files 11.2.0.4.0
Precompiler Required Support Files 11.2.0.4.0
RDBMS Required Support Files 11.2.0.4.0
RDBMS Required Support Files for Instant Client 11.2.0.4.0
RDBMS Required Support Files Runtime 11.2.0.4.0
Required Support Files 11.2.0.4.0
Secure Socket Layer 11.2.0.4.0
SQL*Plus 11.2.0.4.0
SQL*Plus Files for Instant Client 11.2.0.4.0
SQL*Plus Required Support Files 11.2.0.4.0
SSL Required Support Files for InstantClient 11.2.0.4.0
Universal Storage Manager Files 11.2.0.4.0
XDK Required Support Files 11.2.0.4.0
XML Parser for Java 11.2.0.4.0
There are 89 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.
其它剩余3个点,如上操作.
oracle用户下
[oracle@beihangedw05 OPatch]$ ./opatch lsinventory -detail -oh /u01/app/oracle/product/11.2.0/db_1
Oracle Interim Patch Installer version 11.2.0.3.17
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version : 11.2.0.3.17
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2017-11-25_00-38-42AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-11-25_00-38-42AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: beihangedw05
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
Installed Products (136):
Agent Required Support Files 10.2.0.4.5
Assistant Common Files 11.2.0.4.0
Bali Share 1.1.18.0.0
Buildtools Common Files 11.2.0.4.0
Character Set Migration Utility 11.2.0.4.0
Cluster Verification Utility Common Files 11.2.0.4.0
Database Configuration and Upgrade Assistants 11.2.0.4.0
Database SQL Scripts 11.2.0.4.0
Database Workspace Manager 11.2.0.4.0
Deinstallation Tool 11.2.0.4.0
Enterprise Edition Options 11.2.0.4.0
Enterprise Manager Agent 10.2.0.4.5
Enterprise Manager Agent Core Files 10.2.0.4.5
Enterprise Manager Common Core Files 10.2.0.4.5
Enterprise Manager Common Files 10.2.0.4.5
Enterprise Manager Database Plugin -- Agent Support 11.2.0.4.0
Enterprise Manager Database Plugin -- Repository Support 11.2.0.4.0
Enterprise Manager Grid Control Core Files 10.2.0.4.5
Enterprise Manager plugin Common Files 11.2.0.4.0
Enterprise Manager Repository Core Files 10.2.0.4.5
Exadata Storage Server 11.2.0.1.0
Expat libraries 2.0.1.0.1
Generic Connectivity Common Files 11.2.0.4.0
HAS Common Files 11.2.0.4.0
HAS Files for DB 11.2.0.4.0
Installation Common Files 11.2.0.4.0
Installation Plugin Files 11.2.0.4.0
Installer SDK Component 11.2.0.4.0
JAccelerator (COMPANION) 11.2.0.4.0
Java Development Kit 1.5.0.51.10
LDAP Required Support Files 11.2.0.4.0
OLAP SQL Scripts 11.2.0.4.0
Oracle 11g Warehouse Builder Required Files 11.2.0.4.0
Oracle Advanced Security 11.2.0.4.0
Oracle Application Express 11.2.0.4.0
Oracle Call Interface (OCI) 11.2.0.4.0
Oracle Clusterware RDBMS Files 11.2.0.4.0
Oracle Code Editor 1.2.1.0.0I
Oracle Configuration Manager 10.3.8.1.0
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.4.0
Oracle Core Required Support Files 11.2.0.4.0
Oracle Data Mining RDBMS Files 11.2.0.4.0
Oracle Database 11g 11.2.0.4.0
Oracle Database 11g 11.2.0.4.0
Oracle Database 11g Multimedia Files 11.2.0.4.0
Oracle Database Deconfiguration 11.2.0.4.0
Oracle Database Gateway for ODBC 11.2.0.4.0
Oracle Database User Interface 2.2.13.0.0
Oracle Database Utilities 11.2.0.4.0
Oracle Database Vault J2EE Application 11.2.0.4.0
Oracle Database Vault option 11.2.0.4.0
Oracle DBCA Deconfiguration 11.2.0.4.0
Oracle Display Fonts 9.0.2.0.0
Oracle Enterprise Manager Console DB 11.2.0.4.0
Oracle Extended Windowing Toolkit 3.4.47.0.0
Oracle Globalization Support 11.2.0.4.0
Oracle Globalization Support 11.2.0.4.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.4.0
Oracle Java Client 11.2.0.4.0
Oracle JDBC Server Support Package 11.2.0.4.0
Oracle JDBC/OCI Instant Client 11.2.0.4.0
Oracle JDBC/THIN Interfaces 11.2.0.4.0
Oracle JFC Extended Windowing Toolkit 4.2.36.0.0
Oracle JVM 11.2.0.4.0
Oracle Label Security 11.2.0.4.0
Oracle LDAP administration 11.2.0.4.0
Oracle Locale Builder 11.2.0.4.0
Oracle Message Gateway Common Files 11.2.0.4.0
Oracle Multimedia 11.2.0.4.0
Oracle Multimedia Annotator 11.2.0.4.0
Oracle Multimedia Client Option 11.2.0.4.0
Oracle Multimedia Java Advanced Imaging 11.2.0.4.0
Oracle Multimedia Locator 11.2.0.4.0
Oracle Multimedia Locator RDBMS Files 11.2.0.4.0
Oracle Net 11.2.0.4.0
Oracle Net Listener 11.2.0.4.0
Oracle Net Required Support Files 11.2.0.4.0
Oracle Net Services 11.2.0.4.0
Oracle Netca Client 11.2.0.4.0
Oracle Notification Service 11.2.0.3.0
Oracle Notification Service (eONS) 11.2.0.4.0
Oracle ODBC Driver 11.2.0.4.0
Oracle ODBC Driverfor Instant Client 11.2.0.4.0
Oracle OLAP 11.2.0.4.0
Oracle OLAP API 11.2.0.4.0
Oracle OLAP RDBMS Files 11.2.0.4.0
Oracle One-Off Patch Installer 11.2.0.3.4
Oracle Partitioning 11.2.0.4.0
Oracle Programmer 11.2.0.4.0
Oracle Quality of Service Management (Client) 11.2.0.4.0
Oracle RAC Deconfiguration 11.2.0.4.0
Oracle RAC Required Support Files-HAS 11.2.0.4.0
Oracle Real Application Testing 11.2.0.4.0
Oracle Recovery Manager 11.2.0.4.0
Oracle Security Developer Tools 11.2.0.4.0
Oracle Spatial 11.2.0.4.0
Oracle SQL Developer 11.2.0.4.0
Oracle Starter Database 11.2.0.4.0
Oracle Text 11.2.0.4.0
Oracle Text Required Support Files 11.2.0.4.0
Oracle UIX 2.2.24.6.0
Oracle Universal Connection Pool 11.2.0.4.0
Oracle Universal Installer 11.2.0.4.0
Oracle USM Deconfiguration 11.2.0.4.0
Oracle Wallet Manager 11.2.0.4.0
Oracle XML Development Kit 11.2.0.4.0
Oracle XML Query 11.2.0.4.0
Parser Generator Required Support Files 11.2.0.4.0
Perl Interpreter 5.10.0.0.2
Perl Modules 5.10.0.0.1
PL/SQL 11.2.0.4.0
PL/SQL Embedded Gateway 11.2.0.4.0
Platform Required Support Files 11.2.0.4.0
Precompiler Common Files 11.2.0.4.0
Precompiler Required Support Files 11.2.0.4.0
Provisioning Advisor Framework 10.2.0.4.3
RDBMS Required Support Files 11.2.0.4.0
RDBMS Required Support Files for Instant Client 11.2.0.4.0
RDBMS Required Support Files Runtime 11.2.0.4.0
regexp 2.1.9.0.0
Required Support Files 11.2.0.4.0
Sample Schema Data 11.2.0.4.0
Secure Socket Layer 11.2.0.4.0
SQL*Plus 11.2.0.4.0
SQL*Plus Files for Instant Client 11.2.0.4.0
SQL*Plus Required Support Files 11.2.0.4.0
SQLJ Runtime 11.2.0.4.0
SSL Required Support Files for InstantClient 11.2.0.4.0
XDK Required Support Files 11.2.0.4.0
XML Parser for Java 11.2.0.4.0
XML Parser for Oracle JVM 11.2.0.4.0
There are 136 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.
5. unzip patch/
[grid@beihangedw05 ~]$ cd /u01/app/patch/
[grid@beihangedw05 patch]$ ll
总用量 757020
-rwxrw-rw- 1 grid oinstall 775179252 11月 3 10:22 p26635745_112040_Linux-x86-64.zip
[grid@beihangedw05 patch]$
[grid@beihangedw05 patch]$unzip p26635745_112040_Linux-x86-64.zip
[grid@beihangedw05 patch]$chmod -R 755 26635745
[grid@beihangedw05 patch]$chmod 775 26635745
6.stop dbconsole
$ <ORACLE_HOME>/bin/emctl stop dbconsole
7. opatch
节点1:
关闭打补丁节点的实例与监听
[oracle@beihangedw08 ~]$ srvctl stop instance -d odd -n beihangedw08
[oracle@beihangedw08 ~]$ srvctl stop listener -n beihangedw08
ps -ef |grep ora
kill oracle进程
[root@beihangedw06 ~]# ps -ef |grep ora
grid 61283 1 0 Aug18 ? 00:58:43 /u01/app/11.2.0/grid/jdk/bin/java -server -Xcheck:jni -Xms128M -Xmx384M -Djava.awt.headless=true -Ddisable.checkForUpdate=true -Dstdstream.filesize=100 -Dstdstream.filenumber=10 -DTRACING.ENABLED=false -Doracle.wlm.dbwlmlogger.logging.level=INFO -Dport.rmi=23792 -jar /u01/app/11.2.0/grid/oc4j/j2ee/home/oc4j.jar -config /u01/app/11.2.0/grid/oc4j/j2ee/home/OC4J_DBWLM_config/server.xml -out /u01/app/11.2.0/grid/oc4j/j2ee/home/log/oc4j.out -err /u01/app/11.2.0/grid/oc4j/j2ee/home/log/oc4j.err
root 63184 55377 0 11:05 pts/3 00:00:00 grep ora
root 82129 1 0 May15 ? 05:44:00 /u01/app/11.2.0/grid/jdk/jre/bin/java -Xms64m -Xmx256m -classpath /u01/app/11.2.0/grid/tfa/beihangedw06/tfa_home/jar/RATFA.jar:/u01/app/11.2.0/grid/tfa/beihangedw06/tfa_home/jar/je-4.0.103.jar:/u01/app/11.2.0/grid/tfa/beihangedw06/tfa_home/jar/ojdbc6.jar oracle.rat.tfa.TFAMain /u01/app/11.2.0/grid/tfa/beihangedw06/tfa_home
grid 85971 1 0 May15 ? 08:40:11 /u01/app/11.2.0/grid/bin/oraagent.bin
root 86625 1 0 May15 ? 10:47:35 /u01/app/11.2.0/grid/bin/orarootagent.bin
grid 87585 1 0 May15 ? 00:00:00 oracle+ASM2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 87748 1 0 May15 ? 00:00:29 oracle+ASM2_ocr (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 87752 1 0 May15 ? 00:12:19 oracle+ASM2_asmb_+asm2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 87881 1 0 May15 ? 05:39:27 /u01/app/11.2.0/grid/bin/oraagent.bin
root 87885 1 0 May15 ? 15:20:55 /u01/app/11.2.0/grid/bin/orarootagent.bin
grid 87915 1 0 May15 ? 00:00:36 oracle+ASM2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
patrol 140179 111008 0 Nov01 ? 00:05:02 /opt/bmc/Patrol3/Linux-2-6-x86-64-nptl/../oracle/alreader -p 60
patrol 176227 111008 0 Nov24 ? 00:00:00 /u01/app/oracle/product/11.2.0/db_1/bin/sqlplus -s
grid 178656 178654 0 Nov24 ? 00:00:00 oracle+ASM2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 180670 180663 0 Nov24 ? 00:00:00 oracle+ASM2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
[root@beihangedw06 ~]#
[root@beihangedw06 ~]#
[root@beihangedw06 ~]# kill -9 61283
[root@beihangedw06 ~]# kill -9 82129
[root@beihangedw06 ~]# kill -9 140179
[root@beihangedw06 ~]# kill -9 176227
[root@beihangedw06 ~]#
[root@beihangedw06 ~]# ps -ef |grep ora
root 63460 55377 0 11:05 pts/3 00:00:00 grep ora
grid 85971 1 0 May15 ? 08:40:12 /u01/app/11.2.0/grid/bin/oraagent.bin
root 86625 1 0 May15 ? 10:47:35 /u01/app/11.2.0/grid/bin/orarootagent.bin
grid 87585 1 0 May15 ? 00:00:00 oracle+ASM2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 87748 1 0 May15 ? 00:00:29 oracle+ASM2_ocr (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 87752 1 0 May15 ? 00:12:19 oracle+ASM2_asmb_+asm2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 87881 1 0 May15 ? 05:39:27 /u01/app/11.2.0/grid/bin/oraagent.bin
root 87885 1 0 May15 ? 15:20:55 /u01/app/11.2.0/grid/bin/orarootagent.bin
grid 87915 1 0 May15 ? 00:00:36 oracle+ASM2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 178656 178654 0 Nov24 ? 00:00:00 oracle+ASM2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 180670 180663 0 Nov24 ? 00:00:00 oracle+ASM2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
[root@beihangedw06 ~]#
查询当前系统LANG变量为中文
[root@beihangedw05 ~]# echo $LANG
en_US.UTF-8
设置系统变量为英文
[root@newrac1 ~]# export LANG=en_US
oracle与grid用户环境变量先设置
$export LANG=en_US
[root@newrac1 ~]# export LANG=en_US
[root@beihangedw08 ~]# export PATH=$PATH:/u01/app/11.2.0/grid/OPatch
[root@beihangedw08 ~]# /u01/app/11.2.0/grid/OPatch/opatch auto /u01/app/patch/26635745 -ocmrf /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp
Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /u01/app/patch -patchn 26635745 -ocmrf /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params
This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2017-11-07_15-11-56.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2017-11-07_15-11-56.report.log
2017-11-07 15:11:56: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Stopping RAC /u01/app/oracle/product/11.2.0/db_1 ...
Stopped RAC /u01/app/oracle/product/11.2.0/db_1 successfully
patch /u01/app/patch/26635745/26392168 apply successful for home /u01/app/oracle/product/11.2.0/db_1
patch /u01/app/patch/26635745/26609929/custom/server/26609929 apply successful for home /u01/app/oracle/product/11.2.0/db_1
Stopping CRS...
Stopped CRS successfully
patch /u01/app/patch/26635745/26392168 apply successful for home /u01/app/11.2.0/grid
patch /u01/app/patch/26635745/26609929 apply successful for home /u01/app/11.2.0/grid
patch /u01/app/patch/26635745/22502505 apply successful for home /u01/app/11.2.0/grid
Starting CRS...
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.
Starting RAC /u01/app/oracle/product/11.2.0/db_1 ...
Started RAC /u01/app/oracle/product/11.2.0/db_1 successfully
opatch auto succeeded.
查询打补丁节点的实例与监听是否运行.
[oracle@beihangedw05 ~]$ srvctl status database -d odd
Instance odd1 is running on node beihangedw05
Instance odd2 is running on node beihangedw06
Instance odd3 is running on node beihangedw07
Instance odd4 is running on node beihangedw08
[oracle@beihangedw05 ~]$ srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): beihangedw06,beihangedw08,beihangedw05,beihangedw07
8. LOAD MODIFY SQL INTO DB.
The following steps load modified SQL files into the database. For an Oracle RAC environment, perform these steps on only one node.
[oracle@newrac1 ~]$ cd /u01/app/oracle/product/11.2.0/db_1/rdbms/admin/
[oracle@newrac1 admin]$ sqlplus / as sysdba
sql>@catbundle.sql psu apply
sql>@utlrp.sql;
SQL> select * from dba_registry_history;
ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS
------------------------------ ---------- ---------- --------------- ---------- --------------- ------------------------------
24-AUG-13 12.03.45.119862 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
16-MAY-17 03.36.59.213458 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
25-NOV-17 11.48.23.639345 AM APPLY SERVER 11.2.0.4 171017 PSU PSU 11.2.0.4.171017
遇到异常时可rollback补丁:
9. rollback patch
[root@beihangedw08 ~]# /u01/app/11.2.0/grid/OPatch/opatch auto /u01/app/patch/26635745/ -rollback -ocmrf /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp
Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /u01/app/patch -patchn 26635745 -rollback -ocmrf /u01/app/patch/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params
This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2017-11-07_11-42-59.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2017-11-07_11-42-59.report.log
2017-11-07 11:42:59: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Stopping RAC /u01/app/oracle/product/11.2.0/db_1 ...
Stopped RAC /u01/app/oracle/product/11.2.0/db_1 successfully
The patch 26392168 does not exist in /u01/app/oracle/product/11.2.0/db_1
The patch 26609929 does not exist in /u01/app/oracle/product/11.2.0/db_1
Stopping CRS...
Stopped CRS successfully
patch 26392168 rollback successful for home /u01/app/11.2.0/grid
patch 26609929 rollback successful for home /u01/app/11.2.0/grid
patch 22502505 rollback successful for home /u01/app/11.2.0/grid
Starting CRS...
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.
Starting RAC /u01/app/oracle/product/11.2.0/db_1 ...
Started RAC /u01/app/oracle/product/11.2.0/db_1 successfully
opatch auto succeeded.
遇到问题:
OUI-67073:UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed
查询为有相关oracle进程存在,关闭RAC当前实例与监听后,ps -ef |grep ora查询ora还有没有相关进程存在,如果存在kill -9杀掉进程.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28569596/viewspace-2150300/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28569596/viewspace-2150300/