首页 > 代码库 > 【简单的案例分享,停机10分钟】10204升级CRS&DB的PSU至102044
【简单的案例分享,停机10分钟】10204升级CRS&DB的PSU至102044
发现一个现象，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 : /etc/oraInst.loc OPatch version : 10.2.0.5.1 OUI version : 10.2.0.4.0 OUI location : /oracle/product/11.1.0/crs_1/oui Log file location : /oracle/product/11.1.0/crs_1/cfgtoollogs/opatch/opatch2014-11-10_11-19-41AM.log
Patch history file: /oracle/product/11.1.0/crs_1/cfgtoollogs/opatch/opatch_history.txt
Invoking utility "napply" Checking conflict among patches... Checking if Oracle Home has components required by patches... Checking conflicts against Oracle Home... OPatch continues with these patches: 9294403
Do you want to proceed? [y|n] y User Responded with: Y
Running prerequisite checks... 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
You selected -local option, hence OPatch will patch the local system only.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = ‘/oracle/product/11.1.0/crs_1‘)
Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files affected by the patch ‘NApply‘ for restore. This might take a while... … Verifying the update... Inventory check OK: Patch ID 9294403 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 9294403 are present in Oracle Home.
The local system has been patched and can be restarted.
UtilSession: N-Apply done.
OPatch succeeded. |
1.1.5.2 to RDBMS_HOME
[oracle@dwdb1 orainst]$ cd 9294403/ [oracle@dwdb1 9294403]$ opatch napply custom/server/ -local -oh $ORACLE_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/db_1 Central Inventory : /oracle/oraInventory from : /etc/oraInst.loc OPatch version : 10.2.0.5.1 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_11-31-32AM.log
Patch history file: /oracle/product/11.1.0/db_1/cfgtoollogs/opatch/opatch_history.txt
Invoking utility "napply" Checking conflict among patches... Checking if Oracle Home has components required by patches... Checking conflicts against Oracle Home... OPatch continues with these patches: 9294403
Do you want to proceed? [y|n]y Running prerequisite checks... 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
You selected -local option, hence OPatch will patch the local system only.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = ‘/oracle/product/11.1.0/db_1‘)
Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files affected by the patch ‘NApply‘ for restore. This might take a while...
Applying patch 9294403...
ApplySession applying interim patch ‘9294403‘ to OH ‘/oracle/product/11.1.0/db_1‘ … Verifying the update... Inventory check OK: Patch ID 9294403 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 9294403 are present in Oracle Home. Running make for target install Running make for target install
The local system has been patched and can be restarted.
UtilSession: N-Apply done.
OPatch succeeded. |
[oracle@dwdb1 9294403]$ which opatch /oracle/product/11.1.0/db_1/OPatch/opatch [oracle@dwdb1 9294403]$ opatch lsinventory 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.
Oracle Home : /oracle/product/11.1.0/db_1 Central Inventory : /oracle/oraInventory from : /etc/oraInst.loc OPatch version : 10.2.0.5.1 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_11-33-44AM.log
Patch history file: /oracle/product/11.1.0/db_1/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output file location : /oracle/product/11.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2014-11-10_11-33-44AM.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.
Interim patches (1) :
Patch 9294403 : applied on Mon Nov 10 11:33:01 CST 2014 Unique Patch ID: 12382183 Created on 19 Mar 2010, 18:59:24 hrs PST8PDT Bugs fixed: 9294403
Rac system comprising of multiple nodes Local node = dwdb1 Remote node = dwdb2
--------------------------------------------------------------------------------
OPatch succeeded. [oracle@dwdb1 9294403]$ opatch lsinventory -oh $ORA_CRS_HOME 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.
Oracle Home : /oracle/product/11.1.0/crs_1 Central Inventory : /oracle/oraInventory from : /etc/oraInst.loc OPatch version : 10.2.0.5.1 OUI version : 10.2.0.4.0 OUI location : /oracle/product/11.1.0/crs_1/oui Log file location : /oracle/product/11.1.0/crs_1/cfgtoollogs/opatch/opatch2014-11-10_11-34-03AM.log
Patch history file: /oracle/product/11.1.0/crs_1/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output file location : /oracle/product/11.1.0/crs_1/cfgtoollogs/opatch/lsinv/lsinventory2014-11-10_11-34-03AM.txt
-------------------------------------------------------------------------------- Installed Top-level Products (2):
Oracle Clusterware 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.
Interim patches (1) :
Patch 9294403 : applied on Mon Nov 10 11:21:48 CST 2014 Unique Patch ID: 12382183 Created on 19 Mar 2010, 18:59:31 hrs PST8PDT Bugs fixed: 9294403
Rac system comprising of multiple nodes Local node = dwdb1 Remote node = dwdb2
--------------------------------------------------------------------------------
OPatch succeeded. |
1.1.6 Configure the HOME
1.1.6.1 TO CRS_HOME
[oracle@dwdb1 9294403]$ custom/scripts/postpatch.sh -crshome $ORA_CRS_HOME Oracle CRS_ENV_FILE is not specified but using /oracle/product/11.1.0/crs_1/install/params.crs for parameter definitions Oracle CRS_ENV_FILE is not specified … |
1.1.6.2 TO RDBMS_HOME
[oracle@dwdb1 9294403]$ custom/server/9294403/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME Reading /oracle/product/11.1.0/db_1/install/params.ora.. Reading /oracle/product/11.1.0/db_1/install/params.ora.. Parsing file /oracle/product/11.1.0/db_1/bin/racgwrap Parsing file /oracle/product/11.1.0/db_1/css/admin/init.cssd … |
1.1.7 restored security on the CRS Home <root>
11:40
[root@dwdb1 9294403]# custom/scripts/postrootpatch.sh -crshome $ORA_CRS_HOME Checking to see if Oracle CRS stack is already up... Checking to see if Oracle CRS stack is already starting WARNING: directory ‘/oracle/product/11.1.0‘ is not owned by root WARNING: directory ‘/oracle/product‘ is not owned by root WARNING: directory ‘/oracle‘ is not owned by root Startup will be queued to init within 30 seconds. Waiting for the Oracle CRSD and EVMD to start Oracle CRS stack installed and running under init(1M) |
1.1.8 verify pathing
1.1.8.1 TO CRS_HOME
[oracle@dwdb1 9294403]$ opatch lsinventory -detail -oh $ORA_CRS_HOME 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.
Oracle Home : /oracle/product/11.1.0/crs_1 Central Inventory : /oracle/oraInventory from : /etc/oraInst.loc OPatch version : 10.2.0.5.1 OUI version : 10.2.0.4.0 OUI location : /oracle/product/11.1.0/crs_1/oui Log file location : /oracle/product/11.1.0/crs_1/cfgtoollogs/opatch/opatch2014-11-10_11-42-01AM.log
Patch history file: /oracle/product/11.1.0/crs_1/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output file location : /oracle/product/11.1.0/crs_1/cfgtoollogs/opatch/lsinv/lsinventory2014-11-10_11-42-01AM.txt
-------------------------------------------------------------------------------- Installed Top-level Products (2):
Oracle Clusterware 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 (57):
Agent Required Support Files 10.2.0.1.0 Agent Required Support Files Patch 10.2.0.4.0 Bali Share 1.1.18.0.0 Buildtools Common Files 10.2.0.1.0 Cluster Ready Services Files 10.2.0.1.0 Cluster Ready Services Files Patch 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 Manager Minimal Integration 10.2.0.1.0 HAS Common Files 10.2.0.1.0 HAS Common Files Patch 10.2.0.4.0 Installer SDK Component 10.2.0.4.0 Java Runtime Environment 1.4.2.14.0 LDAP Required Support Files 10.2.0.1.0 LDAP Required Support Files Patch 10.2.0.4.0 Oracle Clusterware 10.2.0.1.0 Oracle Clusterware 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 Core Required Support Files 10.2.0.1.0 Oracle Core Required Support Files Patch 10.2.0.4.0 Oracle Database 10g Release 2 Patch Set 3 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 Ice Browser 5.2.3.6.0 Oracle JFC Extended Windowing Toolkit 4.2.33.0.0 Oracle Locale Builder 10.2.0.1.0 Oracle Net Required Support Files 10.2.0.1.0 Oracle Net Required Support Files Patch 10.2.0.4.0 Oracle Notification Service 10.1.0.3.0 Oracle Notification Service Patch 10.2.0.4.0 Oracle One-Off Patch Installer 10.2.0.4.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 Required Support Files 32 bit 10.2.0.0.0 Oracle Required Support Files 32 bit Patch 10.2.0.4.0 Oracle Universal Installer 10.2.0.4.0 Parser Generator Required Support Files 10.2.0.1.0 Perl Interpreter 5.8.3.0.2 Platform Required Support Files 10.2.0.1.0 Platform Required Support Files 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 Required Support Files 10.2.0.1.0 SQL*Plus Required Support Files 10.2.0.1.0 SQL*Plus Required Support Files 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 XDK Required Support Files 10.2.0.1.0 XDK Required Support Files Patch 10.2.0.4.0 There are 57 products installed in this Oracle Home.
Interim patches (1) :
Patch 9294403 : applied on Mon Nov 10 11:21:48 CST 2014 Unique Patch ID: 12382183 Created on 19 Mar 2010, 18:59:31 hrs PST8PDT Bugs fixed: 9294403 Files Touched: cemutlo --> ORACLE_HOME/bin/cemutlo cemutlo.bin --> ORACLE_HOME/bin/cemutlo.bin cemutls --> ORACLE_HOME/bin/cemutls cemutls.bin --> ORACLE_HOME/bin/cemutls.bin clscfg --> ORACLE_HOME/bin/clscfg clscfg.bin --> ORACLE_HOME/bin/clscfg.bin clsfmt --> ORACLE_HOME/bin/clsfmt clsfmt.bin --> ORACLE_HOME/bin/clsfmt.bin clsid --> ORACLE_HOME/bin/clsid clsid.bin --> ORACLE_HOME/bin/clsid.bin cluutil --> ORACLE_HOME/bin/cluutil cluvfy --> ORACLE_HOME/bin/cluvfy crs_getperm --> ORACLE_HOME/bin/crs_getperm crs_getperm.bin --> ORACLE_HOME/bin/crs_getperm.bin crs_profile --> ORACLE_HOME/bin/crs_profile crs_profile.bin --> ORACLE_HOME/bin/crs_profile.bin crs_register --> ORACLE_HOME/bin/crs_register crs_register.bin --> ORACLE_HOME/bin/crs_register.bin crs_relocate --> ORACLE_HOME/bin/crs_relocate crs_relocate.bin --> ORACLE_HOME/bin/crs_relocate.bin crs_setperm --> ORACLE_HOME/bin/crs_setperm crs_setperm.bin --> ORACLE_HOME/bin/crs_setperm.bin crs_start --> ORACLE_HOME/bin/crs_start crs_start.bin --> ORACLE_HOME/bin/crs_start.bin crs_stat --> ORACLE_HOME/bin/crs_stat crs_stat.bin --> ORACLE_HOME/bin/crs_stat.bin crs_stop --> ORACLE_HOME/bin/crs_stop crs_stop.bin --> ORACLE_HOME/bin/crs_stop.bin crs_unregister --> ORACLE_HOME/bin/crs_unregister crs_unregister.bin --> ORACLE_HOME/bin/crs_unregister.bin crsctl --> ORACLE_HOME/bin/crsctl crsctl.bin --> ORACLE_HOME/bin/crsctl.bin crsd --> ORACLE_HOME/bin/crsd crsd.bin --> ORACLE_HOME/bin/crsd.bin crstmpl.scr --> ORACLE_HOME/bin/crstmpl.scr diagcollection.pl --> ORACLE_HOME/bin/diagcollection.pl evmd --> ORACLE_HOME/bin/evmd evmd.bin --> ORACLE_HOME/bin/evmd.bin evminfo --> ORACLE_HOME/bin/evminfo evminfo.bin --> ORACLE_HOME/bin/evminfo.bin evmlogger --> ORACLE_HOME/bin/evmlogger evmlogger.bin --> ORACLE_HOME/bin/evmlogger.bin evmmkbin --> ORACLE_HOME/bin/evmmkbin evmmkbin.bin --> ORACLE_HOME/bin/evmmkbin.bin evmmklib --> ORACLE_HOME/bin/evmmklib evmmklib.bin --> ORACLE_HOME/bin/evmmklib.bin evmpost --> ORACLE_HOME/bin/evmpost evmpost.bin --> ORACLE_HOME/bin/evmpost.bin evmshow --> ORACLE_HOME/bin/evmshow evmshow.bin --> ORACLE_HOME/bin/evmshow.bin evmsort --> ORACLE_HOME/bin/evmsort evmsort.bin --> ORACLE_HOME/bin/evmsort.bin evmwatch --> ORACLE_HOME/bin/evmwatch evmwatch.bin --> ORACLE_HOME/bin/evmwatch.bin gsd --> ORACLE_HOME/bin/gsd gsd.sh --> ORACLE_HOME/bin/gsd.sh gsdctl --> ORACLE_HOME/bin/gsdctl lsdb --> ORACLE_HOME/bin/lsdb lsnodes --> ORACLE_HOME/bin/lsnodes lsnodes.bin --> ORACLE_HOME/bin/lsnodes.bin oclsomon --> ORACLE_HOME/bin/oclsomon oclsomon.bin --> ORACLE_HOME/bin/oclsomon.bin oclsvmon --> ORACLE_HOME/bin/oclsvmon oclsvmon.bin --> ORACLE_HOME/bin/oclsvmon.bin ocrcheck --> ORACLE_HOME/bin/ocrcheck ocrcheck.bin --> ORACLE_HOME/bin/ocrcheck.bin ocrconfig --> ORACLE_HOME/bin/ocrconfig ocrconfig.bin --> ORACLE_HOME/bin/ocrconfig.bin ocrdump --> ORACLE_HOME/bin/ocrdump ocrdump.bin --> ORACLE_HOME/bin/ocrdump.bin ocrpatch --> ORACLE_HOME/bin/ocrpatch ocssd --> ORACLE_HOME/bin/ocssd ocssd.bin --> ORACLE_HOME/bin/ocssd.bin oifcfg --> ORACLE_HOME/bin/oifcfg oifcfg.bin --> ORACLE_HOME/bin/oifcfg.bin olsnodes --> ORACLE_HOME/bin/olsnodes olsnodes.bin --> ORACLE_HOME/bin/olsnodes.bin oprocd --> ORACLE_HOME/bin/oprocd oprocd.bin --> ORACLE_HOME/bin/oprocd.bin racgeut --> ORACLE_HOME/bin/racgeut racgevtf --> ORACLE_HOME/bin/racgevtf racgmain --> ORACLE_HOME/bin/racgmain racgons --> ORACLE_HOME/bin/racgons racgons.bin --> ORACLE_HOME/bin/racgons.bin racgvip --> ORACLE_HOME/bin/racgvip racgwrap --> ORACLE_HOME/bin/racgwrap sclsspawn --> ORACLE_HOME/bin/sclsspawn srvctl --> ORACLE_HOME/bin/srvctl usrvip --> ORACLE_HOME/bin/usrvip vipca --> ORACLE_HOME/bin/vipca init.crs --> ORACLE_HOME/crs/admin/init.crs init.crsd --> ORACLE_HOME/crs/admin/init.crsd inittab --> ORACLE_HOME/crs/admin/inittab clscrsx.h --> ORACLE_HOME/crs/demo/clscrsx.h crsapp.c --> ORACLE_HOME/crs/demo/crsapp.c demo_crs.mk --> ORACLE_HOME/crs/demo/demo_crs.mk env_has.mk --> ORACLE_HOME/crs/lib/env_has.mk env_has.mk --> ORACLE_HOME/crs/lib32/env_has.mk crsar.msb --> ORACLE_HOME/crs/mesg/crsar.msb crscs.msb --> ORACLE_HOME/crs/mesg/crscs.msb crsd.msb --> ORACLE_HOME/crs/mesg/crsd.msb crsdk.msb --> ORACLE_HOME/crs/mesg/crsdk.msb crse.msb --> ORACLE_HOME/crs/mesg/crse.msb crsel.msb --> ORACLE_HOME/crs/mesg/crsel.msb crsf.msb --> ORACLE_HOME/crs/mesg/crsf.msb crshu.msb --> ORACLE_HOME/crs/mesg/crshu.msb crsi.msb --> ORACLE_HOME/crs/mesg/crsi.msb crsiw.msb --> ORACLE_HOME/crs/mesg/crsiw.msb crsja.msb --> ORACLE_HOME/crs/mesg/crsja.msb crsko.msb --> ORACLE_HOME/crs/mesg/crsko.msb crsn.msb --> ORACLE_HOME/crs/mesg/crsn.msb crsnl.msb --> ORACLE_HOME/crs/mesg/crsnl.msb crspl.msb --> ORACLE_HOME/crs/mesg/crspl.msb crspt.msb --> ORACLE_HOME/crs/mesg/crspt.msb crsptb.msb --> ORACLE_HOME/crs/mesg/crsptb.msb crsro.msb --> ORACLE_HOME/crs/mesg/crsro.msb crsru.msb --> ORACLE_HOME/crs/mesg/crsru.msb crss.msb --> ORACLE_HOME/crs/mesg/crss.msb crssf.msb --> ORACLE_HOME/crs/mesg/crssf.msb crssk.msb --> ORACLE_HOME/crs/mesg/crssk.msb crsth.msb --> ORACLE_HOME/crs/mesg/crsth.msb crstr.msb --> ORACLE_HOME/crs/mesg/crstr.msb crsus.msb --> ORACLE_HOME/crs/mesg/crsus.msb crsus.msg --> ORACLE_HOME/crs/mesg/crsus.msg crszhs.msb --> ORACLE_HOME/crs/mesg/crszhs.msb crszht.msb --> ORACLE_HOME/crs/mesg/crszht.msb action_scr.scr --> ORACLE_HOME/crs/public/action_scr.scr TYPE_application.cap --> ORACLE_HOME/crs/template/TYPE_application.cap TYPE_generic.cap --> ORACLE_HOME/crs/template/TYPE_generic.cap application.tdf --> ORACLE_HOME/crs/template/application.tdf generic.tdf --> ORACLE_HOME/crs/template/generic.tdf init.cssd --> ORACLE_HOME/css/admin/init.cssd clssar.msb --> ORACLE_HOME/css/mesg/clssar.msb clsscs.msb --> ORACLE_HOME/css/mesg/clsscs.msb clssd.msb --> ORACLE_HOME/css/mesg/clssd.msb clssdk.msb --> ORACLE_HOME/css/mesg/clssdk.msb clsse.msb --> ORACLE_HOME/css/mesg/clsse.msb clssel.msb --> ORACLE_HOME/css/mesg/clssel.msb clssf.msb --> ORACLE_HOME/css/mesg/clssf.msb clsshu.msb --> ORACLE_HOME/css/mesg/clsshu.msb clssi.msb --> ORACLE_HOME/css/mesg/clssi.msb clssiw.msb --> ORACLE_HOME/css/mesg/clssiw.msb clssja.msb --> ORACLE_HOME/css/mesg/clssja.msb clssko.msb --> ORACLE_HOME/css/mesg/clssko.msb clssn.msb --> ORACLE_HOME/css/mesg/clssn.msb clssnl.msb --> ORACLE_HOME/css/mesg/clssnl.msb clsspl.msb --> ORACLE_HOME/css/mesg/clsspl.msb clsspt.msb --> ORACLE_HOME/css/mesg/clsspt.msb clssptb.msb --> ORACLE_HOME/css/mesg/clssptb.msb clssro.msb --> ORACLE_HOME/css/mesg/clssro.msb clssru.msb --> ORACLE_HOME/css/mesg/clssru.msb clsss.msb --> ORACLE_HOME/css/mesg/clsss.msb clsssf.msb --> ORACLE_HOME/css/mesg/clsssf.msb clsssk.msb --> ORACLE_HOME/css/mesg/clsssk.msb clssth.msb --> ORACLE_HOME/css/mesg/clssth.msb clsstr.msb --> ORACLE_HOME/css/mesg/clsstr.msb clssus.msb --> ORACLE_HOME/css/mesg/clssus.msb clssus.msg --> ORACLE_HOME/css/mesg/clssus.msg clsszhs.msb --> ORACLE_HOME/css/mesg/clsszhs.msb clsszht.msb --> ORACLE_HOME/css/mesg/clsszht.msb cvu_config --> ORACLE_HOME/cv/admin/cvu_config admin.dtd --> ORACLE_HOME/cv/cvdata/admin.dtd admin.xml --> ORACLE_HOME/cv/cvdata/admin.xml constraints.dtd --> ORACLE_HOME/cv/cvdata/constraints.dtd constraints.xml --> ORACLE_HOME/cv/cvdata/constraints.xml exectask --> ORACLE_HOME/cv/remenv/exectask exectask.sh --> ORACLE_HOME/cv/remenv/exectask.sh cvuqdisk-1.0.1-1.rpm --> ORACLE_HOME/cv/rpm/cvuqdisk-1.0.1-1.rpm evm.auth --> ORACLE_HOME/evm/admin/conf/evm.auth evmdaemon.conf --> ORACLE_HOME/evm/admin/conf/evmdaemon.conf evmlogger.conf --> ORACLE_HOME/evm/admin/conf/evmlogger.conf clu.evf --> ORACLE_HOME/evm/admin/filters/clu.evf crs.evf --> ORACLE_HOME/evm/admin/filters/crs.evf evm.evf --> ORACLE_HOME/evm/admin/filters/evm.evf sys.evf --> ORACLE_HOME/evm/admin/filters/sys.evf init.evmd --> ORACLE_HOME/evm/admin/init.evmd clu.evt --> ORACLE_HOME/evm/admin/templates/clu/clu.evt crs.evt --> ORACLE_HOME/evm/admin/templates/clu/crs/crs.evt oraha.evt --> ORACLE_HOME/evm/admin/templates/clu/oraha.evt evm.evt --> ORACLE_HOME/evm/admin/templates/sys/evm.evt evmar.msb --> ORACLE_HOME/evm/mesg/evmar.msb evmcs.msb --> ORACLE_HOME/evm/mesg/evmcs.msb evmd.msb --> ORACLE_HOME/evm/mesg/evmd.msb evmdk.msb --> ORACLE_HOME/evm/mesg/evmdk.msb evme.msb --> ORACLE_HOME/evm/mesg/evme.msb evmel.msb --> ORACLE_HOME/evm/mesg/evmel.msb evmf.msb --> ORACLE_HOME/evm/mesg/evmf.msb evmhu.msb --> ORACLE_HOME/evm/mesg/evmhu.msb evmi.msb --> ORACLE_HOME/evm/mesg/evmi.msb evmiw.msb --> ORACLE_HOME/evm/mesg/evmiw.msb evmja.msb --> ORACLE_HOME/evm/mesg/evmja.msb evmko.msb --> ORACLE_HOME/evm/mesg/evmko.msb evmn.msb --> ORACLE_HOME/evm/mesg/evmn.msb evmnl.msb --> ORACLE_HOME/evm/mesg/evmnl.msb evmpl.msb --> ORACLE_HOME/evm/mesg/evmpl.msb evmpt.msb --> ORACLE_HOME/evm/mesg/evmpt.msb evmptb.msb --> ORACLE_HOME/evm/mesg/evmptb.msb evmro.msb --> ORACLE_HOME/evm/mesg/evmro.msb evmru.msb --> ORACLE_HOME/evm/mesg/evmru.msb evms.msb --> ORACLE_HOME/evm/mesg/evms.msb evmsf.msb --> ORACLE_HOME/evm/mesg/evmsf.msb evmsk.msb --> ORACLE_HOME/evm/mesg/evmsk.msb evmth.msb --> ORACLE_HOME/evm/mesg/evmth.msb evmtr.msb --> ORACLE_HOME/evm/mesg/evmtr.msb evmus.msb --> ORACLE_HOME/evm/mesg/evmus.msb evmus.msg --> ORACLE_HOME/evm/mesg/evmus.msg evmzhs.msb --> ORACLE_HOME/evm/mesg/evmzhs.msb evmzht.msb --> ORACLE_HOME/evm/mesg/evmzht.msb clsdar.msb --> ORACLE_HOME/has/mesg/clsdar.msb clsdcs.msb --> ORACLE_HOME/has/mesg/clsdcs.msb clsdd.msb --> ORACLE_HOME/has/mesg/clsdd.msb clsddk.msb --> ORACLE_HOME/has/mesg/clsddk.msb clsde.msb --> ORACLE_HOME/has/mesg/clsde.msb clsdel.msb --> ORACLE_HOME/has/mesg/clsdel.msb clsdf.msb --> ORACLE_HOME/has/mesg/clsdf.msb clsdhu.msb --> ORACLE_HOME/has/mesg/clsdhu.msb clsdi.msb --> ORACLE_HOME/has/mesg/clsdi.msb clsdiw.msb --> ORACLE_HOME/has/mesg/clsdiw.msb clsdja.msb --> ORACLE_HOME/has/mesg/clsdja.msb clsdko.msb --> ORACLE_HOME/has/mesg/clsdko.msb clsdn.msb --> ORACLE_HOME/has/mesg/clsdn.msb clsdnl.msb --> ORACLE_HOME/has/mesg/clsdnl.msb clsdpl.msb --> ORACLE_HOME/has/mesg/clsdpl.msb clsdpt.msb --> ORACLE_HOME/has/mesg/clsdpt.msb clsdptb.msb --> ORACLE_HOME/has/mesg/clsdptb.msb clsdro.msb --> ORACLE_HOME/has/mesg/clsdro.msb clsdru.msb --> ORACLE_HOME/has/mesg/clsdru.msb clsds.msb --> ORACLE_HOME/has/mesg/clsds.msb clsdsf.msb --> ORACLE_HOME/has/mesg/clsdsf.msb clsdsk.msb --> ORACLE_HOME/has/mesg/clsdsk.msb clsdth.msb --> ORACLE_HOME/has/mesg/clsdth.msb clsdtr.msb --> ORACLE_HOME/has/mesg/clsdtr.msb clsdus.msb --> ORACLE_HOME/has/mesg/clsdus.msb clsdus.msg --> ORACLE_HOME/has/mesg/clsdus.msg clsdzhs.msb --> ORACLE_HOME/has/mesg/clsdzhs.msb clsdzht.msb --> ORACLE_HOME/has/mesg/clsdzht.msb clstar.msb --> ORACLE_HOME/has/mesg/clstar.msb clstcs.msb --> ORACLE_HOME/has/mesg/clstcs.msb clstd.msb --> ORACLE_HOME/has/mesg/clstd.msb clstdk.msb --> ORACLE_HOME/has/mesg/clstdk.msb clste.msb --> ORACLE_HOME/has/mesg/clste.msb clstel.msb --> ORACLE_HOME/has/mesg/clstel.msb clstf.msb --> ORACLE_HOME/has/mesg/clstf.msb clsthu.msb --> ORACLE_HOME/has/mesg/clsthu.msb clsti.msb --> ORACLE_HOME/has/mesg/clsti.msb clstiw.msb --> ORACLE_HOME/has/mesg/clstiw.msb clstja.msb --> ORACLE_HOME/has/mesg/clstja.msb clstko.msb --> ORACLE_HOME/has/mesg/clstko.msb clstn.msb --> ORACLE_HOME/has/mesg/clstn.msb clstnl.msb --> ORACLE_HOME/has/mesg/clstnl.msb clstpl.msb --> ORACLE_HOME/has/mesg/clstpl.msb clstpt.msb --> ORACLE_HOME/has/mesg/clstpt.msb clstptb.msb --> ORACLE_HOME/has/mesg/clstptb.msb clstro.msb --> ORACLE_HOME/has/mesg/clstro.msb clstru.msb --> ORACLE_HOME/has/mesg/clstru.msb clsts.msb --> ORACLE_HOME/has/mesg/clsts.msb clstsf.msb --> ORACLE_HOME/has/mesg/clstsf.msb clstsk.msb --> ORACLE_HOME/has/mesg/clstsk.msb clstth.msb --> ORACLE_HOME/has/mesg/clstth.msb clsttr.msb --> ORACLE_HOME/has/mesg/clsttr.msb clstus.msb --> ORACLE_HOME/has/mesg/clstus.msb clstus.msg --> ORACLE_HOME/has/mesg/clstus.msg clstzhs.msb --> ORACLE_HOME/has/mesg/clstzhs.msb clstzht.msb --> ORACLE_HOME/has/mesg/clstzht.msb install.excl --> ORACLE_HOME/install/install.excl install.incl --> ORACLE_HOME/install/install.incl localconfig --> ORACLE_HOME/install/localconfig paramfile.crs --> ORACLE_HOME/install/paramfile.crs root10103.sh --> ORACLE_HOME/install/root10103.sh root102.sh --> ORACLE_HOME/install/root102.sh rootadd.sbs --> ORACLE_HOME/install/rootadd.sbs rootaddnode.sbs --> ORACLE_HOME/install/rootaddnode.sbs rootconfig.sh --> ORACLE_HOME/install/rootconfig.sh rootdeinstall.sh --> ORACLE_HOME/install/rootdeinstall.sh rootdelete.sh --> ORACLE_HOME/install/rootdelete.sh rootdeletenode.sh --> ORACLE_HOME/install/rootdeletenode.sh rootinstall.sh --> ORACLE_HOME/install/rootinstall.sh rootupgrade.sh --> ORACLE_HOME/install/rootupgrade.sh cvu.jar --> ORACLE_HOME/jlib/cvu.jar srvm.jar --> ORACLE_HOME/jlib/srvm.jar srvmhas.jar --> ORACLE_HOME/jlib/srvmhas.jar libcxaguard.so.5 --> ORACLE_HOME/lib/libcxaguard.so.5 libdbcfg10.so --> ORACLE_HOME/lib/libdbcfg10.so libhasgen10.so --> ORACLE_HOME/lib/libhasgen10.so libocr10.so --> ORACLE_HOME/lib/libocr10.so libocrb10.so --> ORACLE_HOME/lib/libocrb10.so libocrutl10.so --> ORACLE_HOME/lib/libocrutl10.so libsrvm10.so --> ORACLE_HOME/lib/libsrvm10.so libsrvmhas10.so --> ORACLE_HOME/lib/libsrvmhas10.so libsrvmocr10.so --> ORACLE_HOME/lib/libsrvmocr10.so libuini10.a --> ORACLE_HOME/lib/libuini10.a libuini10.so --> ORACLE_HOME/lib/libuini10.so libdbcfg10.so --> ORACLE_HOME/lib32/libdbcfg10.so libhasgen10.so --> ORACLE_HOME/lib32/libhasgen10.so libocr10.so --> ORACLE_HOME/lib32/libocr10.so libocrb10.so --> ORACLE_HOME/lib32/libocrb10.so libocrutl10.so --> ORACLE_HOME/lib32/libocrutl10.so libsrvm10.so --> ORACLE_HOME/lib32/libsrvm10.so libsrvmhas10.so --> ORACLE_HOME/lib32/libsrvmhas10.so libsrvmocr10.so --> ORACLE_HOME/lib32/libsrvmocr10.so libuini10.a --> ORACLE_HOME/lib32/libuini10.a libuini10.so --> ORACLE_HOME/lib32/libuini10.so README --> ORACLE_HOME/racg/README clsrar.msb --> ORACLE_HOME/racg/mesg/clsrar.msb clsrcs.msb --> ORACLE_HOME/racg/mesg/clsrcs.msb clsrd.msb --> ORACLE_HOME/racg/mesg/clsrd.msb clsrdk.msb --> ORACLE_HOME/racg/mesg/clsrdk.msb clsre.msb --> ORACLE_HOME/racg/mesg/clsre.msb clsrel.msb --> ORACLE_HOME/racg/mesg/clsrel.msb clsrf.msb --> ORACLE_HOME/racg/mesg/clsrf.msb clsrhu.msb --> ORACLE_HOME/racg/mesg/clsrhu.msb clsri.msb --> ORACLE_HOME/racg/mesg/clsri.msb clsriw.msb --> ORACLE_HOME/racg/mesg/clsriw.msb clsrja.msb --> ORACLE_HOME/racg/mesg/clsrja.msb clsrko.msb --> ORACLE_HOME/racg/mesg/clsrko.msb clsrn.msb --> ORACLE_HOME/racg/mesg/clsrn.msb clsrnl.msb --> ORACLE_HOME/racg/mesg/clsrnl.msb clsrpl.msb --> ORACLE_HOME/racg/mesg/clsrpl.msb clsrpt.msb --> ORACLE_HOME/racg/mesg/clsrpt.msb clsrptb.msb --> ORACLE_HOME/racg/mesg/clsrptb.msb clsrro.msb --> ORACLE_HOME/racg/mesg/clsrro.msb clsrru.msb --> ORACLE_HOME/racg/mesg/clsrru.msb clsrs.msb --> ORACLE_HOME/racg/mesg/clsrs.msb clsrsf.msb --> ORACLE_HOME/racg/mesg/clsrsf.msb clsrsk.msb --> ORACLE_HOME/racg/mesg/clsrsk.msb clsrth.msb --> ORACLE_HOME/racg/mesg/clsrth.msb clsrtr.msb --> ORACLE_HOME/racg/mesg/clsrtr.msb clsrus.msb --> ORACLE_HOME/racg/mesg/clsrus.msb clsrus.msg --> ORACLE_HOME/racg/mesg/clsrus.msg clsrzhs.msb --> ORACLE_HOME/racg/mesg/clsrzhs.msb clsrzht.msb --> ORACLE_HOME/racg/mesg/clsrzht.msb ocrlog.ini --> ORACLE_HOME/srvm/admin/ocrlog.ini paramfile.sample --> ORACLE_HOME/srvm/admin/paramfile.sample srvctl.jar --> ORACLE_HOME/srvm/jlib/srvctl.jar vipca.jar --> ORACLE_HOME/srvm/jlib/vipca.jar libsrvm10.a --> ORACLE_HOME/srvm/lib/libsrvm10.a libsrvmhas10.a --> ORACLE_HOME/srvm/lib/libsrvmhas10.a libsrvmocr10.a --> ORACLE_HOME/srvm/lib/libsrvmocr10.a libsrvm10.a --> ORACLE_HOME/srvm/lib32/libsrvm10.a libsrvmhas10.a --> ORACLE_HOME/srvm/lib32/libsrvmhas10.a libsrvmocr10.a --> ORACLE_HOME/srvm/lib32/libsrvmocr10.a prcod.msb --> ORACLE_HOME/srvm/mesg/prcod.msb prcoe.msb --> ORACLE_HOME/srvm/mesg/prcoe.msb prcof.msb --> ORACLE_HOME/srvm/mesg/prcof.msb prcoi.msb --> ORACLE_HOME/srvm/mesg/prcoi.msb prcoja.msb --> ORACLE_HOME/srvm/mesg/prcoja.msb prcoko.msb --> ORACLE_HOME/srvm/mesg/prcoko.msb prcoptb.msb --> ORACLE_HOME/srvm/mesg/prcoptb.msb prcous.msb --> ORACLE_HOME/srvm/mesg/prcous.msb prcous.msg --> ORACLE_HOME/srvm/mesg/prcous.msg prcozhs.msb --> ORACLE_HOME/srvm/mesg/prcozhs.msb prcozht.msb --> ORACLE_HOME/srvm/mesg/prcozht.msb prifd.msb --> ORACLE_HOME/srvm/mesg/prifd.msb prife.msb --> ORACLE_HOME/srvm/mesg/prife.msb priff.msb --> ORACLE_HOME/srvm/mesg/priff.msb prifi.msb --> ORACLE_HOME/srvm/mesg/prifi.msb prifja.msb --> ORACLE_HOME/srvm/mesg/prifja.msb prifko.msb --> ORACLE_HOME/srvm/mesg/prifko.msb prifptb.msb --> ORACLE_HOME/srvm/mesg/prifptb.msb prifus.msb --> ORACLE_HOME/srvm/mesg/prifus.msb prifus.msg --> ORACLE_HOME/srvm/mesg/prifus.msg prifzhs.msb --> ORACLE_HOME/srvm/mesg/prifzhs.msb prifzht.msb --> ORACLE_HOME/srvm/mesg/prifzht.msb procd.msb --> ORACLE_HOME/srvm/mesg/procd.msb proce.msb --> ORACLE_HOME/srvm/mesg/proce.msb procf.msb --> ORACLE_HOME/srvm/mesg/procf.msb proci.msb --> ORACLE_HOME/srvm/mesg/proci.msb procja.msb --> ORACLE_HOME/srvm/mesg/procja.msb procko.msb --> ORACLE_HOME/srvm/mesg/procko.msb procptb.msb --> ORACLE_HOME/srvm/mesg/procptb.msb procus.msb --> ORACLE_HOME/srvm/mesg/procus.msb procus.msg --> ORACLE_HOME/srvm/mesg/procus.msg proczhs.msb --> ORACLE_HOME/srvm/mesg/proczhs.msb proczht.msb --> ORACLE_HOME/srvm/mesg/proczht.msb protd.msb --> ORACLE_HOME/srvm/mesg/protd.msb prote.msb --> ORACLE_HOME/srvm/mesg/prote.msb protf.msb --> ORACLE_HOME/srvm/mesg/protf.msb proti.msb --> ORACLE_HOME/srvm/mesg/proti.msb protja.msb --> ORACLE_HOME/srvm/mesg/protja.msb protko.msb --> ORACLE_HOME/srvm/mesg/protko.msb protptb.msb --> ORACLE_HOME/srvm/mesg/protptb.msb protus.msb --> ORACLE_HOME/srvm/mesg/protus.msb protus.msg --> ORACLE_HOME/srvm/mesg/protus.msg protzhs.msb --> ORACLE_HOME/srvm/mesg/protzhs.msb protzht.msb --> ORACLE_HOME/srvm/mesg/protzht.msb rootconfigadd --> ORACLE_HOME/srvm/utl/rootconfigadd rootinstalladd --> ORACLE_HOME/srvm/utl/rootinstalladd Patch Location in Inventory: /oracle/product/11.1.0/crs_1/inventory/oneoffs/9294403 Patch Location in Storage area: /oracle/product/11.1.0/crs_1/.patch_storage/9294403_Mar_19_2010_18_59_31
Rac system comprising of multiple nodes Local node = dwdb1 Remote node = dwdb2
--------------------------------------------------------------------------------
OPatch succeeded. |
1.1.8.2 TO RDBMS_HOME
[oracle@dwdb1 9294403]$ opatch lsinventory -detail -oh $ORACLE_HOME 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.
Oracle Home : /oracle/product/11.1.0/db_1 Central Inventory : /oracle/oraInventory from : /etc/oraInst.loc OPatch version : 10.2.0.5.1 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_11-42-55AM.log
Patch history file: /oracle/product/11.1.0/db_1/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output file location : /oracle/product/11.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2014-11-10_11-42-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.
Interim patches (1) :
Patch 9294403 : applied on Mon Nov 10 11:33:01 CST 2014 Unique Patch ID: 12382183 Created on 19 Mar 2010, 18:59:24 hrs PST8PDT Bugs fixed: 9294403 Files Touched: clscfg --> ORACLE_HOME/bin/clscfg clscfg.bin --> ORACLE_HOME/bin/clscfg.bin clsfmt --> ORACLE_HOME/bin/clsfmt clsfmt.bin --> ORACLE_HOME/bin/clsfmt.bin clsid --> ORACLE_HOME/bin/clsid clsid.bin --> ORACLE_HOME/bin/clsid.bin cluvfy --> ORACLE_HOME/bin/cluvfy crsctl --> ORACLE_HOME/bin/crsctl crsctl.bin --> ORACLE_HOME/bin/crsctl.bin gsd --> ORACLE_HOME/bin/gsd gsd.sh --> ORACLE_HOME/bin/gsd.sh gsdctl --> ORACLE_HOME/bin/gsdctl localconfig --> ORACLE_HOME/bin/localconfig lsnodes --> ORACLE_HOME/bin/lsnodes ocssd --> ORACLE_HOME/bin/ocssd ocssd.bin --> ORACLE_HOME/bin/ocssd.bin racgwrap --> ORACLE_HOME/bin/racgwrap rawutl --> ORACLE_HOME/bin/rawutl srvconfig --> ORACLE_HOME/bin/srvconfig srvctl --> ORACLE_HOME/bin/srvctl srvmspawn --> ORACLE_HOME/bin/srvmspawn vipca --> ORACLE_HOME/bin/vipca clscrsx.h --> ORACLE_HOME/crs/demo/clscrsx.h crsapp.c --> ORACLE_HOME/crs/demo/crsapp.c demo_crs.mk --> ORACLE_HOME/crs/demo/demo_crs.mk env_has.mk --> ORACLE_HOME/crs/lib/env_has.mk env_has.mk --> ORACLE_HOME/crs/lib32/env_has.mk crsar.msb --> ORACLE_HOME/crs/mesg/crsar.msb crscs.msb --> ORACLE_HOME/crs/mesg/crscs.msb crsd.msb --> ORACLE_HOME/crs/mesg/crsd.msb crsdk.msb --> ORACLE_HOME/crs/mesg/crsdk.msb crse.msb --> ORACLE_HOME/crs/mesg/crse.msb crsel.msb --> ORACLE_HOME/crs/mesg/crsel.msb crsf.msb --> ORACLE_HOME/crs/mesg/crsf.msb crshu.msb --> ORACLE_HOME/crs/mesg/crshu.msb crsi.msb --> ORACLE_HOME/crs/mesg/crsi.msb crsiw.msb --> ORACLE_HOME/crs/mesg/crsiw.msb crsja.msb --> ORACLE_HOME/crs/mesg/crsja.msb crsko.msb --> ORACLE_HOME/crs/mesg/crsko.msb crsn.msb --> ORACLE_HOME/crs/mesg/crsn.msb crsnl.msb --> ORACLE_HOME/crs/mesg/crsnl.msb crspl.msb --> ORACLE_HOME/crs/mesg/crspl.msb crspt.msb --> ORACLE_HOME/crs/mesg/crspt.msb crsptb.msb --> ORACLE_HOME/crs/mesg/crsptb.msb crsro.msb --> ORACLE_HOME/crs/mesg/crsro.msb crsru.msb --> ORACLE_HOME/crs/mesg/crsru.msb crss.msb --> ORACLE_HOME/crs/mesg/crss.msb crssf.msb --> ORACLE_HOME/crs/mesg/crssf.msb crssk.msb --> ORACLE_HOME/crs/mesg/crssk.msb crsth.msb --> ORACLE_HOME/crs/mesg/crsth.msb crstr.msb --> ORACLE_HOME/crs/mesg/crstr.msb crsus.msb --> ORACLE_HOME/crs/mesg/crsus.msb crsus.msg --> ORACLE_HOME/crs/mesg/crsus.msg crszhs.msb --> ORACLE_HOME/crs/mesg/crszhs.msb crszht.msb --> ORACLE_HOME/crs/mesg/crszht.msb action_scr.scr --> ORACLE_HOME/crs/public/action_scr.scr init.cssd --> ORACLE_HOME/css/admin/init.cssd inittab_local --> ORACLE_HOME/css/admin/inittab_local clssar.msb --> ORACLE_HOME/css/mesg/clssar.msb clsscs.msb --> ORACLE_HOME/css/mesg/clsscs.msb clssd.msb --> ORACLE_HOME/css/mesg/clssd.msb clssdk.msb --> ORACLE_HOME/css/mesg/clssdk.msb clsse.msb --> ORACLE_HOME/css/mesg/clsse.msb clssel.msb --> ORACLE_HOME/css/mesg/clssel.msb clssf.msb --> ORACLE_HOME/css/mesg/clssf.msb clsshu.msb --> ORACLE_HOME/css/mesg/clsshu.msb clssi.msb --> ORACLE_HOME/css/mesg/clssi.msb clssiw.msb --> ORACLE_HOME/css/mesg/clssiw.msb clssja.msb --> ORACLE_HOME/css/mesg/clssja.msb clssko.msb --> ORACLE_HOME/css/mesg/clssko.msb clssn.msb --> ORACLE_HOME/css/mesg/clssn.msb clssnl.msb --> ORACLE_HOME/css/mesg/clssnl.msb clsspl.msb --> ORACLE_HOME/css/mesg/clsspl.msb clsspt.msb --> ORACLE_HOME/css/mesg/clsspt.msb clssptb.msb --> ORACLE_HOME/css/mesg/clssptb.msb clssro.msb --> ORACLE_HOME/css/mesg/clssro.msb clssru.msb --> ORACLE_HOME/css/mesg/clssru.msb clsss.msb --> ORACLE_HOME/css/mesg/clsss.msb clsssf.msb --> ORACLE_HOME/css/mesg/clsssf.msb clsssk.msb --> ORACLE_HOME/css/mesg/clsssk.msb clssth.msb --> ORACLE_HOME/css/mesg/clssth.msb clsstr.msb --> ORACLE_HOME/css/mesg/clsstr.msb clssus.msb --> ORACLE_HOME/css/mesg/clssus.msb clssus.msg --> ORACLE_HOME/css/mesg/clssus.msg clsszhs.msb --> ORACLE_HOME/css/mesg/clsszhs.msb clsszht.msb --> ORACLE_HOME/css/mesg/clsszht.msb clsdar.msb --> ORACLE_HOME/has/mesg/clsdar.msb clsdcs.msb --> ORACLE_HOME/has/mesg/clsdcs.msb clsdd.msb --> ORACLE_HOME/has/mesg/clsdd.msb clsddk.msb --> ORACLE_HOME/has/mesg/clsddk.msb clsde.msb --> ORACLE_HOME/has/mesg/clsde.msb clsdel.msb --> ORACLE_HOME/has/mesg/clsdel.msb clsdf.msb --> ORACLE_HOME/has/mesg/clsdf.msb clsdhu.msb --> ORACLE_HOME/has/mesg/clsdhu.msb clsdi.msb --> ORACLE_HOME/has/mesg/clsdi.msb clsdiw.msb --> ORACLE_HOME/has/mesg/clsdiw.msb clsdja.msb --> ORACLE_HOME/has/mesg/clsdja.msb clsdko.msb --> ORACLE_HOME/has/mesg/clsdko.msb clsdn.msb --> ORACLE_HOME/has/mesg/clsdn.msb clsdnl.msb --> ORACLE_HOME/has/mesg/clsdnl.msb clsdpl.msb --> ORACLE_HOME/has/mesg/clsdpl.msb clsdpt.msb --> ORACLE_HOME/has/mesg/clsdpt.msb clsdptb.msb --> ORACLE_HOME/has/mesg/clsdptb.msb clsdro.msb --> ORACLE_HOME/has/mesg/clsdro.msb clsdru.msb --> ORACLE_HOME/has/mesg/clsdru.msb clsds.msb --> ORACLE_HOME/has/mesg/clsds.msb clsdsf.msb --> ORACLE_HOME/has/mesg/clsdsf.msb clsdsk.msb --> ORACLE_HOME/has/mesg/clsdsk.msb clsdth.msb --> ORACLE_HOME/has/mesg/clsdth.msb clsdtr.msb --> ORACLE_HOME/has/mesg/clsdtr.msb clsdus.msb --> ORACLE_HOME/has/mesg/clsdus.msb clsdus.msg --> ORACLE_HOME/has/mesg/clsdus.msg clsdzhs.msb --> ORACLE_HOME/has/mesg/clsdzhs.msb clsdzht.msb --> ORACLE_HOME/has/mesg/clsdzht.msb clstar.msb --> ORACLE_HOME/has/mesg/clstar.msb clstcs.msb --> ORACLE_HOME/has/mesg/clstcs.msb clstd.msb --> ORACLE_HOME/has/mesg/clstd.msb clstdk.msb --> ORACLE_HOME/has/mesg/clstdk.msb clste.msb --> ORACLE_HOME/has/mesg/clste.msb clstel.msb --> ORACLE_HOME/has/mesg/clstel.msb clstf.msb --> ORACLE_HOME/has/mesg/clstf.msb clsthu.msb --> ORACLE_HOME/has/mesg/clsthu.msb clsti.msb --> ORACLE_HOME/has/mesg/clsti.msb clstiw.msb --> ORACLE_HOME/has/mesg/clstiw.msb clstja.msb --> ORACLE_HOME/has/mesg/clstja.msb clstko.msb --> ORACLE_HOME/has/mesg/clstko.msb clstn.msb --> ORACLE_HOME/has/mesg/clstn.msb clstnl.msb --> ORACLE_HOME/has/mesg/clstnl.msb clstpl.msb --> ORACLE_HOME/has/mesg/clstpl.msb clstpt.msb --> ORACLE_HOME/has/mesg/clstpt.msb clstptb.msb --> ORACLE_HOME/has/mesg/clstptb.msb clstro.msb --> ORACLE_HOME/has/mesg/clstro.msb clstru.msb --> ORACLE_HOME/has/mesg/clstru.msb clsts.msb --> ORACLE_HOME/has/mesg/clsts.msb clstsf.msb --> ORACLE_HOME/has/mesg/clstsf.msb clstsk.msb --> ORACLE_HOME/has/mesg/clstsk.msb clstth.msb --> ORACLE_HOME/has/mesg/clstth.msb clsttr.msb --> ORACLE_HOME/has/mesg/clsttr.msb clstus.msb --> ORACLE_HOME/has/mesg/clstus.msb clstus.msg --> ORACLE_HOME/has/mesg/clstus.msg clstzhs.msb --> ORACLE_HOME/has/mesg/clstzhs.msb clstzht.msb --> ORACLE_HOME/has/mesg/clstzht.msb rootlocaladd.sh --> ORACLE_HOME/install/rootlocaladd.sh srvm.jar --> ORACLE_HOME/jlib/srvm.jar srvmasm.jar --> ORACLE_HOME/jlib/srvmasm.jar srvmhas.jar --> ORACLE_HOME/jlib/srvmhas.jar libclsr10.a --> ORACLE_HOME/lib/libclsr10.a libclsra10.so --> ORACLE_HOME/lib/libclsra10.so libcxaguard.so.5 --> ORACLE_HOME/lib/libcxaguard.so.5 libdbcfg10.a --> ORACLE_HOME/lib/libdbcfg10.a libdbcfg10.so --> ORACLE_HOME/lib/libdbcfg10.so libhasgen10.so --> ORACLE_HOME/lib/libhasgen10.so libocr10.a --> ORACLE_HOME/lib/libocr10.a libocr10.so --> ORACLE_HOME/lib/libocr10.so libocrb10.a --> ORACLE_HOME/lib/libocrb10.a libocrb10.so --> ORACLE_HOME/lib/libocrb10.so libocrutl10.a --> ORACLE_HOME/lib/libocrutl10.a libocrutl10.so --> ORACLE_HOME/lib/libocrutl10.so liboevm.a --> ORACLE_HOME/lib/liboevm.a libsrvm10.so --> ORACLE_HOME/lib/libsrvm10.so libsrvmhas10.so --> ORACLE_HOME/lib/libsrvmhas10.so libsrvmocr10.so --> ORACLE_HOME/lib/libsrvmocr10.so libuini10.a --> ORACLE_HOME/lib/libuini10.a libuini10.so --> ORACLE_HOME/lib/libuini10.so libclsr10.a --> ORACLE_HOME/lib32/libclsr10.a libclsra10.so --> ORACLE_HOME/lib32/libclsra10.so libdbcfg10.a --> ORACLE_HOME/lib32/libdbcfg10.a libdbcfg10.so --> ORACLE_HOME/lib32/libdbcfg10.so libhasgen10.so --> ORACLE_HOME/lib32/libhasgen10.so libocr10.a --> ORACLE_HOME/lib32/libocr10.a libocr10.so --> ORACLE_HOME/lib32/libocr10.so libocrb10.a --> ORACLE_HOME/lib32/libocrb10.a libocrb10.so --> ORACLE_HOME/lib32/libocrb10.so libocrutl10.a --> ORACLE_HOME/lib32/libocrutl10.a libocrutl10.so --> ORACLE_HOME/lib32/libocrutl10.so liboevm.a --> ORACLE_HOME/lib32/liboevm.a libsrvm10.so --> ORACLE_HOME/lib32/libsrvm10.so libsrvmhas10.so --> ORACLE_HOME/lib32/libsrvmhas10.so libsrvmocr10.so --> ORACLE_HOME/lib32/libsrvmocr10.so libuini10.a --> ORACLE_HOME/lib32/libuini10.a libuini10.so --> ORACLE_HOME/lib32/libuini10.so ins_has.mk --> ORACLE_HOME/racg/lib/ins_has.mk s0clsrdmai.o --> ORACLE_HOME/racg/lib/s0clsrdmai.o s0clsreut.o --> ORACLE_HOME/racg/lib/s0clsreut.o s0clsrmain.o --> ORACLE_HOME/racg/lib/s0clsrmain.o s0clsrmdb.o --> ORACLE_HOME/racg/lib/s0clsrmdb.o ins_has.mk --> ORACLE_HOME/racg/lib32/ins_has.mk s0clsrdmai.o --> ORACLE_HOME/racg/lib32/s0clsrdmai.o s0clsreut.o --> ORACLE_HOME/racg/lib32/s0clsreut.o s0clsrmain.o --> ORACLE_HOME/racg/lib32/s0clsrmain.o s0clsrmdb.o --> ORACLE_HOME/racg/lib32/s0clsrmdb.o clsrar.msb --> ORACLE_HOME/racg/mesg/clsrar.msb clsrcs.msb --> ORACLE_HOME/racg/mesg/clsrcs.msb clsrd.msb --> ORACLE_HOME/racg/mesg/clsrd.msb clsrdk.msb --> ORACLE_HOME/racg/mesg/clsrdk.msb clsre.msb --> ORACLE_HOME/racg/mesg/clsre.msb clsrel.msb --> ORACLE_HOME/racg/mesg/clsrel.msb clsrf.msb --> ORACLE_HOME/racg/mesg/clsrf.msb clsrhu.msb --> ORACLE_HOME/racg/mesg/clsrhu.msb clsri.msb --> ORACLE_HOME/racg/mesg/clsri.msb clsriw.msb --> ORACLE_HOME/racg/mesg/clsriw.msb clsrja.msb --> ORACLE_HOME/racg/mesg/clsrja.msb clsrko.msb --> ORACLE_HOME/racg/mesg/clsrko.msb clsrn.msb --> ORACLE_HOME/racg/mesg/clsrn.msb clsrnl.msb --> ORACLE_HOME/racg/mesg/clsrnl.msb clsrpl.msb --> ORACLE_HOME/racg/mesg/clsrpl.msb clsrpt.msb --> ORACLE_HOME/racg/mesg/clsrpt.msb clsrptb.msb --> ORACLE_HOME/racg/mesg/clsrptb.msb clsrro.msb --> ORACLE_HOME/racg/mesg/clsrro.msb clsrru.msb --> ORACLE_HOME/racg/mesg/clsrru.msb clsrs.msb --> ORACLE_HOME/racg/mesg/clsrs.msb clsrsf.msb --> ORACLE_HOME/racg/mesg/clsrsf.msb clsrsk.msb --> ORACLE_HOME/racg/mesg/clsrsk.msb clsrth.msb --> ORACLE_HOME/racg/mesg/clsrth.msb clsrtr.msb --> ORACLE_HOME/racg/mesg/clsrtr.msb clsrus.msb --> ORACLE_HOME/racg/mesg/clsrus.msb clsrus.msg --> ORACLE_HOME/racg/mesg/clsrus.msg clsrzhs.msb --> ORACLE_HOME/racg/mesg/clsrzhs.msb clsrzht.msb --> ORACLE_HOME/racg/mesg/clsrzht.msb README_srvm.txt --> ORACLE_HOME/relnotes/README_srvm.txt ocrlog.ini --> ORACLE_HOME/srvm/admin/ocrlog.ini README.doc --> ORACLE_HOME/srvm/doc/README.doc srvctl.jar --> ORACLE_HOME/srvm/jlib/srvctl.jar vipca.jar --> ORACLE_HOME/srvm/jlib/vipca.jar env_srvm.mk --> ORACLE_HOME/srvm/lib/env_srvm.mk ins_srvm.mk --> ORACLE_HOME/srvm/lib/ins_srvm.mk libsrvm10.a --> ORACLE_HOME/srvm/lib/libsrvm10.a libsrvmhas10.a --> ORACLE_HOME/srvm/lib/libsrvmhas10.a libsrvmocr10.a --> ORACLE_HOME/srvm/lib/libsrvmocr10.a prifcg.o --> ORACLE_HOME/srvm/lib/prifcg.o prifcmn.o --> ORACLE_HOME/srvm/lib/prifcmn.o prifutl.o --> ORACLE_HOME/srvm/lib/prifutl.o prot.o --> ORACLE_HOME/srvm/lib/prot.o protchek.o --> ORACLE_HOME/srvm/lib/protchek.o protconf.o --> ORACLE_HOME/srvm/lib/protconf.o protdump.o --> ORACLE_HOME/srvm/lib/protdump.o prraw.o --> ORACLE_HOME/srvm/lib/prraw.o sprdbgrp.o --> ORACLE_HOME/srvm/lib/sprdbgrp.o sprifcg.o --> ORACLE_HOME/srvm/lib/sprifcg.o sprotc.o --> ORACLE_HOME/srvm/lib/sprotc.o sprotch.o --> ORACLE_HOME/srvm/lib/sprotch.o sprotd.o --> ORACLE_HOME/srvm/lib/sprotd.o sprraw.o --> ORACLE_HOME/srvm/lib/sprraw.o env_srvm.mk --> ORACLE_HOME/srvm/lib32/env_srvm.mk ins_srvm.mk --> ORACLE_HOME/srvm/lib32/ins_srvm.mk libsrvm10.a --> ORACLE_HOME/srvm/lib32/libsrvm10.a libsrvmhas10.a --> ORACLE_HOME/srvm/lib32/libsrvmhas10.a libsrvmocr10.a --> ORACLE_HOME/srvm/lib32/libsrvmocr10.a prifcg.o --> ORACLE_HOME/srvm/lib32/prifcg.o prifcmn.o --> ORACLE_HOME/srvm/lib32/prifcmn.o prifutl.o --> ORACLE_HOME/srvm/lib32/prifutl.o prot.o --> ORACLE_HOME/srvm/lib32/prot.o protchek.o --> ORACLE_HOME/srvm/lib32/protchek.o protconf.o --> ORACLE_HOME/srvm/lib32/protconf.o protdump.o --> ORACLE_HOME/srvm/lib32/protdump.o prraw.o --> ORACLE_HOME/srvm/lib32/prraw.o sprdbgrp.o --> ORACLE_HOME/srvm/lib32/sprdbgrp.o sprifcg.o --> ORACLE_HOME/srvm/lib32/sprifcg.o sprotc.o --> ORACLE_HOME/srvm/lib32/sprotc.o sprotch.o --> ORACLE_HOME/srvm/lib32/sprotch.o sprotd.o --> ORACLE_HOME/srvm/lib32/sprotd.o sprraw.o --> ORACLE_HOME/srvm/lib32/sprraw.o prifd.msb --> ORACLE_HOME/srvm/mesg/prifd.msb prife.msb --> ORACLE_HOME/srvm/mesg/prife.msb priff.msb --> ORACLE_HOME/srvm/mesg/priff.msb prifi.msb --> ORACLE_HOME/srvm/mesg/prifi.msb prifja.msb --> ORACLE_HOME/srvm/mesg/prifja.msb prifko.msb --> ORACLE_HOME/srvm/mesg/prifko.msb prifptb.msb --> ORACLE_HOME/srvm/mesg/prifptb.msb prifus.msb --> ORACLE_HOME/srvm/mesg/prifus.msb prifus.msg --> ORACLE_HOME/srvm/mesg/prifus.msg prifzhs.msb --> ORACLE_HOME/srvm/mesg/prifzhs.msb prifzht.msb --> ORACLE_HOME/srvm/mesg/prifzht.msb procd.msb --> ORACLE_HOME/srvm/mesg/procd.msb proce.msb --> ORACLE_HOME/srvm/mesg/proce.msb procf.msb --> ORACLE_HOME/srvm/mesg/procf.msb proci.msb --> ORACLE_HOME/srvm/mesg/proci.msb procja.msb --> ORACLE_HOME/srvm/mesg/procja.msb procko.msb --> ORACLE_HOME/srvm/mesg/procko.msb procptb.msb --> ORACLE_HOME/srvm/mesg/procptb.msb procus.msb --> ORACLE_HOME/srvm/mesg/procus.msb procus.msg --> ORACLE_HOME/srvm/mesg/procus.msg proczhs.msb --> ORACLE_HOME/srvm/mesg/proczhs.msb proczht.msb --> ORACLE_HOME/srvm/mesg/proczht.msb protd.msb --> ORACLE_HOME/srvm/mesg/protd.msb prote.msb --> ORACLE_HOME/srvm/mesg/prote.msb protf.msb --> ORACLE_HOME/srvm/mesg/protf.msb proti.msb --> ORACLE_HOME/srvm/mesg/proti.msb protja.msb --> ORACLE_HOME/srvm/mesg/protja.msb protko.msb --> ORACLE_HOME/srvm/mesg/protko.msb protptb.msb --> ORACLE_HOME/srvm/mesg/protptb.msb protus.msb --> ORACLE_HOME/srvm/mesg/protus.msb protus.msg --> ORACLE_HOME/srvm/mesg/protus.msg protzhs.msb --> ORACLE_HOME/srvm/mesg/protzhs.msb protzht.msb --> ORACLE_HOME/srvm/mesg/protzht.msb rootlocaladd --> ORACLE_HOME/srvm/utl/rootlocaladd ins_srvm.mk --> ORACLE_HOME/srvm/lib/install ins_has.mk --> ORACLE_HOME/racg/lib/install Patch Location in Inventory: /oracle/product/11.1.0/db_1/inventory/oneoffs/9294403 Patch Location in Storage area: /oracle/product/11.1.0/db_1/.patch_storage/9294403_Mar_19_2010_18_59_24
Rac system comprising of multiple nodes Local node = dwdb1 Remote node = dwdb2
--------------------------------------------------------------------------------
OPatch succeeded. |
1.1.9 升级DB至10.2.0.4.4 (14:40)
1.1.9.1 升级DB
[oracle@dwdb1 orainst]$ unzip p9352164_DB_PSU_10.2.0.4.4_Linux-x86-64.zip [oracle@dwdb1 orainst]$ which opatch /oracle/product/11.1.0/db_1/OPatch/opatch [oracle@dwdb1 orainst]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./9352164 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.
PREREQ session
Oracle Home : /oracle/product/11.1.0/db_1 Central Inventory : /oracle/oraInventory from : /etc/oraInst.loc OPatch version : 10.2.0.5.1 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_12-34-49PM.log
Patch history file: /oracle/product/11.1.0/db_1/cfgtoollogs/opatch/opatch_history.txt
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded. |
[oracle@dwdb1 orainst]$ srvctl stop instance -i odsptdb1 -d odsptdb [oracle@dwdb1 orainst]$ [oracle@dwdb1 orainst]$ srvctl stop nodeapps -n dwdb1 [oracle@dwdb1 orainst]$ srvctl stop asm -n dwdb1 [oracle@dwdb1 orainst]$ crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora....SM1.asm application OFFLINE OFFLINE ora....B1.lsnr application OFFLINE OFFLINE ora.dwdb1.gsd application OFFLINE OFFLINE ora.dwdb1.ons application OFFLINE OFFLINE ora.dwdb1.vip application OFFLINE OFFLINE ora....SM2.asm application ONLINE ONLINE dwdb2 ora....B2.lsnr application ONLINE ONLINE dwdb2 ora.dwdb2.gsd application ONLINE ONLINE dwdb2 ora.dwdb2.ons application ONLINE ONLINE dwdb2 ora.dwdb2.vip application ONLINE ONLINE dwdb2 ora.odsptdb.db application ONLINE ONLINE dwdb1 ora....b1.inst application OFFLINE OFFLINE ora....b2.inst application ONLINE ONLINE dwdb2 |
[oracle@dwdb1 orainst]$ cd 9352164 [oracle@dwdb1 9352164]$ opatch apply 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.
Oracle Home : /oracle/product/11.1.0/db_1 Central Inventory : /oracle/oraInventory from : /etc/oraInst.loc OPatch version : 10.2.0.5.1 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_12-38-39PM.log
Patch history file: /oracle/product/11.1.0/db_1/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying interim patch ‘9352164‘ to OH ‘/oracle/product/11.1.0/db_1‘
Running prerequisite checks... 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
OPatch detected the node list and the local node from the inventory. OPatch will patch the local system then propagate the patch to the remote nodes.
This node is part of an Oracle Real Application Cluster. Remote nodes: ‘dwdb2‘ Local node: ‘dwdb1‘ elease shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = ‘/oracle/product/11.1.0/db_1‘)
Is the local system ready for patching? [y|n] Y Execution of ‘sh /orainst/9352164/custom/scripts/post -apply 9352164 ‘:
Return Code = 0
The local system has been patched. You can restart Oracle instances on it.
Patching in rolling mode.
The node ‘dwdb2‘ will be patched next.
Please shutdown Oracle instances running out of this ORACLE_HOME on ‘dwdb2‘. (Oracle Home = ‘/oracle/product/11.1.0/db_1‘)
Is the node ready for patching? [y|n] |
此时数据库不要着急回复，把节点一的数据库启起来，节点二的数据库关闭，再回来回复
[oracle@dwdb1 ~]$ crs_start -all Attempting to start `ora.dwdb1.vip` on member `dwdb1` Attempting to start `ora.dwdb1.ASM1.asm` on member `dwdb1` Start of `ora.dwdb1.vip` on member `dwdb1` succeeded. Attempting to start `ora.dwdb1.LISTENER_DWDB1.lsnr` on member `dwdb1` Start of `ora.dwdb1.ASM1.asm` on member `dwdb1` succeeded. Attempting to start `ora.odsptdb.odsptdb1.inst` on member `dwdb1` Start of `ora.dwdb1.LISTENER_DWDB1.lsnr` on member `dwdb1` succeeded. Start of `ora.odsptdb.odsptdb1.inst` on member `dwdb1` succeeded. CRS-1002: Resource ‘ora.dwdb1.ons‘ is already running on member ‘dwdb1‘
Attempting to start `ora.dwdb1.gsd` on member `dwdb1` Start of `ora.dwdb1.gsd` on member `dwdb1` succeeded. CRS-0223: Resource ‘ora.dwdb1.ons‘ has placement error.
[oracle@dwdb1 ~]$ crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora....SM1.asm application ONLINE ONLINE dwdb1 ora....B1.lsnr application ONLINE ONLINE dwdb1 ora.dwdb1.gsd application ONLINE ONLINE dwdb1 ora.dwdb1.ons application ONLINE ONLINE dwdb1 ora.dwdb1.vip application ONLINE ONLINE dwdb1 ora....SM2.asm application ONLINE ONLINE dwdb2 ora....B2.lsnr application ONLINE ONLINE dwdb2 ora.dwdb2.gsd application ONLINE ONLINE dwdb2 ora.dwdb2.ons application ONLINE ONLINE dwdb2 ora.dwdb2.vip application ONLINE ONLINE dwdb2 ora.odsptdb.db application ONLINE ONLINE dwdb1 ora....b1.inst application ONLINE ONLINE dwdb1 ora....b2.inst application ONLINE ONLINE dwdb2 [oracle@dwdb2 9294403]$ srvctl stop instance -i odsptdb2 -d odsptdb [oracle@dwdb2 9294403]$ srvctl stop asm -n dwdb2 [oracle@dwdb2 9294403]$ srvctl stop nodeapps -n dwdb2 [oracle@dwdb2 9294403]$ crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora....SM1.asm application ONLINE ONLINE dwdb1 ora....B1.lsnr application ONLINE ONLINE dwdb1 ora.dwdb1.gsd application ONLINE ONLINE dwdb1 ora.dwdb1.ons application ONLINE ONLINE dwdb1 ora.dwdb1.vip application ONLINE ONLINE dwdb1 ora....SM2.asm application OFFLINE OFFLINE ora....B2.lsnr application OFFLINE OFFLINE ora.dwdb2.gsd application OFFLINE OFFLINE ora.dwdb2.ons application OFFLINE OFFLINE ora.dwdb2.vip application OFFLINE OFFLINE ora.odsptdb.db application ONLINE ONLINE dwdb1 ora....b1.inst application ONLINE ONLINE dwdb1 ora....b2.inst application OFFLINE OFFLINE |
回到节点二重新执行:
Is the node ready for patching? [y|n] y User Responded with: Y Updating nodes ‘dwdb2‘ Apply-related files are: FP = "/oracle/product/11.1.0/db_1/.patch_storage/9352164_Apr_1_2010_11_33_14/rac/copy_files.txt" DP = "/oracle/product/11.1.0/db_1/.patch_storage/9352164_Apr_1_2010_11_33_14/rac/copy_dirs.txt" MP = "/oracle/product/11.1.0/db_1/.patch_storage/9352164_Apr_1_2010_11_33_14/rac/make_cmds.txt" RC = "/oracle/product/11.1.0/db_1/.patch_storage/9352164_Apr_1_2010_11_33_14/rac/remote_cmds.txt" … The node ‘dwdb2‘ has been patched. You can restart Oracle instances on it.
There were relinks on remote nodes. Remember to check the binary size and timestamp on the nodes ‘dwdb2‘ . The following make commands were invoked on remote nodes: ‘cd /oracle/product/11.1.0/db_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk iextjob ORACLE_HOME=/oracle/product/11.1.0/db_1 cd /oracle/product/11.1.0/db_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk iextjobo ORACLE_HOME=/oracle/product/11.1.0/db_1 cd /oracle/product/11.1.0/db_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk client_sharedlib ORACLE_HOME=/oracle/product/11.1.0/db_1 cd /oracle/product/11.1.0/db_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk idgmgrl ORACLE_HOME=/oracle/product/11.1.0/db_1 cd /oracle/product/11.1.0/db_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk ioracle ORACLE_HOME=/oracle/product/11.1.0/db_1 cd /oracle/product/11.1.0/db_1/network/lib; /usr/bin/make -f ins_net_client.mk client_sharedlib ORACLE_HOME=/oracle/product/11.1.0/db_1 cd /oracle/product/11.1.0/db_1/network/lib; /usr/bin/make -f ins_net_server.mk itnslsnr ORACLE_HOME=/oracle/product/11.1.0/db_1 cd /oracle/product/11.1.0/db_1/plsql/lib; /usr/bin/make -f ins_plsql.mk iwrap ORACLE_HOME=/oracle/product/11.1.0/db_1 cd /oracle/product/11.1.0/db_1/sqlplus/lib; /usr/bin/make -f ins_sqlplus.mk genplusso ORACLE_HOME=/oracle/product/11.1.0/db_1 ‘
OPatch succeeded. |
[oracle@dwdb1 9352164]$ crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora....SM1.asm application ONLINE ONLINE dwdb1 ora....B1.lsnr application ONLINE ONLINE dwdb1 ora.dwdb1.gsd application ONLINE ONLINE dwdb1 ora.dwdb1.ons application ONLINE ONLINE dwdb1 ora.dwdb1.vip application ONLINE ONLINE dwdb1 ora....SM2.asm application OFFLINE OFFLINE ora....B2.lsnr application OFFLINE OFFLINE ora.dwdb2.gsd application OFFLINE OFFLINE ora.dwdb2.ons application OFFLINE OFFLINE ora.dwdb2.vip application OFFLINE OFFLINE ora.odsptdb.db application ONLINE ONLINE dwdb1 ora....b1.inst application ONLINE ONLINE dwdb1 ora....b2.inst application OFFLINE OFFLINE [oracle@dwdb1 9352164]$ crs_start -all Attempting to start `ora.dwdb2.ASM2.asm` on member `dwdb2` Attempting to start `ora.dwdb2.vip` on member `dwdb2` Start of `ora.dwdb2.vip` on member `dwdb2` succeeded. Attempting to start `ora.dwdb2.LISTENER_DWDB2.lsnr` on member `dwdb2` Start of `ora.dwdb2.ASM2.asm` on member `dwdb2` succeeded. Attempting to start `ora.odsptdb.odsptdb2.inst` on member `dwdb2` Start of `ora.dwdb2.LISTENER_DWDB2.lsnr` on member `dwdb2` succeeded. Start of `ora.odsptdb.odsptdb2.inst` on member `dwdb2` succeeded. CRS-1002: Resource ‘ora.dwdb2.ons‘ is already running on member ‘dwdb2‘
Attempting to start `ora.dwdb2.gsd` on member `dwdb2` Start of `ora.dwdb2.gsd` on member `dwdb2` succeeded. CRS-0223: Resource ‘ora.dwdb2.ons‘ has placement error.
[oracle@dwdb1 9352164]$ crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora....SM1.asm application ONLINE ONLINE dwdb1 ora....B1.lsnr application ONLINE ONLINE dwdb1 ora.dwdb1.gsd application ONLINE ONLINE dwdb1 ora.dwdb1.ons application ONLINE ONLINE dwdb1 ora.dwdb1.vip application ONLINE ONLINE dwdb1 ora....SM2.asm application ONLINE ONLINE dwdb2 ora....B2.lsnr application ONLINE ONLINE dwdb2 ora.dwdb2.gsd application ONLINE ONLINE dwdb2 ora.dwdb2.ons application ONLINE ONLINE dwdb2 ora.dwdb2.vip application ONLINE ONLINE dwdb2 ora.odsptdb.db application ONLINE ONLINE dwdb1 ora....b1.inst application ONLINE ONLINE dwdb1 ora....b2.inst application ONLINE ONLINE dwdb2 |
1.1.9.2 升级数据字典
升级数据字典
cd $ORACLE_HOME/rdbms/admin sqlplus /nolog @catbundle.sql psu apply @utlrp.sql |
[oracle@dwdb1 ~]$ cd $ORACLE_HOME/cfgtoollogs/catbundle [oracle@dwdb1 catbundle]$ ls -lrt total 0 |
如果有报错，会在该目录下生成文件
1.1.9.3 重编译对象
这一步骤必须停机，STARTUP UPGRADE方式启动，单台节点操作即可。
[oracle@dwdb1 admin]$ cd $ORACLE_HOME/cpu/view_recompile [oracle@dwdb1 view_recompile]$ [oracle@dwdb1 view_recompile]$ ls -lrt total 12 -rwxr-xr-x 1 oracle oinstall 5143 Apr 2 2010 view_recompile_jan2008cpu.sql -rwxr-xr-x 1 oracle oinstall 2095 Apr 2 2010 recompile_precheck_jan2008cpu.sql |
[oracle@dwdb1 9352164]$ srvctl stop database -d odsptdb |
17:30
cd $ORACLE_HOME/cpu/view_recompile sqlplus /nolog SQL> CONNECT / AS SYSDBA SQL> STARTUP NOMOUNT SQL> ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=spfile; SQL> SHUTDOWN SQL> STARTUP UPGRADE SQL> @view_recompile_jan2008cpu.sql SQL> @?/rdbms/admin/utlrp.sql SQL> ALTER SYSTEM SET CLUSTER_DATABASE=TRUE SCOPE=spfile; SQL> SHUTDOWN; SQL> STARTUP NOMOUNT; |
Commit complete.
No. of Invalid Objects is :48 Please refer to README.html to for instructions on validating these objects … SQL> @?/rdbms/admin/utlrp.sql
TIMESTAMP -------------------------------------------------------------------------------- COMP_TIMESTAMP UTLRP_BGN 2014-11-10 13:51:22 SQL> select * from dba_objects where object_id=48;
OWNER OBJECT_NAME ------------------------------ -------------------- SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE ------------------------------ ---------- -------------- ------------------- CREATED LAST_DDL_ TIMESTAMP STATUS T G S --------- --------- ------------------- ------- - - - SYS I_CON1 48 48 INDEX 05-NOV-14 05-NOV-14 2014-11-05:13:03:24 VALID N N N |
失效的对象可以重新跟ultrp.sql脚本来重编译
或
SQL> alterpackage schemaname.packagename compile;
【简单的案例分享,停机10分钟】10204升级CRS&DB的PSU至102044