Oracle 11GR2(11.0.2.4.0) Combo OJVM PSU+GI PSU (11.2.0.4.180116)打補丁
Patch 27282436 Combo OJVM PSU 11.2.0.4.180116 and GI PSU 11.2.0.4.180116
<一> Patch 27107360 GI PSU
Oracle Grid Infrastructure Patch Set Update 11.2.0.4.180116 (Includes Database PSU 11.2.0.4.180116)
1. RAC生產庫打補丁前,請做好DB RMAN全庫備份.
2. oracle與grid家目錄備份,可做恢復.
3. OPatch Utility Information
You must use the OPatch utility version 11.2.0.3.6 or later to apply this patch.
oracle與grid下OPatch Utility更新.
3.1. oracle用戶下OPatch Utility更新
節點1:
[oracle@newrac1 ~]$ cd /u01/app/oracle/product/11.2.0/db_1
[oracle@newrac1 db_1]$ mv OPatch/ OPatch_bak20180130
[oracle@newrac1 patch]$ unzip p6880880_112000_Linux-x86-64.zip -d $ORACLE_HOME
[oracle@newrac1 db_1]$ chmod 755 OPatch
[oracle@newrac1 db_1]$ cd OPatch
[oracle@newrac1 OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.17
OPatch succeeded.
節點2:
[oracle@newrac2 ~]$ cd /u01/app/oracle/product/11.2.0/db_1
[oracle@newrac2 db_1]$ mv OPatch/ OPatch_bak20180130
[oracle@newrac2 patch]$ unzip p6880880_112000_Linux-x86-64.zip -d /u01/app/oracle/product/11.2.0/db_1
[oracle@newrac2 db_1]$ chmod 755 OPatch
[oracle@newrac2 db_1]$ cd OPatch
[oracle@newrac2 OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.17
OPatch succeeded.
3.2. grid用戶下OPatch Utility更新
節點1:
[root@newrac1 ~]# cd /u01/app/11.2.0/grid
[root@newrac1 grid]# mv OPatch/ OPatch_bak20180130
[grid@newrac1 patch]$ unzip p6880880_112000_Linux-x86-64.zip
[grid@newrac1 patch]$ echo $ORACLE_HOME
/u01/app/11.2.0/grid
[root@newrac1 patch]# mv OPatch/ /u01/app/11.2.0/grid
[grid@newrac1 grid]$ chmod 755 OPatch
[grid@newrac1 grid]$ cd OPatch
[grid@newrac1 OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.17
OPatch succeeded.
節點2:
[root@newrac2 ~]# cd /u01/app/11.2.0/grid
[root@newrac2 grid]# mv OPatch/ OPatch_bak20180130
[grid@newrac2 patch]$ unzip p6880880_112000_Linux-x86-64.zip
[root@newrac2 patch]# mv OPatch/ /u01/app/11.2.0/grid
[grid@newrac2 grid]$ chmod 755 OPatch
[grid@newrac2 grid]$ cd OPatch
[grid@newrac2 OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.17
OPatch succeeded.
4. OCM Configuration
節點1:
[grid@newrac1 ~]$ cd /u01/app/11.2.0/grid/OPatch/ocm/bin/
[grid@newrac1 bin]$ ll -athr
總用量 20K
-rwxr-x--- 1 grid oinstall 8.9K 11月 27 2009 emocmrsp
[grid@newrac1 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@newrac1 bin]$
[grid@newrac1 bin]$ ll -athr
總用量 24K
-rwxr-x--- 1 grid oinstall 8.9K 11月 27 2009 emocmrsp
drwxr-x--- 5 grid oinstall 4.0K 10月 11 02:16 ..
drwxr-x--- 2 grid oinstall 4.0K 1月 31 11:29 .
-rw-r--r-- 1 grid oinstall 621 1月 31 11:29 ocm.rsp
[grid@newrac1 bin]$
[grid@newrac1 bin]$ chmod 775 ocm.rsp
[grid@newrac1 bin]$
[grid@newrac1 bin]$ ll -athr
總用量 24K
-rwxr-x--- 1 grid oinstall 8.9K 11月 27 2009 emocmrsp
drwxr-x--- 5 grid oinstall 4.0K 10月 11 02:16 ..
drwxr-x--- 2 grid oinstall 4.0K 1月 31 11:29 .
-rwxrwxr-x 1 grid oinstall 621 1月 31 11:29 ocm.rsp
節點2:
[grid@newrac2 ~]$ cd /u01/app/11.2.0/grid/OPatch/ocm/bin/
[grid@newrac2 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@newrac2 bin]$
[grid@newrac2 bin]$ ll -athr
總用量 24K
-rwxr-x--- 1 grid oinstall 8.9K 11月 27 2009 emocmrsp
drwxr-x--- 5 grid oinstall 4.0K 10月 11 02:16 ..
drwxr-x--- 2 grid oinstall 4.0K 1月 31 11:40 .
-rw-r--r-- 1 grid oinstall 621 1月 31 11:40 ocm.rsp
[grid@newrac2 bin]$
[grid@newrac2 bin]$ chmod 775 ocm.rsp
[grid@newrac2 bin]$ ll -athr
總用量 24K
-rwxr-x--- 1 grid oinstall 8.9K 11月 27 2009 emocmrsp
drwxr-x--- 5 grid oinstall 4.0K 10月 11 02:16 ..
drwxr-x--- 2 grid oinstall 4.0K 1月 31 11:40 .
-rwxrwxr-x 1 grid oinstall 621 1月 31 11:40 ocm.rsp
5. Validation of Oracle Inventory
節點1:
grid用戶下:
$ ./opatch lsinventory -detail -oh /u01/app/11.2.0/grid
[grid@newrac1 ~]$
[grid@newrac1 ~]$ cd /u01/app/11.2.0/grid/OPatch
[grid@newrac1 OPatch]$
[grid@newrac1 OPatch]$ ./opatch lsinventory -detail -oh /u01/app/11.2.0/grid
Oracle 中間補丁程序安裝程序版本 11.2.0.3.17
版權所有 (c) 2018, Oracle Corporation。保留所有權利。
Oracle Home : /u01/app/11.2.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/11.2.0/grid/oraInst.loc
OPatch version : 11.2.0.3.17
OUI version : 11.2.0.4.0
Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch3018-01-31_11-42-02上午_1.log
Lsinventory Output file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2018-01-31_11-42-02上午.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: newrac1
ARU platform id: 226
ARU platform description:: Linux x86-64
已安裝的頂級產品 (1):
Oracle Grid Infrastructure 11g 11.2.0.4.0
此 Oracle 主目錄中已安裝 1 個產品。
已安裝的產品 (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
此 Oracle 主目錄中已安裝 89 個產品。
此 Oracle 主目錄中未安裝任何中間補丁程序。
--------------------------------------------------------------------------------
OPatch succeeded.
oracle用戶下:
[oracle@newrac1 ~]$ cd /u01/app/oracle/product/11.2.0/db_1/OPatch
[oracle@newrac1 OPatch]$ ./opatch lsinventory -detail -oh /u01/app/oracle/product/11.2.0/db_1
Oracle 中間補丁程序安裝程序版本 11.2.0.3.17
版權所有 (c) 2018, Oracle Corporation。保留所有權利。
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/opatch3018-01-31_11-45-16上午_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2018-01-31_11-45-16上午.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: newrac1
ARU platform id: 226
ARU platform description:: Linux x86-64
已安裝的頂級產品 (1):
Oracle Database 11g 11.2.0.4.0
此 Oracle 主目錄中已安裝 1 個產品。
已安裝的產品 (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
此 Oracle 主目錄中已安裝 136 個產品。
此 Oracle 主目錄中未安裝任何中間補丁程序。
--------------------------------------------------------------------------------
OPatch succeeded.
節點2:
grid用戶
[grid@newrac2 ~]$ cd /u01/app/11.2.0/grid/OPatch
[grid@newrac2 OPatch]$ ./opatch lsinventory -detail -oh /u01/app/11.2.0/grid
oracle用戶
[oracle@newrac2 ~]$ cd /u01/app/oracle/product/11.2.0/db_1/OPatch
[oracle@newrac2 OPatch]$ ./opatch lsinventory -detail -oh /u01/app/oracle/product/11.2.0/db_1
6. Unzip the patch as grid home owner
節點1:
[grid@newrac1 patch]$ unzip p27282436_112040_Linux-x86-64.zip
節點2:
[grid@newrac2 patch]$ unzip p27282436_112040_Linux-x86-64.zip
7. emctl stop dbconsole
8. OPatch auto for GI
As root user, execute the following command on each node of the cluster:
節點1: root用戶下
8.1. 關閉打補丁節點的實例與監聽
[oracle@newrac1 ~]$ srvctl stop instance -d newrac -n newrac1
[oracle@newrac1 ~]$
[oracle@newrac1 ~]$ srvctl stop listener -n newrac1
ps -ef |grep ora
kill oracle進程
8.2. 查詢當前系統LANG變量為中文
# echo $LANG
en_US.UTF-8
設置系統變量為英文
# export LANG=en_US
oracle與grid用戶環境變量先設置
$ export LANG=en_US
8.3. OPatch auto
[root@newrac1 ~]# echo $LANG
zh_CN.UTF-8
[root@newrac1 ~]#
[root@newrac1 ~]# export LANG=en_US
把LANG=en_US 變量加入grid與oracle .bash_profile中
[root@newrac1 ~]# vim /home/grid/.bash_profile
[root@newrac1 ~]# vim /home/oracle/.bash_profile
[root@newrac1 ~]# /u01/app/11.2.0/grid/OPatch/opatch auto /u01/install/patch/27282436/27107360/ -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/patch21203.pl -patchdir /u01/install/patch/27282436 -patchn 27107360 -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/opatchauto2018-01-31_14-39-30.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/opatchauto2018-01-31_14-39-30.report.log
2018-01-31 14:39:30: 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/install/patch/27282436/27107360/26925576 apply successful for home /u01/app/oracle/product/11.2.0/db_1
patch /u01/install/patch/27282436/27107360/26609929/custom/server/26609929 apply successful for home /u01/app/oracle/product/11.2.0/db_1
Stopping CRS...
Stopped CRS successfully
patch /u01/install/patch/27282436/27107360/26925576 apply successful for home /u01/app/11.2.0/grid
patch /u01/install/patch/27282436/27107360/26609929 apply successful for home /u01/app/11.2.0/grid
patch /u01/install/patch/27282436/27107360/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.
節點2:
root@newrac2 ~]# export LANG=en_US
把LANG=en_US 變量加入grid與oracle .bash_profile中
[root@newrac2 ~]# vim /home/grid/.bash_profile
[root@newrac2 ~]# vim /home/oracle/.bash_profile
[root@newrac2 ~]# /u01/app/11.2.0/grid/OPatch/opatch auto /u01/install/patch/27282436/27107360 -ocmrf /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp
[root@newrac2 ~]# /u01/app/11.2.0/grid/OPatch/opatch auto /u01/install/patch/27282436/27107360 -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/patch21203.pl -patchdir /u01/install/patch/27282436 -patchn 27107360 -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/opatchauto2018-01-31_17-47-28.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/opatchauto2018-01-31_17-47-28.report.log
2018-01-31 17:47:28: 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/install/patch/27282436/27107360/26925576 apply successful for home /u01/app/oracle/product/11.2.0/db_1
patch /u01/install/patch/27282436/27107360/26609929/custom/server/26609929 apply successful for home /u01/app/oracle/product/11.2.0/db_1
Stopping CRS...
Stopped CRS successfully
patch /u01/install/patch/27282436/27107360/26925576 apply successful for home /u01/app/11.2.0/grid
patch /u01/install/patch/27282436/27107360/26609929 apply successful for home /u01/app/11.2.0/grid
patch /u01/install/patch/27282436/27107360/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.
9. Loading Modified SQL Files into the Database
perform these steps on only one node.
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> QUIT
dba_registry_history
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @utlrp.sql
Patch Deinstallation-
如遇異常可按照如下步驟回滾
As root user, execute the following command on each node of the cluster.
[root@newrac1 ~]# export LANG=en_US
[root@newrac1 ~]# /u01/app/11.2.0/grid/OPatch/opatch auto /u01/install/patch/27282436/27107360 -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/patch21203.pl -patchdir /u01/install/patch/27282436 -patchn 27107360 -rollback -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/opatchauto2018-01-31_15-39-27.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/opatchauto2018-01-31_15-39-27.report.log
2018-01-31 15:39:27: 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 26925576 rollback successful for home /u01/app/oracle/product/11.2.0/db_1
patch 26609929 rollback successful for home /u01/app/oracle/product/11.2.0/db_1
Stopping CRS...
Stopped CRS successfully
patch 26925576 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.
<二>Patch 26925532 OJVM補丁
Oracle JavaVM Component 11.2.0.4.180116 Database PSU
節點1:
[root@newrac1 27282436]# pwd
/u01/install/patch/27282436
[root@newrac1 27282436]#
[root@newrac1 27282436]# ll -athr
總用量 44K
drwxr-xr-x 4 grid oinstall 4.0K 1月 12 13:06 26925532
drwxr-xr-x 5 grid oinstall 4.0K 1月 12 14:03 27107360
-rw-r--r-- 1 grid oinstall 21 1月 12 14:09 README.txt
drwxr-xr-x 4 grid oinstall 4.0K 1月 12 14:09 .
-rw-rw-r-- 1 grid oinstall 21K 1月 23 15:15 README.html
drwxr-xr-x 3 grid oinstall 4.0K 1月 31 13:18 ..
[root@newrac1 27282436]# chown -R oracle:oinstall 26925532/
[root@newrac1 27282436]# ll -athr
總用量 44K
drwxr-xr-x 4 oracle oinstall 4.0K 1月 12 13:06 26925532
drwxr-xr-x 5 grid oinstall 4.0K 1月 12 14:03 27107360
節點2:
[root@newrac2 27282436]# pwd
/u01/install/patch/27282436
[root@newrac2 27282436]#
[root@newrac2 27282436]# ll -athr
總用量 44K
drwxr-xr-x 4 grid oinstall 4.0K 1月 12 13:06 26925532
drwxr-xr-x 5 grid oinstall 4.0K 1月 12 14:03 27107360
-rw-r--r-- 1 grid oinstall 21 1月 12 14:09 README.txt
drwxr-xr-x 4 grid oinstall 4.0K 1月 12 14:09 .
-rw-rw-r-- 1 grid oinstall 21K 1月 23 15:15 README.html
drwxr-xr-x 3 grid oinstall 4.0K 1月 31 13:18 ..
[root@newrac2 27282436]# chown -R oracle:oinstall 26925532/
[root@newrac2 27282436]# ll -athr
總用量 44K
drwxr-xr-x 4 oracle oinstall 4.0K 1月 12 13:06 26925532
drwxr-xr-x 5 grid oinstall 4.0K 1月 12 14:03 27107360
Prerequisites
1. Ensure that the following Oct2014 or greater to be already installed prior to installing this patch:
Database PSU 11.2.0.4.4 (Oct2014) (Patch number: 19121551)
Database SPU 11.2.0.4 (CPUOct2014)
Database patch for Exadata 11.2.0.4.12 (Oct2014)
2. You must use the OPatch utility version 11.2.0.3.5 or later to apply this patch.
3. Ensure that the $PATH definition has the following executables: make, ar, ld and nm
節點1:
[oracle@newrac1 ~]$ which make ar ld nm
/usr/bin/make
/usr/bin/ar
/usr/bin/ld
/usr/bin/nm
節點2:
[oracle@newrac2 ~]$ which make ar ld nm
/usr/bin/make
/usr/bin/ar
/usr/bin/ld
/usr/bin/nm
4. opatch lsinventory
5. verify conflict with this patch 26925532
每個節點上操作.
$ cd 26925532
$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
節點1:
[oracle@newrac1 ~]$ cd /u01/install/patch/27282436/26925532/
[oracle@newrac1 26925532]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.17
Copyright (c) 2018, Oracle Corporation. All rights reserved.
PREREQ session
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/opatch3018-01-31_23-10-02PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
節點2:
oracle@newrac2 ~]$ cd /u01/install/patch/27282436/26925532/
[oracle@newrac2 26925532]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.17
Copyright (c) 2018, Oracle Corporation. All rights reserved.
PREREQ session
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/pr
